Importing Data to Purchase Order in Sage 300

Some Sage users track certain purchase transactions in an external application and need to bring that data into Sage 300 for further processing. Here’s how to import data into the Sage 300 Purchase Order module using the built-in templates.

Generating the Import Template

Sage 300 generates templates that allow you to import one or more entries into Purchase Order (P/O) and other modules within Sage. Depending on your needs, these templates can be generated in a variety of formats such as Excel, CSV file, Access, ODBC and XML. Following the template layout ensures that the data is structured and formatted in a way that Sage 300 will accept and minimizes potential errors.

Generating import template

Follow these steps to generate the import template:

1. In P/O Purchase Order Entry, click File > Export.
2. In the File Type dropdown box, select the type of file you want to generate.
3. In the File field, specify the file name and location you want to save the template.
4. Click the checkboxes to select which fields you want to include in your import template (note that some fields indicated in red are required and cannot be deselected).
5. Click OK to generate the import template which is saved to the location you specified earlier.

NOTE: You may also notice a Save Script button at the bottom of the screen. This option allows you to create a script containing these settings for importing and exporting records for future use.

Importing Data to P/O

Open the template file that was generated above which can be found in the location you specified in step 3. Input your data into the appropriate fields within the template and when finished, go to File > Import in the P/O Purchase Order Entry screen. Choose the import file you created that now contains your data and click OK.

Need Help?

If you have questions about Sage 300, connect with us online or give us a call at 410.685.5512.

©2024 Juice Marketing, LLC. http://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.