3. Module Design
The Count Module consists of five main areas:
- Inventory count card,
- Count configuration interface,
- Count worksheet interface,
- Validation and analysis reports, and
- Posting/transfer routines.
Inventory Count Card
The Inventory Count Module allows you to define Count Cards for each count configuration. Count cards can be used to define and save inventory counts for each
location. A separate Inventory Count Card is normally created for each location, but you can specify multiple locations per count card if required.
|General||Allows you to specify and review basic information for the count, such as description, default location, and count date.|
|Sheets||Allows you to specify how count sheets are configured. Multiple count sheet configurations can be defined for each count card. See section 2.2 for detailed information on how to configure the count sheets.|
|Posting||Allows you to ser default settings for when the count is transferred to the journals.|
The “Process” ribbon includes the most common tasks when using the Count Module.
|Generate Count Sheets||Generates counts sheets for this count card.|
|Edit Count Lines||Opens all count sheet lines page for this count card.|
|Generate Recount Sheets||Creates recount sheets based on specified thresholds.|
|Copy Count to Journals||Copies the count differences to journals.|
|Update Next Count Period||When true, items copied to the journals will have their “Next Counting Period” field updated on the item or SKU.|
|Duplicate Count Config||Creates a new count card with the same configuration as the selected count card.|
|Phys Inventory Ledger Entries||Opens the Phys Inventory Ledger Entries page for this count card. This page shows all of the posted physical inventory ledger entries for this count card.|
Count Sheet Lines
The Count Sheet Lines page is the interface that is used to enter the inventory count.
The count worksheets can either be generated from the configuration page or created manually. A count worksheet is simply a list of items (with variant and location information) and a field to enter the count quantity.
Validation and Analysis
The Count Module provides several reports for validating and analyzing the count sheets and physical count.
|Uncounted Parts||Options on this report include:
Show Items not on Sheets – this option lists items that do not appear on any count sheets and provides an option to add them.
Show Items not Counted – this option lists items where no quantity has been entered into the count worksheet.
|Count Difference Analysis||Lists differences between expected inventory levels and the physical count. Can be sorted by either quantity difference or cost difference.
Allows full filtering on count sheet lines and can be restricted to show only items that have serial number or lot number issues.
|Parts with Modified Shelf No’s||Lists all parts that have had their shelf number field modified during the count.|
|Item Journal Test Report||Evaluates the entries in the physical inventory journal before posting. Performs more rigorous checks than the standard Dynamics 365 Business Central report, and ensures the batch will post before the user attempts to post.|
|Missing Serial No Details||Provides transaction details for counted items with missing serial numbers.|
Posting and Transfer
The Count Module uses the standard Dynamics 365 Business Central Warehouse and Item Physical Inventory journals, Consumption journal, and Reclass journal to post Inventory and WIP changes.
After the count worksheets have been validated, an authorized user runs the transfer functions to copy the Count Worksheet lines to the appropriate journals for posting. The transfer function copies those items that have differences between the on-hand and counted values.