Hi Paul, Thank you for that - a MYOB Company data file has been sent to your email address. I'm looking forward to your further advise.
Thanks Cheng |-----Original Message----- |From: delphi-boun...@delphi.org.nz |[mailto:delphi-boun...@delphi.org.nz] On Behalf Of Paul Heinz |Sent: Friday, 12 November 2010 9:51 a.m. |To: NZ Borland Developers Group - Delphi List |Subject: Re: [DUG] MYOB Rounding Issue | |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 | ##################################################################################### Scanned by MailMarshal - M86 Security's comprehensive email content security solution. Download a free evaluation of MailMarshal at www.m86security.com ##################################################################################### _______________________________________________ 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
