Introduction: Trans History Report (03-64)

Overview

This selection is used to view movement history for a specific item number.

Special Notes

• This report can be viewed on the screen, printed to a laser printer, opened in Excel, or saved to a PDF file. You cannot print it to a spooler.
• You can sort a report column by clicking on the column heading.
• You can move a report column by clicking on the column heading and dragging it to the desired location.

Transactions

The following transactions are analyzed for this report:

• Sales Transactions
• P/O Receipts
• Updated Transfers/Receipts & Adjustments
• Transfers in Transit
• Transfers Not Updated
• Receipts & Adjustments Not Updated
• Sales Not Updated
• Shipped Not Updated
• Service Not Updated

Causes for Inaccurate Quantities

If any of the following conditions exist, the information on the report is likely inaccurate due to a difference in the quantity calculated by this selection and the actual branch file (inventory store file) quantity on hand:

• History files (RTPDEV, PO21H, or IT02H) have been cleared.
• The Purge Inv Trans History File selection (03-30-11) has been run and the history records used for the Physical Inventory Deviation have been purged; causing the records to no longer appear on the selection’s printout.
• The Physical Inventory Date was entered, failing to consider that the system assumes the physical count was taken prior to any business for that date.
• The Posting Files were loaded without a clean cut-off.
• The entered ‘From’ date for the report does not match the ‘Last Physical Inventory’ date for the selected item in the selected branch.
• The entered ‘To’ Date for the report is not the same as the system date, or transactions have been entered or shipped for a future date.
• Ticket days before the Posting File Cutoff Date were not updated at the time of Posting File Load, and tickets were added later.
• The Book Count was done incorrectly.
• Transaction(s) have been entered, but not updated in: Transfers, Receipts and Adjustments, Service, Order Processing, or Sales Transactions.
• Purchase order(s) have been physically received, but have not been entered in Receiving Entry (04-11).
• Damaged/salvaged items have been physically disposed of, but were never adjusted out of Tyler.
• A vendor changed an item number, but the item number was not updated in Inventory Master File Inq/Maint (03-01). As a result, the item is listed with two different SKU’s in Tyler.
• A physical count was completed, but not entered. The Posting File Load was never run to take a snapshot of the current Quantity on Hand (QoH), and daily processing was completed in the interim.
• An item is shipped to a customer with an incorrect item number.
• A purchase order is received from a vendor for inventory that is not set up in Master File Inquiry / Maint (03-01). Quantity on Hand (QoH) is not recognized upon receipt.