Invoice date and Posting date
As an accountant recently having started a new position in a company using MYOB Accountright I came across a strange scenario. when processing a Sales Invoice or Creditor Invoice, (via export to MYOB...
Forum Discussion
Hi paddyr , how are invoices being brought in to AccountRight? Whether by API or manual file import, either way the wrong date may have been mapped to the transaction date.
Hi Mike, they are exported Via API in Workbench (job management sytem) and it has some utility rules ( see attached screenshot). Wondering if i need to take a look at the job management side also! if a period has closed ie july, does MYOB allow a transaction date of july in an august period?
Hi paddyr , sorry I missed your reply. AccountRIght is entirely date driven, so a transaction passed through with a July date will be reported in July. (If that period is locked in AccountRight at the time of posting, an error will be generated. It's possible that Workbench handles that error and changes the date to the current month (unlikely but worth asking WB).)
The rule shown does not apply to AccountRight, which only has one date.
So when you say that "MYOB only supports the Posting date and not the Invoice date.", this implies that WB is passing the posting date not the invoice date. That is just plain wrong. Please refer to WB support. It may be that a configuration switch is incorrect, or possibly a bug exists.
hi Mike_James & Earl_HD
thanks for your replies. Right so just to clarify, if i have a july dated invoice and i want to transact it in MYOB but the July Period is Locked as the invoice is late and we have closed the July period for month end purposes for arguments sake. So it is transacted in August in MYOB. my Question is does MYOB Account right take the date its transacted as the Invoice date or am i understanding it incorrectly. Can you still input it as a july dated invoice but obviously have it transacted in the august period? I thought it could only handle a single date field ?
Earl_HD The accrual accounting adjustments are already done for month end purposes, nothing really to do with the Ageing issue i have in AP & AR. I have a call on monday with the WB developer so i can get some more insight to the options available. For now the AP team are treating anything coded on the 1st of the following period, ie August, as a july invoices for ageing purposes but you know, not ideal in the long term.
thanks
