[Question] CSV Import Invoices Pastel - Comments / Remarks Disappearing

[dkpinn]

Dear Community

I have created an import (.CSV) for Pastel Partner Invoices, and it almost works.

For all the lines that I place with the 7 = Comments/Remakrs, it does not import.

I have tried putting it before and after the 6 = GL Code line and it still does not bring it through.

The other strange thing, is that the I place the Exclusive Amount and Choose 1 for 14%, The .CSV has this and yet it only brings in the Exclusive amount

Customers - 20160606 - 0756.csv

[Neville Bailey]

I've had a look at your CSV file.

There is missing data in your Detail lines.

For each Detail line:

Column B must have 0
Column C must have 1
Column D must have 0
Column E must have 0
Column G must have 0
Column H must have 0
Column I must have 0
Column J must have '

[dkpinn]

Solved

I've had a look at your CSV file.

There is missing data in your Detail lines.

For each Detail line:

Column B must have 0
Column C must have 1
Column D must have 0
Column E must have 0
Column G must have 0
Column H must have 0
Column I must have 0
Column J must have '

Hi Neville

You are indeed correct. ;-) Everything imports.

In fact at first I was having an excel export problem where the apostrophe was not showing in the .CSV, so I doubled up on the Apostraphe's and viola..

Thanks Neville.