Comments
If the Amount (LCY) field is made available in posted sales and purchase documents in future releases, it will greatly improve efficiency and accuracy, particularly in scenarios involving multi-currency invoices.We look forward to this field being included in the upcoming Business Central updates.
This method uses:Past Consumption Data (recent historical demand)Forward Consumption Proxy (demand transactions projected forward from prior comparable periods, e.g., last year)Weighted Contribution of both ranges to form a more adaptive and demand-sensitive ADU.Calculation ExampleSetup ParametersPast Period Days = 90Forward Period Days = 180History Days = 365Weight (Past) = 30%Weight (Forward) = 70%Step 1: Past ADU Total Issued (last 90 days) = 180 ADU₁ = 180 ÷ 90 = 2.0Step 2: Forward ADU Date Range: (today – 365) to (today + 180 – 365) Example: 25/09/2024 → 24/03/2025 Total Issued = 520 ADU₂ = 520 ÷ 180 = 2.88Step 3: Weighted Blended Mix ADU = (ADU₁ × 30%) + (ADU₂ × 70%) ADU = (2.0 × 0.3) + (2.88 × 0.7) ADU = 0.6 + 2.016 = 2.616