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 Children
  • 0 in reply to Jason.
    Thanks for your response Jason. My main concerns are importing Purchase Orders and Sales Orders via uploading them in a fast and efficient way, as these will be the day to day transactions. I was looking at the link you provided but it only makes reference to uploading .imp files, which don't seem to be as effective as an excel (or .csv) file. Is there a way to upload .csv files instead of the .imp? Most of the systems I have worked with allow to upload .csv files. If Sage 50 does not allow to this, it might not be good for me.
  • 0 in reply to Roberto Or
    I used swagman software from Business Innovations. Get ahold of Dan Mason - he's the best and has saved me HOURS of input!
  • 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)

  • 0 in reply to CC-Recycle

    Do you have an example of the file you used?  

  • 0 in reply to MicheleJ

    Jason's post explains how to generate a .IMP file that should work as an example. 

    Because it's generated by your system, it will have your tax codes in the detail, the right version and country codes in the header, etc.