Skip to Content
0

How to adjust the Cumulative Value in Inventory Audit report?

Dec 07, 2016 at 06:32 AM

181

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Johan Hakkesteegt Dec 07, 2016 at 08:10 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0
Johan Hakkesteegt Dec 08, 2016 at 01:20 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Johan

Customer want to adjust the item cost in year 2015. But currently does not have any stock for this item.

Do you have ideas for the item cost and stock adjustment for previous year?

0

Hi Kimberly,

Do you mean that the customer 's system has been set to calculate profit by Cost Price ?

If so, you can adjust the cost price separately in documents, using the Gross Profit form.

Regards,

Johan

0