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

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,266
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 32,526 Super User 2026 Season 1 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,212 Moderator 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,266 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,477 Moderator 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,266 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,477 Moderator 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 32,526 Super User 2026 Season 1 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,796 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 965 Super User 2026 Season 1

#3
Teagen Boll Profile Picture

Teagen Boll 664 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans