We don't import daily from MYOB Account Right because there is no 'Last Updated Date' exposed in the MYOB API, so we have to use other dates.
For other integrations, we use a 'sliding window' approach where we import every item that has been modified since the last time we did an import.
For example, with invoices, we just use the Invoice Date itself, and so we import all invoices with Invoice Dates after the last time we did an import.
The problem arises if they create an invoice in MYOB with an Invoice Date backdated to before the last time we did an import.
So our solution for MYOB is that on Monday between midnight and 1 am, we import:
- Job Receipts and Payments (that have a date within the last 40 days)
- Companies and their Contacts (that have been created or updated in the last 40 days)
- GL Accounts and Leave Balances...all