Import Sales via CSV - Error -25: Invalid amount.

Hi Amber_BIBS,

Nice work getting the groundwork done with an export as your template. The Error -25: Invalid amount usually crops up because Microsoft Excel adds extra characters when saving to CSV, wrapping numbers that contain a comma in double quotes, which the importer treats as invalid. To fix it, you'll need to:

• Identify the column causing the issue, then in Excel select the entire column, then right click the column header, and select Format Cells...
• In Format Cells window, under the Number tab, select the Category: as Number like in the screenshot below.
• When using File>Save As, you might get a a prompt like below, select Yes, as we want to keep the format.
• If you open the import file in Notepad, you will now see the quotation marks have been removed.

After that, the import should run without skipping records.

Cheers,

Doreen

Thanks Doreen_P​ 

There are no quotation marks that have been added as I didn't use excel. As you can see from the error log there is nothing here. From what I can see the customer name & also the Tax code have been converted to a number however these are formatted as plain text fields so unsure why this is coming through as a number. I'm not sure if this is what is pulling the invalid amount error or not?

Hi Amber_BIBS​ 

If you open this in excel, this is what you see - 0.1 on column O is in wrong place. If price is 390.34, the GST and the Inc-Tax Total should be much higher than 0.1 and 1.1 - I would suggest these are the amounts that are out. Rather than 0.1 work out the GST amount, and the tax inclusive amount. MYOB does not use formulae in imports, you need to import the data.

Best approach is to manually enter the transaction (or a sample), then export. This will show you how to correctly prepare import, including {} on line one if required.

Regards

Gavin

Hi Amber_BIBS​ 

If you open this in excel, this is what you see - 0.1 on column O is in wrong place. If price is 390.34, the GST and the Inc-Tax Total should be much higher than 0.1 and 1.1 - I would suggest these are the amounts that are out. Rather than 0.1 work out the GST amount, and the tax inclusive amount. MYOB does not use formulae in imports, you need to import the data.

Best approach is to manually enter the transaction (or a sample), then export. This will show you how to correctly prepare import, including {} on line one if required.

Regards

Gavin

Hi Amber_BIBS​ 

If you open this in excel, this is what you see - 0.1 on column O is in wrong place. If price is 390.34, the GST and the Inc-Tax Total should be much higher than 0.1 and 1.1 - I would suggest these are the amounts that are out. Rather than 0.1 work out the GST amount, and the tax inclusive amount. MYOB does not use formulae in imports, you need to import the data.

Best approach is to manually enter the transaction (or a sample), then export. This will show you how to correctly prepare import, including {} on line one if required.

Regards

Gavin

Hi Amber_BIBS​ , I thought I posted this yesterday but there was an error. Other replies have covered similar ground, but here it is anyway.

The Total, Tax Amount and Inc_Tax values showing are incorrect. They should be $390.24, $39.02 and the sum of these two ($4 2 9 . 2 6) respectively. (The posting error objected to 4 2 9 without spaces).

Also your CSV file needs a pair of curly braces added as line 1 like so:

{}

Nothing else should be on line 1. The braces tell AccountRight to use the correct field list.

I notice the line of column headings has an extra heading "0.1". I don't know if this will impact the result, but it should be deleted.

The heading "Supervisor" should be amended to read "Job" if you are hoping to use Automatching.