To account for bank transactions or posting information where the information was in table SE5, you must fetch the information from the main transaction tables and accounting variables.
Process | Base Table |
Posts Receivable (520) | FK1 |
Posts Payable (530) | FK2 |
Bank Transaction Payable (562) | FK5 |
Bank Transaction Receivable (563) | FK5 |
Checks Payable (590) | FK5 |
Checks Receivable (???) | FK5 |
Advances Payable (513) | FK5 |
Advances Receivable (501) | FK5 |
Clearance Payable (597) | FK2 |
Clearance Receivable (596) | FK1 |
Invoices Payable (530) | FK2 |
Invoices Receivable (520) | FK1 |
Settlement Payable (530) | FK2 |
Settlement Receivable (520) | FK1 |
To account for transactions additional to the posting transactions such as taxes, interest, fines, and discounts, you must use accounting variables.
Variable | Definition | Information |
PIS | PIS calculated on posting | FK4_VALOR when the field FK4_IMPOS = PIS |
COFINS | COFINS calculated on posting | FK4_VALOR when the field FK4_IMPOS = COF |
CSLL | CSLL calculated on posting | FK4_VALOR when the field FK4_IMPOS = CSL |
IRF | IRF calculated on posting | FK4_VALOR when the field FK4_IMPOS = IRF |
ISS | ISS calculated on posting | FK4_VALOR when the field FK4_IMPOS = ISS |
INSS | INSS calculated on posting | FK4_VALOR when the field FK4_IMPOS = INS |
JUROS1 | Bill interest | FK6_VALOR when the field FK6_TPDOC = JR |
JUROS2 | Bills interest in discounted portfolio | FK6_VALOR when field FK6_TPDOC = J2 |
JUROS3 | Bill interest entered on settlement (FINA460) | FO2_VLJUR when the routine is FINA460 |
FO1VADI | Additional Amount Negotiated | FO1_VLADIC when the routine is FINA460 |
MULTA1 | Bill fine | FK6_VALOR when the field FK6_TPDOC = MT |
MULTA2 | Bill fine in discounted portfolio | FK6_VALOR when field FK6_TPDOC = M2 |
DESC1 | Bill discount | FK6_VALOR when the field FK6_TPDOC = DC |
DESC2 | Bill discount in discounted portfolio | FK6_VALOR when field FK6_TPDOC = D2 |
CMONET1 | Bill indexation | FK6_VALOR when the field FK6_TPDOC = CM |
CMONET2 | Bill indexation in discounted portfolio | FK6_VALOR when field FK6_TPDOC = C2 |
Example of use of the standard entry:
Scenario 01: Configuration of posting of bills receivable with withholding taxes on posting
Entries configuration:
SE | Sequence | Debit Account | Credit Account | Amount | History |
520 | 001 | XX.XXXX1 | XX.XXXX2 | FK1->FK1_VALOR | FK1->FK1_HISTOR |
520 | 002 | XX.XXXX1 | XX.XXXX2 | JUROS1 | "INTEREST"+SE1->E1_NUM |
520 | 003 | XX.XXXX1 | XX.XXXX2 | MULTA1 | "FINE"+SE1->E1_NUM |
520 | 004 | XX.XXXX1 | XX.XXXX2 | DESC1 | "DISCOUNT"+SE1->E1_NUM |
520 | 005 | XX.XXXX1 | XX.XXXX2 | CMONET1 | "INDEXATION"+SE1->E1_NUM |
520 | 006 | XX.XXXX1 | XX.XXXX2 | INC. TAX | "INC. TAX"+SE1->E1_NUM |
520 | 007 | XX.XXXX1 | XX.XXXX2 | PIS | "PIS"+SE1->E1_NUM |
520 | 008 | XX.XXXX1 | XX.XXXX2 | COFINS | "COFINS"+SE1->E1_NUM |
520 | 009 | XX.XXXX1 | XX.XXXX2 | CSLL | "CSLL"+SE1->E1_NUM |
Scenario 02: Configuration of posting of bills payable withholding taxes on posting
Entry configuration:
SE | Sequence | Debit Account | Credit Account | Amount | History |
530 | 001 | XX.XXXX1 | XX.XXXX2 | FK2->FK2_VALOR | FK2->FK2_HISTOR |
530 | 002 | XX.XXXX1 | XX.XXXX2 | JUROS1 | "INTEREST"+SE2->E2_NUM |
530 | 003 | XX.XXXX1 | XX.XXXX2 | MULTA1 | "FINE"+SE2->E2_NUM |
530 | 004 | XX.XXXX1 | XX.XXXX2 | DESC1 | "DISCOUNT"+SE2->E2_NUM |
530 | 005 | XX.XXXX1 | XX.XXXX2 | CMONET1 | "INDEXATION"+SE2->E2_NUM |
530 | 006 | XX.XXXX1 | XX.XXXX2 | INC. TAX | "INC. TAX"+SE2->E2_NUM |
530 | 007 | XX.XXXX1 | XX.XXXX2 | PIS | "PIS"+SE2->E2_NUM |
530 | 008 | XX.XXXX1 | XX.XXXX2 | COFINS | "COFINS"+SE2->E2_NUM |
530 | 009 | XX.XXXX1 | XX.XXXX2 | CSLL | "CSLL"+SE2->E2_NUM |
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas