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

Reservation Entries Double Counting in BC/PowerBI

(3) Share

Report

Posted on by RH

291

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

All responses (6)

Answers (0)

Suggested answer

Sohail Ahmed 4,741 on at

Like (1)

Report
Reservation Entries Double Counting in BC/PowerBI

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.
Suggested answer

Sohail Ahmed 4,741 on at

Like (1)

Report
Reservation Entries Double Counting in BC/PowerBI

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.
Gerardo Rentería Ga... 20,638 Most Valuable Professional on at

Like (0)

Report

Reservation Entries Double Counting in BC/PowerBI

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

YUN ZHU 85,503 Super User 2025 Season 1 on at

Like (0)

Report

Reservation Entries Double Counting in BC/PowerBI

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
RH 291 on at

Like (2)

Report

Reservation Entries Double Counting in BC/PowerBI

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!
Suggested answer

YUN ZHU 85,503 Super User 2025 Season 1 on at

Like (0)

Report

Reservation Entries Double Counting in BC/PowerBI

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