Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Cost Variance

Posted on by 45
Dear All,Please help me to rectify this Issue. I posted a sales invoice with override option one item (say XXX)The cost of the item has gone Zero. (Okay)When the inventory item is purchased, and the quantity becomes positive, the cost of the item may be different .I can post journals to correct the entry, but I need to correct the entry in inventory In - out transactions.Inventory uses FIFO Perpetual for Costing. Please advise me to rectify this issue as auditors are reconciling the cost  transaction by transaction(item Transactions). Regards,

 

*This post is locked for comments

  • Gps-Support Profile Picture
    Gps-Support 45 on at
    Re: Re: Cost Variance

    Hi,

    This will not solve my proplem. The Cost adjustment will do when i have cost change in the purchase but the cost is correct for purchase.  Any other option?

  • Braam Koekemoer Profile Picture
    Braam Koekemoer 500 on at
    Re: Cost Variance

    Tools >> Utilities >> Inventory >> Adjust Cost

     

    Here you can adjust the incorrect cost and the system will prompt which journal to process.

  • Gps-Support Profile Picture
    Gps-Support 45 on at
    Cost Variance

    Listing the transactions in order

    Item TrxType Date Inqty Outqty Unitcost Cost
    XXX Sale 01/12/2008   10 1 10
    XXX Purchase 02/12/2008 15   2 30

    Trasactions are this much.

     If i see the Stock it will be 5 (qty)* 2unitcost) =10

    When the auditors will see the transactions, they will go transaction by transaction ,

    What they calculate is All Purchase - sales cost.

    Here in that case 30 -10 =20.

    My Problem is here. how I can correct the transactions, JV I can pass in financial, but when go back to Inventory transactions it remains the same. What transaction i should pass to correct this?

    Please advise,

    Thanks in advance.

  • Braam Koekemoer Profile Picture
    Braam Koekemoer 500 on at
    Re: Cost Variance

     

    I just try to understand your problem.

    Transaction 1 = The product was sold at zero cost with zero qty on hand, so lets say you sold 10, so the inventory went -10

    Transaction 2 = The product was received at e.g. 10 @ $20?

    Please confirm this and I will be able to assist you

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans