Inventory summary sheet
In [Inventory summary sheet], you can output an inventory summary sheet.
→To Operation Procedure
Screen Transition
[Inventory Control Module]
↓
[Forms]
↓
[Inventory Summary Sheet]
↓
[Inventory summary sheet] screen
Item setup
You can select the entry-enabled items in [Entry] as searching condition.
This section only describes items that need special explanations, including those items that are not displayed on the entry screen of [Entry].
-
Output type
Select either "By inventory valuation" or "By analysis code."
-
Valuation method (displayed only when "By inventory valuation" is selected in "Output type")
Select "Valuation method 1" or "Valuation method 2." It is the valuation method that is set up in [Inventory control setup] of
[Register goods] screen.
-
Goods/Goods set/Sub A/C
Select "Goods," "Goods set" or "Sub A/C" and enter the range of the code.
-
Manufacturing No./Analysis code 1, 2 (displayed only when "By analysis code" is selected in "Output type")
Select "Manufacturing No.," "Analysis code 1" or "Analysis code 2" and enter the range of the code.
-
Include scheduled (displayed only when "By analysis code" is selected in "Output type")
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