Histórico da Página

Accumulated DIC

When clearing a NF that has withholding in posting with multiple advance payments not configured for withholding, a single bill of type DIC is generated for the last cleared PA. The DIC will have the accumulated value of the difference of calculated taxes of the other PAs.

Example: Clearing between one 3 PAs without withholding X 1 NF with withholding

NF of BRL 1,000.00

With PCC in posting (4.65%) = BRL 46.50

Total Net Value = BRL 1,000.00 (value of NF) - BRL 46.50 (taxes in posting) = BRL 953.50

NF balance = BRL 1,000.00 

PA 1 of BRL 300.00

Without taxes

Net Value = BRL 300.00

PA balance = BRL 300.00

PA 2 of BRL 300.00

Without taxes

Net Value = BRL 300.00

PA balance = BRL 300.00

PA 3 of BRL 300.00

Without taxes

Net Value = BRL 300.00

PA balance = BRL 300.00

The routine performs the clearing calculation internally in three parts, as if it was clearing each PA separately, generating the DIC only in the last clearing.
 

1st clearing - Clear NF x PA:

NF balance = BRL 1,000.00 (NF balance) - BRL 13.95 (PCC generated in clearing) - BRL 286.05 (cleared value) = 700.00

Transaction: BRL 300.00

Generated the taxes configured in posting, in example, PCC in value of BRL 13.95 with calculation base of BRL 300.00

PA balance = 300.00 (PA balance) - 300.00 (cleared value) = 0.00

Value related to Difference of calculated tax: 13.95

*Important

As previously mentioned, the DIC is not generated at this time.

2nd clearing - Clear NF x PA:

NF balance = BRL 700.00 (NF balance) - BRL 13.95 (PCC generated in clearing) - BRL 286.05 (cleared value) = 400.00

Transaction: BRL 300.00

Generated the taxes configured in posting, in example, PCC in value of BRL 13.95 with calculation base of BRL 300.00

PA balance = 300.00 (PA balance) - 300.00 (cleared value) = 0.00

Value related to difference of calculated tax: 13.95

*Important

As previously mentioned, the DIC is not generated at this time.

3rd clearing - Clear NF x PA:

NF balance = BRL 400.00 (NF balance) - BRL 13.95 (PCC generated in clearing) - BRL 286.05 (cleared value) = 100.00

Transaction: BRL 300.00

Generated the taxes configured in posting, in example, PCC in value of BRL 13.95 with calculation base of BRL 300.00

PA balance = 300.00 (PA balance) - 300.00 (cleared value) = 0.00

Value related to Difference of calculated tax: 13.95

Generated DIC value = 13.95 (DIC calculated in 1st clearing) + 13.95 (DIC calculated in 2nd clearing) + 13.95 (DIC calculated in 3rd clearing) = 41.85

Total clearing without DIC generation

When clearing a NF that has withholding with PAs without withholding, in which the net value of NF is the total of PAs, the routine does not generate DIC.

Example: Total clearing between one 2 PAs without tax X NF with taxes

NF of BRL 1,000.00

With PCC in Posting (4.65%) = BRL 46.50

Total Net Value = BRL 1,000.00 (value of NF) - BRL 46.50 (taxes in posting) = BRL 953.50

NF balance = BRL 1,000.00 

PA of BRL 500.00

Without taxes

Net Value = BRL 500.00

PA balance = BRL 500.00

PA of BRL 453.50

Without taxes

Net Value = BRL 453.50

PA balance = BRL 453.50

Clear 1 NF x 2 PAs

Notice the net value of invoice is equal to the sum of PAs, thus no additional value was paid to the supplier:

The withholdings set to be calculated in posting will be generated. In the example, PCC in the value of BRL 23.25 related to the first clearing.

The withholdings set to be calculated in posting will be generated. In the example, PCC in the value of BRL 23.25 related to the second clearing.

NF balance = BRL 1,000.00 (NF balance) - BRL 23.25 (PCC Generated in 1st clearing) - BRL 23.25 (PCC Generated in 2nd clearing) - BRL 500,00 (cleared value of 1st PA) - BRL 453.50 (cleared value of 2nd PA)

1st PA balance = 500.00 (PA balance) - 500.00 (cleared value) = 0.00

PA balance = 453.50 (PA balance) - 453.00 (cleared value) = 0.00

We have no DIC generation

Example: Reversal of 2nd clearing (2nd PA).

When reversing 2nd clearing (2nd PA):

The withholdings generated will be deleted upon clearing. In the example, PCC in the value of BRL 23.25

NF balance = 500.00

PA balance = 453.50

The system evaluates the clearings previous to the last one reversed and identifies whether a new DIC generation is needed.

Generated DIC value = 23.25 (DIC calculated in 1st clearing) = 23.25

The DIC bill generated refers to the last clearing. In the above example it would be the 1st PA in the value of 500.

DIC Booking

You can book the addition of a DIC type bill through LP 510 (Accounts Payable - Addition of Bills).

You can book the deletion of a DIC type bill through LP 515 (Accounts Payable - Deletion of Bills).

Note: To book the LPs 510 and 515, the question: Book Online of routine Accounts payable (FINA050) must be set to Yes.

Process of DIC generation at time of reversal

For clearances with more than one bill, you can only revert/delete by clearing order. From the last clearing to the first, any different order of this routine will display a warning blocking the process.

When you reverse/delete the last clearing, the routine also deletes the DIC-type bill. After this process, a new DIC related to previous clearings is generated based on the last cleared PA if needed.

Example: Reversal of 3rd clearing

NF balance = BRL 100.00 (NF balance) + BRL 13.95 (PCC generated in clearing) + BRL 286.05 (compensated value) = 400.00
Transaction: BRL 300.00

Withholdings generated by clearing will be deleted. In example, PCC in value of BRL 13.95 with calculation base of BRL 300.00

Deletion of DIC generated by clearing with value of BRL 41.85 (accumulated DIC).

PA balance = 0.00 (PA balance) + 300.00 (cleared value) = 300.00

The system evaluates the clearings previous to the last one reversed and identifies whether a new DIC generation is needed.

Generated DIC value = 13.95 (DIC calculated in 1st clearing) + 13.95 (DIC calculated in 2nd clearing) = 27.90
At this point, a new DIC-type bill is generated related to the first and second clearing.

Example: Reversal of 2nd clearing

NF balance = BRL 400.00 (NF balance) + BRL 13.95 (PCC generated in clearing) + BRL 286.05 (compensated value) = 700.00

Transaction: BRL 300.00

Withholdings generated by clearing will be deleted. In example, PCC in value of BRL 13.95 with calculation base of BRL 300.00

Deletion of DIC generated by reversal with value of BRL 27.90 (accumulated DIC)

PA balance = 0.00 (PA balance) + 300.00 (cleared value) = 300.00

The system evaluates the clearings previous to the last one reversed and identifies whether a new DIC generation is needed.

Generated DIC value = 13.95 (DIC calculated in 1st clearing) = 13.95

At this point, a new DIC bill related to the last clearing is generated. In the example above, it would be the 1st PA with the value of 300.

• Parameter Settings
• Creation of DIC type
• HELP:FA340PALIQ / FA340PABRU
• HELP:NOTITSEL
• Clearing of PA Help NOCHADT
• Adaptation of FINA340 - Clearing NF X PA distinct taxes
• Rdmake to rectify incorrect posting sequence