web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Purchase Invoice uses [Invoice Rounding Account] with Pre-Payment (incl. Sales Tax)

(2) ShareShare
ReportReport
Posted on by 6

Hi Community,
I am working with a customer who uses the D365BC Pre-Payment Functionality on the Purchase Order

  • Prepayment Includes tax = yes
  • Prepayment % = 50
  • Currency Code = ‘’
  • Type on Line = Item (Inventory item)
  • Tax Liable = yes
  • Tax Details work out to calculate 12%

I tested this in their Canadian SaaS environment, as well as a Cronus (no customizations or extensions)

Purchase Order for 

  • Item (Inventory), 1 EA, $200 + 12% Tax, $224 incl Tax

Post Prepayment Invoice for 50%, including Sales tax

  • Debit: Vendor Deposits $113
  • Credit: AP -$113

Post Payment for Pre-Payment Invoice

  • Debit: AP $113
  • Credit: Bank -$113

Post Purchase Receipt

  • Debit: Inventory Interim $200
  • Credit: Accruals GRNI -$200

Post Purchase Invoice using “Get Receipt Lines”

  • Debit: Accruals GRNI $200
  • Credit: Inventory Interim -$200
  • Debit: Inventory $200
  • Credit: Direct Cost Applied -$200
  • Debit: Purchase Account $200
  • Credit: Vendor Deposits (two entries, -$100 and -$13)
  • Debit: Sales Tax $26
  • Credit: AP -$126 (should be -$113)
  • Debit: Invoice Rounding $13 (should not exist)

It gets even worse when I try to post the Invoice from the Purchase Order

  • Debit: Accruals GRNI $200
  • Credit: Inventory Interim -$200
  • Debit: Inventory $200
  • Credit: Direct Cost Applied -$200
  • Debit: Purchase Account $200
  • Credit: Vendor Deposits -$113 (one entry)
  • Debit: Sales Tax $26
  • Credit: AP -$98.31 (should be -$113)
  • Credit: Invoice Rounding $-14.69 (should not exist)
  • Teagen Boll Profile Picture
    4,348 Super User 2026 Season 2 on at

    Hi @RD-13100019-0, I don't know if this title aligns with the post. Is this a Business Central specific question?

     

    Best,

    Teagen Boll, CPA
  • Rico Dammann Profile Picture
    6 on at

    This is also not the text I entered. I have no idea who's post that is - it is not mine.
    I have updated it now again to reflect what I asked

  • Suggested answer
    YUN ZHU Profile Picture
    104,117 Super User 2026 Season 2 on at

    This looks like a potential issue with purchase prepayment and sales tax calculation in the Canadian version of Business Central. Since it can also be reproduced in a standard Cronus environment, I would recommend raising a support request with Microsoft to confirm whether this is a standard product issue.

     

    Thanks

    ZHU

  • Suggested answer
    Assisted by AI
    OussamaSabbouh Profile Picture
    20,851 Super User 2026 Season 2 on at

    Hello Rico,
    This does not look like expected rounding behavior. Microsoft documents that the posted prepayment should be automatically deducted from the final invoice, while the Invoice Rounding Account is intended for actual rounding differences; Microsoft also specifically warns about North American tax/prepayment issues at 100% prepayment, but your example is only 50%. With a $200 taxable order at 12%, a material $13/$14.69 balancing entry—and especially the fact that Get Receipt Lines and invoicing directly from the Purchase Order produce different results for the same transaction—strongly points to a standard application/localization issue rather than normal setup. Since you reproduced it in an unmodified Canadian CRONUS environment, I would first retest on the latest BC 28 update and, if unchanged, open a Microsoft support case with this exact reproduction; I would not use the Invoice Rounding Account as a workaround, because it would only hide the incorrect prepayment/tax calculation.

    Regards,
    Oussama Sabbouh

  • Suggested answer
    AndrewThomas81 Profile Picture
    3,289 Super User 2026 Season 2 on at

    Not sure on Canadian tax rules, but would you account for sales tax on the prepayment?

     

    Kind Regards 

      

    Andrew Thomas FCCA MCP 

    YouTube - Use Business Central 

    LinkedIn 

     

    If you found my answer useful, please mark it as verified 

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 645 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 432 Super User 2026 Season 2

#3
Teagen Boll Profile Picture

Teagen Boll 248 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans