Tickets older than 90days will be Auto-Archived. Ticket updates or comments will reset the timer.

Contract Number Heirarchy

NOTE: if Purchase Price Pages are used then they need to be considered also

Contract Numbers can exist in multiple places in P21. Here is the hierarchy for what will print on a PO.

Here are my findings for the contract number hierarchy. If there is a valid Job Contract it will look there and ignore the Sales Price Page. If there is no Job Contract it will start with the Sales Price Page. In both scenarios it then pulls Contract Numbers from Item Maintenance, first the Supplier by Location contract number, then Supplier Detail contract number.


If a job/contract and sales price page are present:

  1. Job Contract lower pane, PO Cost Mulitplier tab (job_price_line.pocosting_po_contract_number)
  2. Item Maintenance lower pane, Supplier by Location tab (inventory_supplier_x_loc.loc_contract_number)
  3. Item Maintenance lower pane, Supplier Detail tab (inventory_supplier.contract_number)

If there is only a sales price page:

  1. Sales Price Page PO Cost Mult Tab (price_page_po_cost_calc.contract_no)
  2. Item Maintenance lower pane, Supplier by Location tab (inventory_supplier_x_loc.loc_contract_number)
  3. Item Maintenance lower pane, Supplier Detail tab (inventory_supplier.contract_number) 

The following contract numbers were ignored:

  1. Job Contract lower pane, Items tab (job_price_line.customer_part_no)
  2. Sales Price Page, Sales Pricing tab (price_page.contract_number)

Creation date: 10/18/2022 10:29 AM      Updated: 10/18/2022 3:10 PM