web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Exclude Item application entries from inventory Items that have been returned due to a defect

(1) ShareShare
ReportReport
Posted on by 8
Dear Community Experts
 
I have a Client that has inventory items for wich Item Ledger Entries are applied to each inventory transaction. One of the cases is, when a Customer of the Client returns an Item that has no worth, as it is broken or defect. When the return is posted, the sale, to which the Item has previously been applied is cancelled, so that the balance of his Inventory ledger higher than expected. Another case is, the Client has Inventory Items with no Inventory value, as those Items are accounted directy in the P&L. Is there a way I can exclude the item application for this exceptional cases? What is the best practice to deal with such cases? 

Your help will be much appreciated!
 
Many thanks
Juliana
I have the same question (0)
  • Suggested answer
    IB-29041624-0 Profile Picture
    1,191 Moderator on at
    If you have inventory that you want to reduce the inventory value for you should do what we call a revaluation.
    I did a blog post about that a while back where you can read about that process.
     
    For items that are broken I think there are basically two scenarios.
    In some cases you will get / request a credit memo from your vendor. And then that creditmemo will reduce the inventory on hand so you get the correct physical inventory and inventory value.
     
    If the company needs to take the cost them self I would recommend to adjust the inventory.
    That can be done in two ways. You can use the adjust inventory functionality as described here:
     
    Or you can post a transaction directly in a item journal.
    Then you will have to use the entry type of  "negative adjustment".
     

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,344 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,742 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans