Cycle Counting in D365 for Finance and Operations Warehouse Management: Part 3
Part III: Resolving Cycle Count Variances
Inevitably, variances will occur in inventory value during cycle count. That is really the whole point of the cycle count. These variances will need to be reviewed and processed for the new values to be accounted for in the inventory valuation.
When cycle count work is performed by a worker who is not a cycle count supervisor (as indicated in the mobile device work parameters) and the counted value differs from the expected system value, the counting journal will not be posted. This work must be reviewed and accepted for the journal to be posted. This work can be found in the Warehouse Management>Cycle Counting>Cycle Count Work Pending Review. If the worker is a cycle count approver the work will be completed immediately upon entering the cycle count in the mobile device.
In the scenario below, a cycle count was performed at location FL-001 and item A0001. The on-hand quantity in 95 while the cycle count quantity came back as 100. The worker who performed the cycle count is not a Cycle Count Supervisor. Thus, the cycle count work can be found in Cycle Count Work Pending Review.
To review the work, follow the steps below.
- Go to Warehouse Management>Cycle Counting>Cycle Count Work Pending Review
- Select the work ID to review and click Cycle Counting in the Work tab.
- Review the on-hand and counted values. Click Accept or Reject. If accepted, the counting journal will be posted and the counted quantity will be reflected in inventory. If rejected, the counting journal will be cancelled and the quantity will remain unchanged.
- A counting journal was posted because that is the journal specified for cycle counts in Warehouse Management Parameters> Cycle Counting as the default journal type. You can view the posted journal in Inventory Management>Journal Entries>Item Counting>Counting.
About the Author
Tim Downie, AX Consultant
As one of Western Computer's Dynamics AX Consultants, Tim Downie is involved in every type of project from end user technical support to ERP consulting. With over 16 years of Information Technology experience, Tim is proud to be a creative problem solver for even the most complex business issues.
Based on this article, you may be interested in:
We’ve all heard plenty of stories about enterprise resource planning (ERP) implementations going south and the time and money it takes to fix mistakes after the fact. It’s enough to make any you pause before moving forward with a…Read More
Staying ahead of the curve is the name of the game when it comes to business logistics. How do we know? Well, for starters we have been working on Enterprise Resource Planning since 1987.Read More
When utilizing the cycle count functionality discussed in Part I, the Dynamics 365 for Finance and Operations Warehousing App must be used to execute actual cycle counts. In Part I, we discussed how to create the cycle count work. …Read More
There are a variety of costing methods to choose from in Microsoft Dynamics NAV. Depending on the chosen procedure, a costing practice will determine if a budgeted or actual value is used in the cost calculation and it will impact how the cost flow…Read More