How does the MYOB Invoice Number get populated?
The Invoices API endpoint has a Number element which is a 8 character code. You have 2 options when uploading Invoices to MYOB:
- leave this blank and MYOB will will auto-generate this
- populate this with a value from a FileMaker field
In the fmAccounting Link (MYOB AccountRight Edition) file we are using the 2nd option to populate this with the value from the _kp_InvoiceID field (the primary key field for the Invoice in FileMaker). If you wish to change this to have MYOB auto-generate the number for you simply disable/delete this line:
BE_JSON_Encode ( “Number” ; _kp_InvoiceID ) & “,” &
from the calculation formula in these fields:
We have a field in the Invoices table named MYOBInvoiceNumber which we populate with the MYOB Invoice Number value, regardless of the above settings.