Batch Inventory Transactions Page

Use this page to view existing batch files of inventory count records, delete batch files, generate physical inventory reports, and post a batch file's count records to your live database.

You can also access the following pages for performing the actions indicated:

Batch Inventory Transaction Detail Page

• Adding new batch files.

• Adding inventory count records to existing batch files.

Inventory Transactions in Batch Page

• Updating inventory count records.

• Deleting inventory count records.

Some of the above procedures can be performed in both pages.

Menu Path

From the Warehouse Inventory menu, select Entry & Processing. From the Periodic Routines menu, select Batch Inventory Transactions.

Action Bar Item

The Batch Inventory Transactions page's Action Bar displays the following item:

Physical Inventory Reports

Using the Batch Inventory Transactions page's Print item, you can generate two reports on the records in a batch file. Both reports enable you to compare the differences between physical inventory counts for stock items with the quantities stored in the Inventory Catalog.

Physical Inventory Edit Report includes all records in a batch file.

Physical Inventory Discrepancy Report enables you to enter criteria to select records based on the differences between the counts and quantities.
Based on the report data you can determine the catalog records that need to be updated by posting batch records to your live database.

Prerequisites to Post Batch Files

Before posting the inventory count records in a batch file, you should complete the following:

• Run a backup of the Warehouse Inventory database. Backing up your system allows you to restore your data if the posting produces undesired results.

• Generate the Inventory Catalog Summary option from the Reports menu so you can compare your posting results with the catalog's original entries. Use selection criteria limiting the report to the stock items being posted. For the procedure, refer to Inventory Catalog Summary.

• Generate the Physical Inventory Edit report. For the steps, refer to the Procedures section.

 
Following are the procedures you can perform in the main Batch Inventory Transaction page. For additional procedures that begin on this page, refer to the page noted in the introduction.

Generate Physical Inventory Reports

1. On the Batch Inventory Transactions page, select a batch, and click Print.

2. In the Physical Inventory Discrepancy Report page, select one of the following radio buttons, and then click OK.

   • Discrepancy - generates the Physical Inventory Discrepancy report. This option enables you to enter criteria for selecting inventory count records. Proceed to Step 4.

   • Physical - generates the Physical Inventory Edit report. Proceed to Step 5.

3. In the Search Criteria section, enter criteria in the following fields, and then click OK.

   Adj(usted) Quantity	References the difference between a stock item's inventory count and the item's catalog quantity.
   Adj(usted) Value	References the difference between the count's monetary value and the catalog's value.

   You can use query symbols in these fields. For example, entering >5 in the Adj(usted) Quantity field will match all records with differences greater than 5. Entering 5 by itself will only retrieve records with an adjusted quantity of exactly 5.

4. In the Print window, specify how to generate the report, and then click OK. The default file name is invdsc.rpt for the Discrepancy report and phys_inv.rpt for the Edit report.

Post Batch Files

1. Complete the procedures referred to in the Prerequisites for Posting Batch Files section above.

2. On the Batch Inventory Transactions page, select the batch you want to post, and then click Post on the Action Bar.

3. In the Confirmation dialog, click Yes.
   The Batch Inventory Transaction Posting page displays, listing the inventory count records that will be posted.

4. Click OK to post the batch's records.

   • If a data conflict prevents any records from posting, a message displays advising you to rerun the Physical Inventory Edit report.

   • For information on how posting affects the Inventory Catalog and generates accounting transactions, refer to Batch Inventory Transaction Pages.

Delete Batch Files and Inventory Count Records

1. On the Batch Inventory Transactions page, select the batch to delete.

2. Click Delete.

3. In the Confirmation dialog, click Yes.
   The batch and all of its inventory count records are deleted. For the procedure for deleting selected records in a batch, refer to Inventory Transactions in Batch Page.