nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Purchase import data error

Cxpril

Hi,

I tried to import data to MYOB, importlog shows there is a summary error with invalid amount. Can anyone help me figure out what is going on? Thanks

importlog.txt

1.txt

Find more posts tagged with

Accepted answers

Steven_M

Hi @Cxpril

Typically, that import error means that the amount listed in the transactions doesn't match up to the calculated amount. In your case, I've added some additional columns to that report that should allow for that purchase to be imported.

As you have not defined a tax code in the transaction, I've added to FRE. You will need to make sure that you do have the appropriate tax code listed and that the Tax amount listed in the import file matches the calculated amount of that tax code and the Amount includes that tax code amount. For example, $53.45 + $0.00 = $53.45 (FRE being a $0 tax code).

ITEMPUR.TXT

All comments

Cxpril

Hi @Steven_M

I tried to use your template to import data, but there are some errors I cannot identify. Could you please help me take a look? Thank you very much!

3.txt

importlog.txt

Cxpril

Hi Steven,

Thanks for your help. I noticed that when import data contains billed and received, there are always some errors. I tried to export data from my existing purchase bills, and found billed 1 received 37 (I entered billed 1, received 1 in my purchase bill). I am wondering how MYOB identify the received quantity. Thank you!

Steven_M

Hi @Cxpril

ITEMPUR.TXT