Inventory quantity summary sheet

[Inventory quantity summary sheet] outputs an inventory quantity summary.
→To Operation Procedure

Screen Transition

[Inventory Control Module]
  ↓
[Forms]
  ↓
[Inventory Quantity Summary Sheet]
  ↓
[Inventory quantity summary sheet] screen

Item setup

You can select the entry-enabled items in [Entry] as searching condition.
In this section, we comment only the items that you may particularly need some description, for example, some items that do not present on the entry screen of [Entry].

• Goods/Goods set/Sub A/C
  Select "Goods," "Goods set" or "Sub A/C" and enter the range of the code.
• Manufacturing No./Analysis code1, 2
  Select "Manufacturing No.," "Analysis code 1" or "Analysis code 2" and enter the range of the code.
• Searching items
  Select the left part and the comparison operator of the conditional formula from "Inventory Qty," "Difference of standard inventory quantity," "Difference of reordering point quantity," "Std inventory divergence rate" or "Reorder point accessing rate" and from "<=," "<," ">," or ">=," respectively. Enter then the right part (value).
• Formula
  Selecting the left part of "Searching items," the correspondent formula will be displayed.
• Include scheduled
  If you want to output the scheduled inventory data, check the check box.
• Inventory balance = 0
  If you want to output the inventory data even the amount is 0, check the check box

[Buttons]

• Refer
  Click the button at the time of specifying the name of a macro file, and you can make a reference of files in tree format.
• Start
  Click the "Start" button to open the [Output destination] screen. If necessary, click either "Excel output" or "Create CSV" button to output a list that conforms to the output condition.
• Clear
  
• Exit