Monitor Connector - SendOrderToBackoffice
This process sends an order from App4Sales to the Monitor ERP system. The connector generates a tab-delimited text file containing the order information and uploads it to a specified FTP server location.
Data Source Configuration
The connector generates a text file and uploads it to an FTP server. The file is placed in the /orders/ directory on the FTP server, which is relative to the folder specified in the FolderName setting. The filename is based on the order number (e.g., 12345.txt).
Order Header Logic
If the order number (OrderNr) is not already present on the order, a new one is generated by the system. The delivery address is determined by first checking for an alternate address on the order (AlternateAddress). If no alternate address is found, the system looks for the customer's first address with the type "del". If the order notes are longer than 70 characters, they are split into multiple lines and added as separate order lines.
App4Sales Field | Source Field (API/Excel/DB) | Logic/Notes |
Customer Number |
| The customer's code. |
Order Number |
| If empty, a new order number is generated. |
Your Reference |
| The customer's reference for the order. |
Notes |
| Included in the header if 70 characters or less. Otherwise, split into multiple order lines. |
Delivery Name |
| The customer's name. Sent as part of the delivery address block. |
Delivery Address 1 |
| From the alternate address or the primary delivery address. |
Delivery Address 2 |
| From the alternate address or the primary delivery address. |
Delivery Post Code and City |
| From the alternate address or the primary delivery address. Concatenated with a space. |
Delivery Country |
| From the alternate address or the primary delivery address. |
Line & Pricing Logic
Each order line is converted to a specific format in the output file. Pricing behavior depends on a connector setting.
App4Sales Field | Source Field (API/Excel/DB) | Logic/Notes |
Line Number | Derived | A sequential number starting from 1. |
Order Number |
| The main order number. |
Item Code |
| The code of the item on the order line. |
Quantity |
| The quantity of the item ordered. |
Order Date |
| Formatted as "yyMMdd". |
Price |
| The final price per unit. This is used if "Send original price with discount" is disabled. |
Original Price | Derived | The item's original price, retrieved from the database. Used if "Send original price with discount" is enabled. |
Discount |
| The discount percentage from the original price. Used if "Send original price with discount" is enabled. |
Charges & Attachments
This connector does not explicitly handle separate charges or attachments. Surcharges would need to be added as regular order lines.
Responses & Error Handling
If the FTP upload fails, the connector will return an error message to the user. The error message is extracted from the exception details. If the upload is successful, the App4Sales order number is returned. The connector does not read any response from Monitor to update the order status in App4Sales.
Related Settings & Prerequisites
The following settings in the connector configuration affect the behavior of the order export:
Send original price with discount: If enabled, the connector sends the original item price and a separate discount percentage. If disabled, it sends the final calculated price from the order line.
Folder Name: The root folder on the FTP server where the 'orders' folder is located.