Hi Cheng Wei > Does anyone know what rounding convension is MYOB using? > > We export Invoice Line Items to MYOB and we've been > experiencing rounding issues with GST calc, we've tried > different rounding methods but can never get all invoices to > match, a small number of invoices always come out 1 or 2 > cents different in GST.
I don't specifically know the answer to your question but I have a possible theory to throw out there. I have written Delphi native TDatasets and tools which can directly read MYOB company files so I know something of their somewhat 'baroque' internal data model. MYOB is firmly in the 'GL-in-disguise' style of accounting data model and invoices are stored across two separate structures, one which stores the product line details (in the inv and iline tables from memmory) and one which stores the summarised GL journal details (in the ctran table). I wonder if what might be happening is that all the product lines that post to the same underlying GL sales accounts (which is stored per product in the item table) are being summarised into one journal at the ctran level and then GST calculated and rounded for that group to produce a GST journal. If you have a MYOB company file with some sample invoices that show the rounding differences, I can open it up in my MYOB database viewer and look at the underlying data if you would like and I can export the various records for you to help shed light on the underlying pattern. Cheers, Paul Heinz --- Paul Heinz | Accredo Business Software Ltd 34 Burleigh St | PO Box 99156 | Auckland, NZ P: +64 9 373 5963 | F: +64 9 373 5961 M: 021 456 231 | www.accredo.co.nz _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
