This KBA contains the following overview and procedures:

Overview: Ace EDI processing

Ace Hotsheets and maintenance files are automatically processed overnight

Paladin EDI automatically updates your inventory and customer data with the latest Ace Hotsheets and maintenance updates at 4 am local time with these exceptions:

  • If a new price is higher, the price update will be delayed until you manually run EDI. This safeguard helps prevent a checkout price from being unexpectedly higher than the bin tag price on your store shelf.
  • If a price is set by a reference margin, the item cost will be updated, but the price update will be delayed until you manually run EDI.
  • Ace invoices will not be processed until you manually run EDI.

Note: Your Ace EDI price update settings in Paladin Configuration (File > Setup > Supplier tab) will always be respected. For example, if your settings only allow price updates if the price is higher, the automatic Hotsheet processing will not lower any prices.

Some manual EDI processing is still required

Ace  EDI invoices must be processed manually

Note: Ace does not provide invoice numbers, so the Invoice ID column will be blank in the Reporting window.

When you run EDI to process invoices, delayed price updates are also made. To learn how, see How to process Ace Hardware EDI invoices and delayed price updates in Paladin.

Back to Top

How to view pending price updates

You can view the pending price increases prior to running EDI. To do this, in the EDI Processing window, before you  click Download Files, click Reporting. In the EDI Reporting window, look for files with a red X in the Pending Prices column. The files contain delayed price updates.

Ace Delayed Prices Hotsheet EDI Reporting screenshot

Back to Top

Setting parameters to view pending price updates in Excel

  1. In Paladin, on the main menu, select File > Setup.
  2. Open the Company tab.
  3. In the EDI pane, under Ace EDI, uncheck Revert to PDF Reporting.
  4. Click Save and then click Close.

To view a file’s delayed price details in Excel, click the magnifying glass. In the Excel report, items with pending price updates will have an “X” in the Pending Price column. For these items, the listed retail price is the new price that will be applied when you manually run EDI processing. The current price in your inventory does not appear.


Excel EDI Report Showing Pending Price screenshot

After you manually run EDI and price increases are applied, the red X icon in the Pending Price column will change to a green checkmark.Ace Delayed Prices Hotsheet EDI Reporting screenshot

Back to Top

How to send a purchase order to Ace Hardware

  1. On the top ribbon, click the PO module or press Alt + 4.
  2. In the Purchase Order tab, do one of the following options:
    • Create a PO.
    • Recall a PO that you previously saved or that was automatically created, such as a Suggested Order PO.
      Optional: If you want to sort an Ace PO by RSC availability, before you click Recall, select Supplier Stock Check. Ace Hardware must be selected for the supplier. 
  3. In the Supplier list, select Ace Hardware.
  4. When you are ready to send the purchase order to Ace Hardware, on the bottom ribbon, click Confirm PO or press F8.
  5. Then, click Buy or press F1.
  6. Enter a PO number or use the default number, and then click Next.
  7. In the PO Complete  window, click  Done. Your next purchase order will automatically upload to Ace Hardware.
  8. Check your email account for a confirmation message from Ace Hardware.

Back to Top

How to process Ace Hardware EDI invoices and delayed price updates in Paladin 

Note: Only price updates that increase the price (‘delayed price updates’) will be processed along with EDI invoices in this procedure.

  1. On the top ribbon, click the Inventory module or press ALT+ 3.
  2. On the bottom ribbon, click EDI or press F9.
  3. Click Download Files.
  4. If prompted, in the EDI Maintenance Processing window, select Ace Hardware, and then click OK.
  5. In the EDI Processing window, messages will inform you about the data being processed. Watch for messages that require your attention. For example, if a duplicate invoice is identified, EDI processing will stop until you decide whether to continue or cancel.
  6. When EDI file processing is complete, a Cancel Backorder window will appear, even when no backorders are present. Click Yes to complete EDI processing.
  7. To access EDI data reports, click Reporting.
  8. In the Reporting window, highlight any row, and then click Generate Report to view EDI processing details. 

Back to Top

If you have questions or suggestions about this information, contact

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 5/23/22