Skip to main content

MYOB Advanced: Setup Guide

Setup guide for connecting MYOB Advanced to Ordermentum and configuring sync settings.

Updated over a week ago

This guide explains how to connect Ordermentum to MYOB Advanced and configure the required properties for syncing customers, products, orders, and invoices.

πŸ’‘ This guide is for suppliers using MYOB Advanced (Acumatica). If you're using MYOB Business or AccountRight Live, click here instead.

πŸ”— Step 1: Connect to MYOB Advanced

  1. Go to Settings β†’ Integrations β†’ MYOB Advanced in Ordermentum.

  2. Enter the following 4 pieces of information:

    • URL: Copy your MYOB URL and add /(W(22))/ at the end.

      • Example: If your URL is https://yourbusinessname.myobadvanced.com, enter it as https://yourbusinessname.myobadvanced.com/(W(22))/

    • Username: Your MYOB API username.

    • Password: Your MYOB API password.

    • Company: The Company ID the user is attached to.

  3. Click Connect.

βœ… Once connected, Ordermentum will sync orders and invoices to MYOB Advanced. You can also optionally enable automatic payment reconciliation.

βš™οΈ Step 2: Set Up Required Properties

To successfully sync orders and invoices, you'll need to set up specific properties on your customers and products in Ordermentum. These are used to match your MYOB records.

πŸ–οΈ Customer Properties

Property Name

Description

myob_advanced_customer_id

The Customer ID in MYOB Advanced. Required for every customer you want to sync.

myobWarehouseId

(Optional) The Warehouse ID for the customer.

myobBranchId

(Optional) The Branch ID for the customer.

πŸ’† Product Properties

Property Name

Description

myob_advanced_product_id

The Product ID in MYOB Advanced. Required for all products included in synced orders.

myob_advanced_freight_product_id

(Optional) The Product ID in MYOB Advanced used for freight charges.

myob_advanced_surcharge_product_id

(Optional) The Product ID in MYOB Advanced used for surcharges.

myobWarehouseId

(Optional) The Warehouse ID for the product.

myobBranchId

(Optional) The Branch ID for the product.

myobInventoryId

(Optional) The Inventory ID for the product.

myobSubItemId

(Optional) The Sub Item ID for the product.

myobUom

(Optional) The Unit of Measure for the product.

myobTaxCategory

(Optional) The Tax Category for the product.

πŸ“œ Properties can be set manually in Ordermentum or imported in bulk by our team. Reach out to support if you need assistance.

Setting Product Fields Directly in the Integration

You can also configure product properties directly in the MYOB Advanced integration under the Products Fields tab. This allows you to override the product properties set on the product itself.

πŸ’‘ If a product value is set both in the Products Fields tab and as a product property, the integration will always prioritise the value from the Products Fields tab. This is useful for specific warehouse IDs, Inventory IDs, or other MYOB-specific product data.

βš™οΈ Optional Integration Settings

For detailed instructions on setting up automatic payment reconciliation, see this guide.

Ordermentum provides extra configuration options for the MYOB Advanced integration. These allow you to customise how data is synced and displayed in MYOB.

These can be configured from the Settings β†’ Integrations β†’ MYOB Advanced page in Ordermentum.

Setting

Description

Auto Reconciliation

Automatically match payments in MYOB to invoices in Ordermentum.

Cash Account

Set the MYOB cash account reference used for payment reconciliation.

External Invoice Sync

Enable syncing of finalized invoices from MYOB back to Ordermentum.

Mark Invoice as Paid

Mark invoices as paid in Ordermentum when payment is recorded in MYOB.

Customer Order Number

Send the Ordermentum order number to the customerOrderNumber custom field in MYOB.

Customer Order Description

Send the Ordermentum order number to the OrderDesc custom field in MYOB.

Customer Reference Number

Send the Ordermentum order reference to the customerReferenceNumber field in MYOB.

Combined Delivery Date

Set both the delivery and requested dates in MYOB to the Ordermentum delivery date.

Freight Tax Enabled

Enables tax calculation on freight charges in MYOB.

Manual Pricing

Ordermentum is the source of truth for product pricing (default: true).

Override Address

Use Ordermentum's address to override billing and shipping addresses in MYOB.

Requested On Date

Controls whether delivery date or order created date is sent to MYOB.

Send Comments to Description

Send Ordermentum order comments to the MYOB description field.

Send Order Number to Description

Send Ordermentum order number to the MYOB description field (overrides comments if both are enabled).

Warehouse Enabled

Send myobWarehouseId from Ordermentum to the MYOB line item warehouse field.

Order Type

Specify the type of order created in MYOB (default: SO).

Currency

Currency used for synced orders (default: AUD).

Surcharge Enabled

Add a surcharge line item to MYOB orders.

Surcharge Inventory ID

Set the inventory item used for surcharges (default: SURCHARGE, max 10 characters).

Order Status

Define a custom order status for synced orders.

Custom Random Weight Field

Send random weight quantities to a custom MYOB field (e.g. UOM).

πŸ”Ž Not all fields are required. Only enable settings that apply to your business setup.

πŸ› οΈ Troubleshooting & FAQ

Why aren’t my orders syncing?

  • Make sure all products and customers in the order have the correct MYOB properties set.

  • Check the integration logs for any error messages.

Can I change synced orders in MYOB?

Yes. Once an order is sent to MYOB, you can edit or complete it there. Changes made in MYOB will not sync back to Ordermentum.

How often does the sync run?

The integration syncs in near real-time. Some features, like finalized invoice syncing, may run hourly if enabled.

Need help? Reach out to support at support@ordermentum.com if you need any assistance.

Did this answer your question?