Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Reverse the inventory loss that was posted at zero price

(1) ShareShare
ReportReport
Posted on by 5
Hi all,
 
We have an issue with inventory for one customer that is as below:
 
We have items which we hold as third part stock in a Legal entity. This stock arrives at the warehouse at 0 value. If we have an order from our customer, we raise a purchase order to our supplier for the stock. We therefore receipt the PO with a purchase price. We then write off the original third-party stock at zero value. However, because the item has the latest the purchase price and cost price parameter ticked, the write off pulls through the latest cost and therefore shows as a loss rather than 0. In this instance we want to reverse the negative cost, so it shows a nil when writing off.
 
My observations during investigation in order to reverse the loss:
 
- I thought I can post the transactions as below:
 
  1.  Post an Inventory adjustment entry with the same positive quantity at the same price that the original write-off adjustment was posted. This will create null the inventory loss amount but creates an increase in the stock for this item.
  2.  Turn off the Last cost price parameter and then post an inventory adjustment entry with negative quantity at zero price. So that this will write-off the quantity for this item.
But the system still defaulted the latest cost price (which is different from the original write off journal that Customer posted) to the Inventory journal lines which again created another inventory loss.
 
So please suggest me how this Inventory loss transaction can be written off at zero price so that quantity and inventory cost is zero. 

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 294 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 273

#3
Jonas "Jones" Melgaard Profile Picture

Jonas "Jones" Melgaard 177 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans