Forum Discussion

FoxHay's avatar
FoxHay
Experienced Cover User
2 years ago

Import List of Purchases

I have a purchase list (Payments) from my POS system.

I saved the .Xlsx file to .txt and added fields

I tried to import but got the error report also attached.

I am close but do not know how to fix ,i have tried several times.

Any help would be appreciated.

Regards

Peter

 

1 Reply

Sort By
Replies have been turned off for this discussion
  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    2 years ago

    Hi FoxHay , for separate purchases, you need a blank line between each one. And for amounts over $1000, Excel adds quotes and commas, so format the amount as general in Excel before saving as txt.