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

    • Feature - Buyer's Desk Inventory Class Selection Criteria

      Date Released: 11/1/16 When on the Buyer's Desk selection criteria screen, the user now has the ability to limit the items shown in the Item List screen by Inventory Class. 10. Inventory Class - The default is spaces. The valid options are spaces for ...
    • Feature - Added a Function "Create Inventory Trx CSV Import"

      Release date: 12/29/2016 Updated: 2/21/2017 Updated: 4/25/2017 Updated: 5/2/17 Added a function to IM / Maintenance / Item file / Create / Create Inventory Trx CSV Import to automate the receipt of inventory items thru returned inventory. This ...
    • BM1501 Bill of Material Feature/Option Configuration Maintenance

      BM1501 Bill of Material Feature/Option Configuration Maintenance ← Bill of Material / Work Order Plus Feature/Option Configuration File Maintenance Application Overview The Feature/Option Configuration File Maintenance application enables the user to ...
    • BM1601 Bill of Material Feature/Option Configuration Inquiry

      BM1601 Bill of Material Feature/Option Configuration Inquiry ← Bill of Material / Work Order Plus Feature/Option Configuration Inquiry Application Overview The Feature/Option Configuration Inquiry application provides an easy way to display various ...
    • Feature - Create Hold Trx when Posting Inventory Trx

      Release Date: 12/21/2020 Version 8.5 & Up In PO Warehouse Receiving File Maintenance, a "Create Alloc ?" flag exists to signify that during posting of the transactions a record will be created in the Hold Transaction file. That is to say that even ...