Skip to Content
avatar image
Former Member

How to adjust the Cumulative Value in Inventory Audit report?

Hi All Experts

I want to adjust the cumulative value by using the inventory revaluation. But it seems like the cumulative value would not take any effects.

capture.jpg (26.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 07, 2016 at 08:10 AM

    Hi Kimberly,

    Inventory Revaluation will only change the Cost Price of the stock in a certain warehouse. The cumulative stock will remain the same, only the value of that stock will change.

    To adjust the stock amount (number of pieces), you will have to use one of the documents that will do that, that best fits the situation:

    • Sales Delivery
    • Sales Returns
    • Sales Invoice (direct, not copy from delivery)
    • Sales Credit Note
    • Purchase Goods Receipt PO
    • Purchase Goods Return
    • Purchase A/P Invoice (direct, not copy from delivery)
    • Purchase A/P Credit Memo
    • Inventory Goods Receipt
    • Inventory Goods Issue
    • Inventory Inventory Transfer
    • Inventory Initial Quantities, Inventory Tracking, and Inventory Posting

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Johan

      Is there any way to adjust the stock cost without affect the GL and the quantity? I had used the goods receipt to receive 1 qty and the item cost but in the inventory audit report, the cumulative qty become 2.

  • Dec 08, 2016 at 01:20 PM

    Hi Kimberly,

    There is no way to adjust stock cost or quantity without affecting GL in some way.

    The Material Revaluation document that you tried to create did not change the value because 0 pcs x 1.362.348 = 0 stock value.

    Could you please elaborate a little bit on what you are trying to achieve?

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded