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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

incorrect item balance in stock inquiry (URGENT!)

(0) ShareShare
ReportReport
Posted on by

Greetings friends..

is it me or everyone does have problems with inventory in great plains.

for this past few months until today most of our clients whose using Inventory control module.

encounter very similar problem. their item balance (Begbal) in inquiry stock is incorrect.

say we did adjustment in with qty 20. it goes well for several months.

but then one month we saw indiscipline.. the begbal went from 20 to 19.9996

10_2D00_21_2D00_2016-10_2D00_07_2D00_15-AM.png

I mean whats going on in here?? like yesterday it was fine but one day it completely change.

our clients was demanding why it happened? we have no idea and never encounter such a problem.

we checked in table IV10200, IV10201, and IV30300. three of them synchronize. and the amount is match.

reconcile didn't do much work. we tried to fix it by SQL, but it didn't match with HITB report.

can you give us suggestion how to fix it or how it can be happened?

*This post is locked for comments

I have the same question (0)
  • Praveen Kumar RR Profile Picture
    1,552 on at

    Hi,

    can you please check what is the decimal setup in Item Maintenance Window

    Thanks,

    Praveen

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at

    Hello Valen

    Hope you are doing well

    Although I have seen this issue quite often, the root cause is that a posting corruption occurred and resulted with improper and inconsistent data among the tables addressed above. There must be something out of Synch among them, and it needs to be corrected in order for the stock inquiry to provide correct output.

    The stock inquiry does complex calculations on the three tables, in order to come up with the cumulative stock movement report.

    Resolving this completely on all items as a preventive quality check requirements reconciling your inventory on an internal level, which means to implement procedures which matches quantity and cost among the tables, and report any glitch anytime.

    I have published several articles on my blog for that matter, and you may check for further in-depth and technical details.

    Please never hesitate to contact me on my e-mail for additional assistance.

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    on at

    Hi,

    I have the same issue can you please help me

    thank you,

    Mohd.shifan

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans