Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Inventory stock balance

Posted on by Microsoft Employee

At the stock status report I get message " a Revalued periodic cost item can result in a zero quantity and extended amount"

The valuation method for the item is FIFO periodic.

When I export out the transactions at iv30300 for this item, there is a balance for  item.

What is the theory here ?

Thank you

Sanjay

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory stock balance

    The Historical Stock Status report shows this comment regardless of the quantity, either if if it is zero or not. Prior to the HITB reset tool, several companies considered this report to reconcile IV versus GL. To me, that would be considered as an indicator or alarm to consider when matching GL with Historical Stock Status report, which actually has no effective link with GL.

    With the HITB reset tool and HITB tableI would personally rely totally on the Historical Inventory Trial Balance report.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Inventory stock balance

    Thank you Richard & Mahmoud,

    One supplementary question how does the inventory balance get zeroed out where the historical table show a balance.   Would it be due  selecting options to remove historical transaction transaction during  year end close ?

    select itemnmbr, LOCNCODE,BINNMBR ,QTYONHND,ATYALLOC from iv00102 where itemnmbr='itemnumber'

    -- Qtyonhnd is zero

    select SUM(trxqty) from IV30300 where ITEMNMBR = 'itemnumber'

    -- trxqty sum is not zero

    Inventory inquiry screen report balance as zero

    Inventory activity report  report do list all activity on iv30300

    And the inventory status report the extended amount is zero and extended quantity is zero.

    Thanks again!

    Sanjay

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Inventory stock balance

    Sanjay, So long no see.

    For periodic items, the historical stock status report prints out this notification per each line when the valuation method is precisely (4,5) which is; FIFO or LIFO periodic. As Mr. Richard explains, this is to ensure that having "extended amount" with "zero quantity" is justified.

    One more thing to get enlightened, this could result with the FIFO or LIFO perpetual as well, this case is thoroughly illustrated in the post below; HITB Essentials Series – Zero Quantity and Negative/Positive Cost

  • Verified answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: Inventory stock balance

    If you revalue the unit cost of a periodic item and do not make a matching GL entry, you can have dollars left in GL for the items.  Recent versions of GP provide a cost adjustment tool for periodic cost items that makes the matching GL entry.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans