I see a MYOB ID field in most tables – what is the purpose of these fields?
Most tables that upload to MYOB will contain a “MYOB ID” field, e.g.:
- _kf_MYOBContactID in Contacts
- _kf_MYOBInvoiceID in Invoices
- _kf_MYOBPurchaseOrderID in Purchase Orders
These fields store MYOB’s unique identifier for each Contact, Invoice, Purchase Order etc that you upload to MYOB or download from MYOB.
These operate in a similar way to a primary key field does in FileMaker. If there is a value in these fields that means that the Contact, Invoice etc has previously been uploaded (or downloaded from MYOB) – i.e. that FileMaker record also exists in MYOB. When uploading to MYOB if the “MYOB ID” field is empty a new record will be created in MYOB, otherwise the MYOB record that matches the “MYOB ID” field will be updated.
N.B. as these MYOB ID values should be unique make sure when you duplicate an Invoice, Contact, Bill etc that you clear out the value in these MYOB ID fields (_kf_MYOBContactID, _kf_MYOBInvoiceID etc) otherwise you will run into issues when uploading as it will be attempting to update that record in MYOB that matches the value in the MYOB ID field.