Hello all,
We have a handful of items that are counted every single day right now. I have been running these daily counts for about 2 months now. These items have a physical inventory counting period set as 'DAILY' which I defined as 365 counts per year, which is 1 per day.
The count is done the same daily by creating a physical inventory order, loading the items in by 'calculating the counting period' and selecting all the 'DAILY' items, then creating a recording, counting, finishing the recording and then finishing and posting the physical inventory order.
The problem is that every so often the 'next counting start date' is calculated wrong. It usually increments the next counting start date by 1 day after each count, so the next day all the items show they need to be counted again. But sometimes it will add a day and thus will not show as needing to be counted the following day.
For example, today (11/11/21), I just finished the count and instead of setting the next counting start date to 11/12/21, it set it to 11/13/21 therefore skipping a day. This seems to happen randomly. 
Sometimes I will go weeks without it happening, and sometimes it will happen twice in one week. I thought there might be some sort of time zone difference or something like that but I have completed the counts at all times during the day. In the morning, in the late afternoon, etc and they have all incremented the day by 1 just like it should. Then suddenly, like today, it will increment it by 2 for no reason I can find.
The obvious issue is that I have now developed the habit of clicking into many item cards after every count to verify the next date was calculated correctly which it sometimes is not. Also I have noticed other odd behavior with those dates. I have monthly counts that are counting periods set to 12 counts per year that seem to work correctly. I'll create a new item and set it to a monthly count, and it will immediately show I need to count that item this month. But then I have weekly and bi-weekly counting periods that will not behave the same. Setting a new item to weekly (52) or bi-weekly (26) will set the next count start date farther out in the future to the start of the next period and not the current period. So setting a new item to weekly will not show that I need to count that item this week, it will set the date to the next week for its first count. And I am limiting this to newly created items because changing the counting period on items that already have another counting period set is having some very bizarre behavior.
Has anyone else seen this happen or have a solution or just any other notes like does anyone know specificially how these dates are calculated and is it possible to manually change any of these dates? Also is there a way to change the counting period on items that already have a different counting period set in a way that isn't going to take hours clicking thru each item card? I set about 500 items to a monthly period and need to change them to bi-weekly, but you can only mass set a counting period to items that don't already have one set using the excel export method. Trying to change one will not work with excel because of the pop up message so the only way that it seems to do it is to go into each item card and changing it, but now that is made even more difficult because business central will no longer remember that I want the 'warehouse' menu expanded when opening an item card.
Sorry for the long post but I have come to the unfortunate conclusion that just maintaining my old massive excel sheet with manual entries is quicker and easier and I at least know I won't skip something. There doesn't seem to be an easy way to verify nothing is getting skipped or missed when it shouldn't.
