Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Prepmt Line Amount Dis...
Small and medium business | Business Central, N...
Unanswered

Prepmt Line Amount Discrepancy Against PO Line Amount

(2) ShareShare
ReportReport
Posted on by CU27090506-0 29
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!
  • CU27090506-0 Profile Picture
    CU27090506-0 29 on at
    Prepmt Line Amount Discrepancy Against PO Line Amount
    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
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    Prepmt Line Amount Discrepancy Against PO Line Amount
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans