Forum Discussion

FoxHay's avatar
FoxHay
Experienced Cover User
3 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

Replies have been turned off for this discussion
  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    3 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. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Learn:

Level up your skills using MYOB software.

Find help guides and technical solutions for all MYOB products here

Explore video tutorials for our software at the MYOB Academy here

 

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.