Card |
---|
| Allows you to post bills in statuses pending, partially posted, advance with balance, bills in bordereau, etc. After selecting the desired bill and clicking on the Download option, check that the main fields have been filled out and confirm the procedure.
Total posting Every operation that zeroes the corresponding balance, as in: - Total payment of the bill;
- The total return of the goods delivered;
- Application of pending credits/debits.
The field Amount Received establishes the total posting of a bill receivable. This field must contain the amount received on the bill after adding deductions and subtracting increments, where necessary.
Partial Posting This is characterized by posting a bill receivable with a value lower than the original. It happens according to the following situations: - Receipt of part of a bill amount;
- Partial return of goods;
- Application of customer's/supplier's pending credit/debit with an amount lower than the bill amount.
What determines the partial posting of a bill receivable is the Amount Received field. If the amount received, after deductions and increments, is lower than the bill balance, it is characterized as partial posting. Note that the bills with partial posting present the status in blue in the routine's maintenance window.
Example of total posting: - Number: 2112RA001
- Type: RA
- Customer: FIN – Customer Delinquency Fee and Interest.
- Nature: 001
- Issue Date: 12/21/2016
- Current due date: 12/22/2016
- Status: 0 Portfolio
- Posting reason: Regular
- Bank: 001
- Branch: 00001
- Account: 0000000001
- Receipt Date: 01/16/2017
- Credit Date: 01/16/2017
- Posting History: value received without a bill
- Original value: 1,200.00
- Net value: 1,200.00
Amount Received: 1,200.00
Informações |
---|
| The system provides financial discounts for bills posted in advance according to the information in the Financial Discount, Type of Discount, and Days for Discount fields while adding a bill in the Accounts Receivable routine. That way, when the bill is posted, the Discounts field is filled in with the value granted
Example of a single discount: If the bill is paid up to 10 days before the due date, the discount is 2.7% on the amount. |
---|
Bill Amount | 682.00 | Due date | 05/22/2016 | Financial Discount | 2.7 fixed | Type of Discount | Fixed | Days for granting Discount | 1 |
Example of proportional discount: If the bill is paid on 04/03/2016, the discount will be 2.7% per month, proportional to 50 days, which will be BRL 29.62. |
---|
Bill Amount | 682.00 | Due date | 05/22/2016 | Financial Discount | 2.7 p.m. | Type of Discount | Proportional |
|
Totvs custom tabs box |
---|
tabs | 1. Screen,2. ExecAuto |
---|
ids | 1,2 |
---|
| Totvs custom tabs box items |
---|
| ![](/download/attachments/643745829/image2019-7-23_11-6-34.png?version=1&modificationDate=1633629759813&api=v2)
Totvs custom tabs box |
---|
tabs | 1. Main,2. General Data,3. Values Posted |
---|
ids | tela_princ,tela_gerais,tela_valores |
---|
| Totvs custom tabs box items |
---|
default | yes |
---|
referencia | tela_princ |
---|
| Field | Description |
---|
Issue Date History: | History registered on the bill generation. | Status: | Bill's banking status. | Posting Reas.: | Reason for posting | Bank: | Code of the collection agent. | Branch: | Code of the collection agency. | Account: | Bank Account Number. | Receipt Date: | Date when the posting happened/will happen. | Credit Date: | Date of the bank credit referring to the posting of the bill. | Posting hist.: | Posting history. | Mult. Natures Apport.: | Multiple nature apportionment |
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | tela_gerais |
---|
| CampoDescrição | Hist. Emissão: | Histórico cadastrado na geração do título. | Situação: | Situação bancária do título . | Mot. Baixa: | Motivo da baixa. | Banco: | Código do agente cobrador. | Agência: | Código da agência do agente cobrador. | Conta: | Número da conta bancária. | Data Receb.: | Data em que foi/será realizada a baixa. | Data Crédito: | Data do crédito bancário referente à baixa do título. | Hist. Baixa: | Histórico da baixa. | Rateio Mult. Naturezas: | Rateio de múltiplas naturezasDescription |
---|
Issue Date History: | History registered on the bill generation. | Status: | Bill's banking status. | Posting Reas.: | Reason for posting | Bank: | Code of the collection agent. | Branch: | Code of the collection agency. | Account: | Bank Account Number. | Receipt Date: | Date when the posting happened/will happen. | Credit Date: | Date of the bank credit referring to the posting of the bill. | Posting hist.: | Posting history. | Mult. Natures Apport.: | Multiple nature apportionment |
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | tela_valores |
---|
| Field | Description |
---|
Issue Date History: | History registered on the bill generation. | Status: | Bill's banking status. | Posting Reas.: | Reason for posting | Bank: | Code of the collection agent. | Branch: | Code of the collection agency. | Account: | Bank Account Number. | Receipt Date: | Date when the posting happened/will happen. | Credit Date: | Date of the bank credit referring to the posting of the bill | posting. | Posting hist.: | Posting history. | Mult. Natures Apport.: | Multiple nature apportionment |
* Number 1 refers to the currency of the bill currency. If the content of parameter MV_SIMB(currency) is changed, the field description will be changed. |
|
|
Totvs custom tabs box items |
---|
| Parameters used by FINA070: Parameter | Description | Type |
---|
xAutoCab | Data referring to the bills that will be posted | Array | nOpc | Action to be performed by the source: 3 - Bill posting 5 - Posting cancellation 6 - Posting deletion | Numeric | lNoMBrowse | Set if the screen's routine should be presented or not. | Logical | nOpBaixa | Determine which posting or posting cancellation will be run. If a bill is partially posted, you can use this parameter to inform which posting will be canceled.
Informações |
---|
| The nOpBaixa parameter does not comply with the posting sequence recorded in table SE5. In a scenario with 4 partial postings, when canceling the second posting (parameter 2) and then canceling the third posting, the parameter must be passed with value 2 again, since the previously canceled posting is no longer considered in the posting sequence. In this scenario, the routine considers a new sequence, from 1 to 3, with the first posting equivalent to 1, the third posting equivalent to 2, and the fourth posting equivalent to 3. If the parameter's value is higher than the number of existing postings (for example, 3 partial postings and the parameter with a value of 4), the routine automatically considers the parameter to have a value of 1. |
| Numeric | cFiltro | Saves a filter in the Mbrowse bills. | Character |
Example of use: Bloco de código |
---|
firstline | 1 |
---|
title | ExecAuto FINA070 |
---|
linenumbers | true |
---|
| User Function EXEC070()
Local aBaixa := {}
aBaixa := {{ "E1_PREFIXO" ," " ,Nil } ,;
{ "E1_NUM" ,"200 " ,Nil } ,;
{"E1_PARCELA" ," " ,Nil } ,;
{ "E1_TIPO" ,"NF " ,Nil } ,;
{ "AUTMOTBX" ,"NOR" ,Nil } ,;
{ "AUTBANCO" ,"001" ,Nil } ,;
{ "AUTAGENCIA" ,"00001" ,Nil } ,;
{ "AUTCONTA" ,"0000000001" ,Nil } ,;
{ "AUTDTBAIXA" ,dDataBase ,Nil } ,;
{ "AUTDTCREDITO" ,dDataBase ,Nil } ,;
{ "AUTHIST" ,"BAIXA TESTE" ,Nil } ,;
{ "AUTJUROS" ,0 ,Nil ,.T. } ,;
{ "AUTVALREC" ,700 ,Nil }}
MSExecAuto({|x,y| Fina070(x,y)},aBaixa,3)
Return |
|
|
|
Card |
---|
| Allows you to view information from the documents/bills that must be paid by the company. |
Card |
---|
| Use filters to search for information, ordering it in accordance with a given characteristic. Example: - branch+prefix+bill no.+installment+type.
- branch+paymt. order
|
Card |
---|
| This allows you to post several bills at the same time, provided they have similar characteristics. When this option is activated, it is necessary to choose the required information, which includes bank details, bill values, expenses, discounts, fines, interest, due date, and nature.
![](/download/attachments/643745829/image2019-7-23_14-59-20.png?version=1&modificationDate=1633629759883&api=v2)
Totvs custom tabs box |
---|
tabs | 1. Bank Data,2. Values,3. Filtering |
---|
ids | lote_dados_banc,lote_valores,lote_filtragem |
---|
| Totvs custom tabs box items |
---|
default | yes |
---|
referencia | lote_dados_banc |
---|
| Field | Description |
---|
Bank: | Code of the collection agent. | Branch: | Code of the collection agency. | Account: | Bank Account Number. | No. Bills: | The number of bills contained in the bank notification that will be posted. | Batch: | The number of the batch to be posted. This number will be used for bank reconciliation. | Nature: | Code of the nature from which the bank transaction referring to the posting of this batch will be generated. |
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | lote_valores |
---|
| All these fields will be used only for checking at the end of the batch inclusion process. Field | Description |
---|
Bills Value: | The total value of the bills contained in the bank notification to be posted. | Total Expenses: | The total of expenses charged by the collection agent to collect the bills listed in this bank notification. | Total Discounts: | The total value of discounts granted to the bills that belong to the bank notification. | Total Fines: | The total value of the fines charged by the collection agent listed in the bank notification. | Total Interest: | The total value of the interest charged on the bills listed in the bank notification. | Credit in C/C: | Total effectively credited in the checking account of the collection agent. |
|
Totvs custom tabs box items |
---|
default | no |
---|
referencia | lote_filtragem |
---|
| Field | Description |
---|
From Due Date: | The start date of the maturity period of the checks to be deposited. | To Due Date: | End date of the maturity period of the checks to be deposited. | From Nature: | The initial nature to be used for selecting the bills to be posted. | To Nature: | The final nature to be used for selecting the bills to be posted. |
|
|
|
Card |
---|
| In the cancellation of a posting, the accounting entries and the bank balances are reversed. Consequently, a reversal record is generated in the bank transaction so that later the bank statement shows the history of operations performed. In this operation, the system allows you to enter history and identify the returned check. In this case, the Customer Status Query, Pending Bills option, highlights as historical information the Bill with Returned Check. |
Card |
---|
| Allows you to delete a bill. After selecting the desired bill and activating this option, check the information presented and confirm the procedure. While canceling an effective posting, the accounting entries and bank balances are reversed. Completing the procedure deletes the previously made posting record without generating a reversal record. Therefore, the statement does not show the reversal of the posting, only the open bill. |
Card |
---|
| This option indicates, through colors, the types of bills available. |
Card |
---|
| Allows you to add checks for posting the bills. This option is triggered in the Other Actions/Checks item available in the Bill Posting screen. |
Card |
---|
| Field | Description |
---|
Display Accounting Entry Account? | Select Yes or No to indicate whether to display accounting entries when booking online. | "Tax Grouping Entries? | Select Yes or No to indicate whether to group entries in a single line, if accounts, cost center, item, and value class are the same in the entries. | Disc. Commiss.? | Select Yes or No to indicate whether, upon canceling the posting, the discount amount should be deducted when calculating the reversal of the commission generated for the posting. | Book online? | Select Yes or No to indicate whether to book transactions (adding a bill, posting, generating a check, deleting, etc.) one at a time or offline (with all entries booked in one batch process). | Cons. commission interest? | Select Yes or No to indicate if the interest value should be considered when calculating the commission. | Highlight discounts? | Select Yes or No to indicate if you wish to highlight the discount bills for selection. It deals only with discount bills in the bill selection values, i.e. they will be posted, even if not selected, following the rule of the Accounts Receivable routine. | Duplicate Apportionment? | To fill out this field, select from the following options: · On Inclusion: replicate the apportionment from the issuance for this posting. · On Posting: replicate the apportionment from one posting to the current one. · Do not replicate: type the multiple nature apportionment at each posting. If you choose one of the previous options and there is no previous multiple nature apportionment of that type, the routine will not replicate, and you must enter the multiple nature apportionment on posting. | Generate check for advance? | To fill out this field, select from the following options: · Yes: generate checks for returning the advance in the Accounts Payable/Check Generation/Join. · No: when the return is made in cash. | Consider bank withholding? | To fill out this field, select from the following options: · Yes: consider the withholding days of the collection agent when the transfer of the bill is performed. · No: do not consider the withholding days on the transfer, but they can be considered on the bill's posting. | Use previous bank? | Select Yes or No to indicate whether to consider the bank from the last posting or the default bank. |
|
|