Content
Standardized Entries - Financials - P12
IMPORTANT!
01. OVERVIEW
This file is the link between the various Protheus modules and Management Accounting module. The entire accounting integration is done from the registered data and rules.
Accounting rules are fundamental for correct accounting integration. Therefore, before beginning registration, you must define how each process that generates accounting entries should be integrated.
Once accounting rules are established, processes are automatically posted to ledger with no need for user intervention.
You can make integration entries online or offline. This is valid for almost all Protheus modules, except the Management Accounting module, which only generates online entries and the Health Insurance module, which due to processing volume only generates offline entries.
Informações |
---|
|
Entries are generated automatically as processes are executed in Protheus. |
...
Informações |
---|
|
All entry postings that would be executed by processes are made at he moment the user requests the posting, through option Offline Accounting, in menu Miscellanea of Protheus modules. |
02. PROCEDURE
In Standard Entries, select Add.
The system displays the add screen, subdivided into folders:
Stan Ent Cd. : Indicate the code of standardized entry. Each Protheus process has its own code.
Sequence: Indicate the line number of the standardized entry. Each of these lines generates a line of accounting entry.
Status: Indicates whether the standard entry is active or inactive, thus avoiding the need to delete the standard entry when it should not be executed.
Description: Indicate whether the standard entry is active or inactive, thus avoiding the need to delete the standard entry when it should not be executed.
Entry Type: Indicate whether the standard entry is Debit, Credit, Double Entry or Continuation of History.
This folder contains the fields in which you can enter the accounting classifiers to be used in the position as well as in the bonus, depending on the type of entry configured in folder Register.Each field has an associated query, in which you can select the type of data to affect. You can choose between the accounting classifier (account, accounting item, cost center or value class) or yet a formula previously registered in routine FormulasThe routine checks whether the accounting classifier or formula have been registered in the corresponding catalog.
Debit Account: Enter the ledger account for debit or an ADVPL expression.
Credit Account: Enter the ledger account for credit or an ADVPL expression.
In this folder, register the value to have the accounting entry configured. You can use the available fields to save the value of the accounting entry in each currency; thus, the fields can accept the formulas that return numeric values.The routine checks whether the formula, typed or selected through query, is found in the catalog
Currency Entry: Enter for which currencies to make accounting entries. You can fill it out with:1 - Make entry in Currency2 - Do not make entry.Each "1" or "2" represents a currency the system is using.Ex: If you fill out the field with "11211", only in currency 3 the accounting entry will not be madeNOTE: If you use more than 5 currencies, you will have to change the size of this field in the Configurator.
Vl Currency 1: Enter the respective values of currencies for the accounting entries or an ADVPL expression.Ex: SE1->E1_VALLIQ or SE2->E2_VALOR - SE2->E2_IRRF
The accounting entry is only posted if at least one of the values in the existing Currencies differs from zero.
If no content is entered for a Value field (excepting Currency 1), SIGACTB automatically converts the value based on the Conversion Criterion and the Currencies Register.
Currencies.
For further details, refer to "Accounting Entries".
If you use more than 5 currencies, you will have to create the value fields in the Configurator.
...
Document History: (Document History) where you can add further information.When you add additional information to this field, they are considered while Reprocessing the Balances and printed in Typing Check report.
Grouped History: Indicate the history of Grouped Entry. Enter a text in quote marks or an ADVPL expression. If you fill out the field and the Accounting Entry is grouped, it is saved in this history in the Accounting Entry.
Informações |
---|
|
Note that some fields are highlighted in blue, characterizing them as mandatory. Unable to confirm addition if any of these fields is not filled out. Some fields have default query. To activate it, use the magnifying glass or press F3. |
03. STANDARDIZED ENTRIES FINANCIALS
Deck of Cards |
---|
startHidden | false |
---|
effectDuration | 0.5 |
---|
history | false |
---|
|
...
...
|
Card |
---|
default | true |
---|
effectDuration | 0.5 |
---|
id | 0 |
---|
label |
---|
|
|
...
| Accounts Receivable |
---|
effectType | fade |
---|
| 500 - Addition of Accounts Receivable 501 - Addition of Advance Receipt (RA) 502 - Deletion of Advance Receipt 503 - Replacement of Temporary Bills 504 - Bills Generated through Breakdown 505 - Deletion of Accounts Receivable 506 - Apportionment of Multiple Type Cost Center 507 - Cancellation of Apportionment of Multiple Type Cost Center 529 - Deletion of Bill Generated through Breakdown |
Card |
---|
effectDuration | 0.5 |
---|
label | Accounts Payable |
---|
effectType | fade |
---|
| 508 - Apportionment of Multiple Type Cost Center 509 - Cancellation of Apportionment of Multiple Type Cost Center 510 - Addition of Accounts Payable 511 - Addition of Account with Simple Apportionment 512 - Deletion of Account with Simple Apportionment 513 - Addition of Advance Payment (PA) 514 - Deletion of Advance Payment (PA) 515 - Deletion of Accounts Payable 533 - Replacement of Temporary Bills 577 - Generation of Bill through Breakdown 578 - Deletion of Bill generated through Breakdown 50A - Release of Payment Posting 50B - Reversal/Cancellation of Payment Posting Release |
|
...
Card |
---|
effectDuration | 0.5 |
---|
label | Accounts Receivable Transfers |
---|
effectType | fade |
---|
| 540 - Transfer to Portfolio 541 - Transfer to Simple Collection 542 - Transfer for Discounted Collection 543 - Transfer for Guaranteed Collection 544 - Transfer for Linked Collection 545 - Transfer for Attorney Collection 546 - Transfer for Legal Collection 547 - Bordereau for Portfolio 548 - Bordereau for Simple Collection 549 - Bordereau for Discounted Collection 550 - Bordereau for Guaranteed Collection 551 - Bordereau for Linked Collection 552 - Bordereau for Attorney Collection 553 - Bordereau for Legal Collection 554 - Cancellation of Bordereau 555 - Transfer for Guaranteed Discounted Discounted Collection 556 - Bordereau for Guaranteed Discounted Collection |
|
...
Card |
---|
effectDuration | 0.5 |
---|
label | Accounts Receivable Postings |
---|
effectType | fade |
---|
| 520 - Postings Receivable |
|
...
Portfolio 521 - Postings Receivable Simple |
|
...
Collection 522 - Postings Receivable Discounted |
|
...
Collection 523 - Postings Receivable Guaranteed |
|
...
Collection 524 - Postings Receivable Linked |
|
...
Collection 525 - Postings Receivable Attorney |
|
...
Collection 526 - Postings Receivable Legal |
|
...
Collection 527 - Cancellation of Postings |
|
...
Receivable 528 - Postings Receivable Guaranteed Discounted |
|
...
Collection 575 - Addition of Various Receipts |
|
...
Card |
---|
effectDuration | 0.5 |
---|
label | Accounts Payable Postings |
---|
effectType | fade |
---|
| 518 - Postings per Sales Representative 519 - Cancellation of Postings per Sales Representative 530 - Postings Accounts Payable 531 - Cancellation Postings Payable |
Card |
---|
effectDuration | 0.5 |
---|
label | Accounts Payable Automatic Postings |
---|
|
|
...
| 530 - Postings Accounts Payable |
|
...
532 - Postings per Payment Bordereau Example: CT5_FILIAL | D MG 01 | CT5_LANPAD | 532 | CT5_STATUS | 1 | CT5_DESC | LP532 - BORDEREAU POSTING | CT5_DC | 3 | CT5_DEBITO | 1 | CT5_CREDIT | 2 | CT5_MOEDAS | 12222 | CT5_VLR01 | IF(Empty(VALOR), SE2->E2_VALOR, VALOR) | CT5_HIST | "BORDEREAU POSTING - LP532 : " + SEA->EA_NUMBOR | CT5_HAGLUT | "GROUPED > BORDEREAU POSTING - LP532 : " + |
|
|
...
Informações |
---|
| If you need to retrieve the bordereau number and log into history upon posting to ledger, use field SEA→EA_NUMBOR. Note: This option returns the correct Bordereau number only when parameter "Post to Ledger by?" is set to "Bordereau/bordereau". |
Informações |
---|
| Bordereaux: For regular bills, the standard entry is 532. For advance bills the standard entry is 513.
|
|
|
...
Taxes with taxable event "Cash" (at posting) generated by bordereau must be posted to ledger by LP 530. Note: If parameter "Post to ledger by?" is configured as "Bordereau/bordereau", the LP 513 is not posted to ledger. |
513 - Addition of Bill Advance Payment (PA). |
|
...
Card |
---|
effectDuration | 0.5 |
---|
label | Postings with Apportionment |
---|
effectType | fade |
---|
| 537 - Postings with Apportionment |
Card |
---|
effectDuration | 0.5 |
---|
label | Bank Transaction |
---|
effectType | fade |
---|
| 516 - Addition Bank Transaction Payable with Apportionment 517 - Addition Bank Transaction Receivable with Apportionment 557 - Cancellation Bank Transaction Payable with Apportionment 558 - Cancellation Bank Transaction Receivable with Apportionment 560 - Financial Transfer - Outflow Bank of Origin 561 - Financial Transfer - Inflow Destination Bank 562 - Bank Transaction Payable 563 - Bank Transaction Receivable 564 - Bank Transaction Payable Cancellation 565 - Bank Transaction Receivable Cancellation |
|
...
Card |
---|
effectDuration | 0.5 |
---|
label | Financial Loan |
---|
effectType | fade |
---|
| 582 - Appropriation / Loan Redemption 586 - Loan Reversal |
|
...
Card |
---|
effectDuration | 0.5 |
---|
label | Check Generation |
---|
effectType | fade |
---|
| 590 - Generation of Checks 591 - Cancellation of Checks |
|
...
Card |
---|
effectDuration | 0.5 |
---|
label | Check on Bills |
---|
effectType | fade |
---|
| 566 - Generation of Checks on Bills 567 - Generation of Counter Checks 568 - Cancellation of Counter Check 569 - Redeposit of Check on Bills 571 - Cancellation of Checks on Bills |
Card |
---|
effectDuration | 0.5 |
---|
label | Invoices Receivable |
---|
effectType | fade |
---|
| 592 - Cancellation of Invoices Receivable 595 - Invoices Receivable |
Card |
---|
effectDuration | 0.5 |
---|
label | Invoices Payable |
---|
effectType | fade |
---|
| 587 - Invoices Payable 593 - Cancellation of Invoices Payable |
Card |
---|
effectDuration | 0.5 |
---|
label | Compensation of |
---|
|
|
...
Accounts Receivable | effectType | fade |
---|
| 596 - Clearance of Accounts Receivable 588 - Cancellation of Accounts Receivable |
Card |
---|
effectDuration | 0.5 |
---|
label | Compensation of |
---|
|
|
...
Accounts Payable | effectType | fade |
---|
| Used in routines Clearance of Accounts Payable (FINA340) and in Offline Accounting (CTBAFIN), 589 - Cancellation of Clearance 597 - Clearance of Accounts Payable Example:
CT5_FILIAL | D MG 01 | CT5_LANPAD | 597 | CT5_STATUS | 1 | CT5_DESC | LP597 - ACCOUNTS PAYABLE CLEARANCE | CT5_DC | 3 | CT5_DEBITO | 1 | CT5_CREDIT | 2 | CT5_MOEDAS | 12222 | CT5_VLR01 | SE5->E5_VALOR | CT5_HIST | CP - ACCOUNTS PAYABLE CLEARANCE LP597 |
|
|
...
...
| The posting of clearance to ledger is always done based on Invoice data |
Informações |
---|
title | Online Accounting of Variables |
---|
| You can use the following list of variables to configure Standard Entry 597 (AP Clearance) for ONLINE Accounting of AP Clearance (FINA340): VALUE - Stores the amount cleared. VALUE2 - Amount Increase. VALUE3 - Amount Decrease. VALUE4 - Variation of adjustment for inflation. VLRINSTR - Stores the amount cleared. nSldReal - Stores the amount cleared in corresponding currency of bill. DEDUCTION - Deduction Amounts. REGVALOR - Recno of current record. STRLCTPAD - Key of main bill + document number. |
Informações |
---|
title | Offline Accounting of Variables |
---|
| You can use the following list of variables to configure Standard Entry 597 (AP Clearance) for OFFLINE Accounting of AP Clearance (FINA340): VALUE - Stores the amount cleared. VALUE2 - Amount Increase. VALUE3 - Amount Decrease. REGVALOR - Recno of current record. STRLCTPAD - Key of main bill + document number. VARIATION - Monetary Variation Amount. (Must use function ABS() to remain positive). |
|
Card |
---|
effectDuration | 0.5 |
---|
label | Clearance Between Portfolios |
---|
effectType | fade |
---|
| 594 - Compensation Between Portfolios. |
|
...
effectDuration | 0.5 |
---|
label | Monetary Variation |
---|
effectType | fade |
---|
| 598 - Monetary Variation - Accounts Receivable 599 - Monetary Variation - Accounts Payable |
Card |
---|
effectDuration | 0.5 |
---|
label | Bank Communication Return |
---|
effectType | fade |
---|
| 530 - Pay Bank Communication Return |
Card |
---|
effectDuration | 0.5 |
---|
label | Petty Cash |
---|
effectType | fade |
---|
| 572 - Petty Cash Transactions 573 - Replacement Transactions - Bank/Petty Cash - Petty Cash/Bank |
Card |
---|
effectDuration | 0.5 |
---|
label | Offline Accounting |
---|
effectType | fade |
---|
| 500 - Addition of Accounts Receivable 501 - Addition of Advance Receipts (RA) 504 - Generation of Bill Receivable through Breakdown 510 - Addition of Accounts Payable 511 - Addition of Bill Payable with Apportionment 513 - Addition of Advance Payment (PA) 577 - Generation of Bill Payable through Breakdown 540 - Transfer Receive for Portfolio 520 - Posting Receivable - Portfolio 521 - Posting Receivable - Simple Collection 522 - Posting Receivable - Discounted Collection 523 - Posting Receivable - Guaranteed Collection 524 - Posting Receivable - Linked Collection 525 - Posting Receivable - Attorney Collection 526 - Posting Receivable - Legal Collection 527 - Cancellation of Postings Receivable 528 - Posting Receivable - Guaranteed Discounted Collection 530 - Posting Payable 531 - Posting Payable Cancellation 532 - Posting per Payment Bordereau 560 - Financial Transfer - Outflow Bank of Origin 561 - Financial Transfer - Inflow Bank of Destination 562 - Bank Transaction - Payment 563 - Bank Transaction - Receipt 516 - Apportionment Bank Transaction Payment 517 - Apportionment Bank Transaction Receipt 580 - Financial Investment 581 - Financial Investment Deletion 590 - Generation of Checks 566 - Generation of Checks on Bills 567 - Generation of Counter Checks 572 - Petty Cash Transaction 573 - Petty Cash Replacement Transaction |
Card |
---|
effectDuration | 0.5 |
---|
label | Travels |
---|
effectType | fade |
---|
| Used in routines Rendering of Accounts (FINA677) and in Offline Accounting (CTBAFIN)
8B3 - Rendering of Accounts Example: CT5_FILIAL | D MG 01 | CT5_LANPAD | 8B3 | CT5_STATUS | 1 | CT5_DESC | LP8B3 - RENDERING OF ACCOUNTS | CT5_DC | 3 | CT5_DEBITO | 001 | CT5_CREDIT | 002 | CT5_MOEDAS | 12222 | CT5_VLR01 | FLE->FLE_VALREE | CT5_HIST | LP8B3 - RENDERING OF ACCOUNTS |
Informações |
---|
| You may use field FLE_QUANT to return the quantity related to Expense. |
8B4 - Reversal of Rendering of Accounts
Informações |
---|
| Use this standard entry for Online Accounting only. |
Example: CT5_FILIAL | D MG 01 | CT5_LANPAD | 8B4 | CT5_STATUS | 1 | CT5_DESC | LP8B4 - RENDERING OF ACCOUNTS REVERSAL | CT5_DC | 3 | CT5_DEBITO | 001 | CT5_CREDIT | 002 | CT5_MOEDAS | 12222 | CT5_VLR01 | FLE->FLE_VALREE | CT5_HIST | LP8B3 - RENDERING OF ACCOUNTS REVERSAL |
8B5 - Rendering of Accounts Header Example:
CT5_FILIAL | D MG 01 | CT5_LANPAD | 8B5 | CT5_STATUS | 1 | CT5_DESC | LP8B5 - ACCOUNTS RENDERING HEADER | CT5_DC | 3 | CT5_DEBITO | 001 | CT5_CREDIT | 002 | CT5_MOEDAS | 12222 | CT5_VLR01 | FLF->FLF_TVLRE1 | CT5_HIST | LP8B5 - ACCOUNTS RENDERING HEADER | CT5_HAGLUT | |
8B6 - Reversal of Rendering of Accounts Header
Informações |
---|
| Use this standard entry for Online Accounting only. |
Example: CT5_FILIAL | D MG 01 | CT5_LANPAD | 8B6 | CT5_STATUS | 1 | CT5_DESC | LP8B5 - ACCOUNTS RENDERING HEADER REVERSAL | CT5_DC | 3 | CT5_DEBITO | 001 | CT5_CREDIT | 002 | CT5_MOEDAS | 12222 | CT5_VLR01 | FLF->FLF_TVLRE1 | CT5_HIST | LP8B6 - ACCOUNTS RENDERING HEADER REVERSAL |
|
|
...
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>
|
...