web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Cycle Count posting Wr...
Finance | Project Operations, Human Resources, ...
Suggested answer

Cycle Count posting Wrong Quantities

(0) ShareShare
ReportReport
Posted on by CBSS1956 2

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?

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Angela Eckman Ebensteiner Profile Picture
    Angela Eckman Ebens... 1,216 on at
    RE: Cycle Count posting Wrong Quantities

    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

  • Suggested answer
    CBSS1956 Profile Picture
    CBSS1956 2 on at
    RE: Cycle Count posting Wrong Quantities

    Sadly it was user error. I don't know why, but the user that has been doing it for years, started moving over to the variance field and over writing the system generated qty.

    Thanks for all of your help.

  • Angela Eckman Ebensteiner Profile Picture
    Angela Eckman Ebens... 1,216 on at
    RE: Cycle Count posting Wrong Quantities

    Okay. Sounds good.  

    Most Welcome,

    Angela

  • CBSS1956 Profile Picture
    CBSS1956 2 on at
    RE: Cycle Count posting Wrong Quantities

    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.

  • Suggested answer
    Angela Eckman Ebensteiner Profile Picture
    Angela Eckman Ebens... 1,216 on at
    RE: Cycle Count posting Wrong Quantities

    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

  • CBSS1956 Profile Picture
    CBSS1956 2 on at
    RE: Cycle Count posting Wrong Quantities

    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.

  • Angela Eckman Ebensteiner Profile Picture
    Angela Eckman Ebens... 1,216 on at
    RE: Cycle Count posting Wrong Quantities

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,239

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 903 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 604 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans