When your Ordermentum account is integrated with MYOB Advanced, data is automatically synced between the two platforms. This article explains how fields in Ordermentum map to their corresponding fields in MYOB Advanced for orders, products, and automatic bank reconciliation (Auto-Rec).
Orders
The table below shows how order fields in Ordermentum map to fields in MYOB Advanced.
Ordermentum Field | MYOB Advanced Field | Description | Notes |
| Order Type | Matches the Order Type setting in your integration | Usually either SO (Sales Order) or IN (Invoice) |
Delivery Day | Date |
|
|
Order Placed | Requested On |
| Date fields may map differently depending on the integration settings for 'Combined Delivery Date' and 'Requested on Date' |
PO Number | Customer Order Nbr. | Purchase Order number |
|
Comment | Description | Order comments | May be overridden if other settings are changed to map to the description field (e.g. 'Send Order Number to Description'). Sending both a comment and an order number to the description field at the same time is not supported. |
UOM | *Custom Field |
| Set the custom field name in your integration settings |
Surcharge | Inventory ID | Line item on the sales order in MYOB | Set the MYOB inventory item in your integration settings |
Freight | Premium Freight Price | Total Freight |
|
Products
The table below shows how product fields in Ordermentum map to fields in MYOB Advanced.
Ordermentum Field | MYOB Advanced Field | Description | Notes |
Inventory ID | Inventory ID | MYOB's version of SKU | This may differ from the SKU used in Ordermentum |
UOM | Sales Unit |
| Unit of measurement the product is sold in (e.g. Kg) |
Tax Category | Tax Category |
| Tax category for this product in MYOB |
Warehouse ID | Warehouse |
|
|
Auto-Rec (Automatic Bank Reconciliation)
When using the Auto-Rec feature in MYOB Advanced, Ordermentum payment records are matched using the following reference:
Ordermentum | MYOB Advanced |
Reference Number | Document Ref. |
The Ordermentum reference number is used as the Document Ref. in MYOB Advanced to match transactions during the bank reconciliation process.
Need more help?
If a field mapping isn't behaving as expected after checking your integration settings, contact Ordermentum Support with the order or product affected and a description of what you're seeing in MYOB Advanced.
Use the Help chat in the bottom-right corner, or email support@ordermentum.com.