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

Issue with Lot Tracking After Credit Memo in Business Central

(0) Share

Report

Posted on by nasirmahmood

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:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,505 Super User 2025 Season 2 on at

Like (1)

Report
Two possibilities:

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.

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/

Was this reply helpful? Yes No
nasirmahmood 8 on at

Like (1)

Report
Hi Valentin,

Thank you for your reply.

Yes, the item is shipped, and a shipment has been created from the sales order.

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.

Was this reply helpful? Yes No
nasirmahmood 8 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ramiz 597 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,505 Super User 2025 Season 2 on at

Like (0)

Report

That screenshot is from another user, not the OP asking the question.

Was this reply helpful? Yes No