MYOB Import "amount paid"
Posted
by php-b-grader
on Stack Overflow
See other posts from Stack Overflow
or by php-b-grader
Published on 2010-06-14T00:04:48Z
Indexed on
2010/06/14
0:12 UTC
Read the original article
Hit count: 296
I seem to have found an anomaly with MYOB (I've actually found many anomalies, this is just another one that is doing my head in...)
I am generating a file with all invoices from the web system - no problems.
If an invoice has 3 lines and the account is paid COD, I am having an problem
e.g.
"INV", "DATE" ... "AMOUNT", "INC TAX AMOUNT" ... "AMOUNT PAID"
8421, 12/06/2010 ... 60, 66 ... 66
8421, 12/06/2010 ... 120, 132 ... 132
8421, 12/06/2010 ... 96, 105.6 ... 105.6
8421, 12/06/2010 ... 84, 92.4 ... 92.4
When I import this file, the balance of the invoice is still outstanding and what it appears is the issue is that it is only importing the first line of "amount paid" ... so in other words, based on the above:
- Invoice 8421 is imported with 4 lines
- The total invoice amount is $396
- The Amount paid (that is imported) is $66
- The outstanding balance = $330
Surely the first line isn't expected to be: Inc tax Amount = $66 Amount Paid = $396
It seems completely illogical to me... am I doing something wrong or is MYOB just really bad?
© Stack Overflow or respective owner