Microsoft Dynamics GP Stock Count Calendar 2021 Error and Work Around
The Microsoft Dynamics GP Stock Count Calendar 2021 is used by the inventory manager to schedule which days are available for counting inventory. One task for the role of an inventory manager at the end of each year is to plan next year’s counting days. To accomplish this task, they will be using the stock calendar maintenance window to mark the down-days. Marking every day except for Friday as shown below for an example.
The design for the window allows the inventory manager to select every year up until 2020, but cannot select 2021 as needed to plan for that year.
Microsoft has submitted a design change for this window, but that change may not be ready for quite some time. Between now and then, what can we do? Stoneridge uses the spreadsheet below as a work-around for our customers.
Some simple formulas in a spreadsheet are used to generate an insert statement that can be executed by a member of the IT staff. Please contact us know if you need help or support for your Dynamics GP implementation.
Under the terms of this license, you are authorized to share and redistribute the content across various mediums, subject to adherence to the specified conditions: you must provide proper attribution to Stoneridge as the original creator in a manner that does not imply their endorsement of your use, the material is to be utilized solely for non-commercial purposes, and alterations, modifications, or derivative works based on the original material are strictly prohibited.
Responsibility rests with the licensee to ensure that their use of the material does not violate any other rights.