[DUG] MYOB Rounding Issue

[Cheng Wei (FMI)]

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-bounces at delphi.org.nz 
|[mailto:delphi-bounces at 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 at delphi.org.nz
|Admin: http://delphi.org.nz/mailman/listinfo/delphi
|Unsubscribe: send an email to delphi-request at 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
#####################################################################################