Importing Data to Purchase Order In Sage 300

By: Sharon Paul

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 - Sage 300

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. 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.

Published March 21, 2024

Webinar Recording

Streamline Your Year-End Close With Improved Technology

year-end webinar slide deck on computer

Business Central 2024 Release Wave 1: New Features and Enhancements

Microsoft Dynamics 365 Business Central continues to evolve, bringing new features and improvements that enhance...

Transitioning Your Accounting and Payroll Systems to the Cloud

If you’re still using a legacy on-premises accounting system, there’s a good chance you’re facing some challenges and...