Sage 100 Warehouse List for Imported Purchase Orders

Modified on Thu, 7 Sep, 2023 at 10:23 AM

Warehouse is a mandatory list for Sage 100 Imported Purchase Orders in Quadient AP. By default, the Warehouse list is inactive in Quadient AP, and may not contain all Warehouse list items in Sage 100. Follow the guide below to ensure the Warehouse list is active and accessible in Quadient AP.

How to sync the Warehouse list from Sage 100 into Quadient AP

Quadient AP imports Warehouse items in the following statuses from Sage 100:

  • Active 
  • Inactive
  • Null 
  • Restricted (Restricted Warehouse list items appear as Active in Quadient AP) 

Run a backdated sync in Quadient AP to sync the entire Warehouse list. To do this, navigate to the SmartSync Menu. Ensure that the PO & Receivings Sync From Date toggle is on, and click the calendar icon to select the date. Click Sync to run the sync.  

The sync start date must be at least a day prior to when the first Warehouse list items were created. You can find this information in Sage 100 with the following steps: 

  • In Library Master - Utilities, open Data File Display and Maintenance
  • Click the folder icon beside the File Name field to open the file explorer
  • Select the necessary file path. For the Warehouse list, the file path is MAS90 > MAS_ABX > IMABX > IM_Warehouse.M4T
  • Scroll down to the DateCreated$ line. The date is in YYYYMMDD format. 

After syncing the list, it's important to ensure that it is activated. In List Management, select the Legal Entity and the Warehouse dropdown list. Under Active, ensure the toggle is set to Yes. 

Using the Warehouse list in Quadient AP

The Warehouse list is visible on the purchase order Line Items field. It will also be visible on the invoice Line Items field once the purchase order is matched to an invoice.

The Warehouse list on a purchase order or PO-matched invoice should not be edited in Quadient AP. Editing the Warehouse list will cause sync errors when exporting the invoice back to Sage 100. Additionally, the Warehouse list should not be coded on non-imported PO matched invoices, or invoices matched to a PO generated in Quadient AP. 

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article