Field Mapping



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

  • Products (items) can only be imported from MYOB to Neto, 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

MYOB FieldsNeto Fields
Item CodeSKU
Item NameModel
Item DescriptionDescription
Item Purchase CostCost
On Hand QtyWarehouse Qty
On Commit QtyCommitted Qty
ActiveVisible
ActiveApproval
Is BoughtIs Bought
Is InventoriedIs Inventoried
Is VirtualAllow Oversell
Is InventoriedIs Inventoried
Is SoldIs Sold
Item Images (main image only)Image (main image)
Asset AccountAsset Account
Sales AccountSales Account
Purchase AccountExpense Account
Income AccountIncome Account
Reorder QtyRestock Qty
Supplier Supplier
Supplier CodeSupplier Code
Stock AlertRestock Warning Level
Default CostDefault Purchase Price
Purchase Tax CodePurchase Tax Code
Price RetailRetail Price
UnitUnit
Tax InclusiveTax Inclusive
Sales Tax CodeNo Tax
Multilevel PricesMultilevel Prices
Quantity OverMultilevel Prices Min Qty
Quantity OverMultilevel Prices Max Qty
Price Levels A – EUser Group ID Prices

Customers

Neto FieldsMYOB Fields
UsernameContact Code
Last NameLast Name
First NameFirst Name
ActiveActive
NotesNotes
Tax CodeTax Code
Freight Tax CodeFreight Tax Code
User Custom2Tax Number
CompanyCompany Name
Address (Street, City, State, Country, Zip, Phone, FaxAddress
EmailEmail
WebsiteWebsite
Address Book First & Last NameAddress Contact Name

Invoices

Neto FieldsMYOB Fields
UsernameContact Code
Last NameLast Name
First NameFirst Name
ActiveActive
NotesNotes
Tax CodeTax Code
Freight Tax CodeFreight Tax Code
User Custom2Tax Number
CompanyCompany Name
Address (Street, City, State, Country, Zip, Phone, FaxAddress
EmailEmail
WebsiteWebsite
Address Book First & Last NameAddress Contact Name

Payments

Neto FieldsMYOB Fields
Payment ReferenceReceipt Number
Date PaidDate
Payment AmountAmount Received
Payment TypePayment Method
Payment AmountAmount Applied

  • Last Modified: 18/11/2016