Inventory Stock Status Report of a Certain Date

Inventory Stock Status Report of a Certain Date

Release Date: 12/6/19
Version: All

Q - If I need an inventory report, do I need to run that at month end or can I run that at any point in the future for a date in the past?

A - An inventory status report for a date in the past is a very complicated animal. There are several ways to help your accounting department keep inventory stock status information.
  1. Use Defer Processing - Implement a Defer Processing task so you can schedule tasks to run at a given time, like running an inventory stock status report at the end of month, or on the first of every month. The Defer Processing reports are spooled to disk so you can later on go to the spooled reports manager to view your inventory stock status report at the end of a given month.
  2. Freeze Inventory at End of Month - You may use “Freeze Inventory” as a month-end procedure to take a snapshot of the inventory on a particular date and print to disk.  There's a separate "Free Inventory" Report that you can run to retrieve that snapshot value.
  3. Print Inventory Stock Status Report with a Snapshot – A user may print a Stock Status Report any time and keep a snapshot report in the database for future reprinting. Because there's no limit for the number of snapshots, this method is more flexible than "Freeze Inventory."
  4. Inventory Aging Report by Specific Date - A user may run an Aging Report for a specific date in the past. While this report is very flexible and does not require the user to defer, freeze or do a snapshot as in the previous three methods, running an inventory aging report for a specific date tends to be  slow.   In addition, it uses a different database table - a transaction audit file for inference on the “Quantity and Unit Cost” of a specific date. The accuracy of this report sometimes can suffer if the quality of the transaction audit file is in question. For example, purging of this table can be problematic for the accuracy of this report. Transferring  inventory between locations can affect the accuracy of this report when running it for a single location only. 


EMK

    • Related Articles

    • How to Run Inventory Stock Status Report for a Certain Date

      Release Date: 8/1/2017 Q - I am trying to run an inventory report by location as of 10/31/16. I know that the Stock Status is a live report generally, so I am not sure how I would do this. Is there a way? A - Generally speaking, there are three ...

    • IM26SCN Inventory Management Frozen Stock Status Report

      Frozen Stock Status Report Application Overview The Frozen Stock Status Report provides information on inventory levels "frozen" in the Freeze Inventory application. This report allows the user to go back and analyze inventory levels and values as of ...

    • IM19S1 Inventory Management Serial/Lot Stock Status Report

      Serial/Lot Stock Status Report Application Overview The Serial/Lot Stock Status Report tracks serial/lot items received into inventory. It lists each item's location, received date, batch numbers, purchase order number, and allocation status. It will ...

    • IM06SCN Inventory Management Stock Status Report

      Stock Status Report Application Overview The Stock Status Report is used to print out stock status information about a selected item or range of items by location and product category. The report can be printed for All locations or for a range of ...

    • IM0500Q Inventory Management Stock Status Inquiry

      Stock Status Inquiry Application Overview This function provides you with a wealth of customer service information available by using Function Keys. For maximum benefit, the users should thoroughly familiarize themselves with the many item inquiry ...