BC rounding error when posting a sales order that has a paid prepayment invoice

Business Central/NAV Developers Forum
1

This is in BC V 19.5.36567.36841.

Created a prepayment invoice from a sales order and paid the invoice via the cash receipts journal. When attempting to ship and invoice the sales order am receiving the error “Amount xxx.xx needs to be rounded in Gen Journal Line Journal Template Name ‘’, batch ‘’, line 0”. G/L setup has rounding precision set to 0.01.

Has anyone seen this error? And how to address?

Thanks in advance!

PB

2

Paul,

Is their a Foreign Currency involved? I am thinking this might be the case. If that is not the case, I highly recommend putting a Microsoft Support ticket in via your Partner.

Hope this helps.
Thanks,
Steve

3

The error message you are encountering, “Amount xxx.xx needs to be rounded in Gen Journal Line Journal Template Name ‘’, batch ‘’, line 0,” indicates an issue with rounding precision during the invoicing process in Business Central (BC) version 19.5.36567.36841. Here are a few suggestions to address this error:

  1. Rounding Precision: Double-check the rounding precision settings in the G/L setup to ensure it is correctly configured as 0.01. Confirm that the precision is applied consistently across all relevant modules and journals.
  2. Journal Templates: Review the journal template settings associated with the error message. Ensure that the precision defined in the template matches the rounding precision set in the G/L setup. Verify that the template is correctly mapped to the appropriate transactions, such as sales orders and cash receipts.
  3. Rounding Methods: Consider checking the rounding methods used for prepayment invoices, cash receipts, and subsequent invoicing. Confirm that they are aligned and consistent throughout the process. Adjustments may be required to ensure proper rounding and minimize precision discrepancies.
  4. Testing Environment: Test the invoicing process in a separate environment, such as a sandbox or test company, to replicate the issue and validate potential solutions without affecting live data. This allows you to experiment with different configurations and settings to identify the root cause.
  5. Contact Support: If the issue persists or you require further assistance, it is advisable to reach out to the official support channels for Business Central. They can provide specific guidance based on the version you are using and offer insights or potential hotfixes related to the rounding precision error.

By following these steps, you should be able to address the error and ensure accurate rounding during the invoicing process in Business Central.