- Criado por Otto Alexandre Monteiro Altorfer, última alteração em 20 jul, 2023
01. OVERVIEW
While the Fintechs are financial market companies using technology to offer conventional services, the Techfin goes beyond: this a technology and data company offering customized financial services, which are more competitive, to help companies to overcome business challenges.
TOTVS Techfin arrives on the market to revolutionize the credit, payment, and services solutions, using the power of technology. You will be able to evaluate the necessary settings for the Techfin integrations with Protheus.
02. PRODUCTS
To start the Configuration Wizard, enter WizardTF1 in the homepage
Click OK
Check whether initial requisites have been met, then click Next
Enter Admin user and password, then choose the companies to set and click Next
Choose Product to be set. Click Next.
Click Next.
Accept parameters sharing verification.
Enter ClientID and Client Secret.
Fill in the parameters in accordance with the request for the product selected.
TOTVS More Time to Pay
Prefix
Prefix to be used in new installments of the postponement process.
Type
Type of bill to be used in new installments of the postponement process.
Financial Class
Nature to be used in new installments of the postponement process.
Use the button "Search" to select an already existing Nature, and the button "Add" to open an addition screen with data suggested for registration.
Supplier/Store
Supplier and store for which the new installments of the postponement process will be generated.
Use the button "Search" to select an already existing Supplier, and the button "Add" to open an addition screen with data suggested for registration.
Accessory Value
Code of accessory value to be used when the due dates of TOTVS More Time to Pay bills are changed.
Use the button "Search" to select an already existing Accessory Value, and the button "Add" to open an addition screen with data suggested for registration.
Posting Reason
Reason to be used when posting original bills.
This reason for posting must not involve bank transactions and must be paid by portfolio (P). All posting reasons in this situation are listed automatically and the Wizard automatically registers the MPR code.
For further information on TOTVS Antecipa integration, refer to this link:
For further information on the TOTVS Financial Panel integration, refer to this link:
Implementation
To implement TOTVS More Time to Pay:
1) Check minimum requirements:
- Binary from version 7.00.191205P-20200220
- DbAccess from version 20200606
- Protheus Release from 12.1.25
- Lib Techfin from version 2.4.0
2) Apply the last Protheus continuous expedition, along with the dictionary differential through the UPDDISTR, according to the release version.
3) Registers of these items:
- Supplier Provider - supplier for which the new installments of the postponement process will be generated.
- Financial Nature - nature to be used in new installments of the postponement process.
- Posting Reason - Reason to be used when posting original bills. This reason for posting must not involve bank transactions and must be paid by portfolio (P).
- Accessory Value Types - code of accessory value to be used when the due dates of TOTVS More Time to Pay bills are changed.
4) Execute the o wizard according to the steps of the Configuration Wizard tab.
Operation
The operation consists of scheduling the execution by FINA137F, which is the JOB in charge of requesting the transactions along with the Techfin and execute them in Protheus.
Operations flow:
1) JOB FINA137F, with schedule and periodicity at every 10 minutes, will perform a request along with the TechFin to receive a message with the transactions to be executed in Protheus. The customer may adjust the periodicity; however, we recommend never to increase this interval too much, in order to keep the Techfin portal as synchronized as possible with Protheus.
2) After the transaction in Protheus, the system notifies the Techfin that the operations have been executed in the ERP, thus keeping Protheus and the Techfin Portal synchronized.
Posting of Bills
The Posting of Bills will be executed with the posting reason set in the Wizard. Be mindful that the Posting Reason does not involve any bank transactions, so it does not appear in the bank statement.
The posting date is the processing date and the TOTVS More Time to Pay negotiation number is recorded in the posting history.
Adding New Bills
New bills are added in accordance with the negotiation in the Techfin portal.
The value of new bills is recorded in the fields below, always in proportion to the quantity of negotiation installments:
- Bill Value (E2_VALOR) - Value of original bill
- Increase (E2_ACRESC) - Interest value + operation IOF
- IOF (FKF_IOF) - Value of operation IOF
The due dates of new bills agree with the selections made when executing the operation, and the barcodes become available duly registered in the bill.
Note the traceability of the bills and breakdowns according to the images.
Screen of routine Bill Complement, IOF field.
Change to due dates of TOTVS More Time to Pay bills.
You can change the due dates of new bills generated in the postponement process.
The requested installments will be changed with new due dates, new bar codes and increased interest negotiated.
The Interest is added via Accessory Values (table FKD), with the code chosen in the Wizard.
Booking
See below two examples of parameter settings for Standard Entries to book TOTVS More Time to Pay integration transactions.
Important
You should use the examples below only as a reference, because the accountant of the company must validate the accounting rules, the Standard Entries also being adapted to the business rule and parameter settings found in the environment.
For Standard Entries, the following registers and parameter settings are used:
Ledger Account
- 2101010002 = Clearing Account Suppliers
- 2102019999 = (-) Interest Accruing
- 2102019998 = (-) IOF Accruing
- 3101010002 = Interest Expense
- 3101010003 = IOF Expense
Other Parameter Settings
- Nature of new bills = MORETIMETOPAY
- Posting Reason used in posting of original bill = MPR
- Booking value of Accessory Value (for cases with Due Date changes) = MPR001
Scenario 1 - Using the account (-) Interest and IOF Accruing
In this scenario, when adding the new installment, the values of Interest and IOF are booked in an Accrual account. When this new installment is posted, the values of Interest and IOF are posted from the Accrual account and entered in an Interest Expense and IOF Expense account.
Field |
Content |
Stand Entry Code |
510 |
Sequential |
001 |
Description |
ADD BILL PAYABLE - SUPPLIER / SUSPENSE |
Entry Type |
1 - Debit |
Debit Account |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",2101010002,SA2->A2_CONTA) |
Credit Account |
|
Currency Val 1 |
SE2->E2_VALOR |
History |
"INC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
510 |
Sequential |
002 |
Description |
ADD BILL PAYABLE - INTEREST ACCRUING |
Entry Type |
1 - Debit |
Debt Account |
2102019999 |
Credit Account |
|
Currency Val 1 |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",SE2->E2_ACRESC - FKF->FKF_IOF,0) |
History |
"INC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
510 |
Sequential |
003 |
Description |
ADD BILL PAYABLE - IOF ACCRUING |
Entry Type |
1 - Debit |
Debt Account |
2102019998 |
Credit Account |
|
Currency Val 1 |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO", FKF->FKF_IOF ,0) |
History |
"INC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
510 |
Sequential |
004 |
Description |
ADD BILL PAYABLE - SUPPLIER |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
SA2->A2_CONTA |
Currency Val 1 |
SE2->E2_VALOR + IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",SE2->E2_ACRESC,0) |
History |
"INC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
515 |
Sequential |
001 |
Description |
DEL BILL PAYABLE - SUPPLIER |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",2101010002,SA2->A2_CONTA) |
Currency Val 1 |
SE2->E2_VALOR |
History |
"EXC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
515 |
Sequential |
002 |
Description |
DEL BILL PAYABLE - INTEREST ACCRUING |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
2102019999 |
Currency Val 1 |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",SE2->E2_ACRESC - FKF->FKF_IOF, 0) |
History |
"EXC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
515 |
Sequential |
003 |
Description |
DEL BILL PAYABLE - IOF ACCRUING |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
2102019998 |
Currency Val 1 |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",FKF->FKF_IOF, 0) |
History |
"EXC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MORE TIME TO PAY " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
515 |
Sequential |
004 |
Description |
DEL BILL PAYABLE - SUPPLIER / SUSPENSE |
Entry Type |
1 - Debit |
Debt Account |
SA2->A2_CONTA |
Credit Account |
|
Currency Val 1 |
SE2->E2_VALOR + IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",SE2->E2_ACRESC,0) |
History |
"EXC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
530 |
Sequential |
001 |
Description |
POST BILL PAYABLE - SUPPLIER |
Entry Type |
1 - Debit |
Debt Account |
SA2->A2_CONTA |
Credit Account |
|
Currency Val 1 |
SE5->E5_VALOR - MPR001 |
History |
"BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
530 |
Sequential |
002 |
Description |
POST BILL PAYABLE - SUSPENSE / BANK |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR",2101010002,SA6->A6_CONTA) |
Currency Val 1 |
SE5->E5_VALOR |
History |
"BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
530 |
Sequential |
003 |
Description |
POST BILL PAYABLE - INTEREST EXPENSE |
Entry Type |
1 - Debit |
Debt Account |
3101010002 |
Credit Account |
|
Currency Val 1 |
SE5->E5_VLACRES + MPR001 - POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF') |
History |
"BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
530 |
Sequential |
004 |
Description |
POST BILL PAYABLE - INTEREST ACCRUING |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
2102019999 |
Currency Val 1 |
IIF(ALLTRIM(SE5->E5_NATUREZ)=="MAISPRAZO",SE5->E5_VLACRES - POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, FKF_IOF'), 0) |
History |
"BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
530 |
Sequential |
005 |
Description |
POST BILL PAYABLE - IOF EXPENSE |
Entry Type |
1 - Debit |
Debt Account |
3101010003 |
Credit Account |
|
Currency Val 1 |
POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF') |
History |
"BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
530 |
Sequential |
006 |
Description |
POST BILL PAYABLE - IOF ACCRUING |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
2102019998 |
Currency Val 1 |
IIF(ALLTRIM(SE5->E5_NATUREZ)=="MAISPRAZO",POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, FKF_IOF'), 0) |
History |
"BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
531 |
Sequential |
001 |
Description |
DEL POST BILL PAYABLE - SUPPLIER |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
SA2->A2_CONTA |
Currency Val 1 |
SE5->E5_VALOR - MPR001 |
History |
"EXC BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
531 |
Sequential |
002 |
Description |
DEL POST BILL PAYABLE - SUSPENSE / BANK |
Entry Type |
1 - Debit |
Debt Account |
IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR",2101010002,SA6->A6_CONTA) |
Credit Account |
|
Currency Val 1 |
SE5->E5_VALOR |
History |
"EXC BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
531 |
Sequential |
003 |
Description |
DEL POST BILL PAYABLE - INTEREST EXPENSE |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
3101010002 |
Currency Val 1 |
SE5->E5_VLACRES + MPR001 - POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF') |
History |
"EXC BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
531 |
Sequential |
004 |
Description |
DEL POST BILL PAYABLE - INTEREST ACCRUING |
Entry Type |
1 - Debit |
Debt Account |
2102019999 |
Credit Account |
|
Currency Val 1 |
IIF(ALLTRIM(SE5->E5_NATUREZ)=="MAISPRAZO",SE5->E5_VLACRES - POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF'),0) |
History |
"EXC BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
531 |
Sequential |
005 |
Description |
DEL POST BILL PAYABLE - IOF EXPENSE |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
3101010003 |
Currency Val 1 |
POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF') |
History |
"EXC BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
531 |
Sequential |
006 |
Description |
DEL POST BILL PAYABLE - IOF ACCRUING |
Entry Type |
1 - Debit |
Debt Account |
2102019998 |
Credit Account |
|
Currency Val 1 |
IIF(ALLTRIM(SE5->E5_NATUREZ)=="MAISPRAZO",POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF'),0) |
History |
"EXC BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Scenario 2 - Expense when Adding New Installments
In this scenario, when adding the new installment, the values of Interest and IOF are booked directly to Interest Expense and IOF Expense accounts.
Field |
Content |
Cod Stand Entry |
510 |
Sequential |
001 |
Description |
ADD BILL PAYABLE - SUPPLIER / SUSPENSE |
Entry Type |
1 - Debit |
Debt Account |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",2101010002,SA2->A2_CONTA) |
Credit Account |
|
Currency Val 1 |
SE2->E2_VALOR |
History |
"INC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MORE TIME TO PAY " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
510 |
Sequential |
002 |
Description |
POST ADD BILL PAYABLE - INTEREST EXPENSE |
Entry Type |
1 - Debit |
Debt Account |
3101010002 |
Credit Account |
|
Currency Val 1 |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",SE2->E2_ACRESC - POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF'),0) |
History |
"INC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MORE TIME TO PAY " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
510 |
Sequential |
003 |
Description |
POST ADD BILL PAYABLE - IOF EXPENSE |
Entry Type |
1 - Debit |
Debt Account |
3101010003 |
Credit Account |
|
Currency Val 1 |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF'),0) |
History |
"INC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MORE TIME TO PAY " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
510 |
Sequential |
004 |
Description |
ADD BILL PAYABLE - SUPPLIER |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
SA2->A2_CONTA |
Currency Val 1 |
SE2->E2_VALOR + IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",SE2->E2_ACRESC,0) |
History |
"INC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
515 |
Sequential |
001 |
Description |
DEL BILL PAYABLE - SUPPLIER |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",2101010002,SA2->A2_CONTA) |
Currency Val 1 |
SE2->E2_VALOR |
History |
"EXC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
515 |
Sequential |
002 |
Description |
DEL BILL PAYABLE - INTEREST EXPENSE |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
3101010002 |
Currency Val 1 |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",SE2->E2_ACRESC - POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF'),0) |
History |
"EXC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
515 |
Sequential |
003 |
Description |
DEL BILL PAYABLE - IOF EXPENSE |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
3101010003 |
Currency Val 1 |
IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",POSICIONE('FKF', 1, xFilial("FK7")+FK7->FK7_IDDOC, 'FKF_IOF'),0) |
History |
"EXC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
515 |
Sequential |
004 |
Description |
DEL BILL PAYABLE - SUPPLIER / SUSPENSE |
Entry Type |
1 - Debit |
Debt Account |
SA2->A2_CONTA |
Credit Account |
|
Currency Val 1 |
SE2->E2_VALOR + IIF(ALLTRIM(SE2->E2_NATUREZ)=="MAISPRAZO",SE2->E2_ACRESC,0) |
History |
"EXC CP " + SE2->E2_PREFIXO+SE2->E2_NUM+SE2->E2_PARCELA+SE2->E2_TIPO + " - TOTVS MAIS PRAZO " + ALLTRIM(SE2->E2_NUM) + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
530 |
Sequential |
001 |
Description |
POST BILL PAYABLE - SUPPLIER |
Entry Type |
1 - Debit |
Debt Account |
SA2->A2_CONTA |
Credit Account |
|
Currency Val 1 |
SE5->E5_VALOR - MPR001 |
History |
"BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
530 |
Sequential |
002 |
Description |
POST BILL PAYABLE - SUSPENSE / BANK |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR",2101010002,SA6->A6_CONTA) |
Currency Val 1 |
SE5->E5_VALOR |
History |
"BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
531 |
Sequential |
001 |
Description |
DEL POST BILL PAYABLE - SUPPLIER |
Entry Type |
2 - credit |
Debt Account |
|
Credit Account |
SA2->A2_CONTA |
Currency Val 1 |
SE5->E5_VALOR - MPR001 |
History |
"EXC BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Field |
Content |
Cod Stand Entry |
531 |
Sequential |
002 |
Description |
DEL POST BILL PAYABLE - SUSPENSE / BANK |
Entry Type |
1 - Debit |
Debt Account |
IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR",2101010002,SA6->A6_CONTA) |
Credit Account |
|
Currency Val 1 |
SE5->E5_VALOR |
History |
"EXC BX CP " + SE5->E5_PREFIXO+SE5->E5_NUMERO+SE5->E5_PARCELA+SE5->E5_TIPO + IIF(ALLTRIM(SE5->E5_MOTBX)=="MPR"," - " + ALLTRIM(SE5->E5_HISTOR),"") + " - " + ALLTRIM(SE2->E2_NOMFOR) |
Technical Data
Tables and Parameters
Tables:
- SE2 - Accounts Payable Table
- SE5 - Bank Transaction Table
- FI8 - Financial Natures Table
- FKC - Accessory Value Codes
- FKD - Bills x Accessory values
- FKF - Bill Complement Table
- FI7 - CR Tracing
Parameters:
- MV_PRETECF – Prefix of Bills negotiated must contain the prefix of the bills in favor of Supplier
- MV_TPTECF – Prefix of Bills negotiated must have the bill type of the bills in favor of Supplier
- MV_NTTECF – Nature of Bills negotiated must have the financial nature registered for the bills in favor of Supplier
- MV_FNTECF – Prefix of Bills negotiated must have the supplier code registered for the bills in favor of Supplier
- MV_LFTECF – Store of supplier negotiated must have the supplier store code registered for the bills in favor of Supplier
- MV_MBXTECF – Code of Posting Reason for anticipated bills.
- MV_VATECF – Code of the accessory values, bills negotiated in favor of the Supplier, which were requested for extension
*** Important: Sharing parameters must be observed in accordance with the customer’s structure. We suggest that the codes of Suppliers and Natures be the same in all branches; however, if this is not possible, they must be dealt with exclusively.
Sources:
- PRW (In charge of requesting the TOKEN to Carol)
- PRW (In charge of the JOB receiving the Json with the bills to be posted/added or edited)
- PRW (In charge of the POST in the platform to notify that the bills were properly operated in Protheus)
- PRW (In charge of the Bill Posting/Generation and Editing routines)
Standard Entry Codes
You can use the following Standard Entry codes to book transactions:
- 510 - Accounts Payable - Addition of Bills
- 515 - Accounts Payable - Deletion of Bills
- 530 - Accounts Payable - Posting of Bills
- 531 - Accounts Payable - Cancellation of Bill Postings
Enable the Generation of the Logs
To Enable the Logs in the Console.Log, add to the Appserver.Ini this Environment Session, according MP - ADVPL - How to Activate the function FWLogMsg. – TOTVS Service Central
FWLOGMSG_DEBUG = 1
To start the Configuration Wizard, enter WizardTF1 in the homepage.
Click OK.
Check whether initial requisites have been met and click Next.
Enter Admin user and password, then choose the companies to set and click Next.
Choose the Product to be configured, which in this case is TOTVS More Time to Pay, then click Next.
Click Next.
Click Acknowledged and Close.
Enter ClientID and Client Secret, sent by Techfin. Then click Next.
For the integration, you need to register/associate the Supplier (CNPJ/EIN of partner that provides credit) and Customer (CNPJ/EIN of partner that obtains credit). In this case, you need to enter the registration data in Protheus.
In the case above, Supplier is a partner that plays two roles (do not forget to set a Legal Nature for both registers). Next, you must enter the data of the bank account in which the financial transactions will be credited and reconciled. Be mindful that these data must be the same used by the partner (for payments and receipts).
Select desired option for Schedule configuration in the system, then click Finish.
Wait for system configuration processing.
Click Finish to close the Wizard.
Then, click Finish to close the screen.
For further information on the extraction of indicators, refer to the following link:
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas
- Desenvolvido por Confluence da Atlassian 7.19.17
- Impresso pelo Confluence da Atlassian 7.19.17
- Reportar um problema
- Notícias da Atlassian