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 / Microsoft Dynamics GP (Archived) / Average Perpetual Inve...
Microsoft Dynamics GP (Archived)

Average Perpetual Inventory with Negative Item Quantity

(0) ShareShare
ReportReport
Posted on by Community Member

We use average perpetual valuation method for all our inventory item.

This month we saw discrepancies between Item Quantity * Item Current Cost with the GL Account, for some of our Items

How can we track what cause this?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Justin Sutton Profile Picture
    Justin Sutton on at
    RE: Average Perpetual Inventory with Negative Item Quantity

    Hello Hendry,

    How big are these discrepancies?

    If you are off by a few pennies in either direction, this would be normal. This can happen if the average is $80.01 when you have only $80.00 left in the GL account.

    A lot of information in regards to Average Costing can be found in KB 923960: support.microsoft.com/.../923960

    I would also recommend reviewing the HITB for this month and see it reconciles to your GL account. This report (printed in detail) also shows a lot of information that would help you track down differences.

    Edit: You can find this report by going to Reports -> Inventory -> Activity

    Please let me know if you have any additional questions on this.

    Justin Sutton

    ------------------------------------------------------------------------------------

    Microsoft Dynamics GP Support

    ------------------------------------------------------------------------------------

    **This posting is provided 'AS IS' with no warranties and confers no rights.**

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Average Perpetual Inventory with Negative Item Quantity

    The difference is big and I have spend the last 3 days tracking it in table SEE30303 which is HITB detail.

    The root cause is because we input inventory adjustment transaction backdate.

    The chronology

    1. We posted a lump sum item inventory adjustment out at current price (say $1) at the end of month document date
    2. We decide that we should have posted it in day wise quantity, so we posted another lump sum item inventory adjustment in at current price ($1) at the end of month document date  (to cancel the first transaction), to get our item quantity back.
    3. At this point the item quantity and current price is correct, going to GL Account summary also show correct amount
    4. Then we posted some inventory adjustment out at current price for several dates between the first of the month till end of the month.
    5. GP recalculate average moving cost for transaction #1, but not for transaction #2. This is the cause of GL account amount miss match.

    Solution:

    • use this query

    select * from see30303 where itemnmbr=<itemnumber> order by docdate,GLPOSTDT,SEQNUMBR

    and recalculate moving average price for each item receipt up to transaction #2. The formula is provided in KB 923960.

    • then use GP - Tools - Inventory - Adjust Cost and adjust the cost for transaction #2
    • GL adjustment will be created and once posted will correct the GL amount.

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans