Inventory Zero Balance Report

 

Function

Use this task to create a report showing all items that are currently out-of-stock (those with a zero balance.) This report can be created to show items that went out-of-stock as of a specific date, and currently remain out-of-stock. The information can help avert potential inventory shortages or computer errors. The physical verification of the out-of-stock items that appear on this report can be used to compliment inventory cycle counting.

 

=> To access this task...

Select Inventory Zero Balance Report from the Reports menu.

 

Inventory Zero Balance Report menu

Inventory Zero Balance Report

 

About the Fields

 

In the Last Run Date field...

Display only. Shows the date that the report was last generated.

 

In the Which 0 Bal Items field...

  • Select All Records (A) from the drop down list to display all items out of stock.

  • Select Only Since Last Run (R) from the drop down list to display all items that have gone out of stock since last run date.

  • Select Only Since Process Date (P) from the drop down list to display all items that have gone out of stock since process date.

  • Select Since System Date (S) from the drop down list to display all items that have gone out of stock since system date.

In the Report Date field...

  • Enter a date. The report will display only items that are currently out-of-stock and that went out-of-stock on or after the date entered.

Note: If you run this report less than daily, the Since date will only be accurate within the time period that you last ran the report. For instance, if you run the report weekly, you can only report on items that went out-of-stock within that week, not on a specific day.

 

In the Report Sequence field...

  • Select Item Code (I) from the drop down list to create the report in item number sequence.

  • Select Product Type (P) from the drop down list to display in product type sequence.

  • Select Cycle Code (C) from the drop down list to display in cycle/location sequence.

In the Beginning/Ending Product Type ...

  • Enter the type of the first/last product to include on the report.

  • Press [Tab] to select the first/last product type record.

  • Click Click to select from a list of product types.

When done making selections...

  • Click Run Process button to create the Inventory Zero Balance Report.

  • Click Clear Form button to clear the form and re-enter options.

Inventory Zero Balance Report output

Sample Inventory Zero Balance Report

 

See Output Options.

 



______________________________________________________________________________________

Copyright BASIS International Ltd. AddonSoftware® and Barista® Application Framework are registered trademarks.