Card |
---|
id | 1 |
---|
label | Configuration Wizard |
---|
effectType | fade |
---|
| To start the Configuration Wizard, enter WizardTF1 in the homepage
Image Added Click OK Image Added Check whether initial requisites have been met, then click Next
Image Added Enter Admin user and password, then choose the companies to set and click Next Image Added Choose Product to be set. Click Next.
Image Added Click Next. Image Added Accept parameters sharing verification. Image Added Enter ClientID and Client Secret. Fill in the parameters in accordance with the request for the product selected. Image Added
Expandir |
---|
title | TOTVS More Time to Pay |
---|
| Image Added 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. |
Image Added
|
Card |
---|
label | TOTVS More Time to Pay |
---|
| Expandir |
---|
| 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. |
Expandir |
---|
| 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. |
Expandir |
---|
| 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. Image Added |
Expandir |
---|
| 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. Image Added Image Added
Screen of routine Bill Complement, IOF field. Image Added |
Expandir |
---|
title | 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. Image Added |
Expandir |
---|
| See below two examples of parameter settings for Standard Entries to book TOTVS More Time to Pay integration transactions.
Informações |
---|
|
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) |
|
Expandir |
---|
| Expandir |
---|
title | 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)
|
Expandir |
---|
title | 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
|
|
|
Card |
---|
id | 1 |
---|
label | TOTVS More Business |
---|
effectType | fade |
---|
| To start the Configuration Wizard, enter WizardTF1 in the homepage. Image Added Click OK. Image Added Check whether initial requisites have been met and click Next. Image Added Enter Admin user and password, then choose the companies to set and click Next. Image Added Choose the Product to be configured, which in this case is TOTVS More Time to Pay, then click Next. Image Added Click Next. Image Added Click Acknowledged and Close. Image Added Enter ClientID and Client Secret, sent by Techfin. Then click Next. Image Added 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. Image Added Wait for system configuration processing. Image Added Click Finish to close the Wizard. Then, click Finish to close the screen. Image Added |
Card |
---|
id | 1 |
---|
label | Indicators |
---|
effectType | fade |
---|
| For further information on the extraction of indicators, refer to the following link: Indicators Extraction |
|