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

Filed under:
|
|

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:

  1. Invoice 8421 is imported with 4 lines
  2. The total invoice amount is $396
  3. The Amount paid (that is imported) is $66
  4. 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

Related posts about import

Related posts about Sales