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

Reservation Entries Double Counting in BC/PowerBI

(3) Share

Report

Posted on by RH

396

Hello all,

How would you handle reservation entries if our system is Lot No. tracking oriented?
In BC, it appears that it will reserve the quantity/lot based on Item Ledger Entries, etc. However since it's based on Lot No., if this Lot is split between different bins, then the reserved amount on the reporting side will count for every line, bin, creating multiple entries as shown in photo below. The same Lot is in two separate bins as you can see split. The system is not allocating the bin yet (BC seems to not be able to reserve by exact Bin/Lot) so this shows up as a double count on our report in which Bin AK7 shows negative available afterwards.
In reality and in BC, it's only a total of 500kg reserved for this lot but since it's lot specific, it overlaps into each line. So if this Lot was split into 50 bins, it would show 50 times which is incorrect. Is there a way for the reporting to allocate correctly?

Is this some kind of formula issue in PowerBI that we can change?

Thanks in advance!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (0)

Report

If this is the case, you can count the number first, then divide the total by the counted number, which should give you the correct number.

Hope this can give you some hints.

THanks.

ZHU

Was this reply helpful? Yes No
RH 396 on at

Like (2)

Report

Hello Yun!

You mean for that column do a formula that does a total count of the reserved or? So for my example, total divided by the counted - doesn't that cancel each other out? 500/500=1?

Could you please elaborate on that?

Thanks!

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (0)

Report

I mean the item no. in AK3 and AK7 is the same, so sum=1000, count=2, 1000/2=500.

Sorry if my understanding is wrong.

Thanks.

ZHU

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,225 Most Valuable Professional on at

Like (0)

Report

Hi Reservation Entry table - Features that update the Reservation Entry table - Business Central | Microsoft Learn Best

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (1)

Report
The "double-counting" on your report for lot-tracked reservations across multiple bins is a reporting artifact, not a true double-reservation by Business Central. BC correctly reserves the total lot quantity.

To fix for reporting (e.g., Power BI):

Aggregate by Item No. and Lot No.: Sum your reserved quantities at the Lot No. level to get the correct total reserved for the entire lot.

Don't over-rely on bin-level detail for reservations before picking: Bin allocation happens later in the warehouse process.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,148 Super User 2025 Season 2 on at

Like (1)

Report
you can refer to:

Microsoft Learn - Design Details: Reservation, Tracking, and Action Messaging:
https://www.google.com/search?q=https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-reservation-tracking-action-messaging

Microsoft Learn - Design Details: Item Tracking:

(Explains how Lot Numbers and Serial Numbers are handled).

https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-item-tracking

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No