How To: Running the Trans History Report (03-64)

Overview

This tutorial describes how to run the Transaction History Report.

Before running this report, please see the Overview of this selection for important information regarding the accuracy of quantities on this report.

Step-By-Step

Click image to enlarge.

  1. In the ‘Item Number’ field, enter an item for the report.
    • Click the ‘Search’ button to perform an item search.

  1. From the ‘Store’ drop-down list, select a branch for the report, or select ‘All’ to include all branches.

  1. If a single branch was selected in the ‘Store’ field, the Last Physical Inventory Date automatically appears in the ‘From’ field. You can change it, but remember that it could lead to inaccurate quantities on the report.

    If there is no Last Physical Inventory Date or ‘All’ was selected in the ‘Store’ field, you will need to enter the ‘From’ date or select it from the calendar. In this case, all transaction history for the item will be included on the report.

  1. The current Start of Day Date appears in the ‘To’ field. You can change it, but remember that it could lead to inaccurate quantities on the report.

  1. Click the ‘Refresh’ button. The report displays.

Click image to enlarge.

  1. The following information appears in the fields at the top of the screen:

    2. Last Physical Inv Date
    This is the date of the last physical inventory.

    Qty Last Physical
    This is actual count quantity from the last physical inventory.

    Net Activity
    This is the item’s net activity (sold, returned, received, transferred, etc.) since the last physical inventory.

    System On Hand
    The is the current quantity on hand in the branch file (inventory store file).

    Deviation Last Physical
    This is the difference between the actual count quantity and the branch file quantity from the last physical inventory.

  1. Item activity appears in the middle of the screen and can include the following transaction types:
    • 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

  1. There are several ways to adjust the report view:
    1. Click the plus sign to the left of the transaction type to view details of the transaction.
    2. Click the ‘Expand’ button at the bottom of the screen to view the details of all transaction types on the screen. Once expanded, click ‘Collapse’ to hide the details of each transaction type.
    3. Click the ‘Detail’ button at the bottom of the screen view the details of all transactions without the option to expand and collapse the view. Click the ‘Summary’ button to return to the expandable and collapsible view.

  1. Click the ‘Print’ button to print a paper or digital copy of the report (optional). At the prompt, enter the ID of a physical printer, or enter “PDF” to save the report to a PDF file. If printing to a PDF, accept or modify the file name and click ‘Ok.’
    IMPORTANT: When printing to PDF, you must have a ‘Miscellaneous’ folder specified in Company PDF/Export Directory (30-04) or By Term PDF/Export Directory (30-05) in order for the PDF to save successfully to your computer.

  1. Click ‘Export’ to open the report in Excel and also save it to your computer (optional).
    IMPORTANT: You must have a ‘Miscellaneous’ folder specified in Company PDF/Export Directory (30-04) or By Term PDF/Export Directory (30-05) or a folder named “tyler” in the root directory of your C drive (“C:\tyler”) in order for the report to open correctly in Excel and successfully save to your computer.
Tags: