Feature - Inventory Snapshot
Create Inventory Snapshot has been added to IM, Reports, Stock Status Report, Stock Status By Item/Prod Cat. See the sample screen below:
Answering Yes to the prompt will create a snapshot of inventory at the time that the report is run. This is beneficial for financial departments at the end of the month to save the inventory valuation detail so it can be reconciled with General Ledger.
Before this enhancement, you could accomplish this through Freeze Inventory and print the Frozen Stock Status report, but the freeze function provides only one snapshot and the next freeze will override the previous one. 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. An option has been added to the Inventory Management, Reports, and Stock Status Reports menu.
An Inventory Snapshot Selection window will appear to allow you to 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, is changed from the default of Y to N, obsolete items will not print on the report because they were not captured when the snapshot was created. In this case, a warning will be displayed:
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