Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
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,144
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?
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 27,509 Super User 2025 Season 1 on at
    CMs not applying to item ledger
    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?
     
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,284 Super User 2025 Season 1 on at
    CMs not applying to item ledger
    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
  • rcboiler Profile Picture
    rcboiler 1,144 on at
    CMs not applying to item ledger
    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
  • Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,284 Super User 2025 Season 1 on at
    CMs not applying to item ledger
    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,144 on at
    CMs not applying to item ledger
    Same location, no bins, no item tracking.
     
    The items are open, so the worksheet does not help as you cannot remove/apply.
     
  • Jun Wang Profile Picture
    Jun Wang 7,679 Super User 2025 Season 1 on at
    CMs not applying to item ledger
    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. 
  • Valentin Castravet Profile Picture
    Valentin Castravet 27,509 Super User 2025 Season 1 on at
    CMs not applying to item ledger
    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
     

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,017 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,852 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans