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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / CMs not applying to it...
Small and medium business | Business Central, N...
Suggested Answer

CMs not applying to item ledger

(1) ShareShare
ReportReport
Posted on by rcboiler 1,204
Have a couple of item ledger entries that are not being closed out and in turn we cannot close inventory periods.
 
Looks like the common element is that these are sales shipments that take the inventory negative and when they issue a corrective credit memo on the sales invoice that the credit is not offsetting the shipment record and in turn leaving the item ledger entry open.   Both records show (same date, correct quantities) but they CM is not applying to the sales shipment.  Can this be corrected thru a standard feature or do we have to manually correct?
I have the same question (0)
  • Valentin Castravet Profile Picture
    Valentin Castravet 31,481 Super User 2025 Season 2 on at
    Are both entries the same location? Same bin if you have bins? Same lot/serial no.? You can try to use the Application Worksheet to try to apply them together - Remove and Reapply Item Entries - Business Central | Microsoft Learn
     
  • Jun Wang Profile Picture
    Jun Wang 8,202 Super User 2025 Season 2 on at
    not sure if negative inventory is the normal business practices in your case. It's generally not recommended due to potential complications to inventory/costing. But you could try to use an inbound transaction such as a transfer order to offset the negative inventory. 
  • rcboiler Profile Picture
    rcboiler 1,204 on at
    Same location, no bins, no item tracking.
     
    The items are open, so the worksheet does not help as you cannot remove/apply.
     
  • Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at
    Hello rcboiler,
     
    If you have both entries in Item ledger entries open, then you could apply them through Application Worksheet like Valentin said.
     
    I did not understand what did you mean when you said that worksheet does not help as you cannot remove/apply? You will need to apply entries in this situation, or please say this another way so we can understand why you cannot use Appl Worksheet.
     
    Also, you can paste us that two rows from ILE so we can have a better info and solution for you.
     
    Greetings
  • rcboiler Profile Picture
    rcboiler 1,204 on at
    The two entries are open.  How can you apply them using the worksheet?
    Date Filter Item Filter Item No. Document No. Location Code Posting Date Entry Type Source Type Document Type Source No. Quantity Remaining Quantity Invoiced Quantity Reserved Quantity Shipped Qty. Not Returned Cost Amount (Actual) Serial No. Lot No. Open Positive Applies-to Entry Applied Entry to Adjust Entry No.
    06/01/24.. 154EP-200-125 154EP-200-125 154EP-200-125 800 6/7/2024 Positive Adjmt.       1. 0. 1. 0. 0. 45.41     FALSE TRUE 0 FALSE 554565
    06/01/24.. 154EP-200-125 154EP-200-125 S-SHPT150806 800 6/18/2024 Sale Customer Sales Shipment CB15780 -1. -1. -1. 0. 0. -45.41     TRUE FALSE 0 FALSE 557320
    06/01/24.. 154EP-200-125 154EP-200-125 PS-CR105008 800 6/18/2024 Sale Customer Sales Credit Memo CB15780 1. 1. 1. 0. 0. 45.41     TRUE TRUE 0 FALSE 558202
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at
    Hello,
     
    you can find more information on the links below.
     
     
     
    You can try to investigate these links, and if you have a specific question feel free to ask.
     
    Greetings
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 31,481 Super User 2025 Season 2 on at
    Your positive adjustment entry has the status of not open, so its applied to something. Usually this entry is applied to the sales invoice, but in this case its not as the sales invoice has the status of open. Can you select the positive adjustment entry and click on applied entries to see what its being applied to?
     
    Also, in the inventory setup page do you allow negative inventory? And in the sales & receivables setup page, do you have exact cost reversing set to yes?
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November 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,468

#2
YUN ZHU Profile Picture

YUN ZHU 923 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans