Dynamics Community Forum Thread Details

Issue with Lot No (Lot Deduction Not Correct)

Hello everyone,

We are facing an issue in Business Central related to Item Tracking (Lot No.) behavior during Transfer Orders.

The problem occurs when the user selects a specific lot to transfer — however, the system ends up deducting the quantity from another lot instead of the one selected.

Below is a detailed explanation of the scenario with attached screenshots for reference:

Attached Explanation (Screenshots):

Image 1:

A Transfer Order was created for item LA6JL35, transferring a quantity of 3 units.

Image 2:

The Item Tracking Lines page was opened, showing all available lots and their respective quantities.

Image 3:

The user selected Lot No. 225691328, which had a balance of 8 units before posting, and then posted the transfer.

Image 4:

A new Transfer Order was created for the same item.

Image 5:

When reopening the Item Tracking Lines page, we noticed that the previously selected lot (225691328) still shows the same balance (8 units), while the quantity was actually deducted from another lot, which previously had 5 units and now shows 2 units — even though this second lot was never selected.

Additional Notes:

The issue occurs intermittently, only when the item has multiple lots in the same location.

In Item Ledger Entries, the system shows the movement recorded under the correct lot (the one selected), but the quantity deduction occurs from a different lot in the tracking summary.

Expected Behavior:

When the user manually selects a specific Lot No. for transfer, the system should deduct the quantity only from that selected lot, not from another available lot.

Questions to the Community: