How to adjust item quantity negative but with a zero stock value

(0) Share

Report

Posted on by Connexionz

Item journal allowed entry of a positive item quantity adjustment with no item value.

I need to reverse this but Item journals is not allowing to enter a negative item quantity journal with no item value. Have deleted the item value in the item journal but regardless of doing this the value posts the item value.

Can you do an item journal for a negative item quantity adjustment with zero item value?

I have the same question (0)

All responses (7)

Answers (1)

Connexionz 5 on at

Like (0)

Report

RE: How to adjust item quantity negative but with a zero stock value

I did the process to you have done also but on your last screen shot it is showing quantity adjusted and I had entered amount as zero but Dynamics when posting changed the amount from zero to current value of stock per item. Your last screen shot does not show the amount.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 90,017 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to adjust item quantity negative but with a zero stock value

Hi, I don't know if there is something wrong with my understanding, I just tested it in Item Journal, the quantity is negative, the amount is 0, it can be posted. Do you have any error messages? maybe different depending on the cost method.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Dallefeld 193 User Group Leader on at

Like (0)

Report

RE: How to adjust item quantity negative but with a zero stock value

Do you have multiple locations? Are you trying to clear just one location's non-zero value? I have used the above system for all costing methods.

Revalue Journal does not allow you to enter much data, you must use the Calculate Inventory Value Process. This process will prompt you to make sure that you have run a Cost Adjust. Then you populate the posting date, a document number, calculate per, etc. You can filter just the item(s) in question, etc.

Was this reply helpful? Yes No
Connexionz 5 on at

Like (0)

Report

RE: How to adjust item quantity negative but with a zero stock value

Have gone into the Revalue Inventory Journal but cannot get into the majority of the fields, can enter only date, item code, value. Therefore I think the Revalue Inventory Journal is not set up to work in our application of Dynamics.

Was this reply helpful? Yes No
MahGah 15,511 on at

Like (0)

Report

RE: How to adjust item quantity negative but with a zero stock value

Dallefeld Hi Kim

Any suggestion for Avg Costing?

Thanks

Was this reply helpful? Yes No
Dallefeld 193 User Group Leader on at

Like (1)

Report
RE: How to adjust item quantity negative but with a zero stock value

I've worked with Microsoft support on this several times and here are my notes:

Situation:

Total quantity is zero, total cost is not zero. Costing Method is not Average.

Solution:

You will enter and post a positive adjustment and a negative adjustment to offset the residual balance. With the process, we override the cost of the entries to force the balance offset. Then fixed data to stop additional cost postings.

Set Automatic Cost Adjustment to Never

If a negative balance exists, post a positive adjustment with quantity of 1 for the cost of the residual in the location. Then post a negative adjustment with quantity of 1 with an override on the cost of $0.00. This will close the quantity out and force a zeroing out of the balance.

If the inventory value balance is positive with no quantity, you will enter the positive adjustment for a quantity of 1 and $0.00 unit cost and post the negative adjustment with a quantity of 1 override the cost for the residual.

After posting the entries, you set Cost is Adjust to true in table 5804

Deselect the applied Entry to Adjust (set to False) for the positive item ledger entries in Table 32.

Run table 339 and set the Outbound Entry is Updated to True.

Steps 4,5,6 prevent adjust cost from running against the entries and changing the override cost amounts.

Once finished and all is set as desired, you may return setting for Automatic Cost Adjustment to its former setting

This process works, if you have any problems, I'm happy to help.

Was this reply helpful? Yes No
Suggested answer

JAngle 113 on at

Like (1)

Report

RE: How to adjust item quantity negative but with a zero stock value

Use the item revaluation journal to mark it at 0 value. You can do a calculation at item ledger entry level and pick that specific adjustment: docs.microsoft.com/.../inventory-how-revalue-inventory

Was this reply helpful? Yes No