Knowledge Base

Neto By Maropost

MYOB AccountRight Live Field Mapping

The following is the field mapping information showing data exchanged via the integration. Things to note:

Products (items) can only be imported from MYOB to Neto by Maropost, not exported from Neto to MYOB.
Invoices and Payments are exported to MYOB, not imported from MYOB.
Customers can be imported from and exported to MYOB
Products in MYOB must have valid SKUs
Customer Cards in MYOB must have valid alphanumeric CardIDs
User Group data is limited to the first 5 groups (A – E) in MYOB

Products (Items) from MYOB

Note: Check the Item Details tab of an item in MYOB for the Item Details checkbox. If this box is selected, the Name and Description mapping needs to be reversed.

MYOB Fields	Neto Fields
Item Code	SKU
Item Name	Name (Item Description if the Item Details checkbox is selected).
Item Description	Description (Item Name if the Item Details checkbox is selected).
Standard Cost	Cost Price
On Hand Qty	Warehouse Qty
On Commit Qty	Committed Qty
Active	Visible
Is Bought	Is Bought
Is Inventoried	Is Inventoried
Is Virtual	Allow Oversell
Is Inventoried	Is Inventoried
Is Sold	Is Sold
Item Images (main image only)	Image (main image)
Asset Account	Asset Account
Sales Account	Sales Account
Purchase Account	Expense/COS Acct
Income Account	Income Account
Reorder Qty	Restock Qty
Primary Supplier	Primary Supplier
Supplier Item Number	Supplier Item Code
Minimum Level	Restock Warning Level
Default Cost	Default Purchase Price
Tax Code When Bought	Purchase Tax Code
Price Retail	Retail Price
Unit	Unit
Tax Inclusive	Tax Inclusive
Sales Tax Code	No Tax
Multilevel Prices	Multilevel Prices
Quantity Over	Multilevel Prices Min Qty
Quantity Over	Multilevel Prices Max Qty
Price Levels A – E	User Group ID Prices
Sell Price Inclusive	Price (Default Customer Group)
Items/Buy Unit	Buy Unit Qty
Items/Sell Unit	Sell Unit Qty

Pricing

MYOB Fields	Neto Fields
Price Level A, Qty Break 1	Price A
Price Level B, Qty Break 2	Price B
Price Level C, Qty Break 3	Price C
Price Level D, Qty Break 4	Price D
Price Level E, Qty Break 5	Price E

Customers

MYOB Fields	Neto Fields
Username	Contact Code
Last Name	Last Name
First Name	First Name
Active	Active
Notes	Notes
Tax Code	Tax Code
Freight Tax Code	Freight Tax Code
User Custom2	Tax Number
Company	Company Name
Address (Street, City, State, Country, Zip, Phone, Fax	Address
Email	Email
Website	Website
Address Book First & Last Name	Address Contact Name

Invoices

MYOB Fields	Neto Fields
Username	Contact Code
Last Name	Last Name
First Name	First Name
Active	Active
Notes	Notes
Tax Code	Tax Code
Freight Tax Code	Freight Tax Code
User Custom2	Tax Number
Company	Company Name
Address (Street, City, State, Country, Zip, Phone, Fax	Address
Email	Email
Website	Website
Address Book First & Last Name	Address Contact Name

Payments

Tip: This includes overpayments, which are exported to the default income account set in the MYOB integration settings page.

MYOB Fields	Neto Fields
Payment Reference	Receipt Number
Date Paid	Date
Payment Amount	Amount Received
Payment Type	Payment Method
Payment Amount	Amount Applied