3. Module Design

3. Module Design

You are here:

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.

Inventory Count Card
FastTab Description
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.

Process Ribbon

The “Process” ribbon includes the most common tasks when using the Count Module.

Process Ribbon
Process Description
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.

Report Description
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.

Was this article helpful?
3.8 out Of 5 Stars

2 ratings

5 Stars 50%
4 Stars 0%
3 Stars 0%
2 Stars 50%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Need help?

Leave A Comment

Go to Top