Click Inventory management> Journals> Item counting> Countingto open the Inventory journalform.

Press CTRL+N to create a new line, and enter the required details.

Note
For more information, see "Inventory journal (form)" in the Applications and Business Processes Help.

Click Linesto open Journal line, Inventoryform, and enter the required details.

Note
For more information, see "Journal lines, Inventory count (form)" in the Applications and Business Processes Help.

Click Functions> Create counting listto create the counting list. The empty cells in the Countedfield column are updated with the values specified in the On-handfield for each line.

Close the Journal line, Inventoryform.

In the Inventory journalform, click Print> Counting list (INV-3)to open the Printing counting list (INV-3)form.

In the Counting list creation datefield, select the counting list creation date.

In the Order numberfield, enter the order number for which the counting list is to be generated.

In the Order datefield, select the date of order for which the counting list is to be generated.

In the Inventory start datefield, select the starting date of the inventory counting period.

In the Inventory end datefield, select the ending date of the inventory counting period.

Click Officialsto open the Officialsform, and enter the required details.

In the Printing counting list (INV-3)form, click OKto generate the report using the MS Excel template.

Note
You can also view and print the posted counting list details in MS Excel format from the Counting list journalform ( Inventory Management> Inquiries> Journals> Counting list (INV-3)> Show).