Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Issue with Lot Tracking After Credit Memo in Business Central

Posted on by 8

Hi all,

I'm experiencing a lot tracking issue in Business Central, and I need some advice. Here's the scenario:

  • I cancel a sales invoice and post it as a credit memo. The associated lot number and quantity are reversed correctly.
  • When I create a new sales order and post a shipment using that same reversed lot number, the system processes the shipment as expected.
  • However, after processing the shipment, the system continues to show that lot number as available for selection, despite the quantity under that lot being zero.

This issue persists no matter how many sales orders I process, and the lot number remains available to assign to new sales orders. As a result, it's impacting my overall lot tracking, since the system isn't preventing the selection of lot numbers that should have no remaining quantity.

Has anyone encountered this issue before or have any suggestions on what could be causing it?

Thanks in advance!

Categories:
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Issue with Lot Tracking After Credit Memo in Business Central
    That screenshot is from another user, not the OP asking the question. 
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,377 Super User 2024 Season 2 on at
    Issue with Lot Tracking After Credit Memo in Business Central
    From the screenshot, it seems you are using a demo database? You could check the item tracking entries from item card to analyze how the system is tracking all the inbound/outbound transactions. Also check if the Prevent negative inventory flag on the inventory setup page. You also need to find out the qty on different locations of that item.
     
     
  • Ramiz Profile Picture
    Ramiz 275 on at
    Issue with Lot Tracking After Credit Memo in Business Central
    Hi,

    Kindly check if the posted shipment has Lot assigned or not.
     
    I repeated your scenario and all seems to be working correctly. If you have any customization check that as well.

     
  • nasirmahmood Profile Picture
    nasirmahmood 8 on at
    Issue with Lot Tracking After Credit Memo in Business Central
    Hi Jun,
     
    When I choose the lot with zero quantity and try to post, the system does not throw an error, and the shipment is processed as if the quantity is still available, which shouldn't be the case. This behavior continues even after multiple shipments using the same lot number with zero remaining quantity.
     
    it’s consistent across different items where credit memo was created using that item & Lot in the past.
  • nasirmahmood Profile Picture
    nasirmahmood 8 on at
    Issue with Lot Tracking After Credit Memo in Business Central

    Hi Valentin,

    Thank you for your reply.

    1. Yes, the item is shipped, and a shipment has been created from the sales order.
    2. To clarify, the lot was reversed with a quantity of 7000. I used this entire 7000 in my next shipment, meaning the available quantity should now be zero. However, when I create the next sales order, the system still shows the same 7000 units available for selection under that lot.

    Additionally, when I check the item master card and look at the "Item Availability by Lot" page, I can still see the 7000 units listed under the same lot.

     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 23,733 Super User 2024 Season 2 on at
    Issue with Lot Tracking After Credit Memo in Business Central

    Two possibilities:

    1. Are you sure the item is shipped rather than just added to an order? If it's added but not shipped, it will still be available for selection.

    2. Has the entire lot quantity been shipped, or is there still some remaining in inventory?

     

    Valentin Castravet
    Work: Zander ERP Services
    Blog: Dynamics 365 Business Central Insights
    LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

     

  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,377 Super User 2024 Season 2 on at
    Issue with Lot Tracking After Credit Memo in Business Central
    If the remaining qty is zero for a lot, it shouldn't be available for selection. In your case, if you choose the zero qty lot and post, do you get an error? I would suggest you test with another item. Also check if there might be any extension affecting the behavior.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans