Purchase Entry Processing Open PO Cost Update Report overview

Purchase > Entry > POE Reports > POEPU

Function acronym: POEPU

Use this report to update the price on open purchase orders in Stage 4 or below when the purchase price changes. This reduces the number of discrepancies between receiving and costing.

When you run the Purchase Entry Processing Open PO Cost Update Report, it uses either Last cost or Replacement cost from Product Warehouse Product Setup. The cost used is based on the Cost selected in SA Administrator Options-Documents-Purchase Orders-Entry Defaults-PO Entry.

When a purchase order line is identified for updating, the report sets the line item cost to the updated price and re-totals the order. Only line items with a change to the purchase order price are listed on the report.

Exceptions and hierarchy

The report checks for orders with special price or cost, for orders with foreign vendors, and whether the price has changed since the PO was created. It does not update the price in these cases.

Updates are not made if these conditions are met:

  • Purchase orders with foreign vendors
  • Return Merchandise (RM) purchase orders
  • The PO line price override flag is set to Yes, which indicates that a user manually entered a price on the PO line.
  • The Authorized replenishment path (ARP) vendor is checked in Product Warehouse Product Setup. The price is not updated if the vendor or ARP vendor is excluded from the Vendor range on the report.

Hierarchy for tied lines (updates are made):

  • Sales order lines where:
    • The PO transaction type is DO or AC.
    • The tied OE line is in ‘shipped’ stage or below.
    • The tied OE line is not for a Warranty exchange item.
    • The tied OE line is a special or a nonstock.
      Note: Special and nonstock kit component lines are updated as well.
  • WT lines where:
    • The PO transaction type is AC.
    • The tied WT line is in ‘shipped’ stage or below.
    • The tied WT line is a special or a nonstock.
  • VA lines where:
    • The PO transaction type is DO or AC.
    • The tied VA line is in ‘shipped’ stage or below.
    • The tied VA line section type is ‘Inventory’ or ‘External process.
    • The tied VA line is a special or a nonstock.
  • KP WO lines where:
    • The PO transaction type is AC.
    • The KP WO line is in below ‘built’ stage.
    • The tied KP WO line is a special.
    Note: Cost on tied transactions with foreign currencies are adjusted based on current exchange rates in SA Currency Setup.