Withholding Rounding

01. OVERVIEW

The calculations for withholding bills generated by the Financials, Billing and Purchases modules are performed differently at the posting time.

While bills generated by the Financials check the rate fields from the nature registration (table SED), bills generated by the Billing and Purchases modules recalculate their percentage due to the possibility of entering different rates in their items.  The calculation applied in these cases is the withholding calculated value divided by the invoice total value, resulting in the rate percentage.

02. OBJECTIVE

This document aims to explain the difference between the bill withholding calculations from the Financials, Purchases and Billing modules at posting time.

03. BILL ADDITION EXAMPLE

With the PIS, COFINS, and CSLL withholdings configured to be deducted at posting (parameter MV_BR10925 for the accounts receivable portfolio, and MV_BX10925 for the accounts payable portfolio), we add an invoice for BRL 1,327.50.

Calculation example with rounding parameters (MV_RNDPIS, MV_RNDCOF, and e MV_RNDCSL) set to ".T." (round the values).

Invoice Addition (E1_VALOR): 1,327.50

• PIS calculation (E1_PIS):

1,327.50 x (0.65/100) = 8.62875

Rounding: 8.63

• COFINS calculation (E1_COFINS):

1,327.50 x (3.00/100) = 39.825

Rounding: 39.83

• CSLL calculation (E1_CSLL): 

1,327.50 x (1.00/100) = 13.275

Rounding: 13.28

04. BILL POST EXAMPLE

The calculation is performed differently for bills originated directly from the Financials module and bills originated from the Billing and Purchases modules.

Partially posting the bill entered in the previous item.

Post example for a bill originated by the Financials module:

Example of post for a bill coming from the Billing module