Skip to main content

Notifications

Microsoft Dynamics GP forum
Unanswered

Item Stock Inquiry Beginning Balances

Posted on by 75,730

I was looking at the Item Stock Inquiry screen for a client and immediately noticed something that made no sense. Instead of seeing something like below I would see and increase adjustment of 100 but the balance was (25,000). So somehow the beginning balance had a value of minus 25,100. From where would that beginning balance value come?

pastedimage1576194042081v1.png

Categories:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Item Stock Inquiry Beginning Balances

    Here is an example of what I mean. The results you see at the bottom are from the IV30300 table for this item. The QTY on the first line of the Item Stock Inquiry grid should read 610 pounds and I have no idea from where the value for balance comes. Since this is the first transaction it should also be 610 pounds.

    pastedimage1576245670235v1.png

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Item Stock Inquiry Beginning Balances

    There is a local field called tcsFLCU_QTY_OUT in the grid which is the balance. Can anyone tell me the equation for that field? It appears to be a running total but in the case of this client it is starting out with some unknown value.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans