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

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