Preparing a Physical Inventory
This job aid contains instructions related to preparation of physical inventory.
Preparing a Physical Inventory Count
- Open the Prepare Physical Count (IN504000) form.
- In the Type ID box of the Preview tab, select the appropriate physical inventory type for counting.
- If the Warehouse box is not filled in, select the warehouse in which the count should be performed. A user can select a particular warehouse only if the physical inventory type does not intend for a particular warehouse.
-
On the form toolbar, click Generate PI.
The system generates the physical inventory document and opens it on the Physical Inventory Review (IN305000) form. Count the items on the list and edit the list if needed. -
On the form toolbar, click Save.
Exporting a Count Sheet to an Excel Spreadsheet
- Open the Physical Inventory Review (IN305000) form.
- In the Reference Nbr. box of the Summary area, select the identifier of the required physical inventory document.
- Make sure that the physical inventory document has the Counting in Progress status.
- On the table toolbar of the Physical Inventory Details tab, click Export to Excel.
- Open the downloaded file and review its contents.
Printing Count Sheets
- Open the Physical Count Sheets (IN620500) report.
- In the Reference Nbr. box of the Report Parameters tab, select the reference number of the physical inventory count.
- On the report form toolbar, click Run Report. The system opens the printable version of the count sheet.
- On the report toolbar, click Print to print as many copies of the count sheet as you need.
Printing Tags
- Open the Physical Count Tags (IN621000) report.
- In the Reference Nbr. box of the Report Parameters tab, select the reference number of the physical inventory count.
- On the report form toolbar, click Run Report.
- On the report toolbar, click Print to print the tags.