Define inventory counting processes
This article describes the configuration of basic inventory counting processes by creating a counting group and a counting journal. It also shows you how to enable counting policies on a warehouse and item level. These tasks would typically be carried out by a warehouse supervisor. It is a prerequisite to have some existing released products and warehouses. If you're using a demo data company, you can run this procedure in the USMF company with any stocked item.
Create a counting group
In the navigation pane, go to Modules > Inventory management > Setup > Inventory > Counting groups.
In the Counting group field of the new row, type a value.
In the Name field, type a value.
In the Counting code field, select an option.
- Manual – Includes lines every time you run the job. In other words, you decide the counting interval for the counting group.
- Period – Includes lines for the period in the counting journal when the period interval has expired.
- Zero in stock – If on-hand inventory reaches zero (0), lines are generated in the counting journal when the job is run. If the on-hand inventory reaches 0 after a count, lines are generated the next time that you start the count.
- Minimum – Inserts lines in the counting journal if the on-hand inventory is equal to or less than the minimum that is specified.
- Optional: If you have specified Period in the Counting code field, you must type the interval for the period in the Counting period field. The unit for intervals is days.
- When you run the job for creating new lines in the counting journal, new lines are created at the interval specified in this field, regardless of how often you run the same job. For example, if Counting period is set to 7, and journal lines were last generated for a count on January 1, if another job is started on January 5, seven days have not passed and so no lines are generated in the journal for that period interval. If you start the job again on January 8, lines are generated for the period in the counting journal, because 7 days have passed.
Create a counting journal name
In the navigation pane, go to Modules > Inventory management > Setup > Journal names > Inventory.
In the Name field, type a value.
In the Description field, type a value.
In the Journal type field, select Counting. Optional: you can select a different voucher series ID if you want a specific number sequence for the voucher IDs generated when creating counting journals. Voucher series are created in the Number sequences page.
In the Detail level field, select an option.
- This is the level of detail that is applied when the journal is posted.
- Optional: you can change the value in the Reservation field. This is the method used to reserve items during counting.
- Manual – The items are reserved manually in the Reservation form.
- Automatic – The order quantity is reserved from the available, on-hand inventory for the item.
- Explosion – The reservation is part of the master planning of the transaction.
Set standard counting journal name
- In the navigation pane, go to Modules > Inventory management > Setup > Inventory and warehouse management parameters.
- Select the Journals tab.
- In the drop down menu of the Counting field, select the journal you previously created. This journal will then be the default journal name for inventory journals of the Counting type.
- Select the General tab. Optional: Select this option to lock an item during the counting process to prevent updates for packing slips, picking lists, or picking list registrations.
Set the counting policy for an item
- In the navigation pane, go to Modules > Product information management > Products > Released products.
- In the list, select the link for the Item number of the product that you want to set counting policies on. You must select an item that is inventory tracked. A non-stocked product can't be counted. If you are using USMF demo data you can select item A0001.
- Select Edit.
- Toggle the expansion of the Manage inventory section.
- In the drop-down menu of the Counting group field, select the counting group you previously created. This product will now be included when inventory counting journal lines are created using this counting group.
- Select Save.
Set the counting policy for an item in a specific warehouse
- On the Action Pane, select Manage inventory.
- Select Warehouse items.
- Select New.
- In the drop-down menu of the Warehouse field, select the warehouse you want to set up specific counting policies for.
- In the drop-down menu of the Counting group field, select a counting group. You can select a specific counting group that should apply to the item in the specific warehouse you have selected. When counting is performed in that warehouse, this counting policy will override the general counting policy for the item.
- Select Save.
Help us understand
Submit and view feedback for