Sage 300 Imported Purchase Order Workflow - NextGen

Modified on Wed, 22 Nov 2023 at 04:18 PM

Quadient AP's Purchase Order module allows you to import purchase orders from Sage 300. The purchase order and receiving data are imported into Quadient AP from Sage 300 via SmartSync and can be matched to invoices entered into Quadient AP. To learn more about this process, please reach out to your Customer Success Manager.  


General Overview of Sage 300 Imported Purchase Order Workflow

Purchase Order

  • Imported purchase orders can be synced into Quadient AP in either fully approved (PO) status, or Pending Approval (PA) status. By default, purchase orders will be synced in PO status.

  • For the purchase order approval workflow, the purchase orders will go through the Approval Channels set up in Quadient AP.

  • Only 'Active' purchase orders are imported from Sage 300.
  • Any updates to the purchase order in Sage 300 must be synced to Quadient AP. For the purchase order approval workflow, the purchase order does not need to be approved again for any updates.

Receiving Data

  • The receiving data can be viewed in Quadient AP from within the purchase order and invoice module. 

  • There is no approval workflow for receiving data. Receiving data is automatically linked to the purchase order after syncing.

Importing Purchase Orders from Sage 300 to Quadient AP

In Sage 300, ensure that the purchase orders you want to import are in Active status. In the SmartSync menu in settings, ensure that the PO & Receivings sync from date toggle is enabled. Set the date back as far as needed to sync in the required purchase orders. You can verify the number of purchase orders and receivings synced at the bottom of the sync log. 


Once synced, the purchase orders from Sage 300 can be differentiated from purchase orders made in Quadient AP by the Imported from ERP banner. 


Matching an Imported Purchase Order to an Invoice

In the Invoice module, click on the invoice that you want to match to an imported purchase order. On the Header details, ensure that the vendor is coded to the invoice. Click on the PO dropdown to match the correct purchase order to the invoice.

Once the purchase order is matched to the invoice, click the 'Adopt from purchase order'  button in the bottom left corner. This opens the receivings menu, allowing you to adopt the purchase order coding to the invoice. 


Select the lines you need to adopt, followed by the Receivings for that line. Click the green Adopt Lines button. Once back in the invoice view, click Save to save the changes. 

Some purchase order lines may not be available for adoption. The reason for this is usually that the line is already fully adopted on another invoice in Quadient AP, or the line is fully invoiced in Sage 300. All invoice lines must be adopted from the matched purchase order. Additional invoice lines can not be added manually. Invoices with additional added lines will receive an error message when submitted for approval. 

 You can not manually add additional line items to the invoice nor can you use the 'Adopt to PO Coding' feature as opposed to 'View Receivings'. 


Additional information

The 'quantity invoiced' on the purchase order is updated only after the invoice data is exported from Quadient AP into Sage 300. It's recommended that you sync the invoice data from Quadient AP into Sage 300 frequently to ensure it is kept up to date.

If you have multiple invoices against the same receiving and mark any of the lines as fully invoiced, then we recommend exporting the first invoice into Sage 300 before you export the second invoice, to avoid sync errors. Also, avoid batch exporting invoices in this scenario. 


If you have any questions or would like to enable the workflow for your company, please reach out to your Customer Success Manager.  

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article