Program Description
This program can be found on the Purchase Order Reports menu (PO-4-10). The report can be printed from this menu or upon exiting the PO Receipts program (which is recommended). The report includes all receipt transactions entered through the PO Receipts program. Receipt transactions entered through Inventory Receipts are not included on the PO Stocking Report. The report provides a way to monitor the receipt transactions entered for a specific date, date range, or the current accounting month. The included receipt transactions can be specified by a specific or range or all vendors and purchase orders. It also provides the total received cost per item, purchase order, and vendor. When the quantity received is entered incorrectly in PO Receipts, corrections are made in Purchase Order File Maintenance. These corrections are included on the PO Stocking Report. The old and new average costs and old last costs are also included. This helps to fix incorrect costs that were written into the Item File.
The PO Stocking Report sorts in vendor number, purchase order number order. All of the items that were received are printed. Information printed per item is item description, Vendor Item Number, receiving warehouse, quantity received (using the P.O.'s pack multiple), the P.O.'s pack multiple, received last cost and extended cost (using the PO's pack multiple), date received, and the comment line for the item from the purchase order. Also included is the newly calculated average cost, and the old average and last cost. Note: These figures correspond with the Item File's pack multiple. If an item has a ship via of Direct Ship, D is printed next to the quantity received. A total extended received cost and quantity received is included for each purchase order and vendor. A grand total is also included. The report uses the Inventory Transaction file (IMWACTD) File. The information stored in this file is maintained on the system until a purge is run. The Inventory Transaction Purge is found on the Inventory File Maintenance menu (INV-3-7). The Initialize Index Files program, which must be run with the AR Billing End of Month Procedures, marks the current month's transaction as not a current month transaction. This enables the report to only include all of the PO Receipt transactions for the current accounting month. The PO Stocking Report can be included in the AR Billing End Of Month Reports. When this report is included, all PO Receipts for all vendors and purchase orders for the current month only are included. The packing slip or invoice can be compared to the report. When this is done, errors can be corrected on the same day.
When serial numbered items are received through PO Receipts, the actual serial numbers are not included on the PO Stocking Report when printing the report from the report menu. However, when the PO Stocking Report is printed from PO Receipts, the serial numbers are included. There is also the ability to view or print all received serial numbers from purchase orders on the Serial Number Receipts Inquiry/Report. The purchase order number that the serial numbered item was received on can be found on the PO Stocking Report and further detail found on the Serial Number Receipts Inquiry.
Results
The following screen display shows results for the current month, all vendors, and all purchase orders:
Rev 15 Changes
If the OEM Interface created the Purchase Order, additional information will print on the PO Stocking Report. The report will state “OEM Created” and print the Custody Order Number that was created and the Ship-To Customer Name linked to that PO. If the PO was not created by the OEM Interface, or if the OEM Interface is not activated, this information will not print.
Rev 14 Changes
N/A
Rev 13 Changes
With the addition of the ability to override the item description on the purchase order, a change was made to print the overridden item description of the line items where the description was overridden. If the description was not overridden, the item description from the Item data file (ITEM) will print.