QRG - Inventory freeze and inventory history

QRG - Inventory freeze and inventory history

(A copy of the QRG with screenshots can be found here:  https://drive.google.com/file/d/1fISiGBI0u6aDtPd_9fC0sdZ8LcV726_y/view )

Introduction
To assure accuracy, inventories are periodically frozen in FINET to allow physical counts of the items in the warehouses. Currently, those with Inventory have selected to freeze entire warehouses to perform the count.  However, it is also possible to freeze subsets of the warehouse if necessary to count specific items without taking the whole warehouse offline. Regardless of full or sectional freeze, there are two pages that will assist  with the freeze process/understanding. They are the Inventory Freeze (INVF) and the new Inventory Freeze (INVFH).

Instructions
INVF is where the hand counts are entered if a discrepancy if found during a freeze. Then, the warehouse will be unfrozen with a reconciliation posting. A report is then run that would show what was changed. 

With the new INVFH all the information found in the report and more is available right in FINET. 

Each individual freeze will have an Event ID assigned to it when the batch job is run to freeze the warehouse (section). So,  when you are looking at the history of a warehouse you will see multiple event types. Know that each event type is an individual freeze of that warehouse or subset of the warehouse.

The INVFH, provide a number of options you can use for search criteria, but the most common one would be the Warehouse.

From the FINET search, in the ALL search button, click the drop-down and change the search to Page Code

In your updated search bar, you can now type INVFH to locate the inventory freeze history screen. 

The inventory freeze history page, provides number of options you can use for search criteria, but the most common one would be the Warehouse.

By searching by warehouse you can see all wall to wall freezes (full warehouse) and any subsection freezes, if any.

In the upper left corner of the search results you will see the number of recorded event types (that matched your search criteria) for the warehouse. Below that you will see each event type, and you can expand the  record line to see additional information if you have not selected to show them all through the gear.

On the right side of each line is a VIEW button. Selecting this will open the record line to see all the details.

The inventory freeze history will record changes, so there must be an actual count entered through and Inventory Adjustment (IA) transaction. 

When the freeze is removed through reconciliation posting, the INVF table records will disappear. However, they will not appear on the INFHV until the IA transaction is FINAL. 

The details also include a clickable link to the IA so you can see the creating transaction. Finally, from the results grid, you can export all the search results into an excel spreadsheet. Here you can download all Viewable columns or all available  columns. All available will provide much more information about each individual transaction. Downloading the data will give you a greater ability to manipulate the data to find what you are looking for.

    • Related Articles

    • QRG - Inventory Freeze and Inventory History

      Description and Purpose To assure accuracy, Inventories are periodically frozen in FINET to allow physical counts of the items in the warehouses. Currently, those with Inventory have selected to freeze entire warehouses to perform the count. However, ...
    • QRG - Item Transaction History

      Description and Purpose Have you ever wanted to know the specific history of a stock item and figuring it out was not easy? You would have to jump around to the various transactions and tables to assess what happened. FINET now has a new query page ...
    • QRG - Creating inventory payment

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1GBv1GsDsgW4yhk0o_2u7_OPLlwcVX8Ws/view ) Introduction The process is designed to allow the user to enter the quantity on the payment request when the Receiver (RC) ...
    • QRG - Inventory by Location Count and Date

      Description and Purpose When dealing with inventory, it is important to know the quantity you have and where it is located. This information is available through the Inventory by Location table, or ILOC. It is also important to establish a baseline ...
    • QRG - Inventory by Location Count and Date

      (A copy of the QRG with screenshots can be found here: https://drive.google.com/file/d/1Em5XDNQeop2_FLiyIzikQkkKWe9A6Vgk/view ) Introduction When dealing with inventory, it is important to know the quantity you have and where it is located. This ...