[Question] Importing Cashbook Payments Batch into Pastel

[Anemari]

I need some help in checking the format of my import batch. I used the Pastel help to get the format of the csv file yet I keep getting errors when I import. IT IS DRIVING ME CRAZY - if I wasn't already crazy LOL. Anyone who has successfully imported a cash payments batch into Pastel please have a look at my source file and my error messages and PLEASE help me!
Thank you a MILLION in advance

[Neville Bailey]

Hi Anemari,

I have had a look at the layout of your CSV file, and I can see that there are a number of mandatory columns that are not present, i.e. columns M through to R.

M = Exchange Rate (set to 1)
N = Bank Exchange Rate (set to 1)
O = Batch ID (set as 0)
P = Discount Tax Type (set as 0)
Q = Discount Amount (set as 0)
R = Home Amount (same as in column G)

I have attached a modified version of your CSV file for you to try.

[Anemari]

Hi Neville
THANK YOU THANK YOU THANK YOU!!! It worked a treat!! Too thrilled for words! Thank you so much!!!!

[Anemari]

Hi Neville
May I be a pest and ask you if you have a csv file for AP imports? I used the help on Pastel and they have numerous fields for the header as well as the detail lines - this will take me hours to figure out!?
Yours HOPEFULLY
Anemari
: )