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

Prepmt Line Amount Discrepancy Against PO Line Amount

(1) Share

Report

Posted on by CU27090506-0

134

Hello!

The BC environment I'm currently working on has the "Prepmt. Auto Update Frequency" field in the "Purchases & Payables Setup" page set to Daily. Some of Released POs automatically reverted to Pending Prepayment. It turns out that there are discrepancies between the Prepmt. Amt. Invoice and Prepmt Line Amount on the PO lines.

Can anyone please tell me what's causing the discrepancy on the Prepmt Line Amount?

Thanks!

I have the same question (0)

All responses (4)

Answers (0)

Sort by

KasparsSemjonovs 4,821 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

0,01 difference could be caused due to rounding, if the prepayment is split, but still I would think it could be a bug, or some wrong rounding setups.

Can You share more details? IS this SaaS or On-Prem (which version?)
Also Please send more details how the lines are created - what is the quantity, direct unit cost and what is the VAT % - that way we can try to replicate this scenario in different systems and check if the same result is given.

Also if You have any extensions/localization/external document management system integrated with BC - You can try to remove them in your test system, and try to repeat these scenarios.

Was this reply helpful? Yes No
CU27090506-0 134 on at

Like (0)

Report
Copy link

Link copied!

I'd like to focus on the third example I posted.

This PO was originally reverted to Pending Prepayment because of the .01 Prepmt Line Amount. We reopened this and corrected the decimal point. This PO was then released. However, after the warehouse user posted a receiving report for this PO, the .01 in the Prepmt Line Amount returned, causing the status of the Purchase Order to be reverted to Pending Prepayment.

SaaS, 24.4.22295.25119
Check Prepmt. when Posting : Disabled
Prepmt. Auto Update Frequency : Daily
Prepayment Invoice is not split.
Quantity: 152
Unit Code: MT
Unit: Metric Ton
Direct Unit Cost: 535.00
Line Amount: 81,320.00
VAT Posting Group: PUR_EXEMPT

Qty Received : 152
Qty to Invoice : 37.975
Qty Invoiced : 114.025

Prepayment %: 100
Prepayment Amt. Invoice : 81,320.00
Prepayment Line Amount : 81,320.01
Prepayment Amt. Deducted : 61,003.38
Prepayment Amt. to Deduct: 20,316.62

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,419 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Thanks for your question! The discrepancy you're seeing between the Preempt. Amt. Invoice and the Preempt Line Amount on the Purchase Order lines could be due to a few factors, especially when the "Preempt. Auto Update Frequency" is set to Daily.

Here are some possible causes:

Partial Prepayment Invoicing: If a prepayment invoice has been posted but not fully applied or deducted, the Preempt Amt to Deduct may not reflect the full amount, causing a mismatch.

Manual Adjustments: Any manual changes to the PO lines after the prepayment invoice was posted can lead to inconsistencies in the calculated prepayment amounts.

VAT Calculation Differences: Ensure that VAT is consistently excluded or included across all fields. Sometimes, rounding or VAT treatment differences can cause apparent discrepancies.

Update Timing: Since the update frequency is set to Daily, the system may not immediately reflect changes made during the day. Try manually triggering the update or reviewing the job queue to confirm when the last update occurred.

Prepayment % vs. Line Amount Logic: Double-check that the Prepayment % is correctly applied to the line amount excluding VAT. Any mismatch in the base amount used for calculation can result in differences.

If the issue persists, it might be worth reviewing the prepayment setup on the vendor card and the PO itself, or checking for any customizations that could affect this logic.

Hope this helps!
Please mark this response as helpful if it answered your question.

Best regards!

Was this reply helpful? Yes No
Suggested answer

Ahmad Subhani 660 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think so because we can control taxation at the time of Posting a Prepayment in the System and in the Final Invoice it gives us the adjusted value. Because of that it could occur.

Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No