You’re offline. This is a read only version of the page.
Good Morning All,
We have noticed recently that on some of our counts the COUNTEDQTY, no matter what is in the CAPTUREDQTY is pulling over to the variance.
| COUNTEDQTY | CAPTUREDQTY | IVDOCNBR | UNITCOST | VARIANCEQTY |
| 17.00 | 19.00 | V0000031204 | 4.07 | 17.00 |
| 8.00 | 4.00 | V0000031204 | 5.06 | 8.00 |
| 40.00 | 15.00 | V0000031204 | 2.20 | 40.00 |
| 400.00 | 576.00 | V0000031242 | 1.30 | 400.00 |
| 399.00 | 447.00 | V0000031242 | 2.06 | 399.00 |
| 207.00 | 202.00 | V0000031289 | 5.21 | 207.00 |
| 170.00 | 109.00 | V0000031289 | 5.49 | 170.00 |
| 1,604.00 | 1,572.00 | V0000031289 | 0.41 | 1,604.00 |
This is not happening to all cycle counts and I can't find the problem that is causing it. I searched the forums and didn't see anyone else with the issue.
Has anyone seen this happen before?
Most welcome. I'd glad to hear you at least found out what was happening and that it wasn't a GP issue.
Have a great week!
Angela
Okay. Sounds good.
Most Welcome,
Angela
Just to be clear. We don't reuse Stock Count Schedule ID's. They are built on the day of the count and the reuse box is unchecked.
We just loaded up test. I will test the counts that have errors and see if I can't duplicate the results.
Thanks for your help.
Shoot, it posted to inventory that way.
The only thing I can suggest is to identify those stock counts that have an issue then do the following:
1. Move the data into a TEST company and try to post the counts to see if you have the issue. If you do, try to do a new stock count off that same schedule and see if the issue continues. If it does, then I would delete the stock count schedule all together and create a new one. There has to be some odd corruption if it continues.
2. If you don't have the issue when moving into the test company after trying a new count, then it must have been something with the count data itself. Something went wrong, but hard to know what. As long as the issue doesn't continue with the schedule then you could leave the schedule alone and continue processing off it.
Let me know if you have questions! Good luck!
Angela
Thanks for the replay.
1. Just noticed it this yesterday. I was pulling cycle count info for a audit and pulled our first qtr.
2. I am currently testing all stock counts going forward to see what they say before they are posted to see if I can see anything.
3. Of the ones we found errors on 114 out 9594 lines, 104 were from one site. No Serial or lots. This is our largest site and makes up half our inventory.
4. No customization.
5. No Modified windows.
6. This are posted transactions. I looked in the item stock window and the entries are made just like the data above.
7. Manually. The users choose site and date. We have three month run where we import the count date in the items.
8. The cycle counts I have reviewed since yesterday haven't had a issue.
Hi,
This is interesting that your Counted quantity is pulling into the variance quantity. I personally haven't seen that in all the years supporting GP. Few questions to see if we can narrow in on the issue.
1. When did this start happening?
2. Have you tried to delete the Stock count and start a new one with the same items/sites to see if that continues to occur? (May want to try that in a test company for now just to see.)
3. Anything in common with these items? Are they serial/lots?
4. Are there any customizations with Inventory? Go to Microsoft Dynamics GP > Tools > Customize > Customization Status to grab a screenshot.
5. Is it a modified window? If yes, can you look to see if the unmodified window looks different?
6. Have you by chance posted any of these counts to see what value actually gets posted to GP?
7. How are the stock counts added? Is it all manually added and manually typed counts? Or were things imported?
8. Do you see the variance automatically change to counted qty when you type the counted qty and tab or does it look right at any point?
Thank you for using Microsoft Dynamics Communities,
Angela Ebensteiner
Sr Technical Advisor
Microsoft Dynamics GP
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (