532 Post Bills per Payment Bordereau

01. OVERVIEW

The standard entry 532 (Accounts payable - bill post per bordereau) is used to account for all payments made to bills in a bordereau. In this document, we will exemplify its use and main concepts.

02. EXAMPLE OF USE

Standard entry configuration:

	Sequence 001
Entry type	3 - double entry
Debit Account	SE2->E2_DEBITO
Credit Account	SE2->E2_CREDIT
Entry Value	SE5->E5_VALOR
History	"Pagamento do titulo "+ SE2→E2_NUM+SE2→E2_PREFIXO+ " no borderô" + SE2→E2_NUMBOR
Origin	"532-001"

It can be used both in the accounting of the bill associated with the bordereau and in the accounting of the total value of the bordereau (variable VALOR)

	Sequence 001
Description	LP532 - BORDEREAU POSTING - BILL TO BILL
Entry type	1 - debit
Debit Account	SA2->A2_CONTA
Credit Account
Entry Value	SE2->E2_VALLIQ
History	"BAIXA TIT "+SE2->E2_NUM+" REF BORDERO "+SE2->E2_NUMBOR+" DT "+DTOC(SE2->E2_DTBORDE)

	Sequence 002
Description	LP532 - BORDEREAU POSTING - BORDEREAU TOTAL
Entry type	2 - credit
Debit Account
Credit Account	SA6->A6_CONTA
Entry Value	VALOR
History	"BAIXA REF BORDERO "+SEA->EA_NUMBOR+" DT "+DTOC(SEA->EA_DATABOR)

Offline Accounting Behavior (CTBAFIN)

Example situation: In the same date, generate 2 payment bordereaux, each with 2 bills for BRL 1,000.00, and perform automatic posting;
- Total of each bordereau: BRL 2,000.00;
- Total for all bordereaux: BRL 4,000.00

When the Offline Accounting (CTBAFIN) is performed by Bordereau Total with the separator By Period or By Process:
1. A single document displays entries for each bill posting (4 debits for BRL 1,000.00) and one single bordereaux totalizer (1 credit for BRL 4,000.00);
When the Offline Accounting (CTBAFIN) is performed by Bordereau/Bordereau with the separator By Period or By Process:
1. A single document displays all postings (4 debits for BRL 1,000.00) and 2 bordereau totalizers (2 credits for BRL 2,000.00);
When running the Offline Accounting (CTBAFIN) using the By Document separator:
1. Each bordereau is separated in an accounting document;
2. Each document displays the posts (2 debits for BRL 1,000.00) and the totalized bordereau (1 credit for BRL 2,000.00);

Note: Since the VALOR variable is a totalizer, the accounting of the entries that use it will not contain positioned data from tables SE2 and SE5. This is to avoid entry duplication.

03. MORE INFORMATION

Accounting CNAB LP530 and LP532
Difference between LPs 521 and 532

Important

Bordereaux: For regular bills, the standard entry is 532. For advance bills, the standard entry is 513.

Bills with "Cash" as generator fact (in posting) generated by the bordereau must be accounted by LP 530.

Note: If the "Account by?" parameter is set to "Bordereau/bordereau", LP 513 will not be accounted.

04. AVAILABLE ACCOUNTING VARIABLES

VALOR - Variable that totals the payment amounts made on the bordereau's bills - available at online and offline accounting;
VALOR2 - Variable that totals the discounts applied on the bordereaux payment - available at offline accounting;
VALOR3 - Variable that totals the interest applied on the bordereaux payment - available at offline accounting;
VALOR4 - Variable that totals the fines applied on the bordereaux payment - available at offline accounting;
VALOR5 - Variable that totals the monetary correction applied on the bordereaux payment - available at offline accounting;
STRLCTPAD - contains the bordereaux numbers - available at offline accounting;
- In the offline accounting (CTBAFIN), if the accounting entry is the aggregator of various bordereaux, this variable will be available with a list of all of them (separated by semi-colon);

Important!

In offline accounting (CTBAFIN), when the totalizer variable "VALOR" is used, records from bills (SE2), and their respective bank transfers (SE5) will not be available. For example, to build the history for LP CT5_HIST:

Do not use SE2/SE5 fields: "Pagamento do titulo "+ SE2→E2_NUM+SE2→E2_PREFIXO+ " no borderô" + SE2→E2_NUMBOR.
Use fields from table SEA: "Pagamento Total Ref. Borderô: " + SEA→EA_NUMBOR + " de Emissão: " + SEA->EA_DATABOR

EA_FILIAL	EA_NUMBOR	EA_DATABOR	EA_PREFIXO	EA_NUM	EA_PARCELA	EA_TIPO	EA_FORNECE	EA_LOJA	E2_EMISSAO	E2_VENCREA	E2_VALOR	E5_DATA	E5_VALOR	E5_VLDESCO	E5_VLJUROS
D RJ 02	CTBF01	20200120	CTB	CTBFIN087	1	NF	CTBFIN	1	20200120	20200120	1000	20200120	1100	0	100
D RJ 02	CTBF01	20200120	CTB	CTBFIN087	2	NF	CTBFIN	2	20200120	20200120	1000	20200120	900	100	0
D RJ 02	CTBF02	20200120	CTB	CTBFIN087	3	NF	CTBFIN	1	20200120	20200120	1000	20200120	1100	0	100
D RJ 02	CTBF02	20200120	CTB	CTBFIN087	4	NF	CTBFIN	2	20200120	20200120	1000	20200120	900	100	0
D RJ 02	CTBF03	20200120	CTB	CTBFIN087	5	NF	CTBFIN	1	20200120	20200120	1000	20200120	1100	0	100
D RJ 02	CTBF03	20200120	CTB	CTBFIN087	6	NF	CTBFIN	2	20200120	20200120	1000	20200120	900	100	0

Attention - Important!

Behavior according to parameterization in the offline accounting - CTBAFIN
Question 13 - Account Bordereau:
1 - Total Bordereaux - Table SEA will be positioned in the last record of the bordereau list accounted in the Period/Process.

2 - Bordereau/Bordereau - Table SEA will be positioned in the last record of each bordereau.

05. TABLES USED

FK2 - Posts payable
SE2 - Accounts payable
SEA - Bills sent to the bank
SE5 - Bank transfer
CT2 - Accounting entries
CT5 - Standard entries

06. OTHER INFORMATION

Offline accounting - CTBAFIN - Financials - P12

Páginas filhas