Feature - Inventory Snapshot

Feature - Inventory Snapshot

Release Date - 2/11/16

A new option, Create Inventory Snapshot, has been added to the IM -> Reports -> Stock Status Report -> Stock Status by Item/prod cat.  See sample screen below:



Answering Yes to the prompt will create a "snapshot" of inventory at the time that the report is run. Financial departments like to do this at the end of the month to save the inventory valuation detail to reconcile with General Ledger.

Before this enhancement, users can accomplish this through the Freeze Inventory application and print the Frozen Stock Status report. But the freeze function provides only one snapshot and the next freeze will override the previous freeze. With the new snapshot function, you can have as many snapshots as you want.    

This option is not available when printing the report in product category order or if you choose the F1=Enter by Individual Item No when entering the starting item number.


This snapshot can be created many times and will store the data printed on the Stock Status report. This information is stored in two new tables, IMSSIHDR and IMSSIDTL. 

A new Snapshot Stock Status report will print this captured data. A new option has been added to the Inventory Management-> Reports-> Stock Status Reports menu.


When choosing this option, the user will pick which snapshot should be used to generate the report. 


The available snapshots are shown in descending order with the latest snapshot listed first. This selection screen also shows all of the report options that were used when the snapshot was generated. The report will print inventory quantities from the time of the snapshot and not the current inventory values. Once a snapshot is chosen, the snapshot options are returned to the report parameter screen.


The report parameter screen shows the chosen snapshot and the parameters default to the ones chosen when the snapshot was originally created.

The report options can be changed, but the program will only print data from the snapshot. For example, if option 9. Exclude Obsolete Item defaulted to Y. If this option is changed to N, obsolete items will not print on the report because they were not captured when the snapshot was created. In this case, the user will see the following warning:


If the snapshot was created for all items and the user runs the report for only one item, the user will not receive a warning and the report will print the requested information since the item should be available in the captured data.


Modified Programs: IM06SCNM, IM06S1, IM06P1, IM06SCN 
New Programs Added: IMSNPGEN, IMSNPSCN, IMSNPLST, IMSSIHDR.SL, IMSSIHDR.FD, IMSSIHDR.WS, IMSSIHDR.DS, IMSSIHDR.IO, IMSSIDTL.SL, IMSSIDTL.FD, IMSSIDTL.WS, IMSSIDTL.DS, IMSSIDTL.IO

CLS



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

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

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

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

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