...
Deck of Cards |
---|
|
Card |
---|
| Deck of Cards |
---|
| Card |
---|
id | 1 |
---|
label | Scenario 1 - Double entry |
---|
| 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" |
|
Card |
---|
id | 2 |
---|
label | Scenario 2 - Simple entry with bordereau totalizer |
---|
| 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) |
Informações |
---|
title | 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:
- 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:
- 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:
- Each bordereau is separated in an accounting document;
- 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.
|
|
|
|
|
...
Informações |
---|
|
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. |
...
Informações |
---|
|
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 |
Aviso |
---|
title | 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
HTML |
---|
<!-- esconder o menu -->
<style>
div.theme-default .ia-splitter #main {
margin-left: 0px;
}
.ia-fixed-sidebar, .ia-splitter-left {
display: none;
}
#main {
padding-left: 10px;
padding-right: 10px;
overflow-x: hidden;
}
.aui-header-primary .aui-nav, .aui-page-panel {
margin-left: 0px !important;
}
.aui-header-primary .aui-nav {
margin-left: 0px !important;
}
</style>
|