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 ...

    • Feature - Stock Analysis Processing

      Release Date: 10/28/16 This new feature is available under COP -> Processing -> Pick/Pack Tickets/Ship Labels-> Stock Analysis. This new feature is only available when the QTYAVAILBYCOMP, QTYAVAILBYCOM2 and QTYAVAILBYCOM3 attributes are in use. These ...

    • Feature - Order Ship Status Auditing Report

      Release Date - 7/14/16 The Order Ship Status Auditing Report is available under COP -> Processing -> Pick/Pack tickets & Ship Label -> Shipping -> Order Ship Status Auditing Report. The feature gives the user the ability to reconcile EDI orders ...

    • IMAGESCN Inventory Management Inventory Aging Report

      Inventory Aging Report Application Overview The inventory aging report can provide the current inventory data breakdown into multiple aging buckets, like 30, 60, 90, or over 90 days. The period is user definable in Global Setup and can be overridden ...

    • Limitations for Inventory Aging Report

      Release Date: 08/15/2018 The Inventory Aging Report is a very valuable tool. It is primarily used to determine the aging of the inventory for all locations for the current date, but you could use it for a specific location or use it to determine the ...