Open Purchase Order Commodity Line Work Inquiry (OPWK)

Open Purchase Order Commodity Line Work Inquiry (OPWK) is identical to Open Purchase Order Commodity Line Inquiry (OPPC), and contains the data from Open Purchase Order Commodity Line Inquiry (OPPC) that was adjusted when the Receipt of Stock Adjustment (AFINEPRS) program was run. It serves as a snapshot of input data to the Receipt of Stock Adjustment program.

You can browse this window in the same manner as Open Purchase Order Commodity Line Inquiry (OPPC) to view the adjustments made and the actual input to the Receipt of Stock Adjustment program. This data is only available if the purge step is omitted from the commands that execute the Receipt of Stock Adjustment program and is only valid for the most recent run of the program.


Vendor	Key field. You can enter the vendor number about which you are inquiring.
Transaction ID	Key field. You can enter the transaction ID that identifies the document, if you are interested in viewing a specific vendor/order combination.
Line Number	Key field. You can enter the number of the order commodity line, if you are interested in a specific line.
Account Line	The accounting line that this commodity points to as a source of funds is displayed. Only used when the Extended Purchasing Subsystem is installed with linking turned on.
Commodity/Item	The commodity code which uniquely identifies the goods ordered and the item code that identifies the goods ordered as warehouse stock is displayed. The commodity and item combination must be valid on Inventory (INV3).
Description	The description of the commodity line is displayed.
Unit	The unit of measure used to order the goods (box, each, dozen, etc.) is displayed.
Eligible for Auto PV	This field indicates whether you can pay purchase orders through the EPPV process.
Manuf Number	The manufacturer's number for this commodity line is displayed.
Name	The manufacturer's name for this commodity is displayed.
Text Flag	This field shows what kind of additional text is associated with this commodity line. Valid values are: Standard [S] Standard text Custom [Y] Non-standard text No Text [blank]
Bid ID, Bid Line	If this order references a bid, the ID and line number are displayed.
Quantity Ordered	The quantity of goods ordered on this line is displayed.
Unit Cost	The discounted cost per unit of goods ordered is displayed.
Total	The quantity of units multiplied by the discounted price per unit plus tax amount and freight amount for this line is displayed.
Quantity Paid	The quantity of goods paid for against this commodity line is displayed.

Cost Details View


Original Unit Cost	The original cost per unit of goods ordered (to three decimal places) before discounts are added is displayed.
Last Unit Cost	The most recent cost invoiced against this order line is displayed.
Discount Code	The purchase order discount code applied to this commodity line is displayed.
Discount %	The percent of discount applied to this commodity line is displayed. If a discount code is not used, this field is zero.
Discount Amount	The total discount amount for the sum of all commodity lines is displayed.
Pre-Tax Amount	The total amount calculated for this line (unit cost multiplied by quantity), before tax is added is displayed. This value factors in discounts.
Tax Code	The tax code used to compute the document's tax amounts is displayed. See Tax Code (TAXT) for this code and corresponding rate.
Tax Amount	The amount of tax calculated from the pre-tax amount multiplied by the tax rate associated with the tax code is displayed.
Freight Amount	The current commodity line of freight charges for this line is displayed.

Received View


Quantity Received	The quantity of goods received against this commodity line is displayed.
Receipt Condition	Displays a code indicating special conditions associated with the receipt of goods from this line. This field is updated when goods are received.
Final Receipt	Final [F] is displayed if all goods have been received. Partial [P] is displayed if only some of the goods have been received. Unreferenced [blank] is displayed if none of the goods have been received.
Total	The total dollar amount of goods received against this line is displayed.

Invoiced View


Quantity Invoiced	The quantity of goods invoiced by the vendor against this commodity line is displayed.
Invoice Condition	A code to indicate special or unusual circumstances with the invoice referencing this line is displayed.
Final Invoice	Final [F] is displayed if all goods have been invoiced. Partial [P] is displayed if only some of the goods have been invoiced. Unreferenced [blank] is displayed if none of the goods have been invoiced.
Total	The total dollar amount invoiced against this order line is displayed.

Forward Transaction View


Last Forward Transaction ID	The transaction ID of the most recent vendor invoice, receiver, payment voucher, or manual warrant document that referenced this purchasing document is displayed.
Date	The acceptance date of the most recent vendor invoice, receiver, payment voucher, or manual warrant document that referenced this purchase document is displayed.