What is the process to create Purchase Orders or Sales Orders via uploading a .csv file?

SUGGESTED

I am a new user of Sage 50. I am trying to figure out how to create Purchase Orders or Sales Orders in Sage 50 via uploading an excel file (or CSV). Any help would be appreciated.

Parents Reply
  • 0 in reply to Roberto Or

    Roberto, I'm not sure if you are aware of this, but an .imp file is actually a .csv file with a specific format. If you can create a .csv file, then you can create an .imp file -- both are text files in the strictest sense and both can be edited with any text editor.

    I just exported roughly 500 invoices from Quickbooks to bring them into Sage 50. I exported from quickbooks into a spreadsheet and then did some processing of the spreadsheet to generate an .imp file (which. as I said, is really just a .csv file with particular headers)

Children