...
To book the information for bank transfers or posts that were in table SE5, it will be necessary to search the information from the main transfer tables and booking variables.
Process | Base Table |
---|---|
Posts Receivable (520) | FK1 |
Posts Payable (530) | FK2 |
Bank Transfer Payable (562) | FK5 |
Bank Transfer Receivable (563) | FK5 |
Checks Payable (590) | FK5 |
Checks Receivable (???) | FK5 |
Advances Payable (513) | FK5 |
Advances Receivable (501) | FK5 |
Compensation Payable (597) | FK2 |
Compensation Receivable (596) | FK1 |
Invoices Payable (530) | FK2 |
Invoices Receivable (520) | FK1 |
Settlement Payable (530) | FK2 |
Settlement Receivable (520) | FK1 |
To book the additional transfers to the post, such as taxes, interest, fines, and discounts, use booking variables.
Variable | Definition | Information |
---|---|---|
PIS | PIS calculated on posting | FK4_VALOR when field FK4_IMPOS = PIS |
COFINS | COFINS calculated on posting | FK4_VALOR when field FK4_IMPOS = COF |
CSLL | CSLL calculated on posting | FK4_VALOR when field FK4_IMPOS = CSL |
IRF | IRF calculated on posting | FK4_VALOR when field FK4_IMPOS = IRF |
ISS | ISS calculated on posting | FK4_VALOR when field FK4_IMPOS = ISS |
INSS | INSS calculated on posting | FK4_VALOR when field FK4_IMPOS = INS |
JUROS1 | Bill interest | FK6_VALOR when field FK6_TPDOC = JR |
JUROS2 | Bill interest in the discounted portfolio | FK6_VALOR when field FK6_TPDOC = J2 |
JUROS3 | Bill interest entered in settlement (FINA460) | FO2_VLJUR when the routine is FINA460 |
FO1VADI | Negotiated additional value | FO1_VLADIC when the routine is FINA460 |
MULTA1 | Bill fine | FK6_VALOR when field FK6_TPDOC = MT |
MULTA2 | Bill fine in discounted portfolio | FK6_VALOR when field FK6_TPDOC = M2 |
DESC1 | Bill discount | FK6_VALOR when field FK6_TPDOC = DC |
DESC2 | Bill discount in discounted portfolio | FK6_VALOR when field FK6_TPDOC = D2 |
CMONET1 | Bill monetary correction | FK6_VALOR when field FK6_TPDOC = CM |
CMONET2 | Bill monetary correction in discounted portfolio | FK6_VALOR when field FK6_TPDOC = C2 |
...
Journal entry configuration:
SE | Sequence | Debit Account | Credit Account | Value | 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 | “MONETARY CORRECTION”+SE1->E1_NUM |
520 | 006 | XX.XXXX1 | XX.XXXX2 | IRF | “IRF”+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: Bills payable posting configuration with tax withholding on posting
Journal entry configuration:
SE | Sequence | Debit Account | Credit Account | Value | 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 | “MONETARY CORRECTION”+SE2->E2_NUM |
530 | 006 | XX.XXXX1 | XX.XXXX2 | IRF | “IRF”+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 |