Linha Microsiga Protheus - Inglês

Páginas filhas
  • Manual Postings Payable - FINA080 - Financials - P12

Index

Objective

Use this routine to post bills individually. To specify a reason for a posting, you must first register it in the Posting Reasons Table (available in the Miscellaneous option); thus, besides identifying bills, it allows a reason for a posting to make Bank Balance Transactions and Generate Checks. This control is accomplished through the fields Bank Transaction and Check.
The following posting types do not make bank balance transactions:

  • BA - Automatic Posting without Bordereau.
  • JR - Interest.
  • MT - Fine.
  • DC - Discount.
  • CM - Indexation.
  • D2 - Discount of bill discounted.
  • J2 - Interest of bill discounted.
  • M2 - Fine of bill discounted.
  • V2 - Net value of bill discounted.
  • TL - Value posted with tolerance.
  • CP - Posting through Clearing.
  • C2 - Adjustment of bill discounted.

There are five default reasons for posting bills payable:

  • Regular (NOR): bills of ordinary payments. Update bank transaction automatically if a check has been generated for the bill.
  • Return (DEV): receipts related to returns. Do not automatically update bank transaction.
  • Accord and Satisfaction (DAC): occurs when one thing is offered as payment for another. Do not automatically update bank transaction.
  • Vendor (VEND): Payment of bill through bank loan. The bank becomes the beneficiary; however, the company must have a bank contract registered to enable this loan. It automatically updates the bank transaction.
  • Checking Account Debit: it automatically debits the bank transaction without needing to generate a check on the bill.


Note

In the main page of the routine, the following options are available:The routine also requires some default or specific settings enabled by parameters. The Mental Map highlights those used in this routine, and also makes some of them easier to view so you may know when they are working.
The configuration of the Schedule and EAI Adapter routines promotes the following conditions:

  • Integration of TIN (TOTVS Real Estate Enterprising) which sends and receives XML files, in accordance with the XSD ratified by TOTVS.
  • Single message in XML file with posting of bills payable (ACCOUNTPAYABLEDOCUMENTDISCHARGE).



Mental Map

In this diagram, the data refer to the features of the routine: 

 

Before posting, consider setting routine parameters to include the following criteria: 

Field

Description

Display Acctg. Entry?

Select Yes or No to indicate whether to display accounting entry when booking online.
Example:
No.

"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.
Example:
No.

Online Booking?

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).
Example:
No.

Note

Accounting entries related to the Posting of Bills Payable may occur in posting, in check generation or in both cases, through the setting of parameter MV_CTBAIXA, which can be: B, C or A, respectively.
In this case, first register the standardized entries corresponding to the generation of checks. In field Currency Val, fill out the variable VALUE.
The booking occurs when you enter a check number directly on the Manual Posting screen, enabling standardized entry 530. Meanwhile, in the automatic posting payable, the entry is performed in the routine itself if the bordereau number is entered, executing standardized entry 532.

Allow bordereau posting?

Enter whether to allow posting of bills in bordereau.
Example:
Yes.

Duplicate Apportionment?

To fill out this field, select from the following options:

  • Addition: duplicates the distribution of multiple natures and multiple natures by cost center already entered while adding this bill, only recalculating the amounts in accordance with the amount posted. The amounts can be edited.
  • Posting: duplicates the distribution of multiple natures and multiple natures by cost center already entered during a partial bill posting, only recalculating the amounts in accordance with the amount posted in current posting. The amounts can be edited.
  • Do Not Duplicate: a window shows the distribution of multiple natures and multiple natures by cost center for entering their data.

    Example:
    Addition.


Note

When you fill out the field Duplicate Apportionment? with option Posting, you need to take the following criteria into account:

  • Create standard entries
Standard EntryDescriptionTo get value (field Currency 1 Vl.)
537Accounts Payable Posting with distribution in multiple natures by cost center.SEZ->EZ_VALOR
539Cancellation of Accounts Payable Posting with distribution in multiple natures by cost center.SEZ->EZ_VALOR
  • Edit standard entries

    All standard entries relating to the postings and cancellation of postings of accounts payable, to use distribution for multiple natures, must contain the following expression while obtaining the value (for standard entry, field Currency 1 Vl. - CT5_VLR01): IF(SE5->E5_MULTNAT="1",SEV->EV_VALOR,SE2->E2_VALLIQ). The entries affected are:
    530 - Postings - Accounts Payable.
    531 - Cancellation of Accounts Payable Postings.
    518 - Posting by Vendor.
    519 - Cancellation of Posting by Vendor.
    With these definitions you can select the checkbox Multiple Natures Apportionment when posting the bill. Just check the data and confirm the procedure.
    The system displays the screen for Distribution of Multiple Natures by Bills for entering the natures for apportionment and for each, whether there will be apportionment by cost center. Mainly, pay attention to the contents of the following fields:
    Nature: enter the code of the nature to be used in distribution.
    Transaction Value: use this field to set the distribution value in the nature selected. When you fill this out, the system fills out the field Dist. Perc..
    Dist. Perc.: use this field to set the distribution percentage in the nature selected. When you fill this out, the system fills out the field Transaction Vl..
    Apportionment by Cost Center: for every nature marked for apportionment, a window is displayed allowing entry of cost centers involved and the apportionment percentages. If you fill out this field with option No, simply confirm the data for the system to display the accounting entries screen. In this step, also enter the information needed and confirm the posting. If you fill out the field with option Yes, the system displays the screen for apportionment distribution among cost centers for multiple natures. After entering the data, confirm the procedure and the system goes back to the screen for Distribution of Multiple Natures by Bills. Confirm it again to display the accounting entries screen, which you must also fill out and confirm.
    After entering the apportionment distribution in multiple natures, you only save the procedure when you confirm the operation; otherwise, the bill posting is regarded as a regular posting, without distribution of values to multiple natures and cost center.|





In the main page of the routine, the following options are available:

    Upon selecting this option, check the contents of the main fields and confirm the procedure.
    Example:

    • Number: CT34008
    • Type: PA
    • Supplier: FINC49
    • Nature: FIN02CA
    • Issue: 3/24/16
    • Current due date: 3/24/16
    • Posting reason: Regular
    • Bank: 001
    • Branch: 00001
    • Account: 0000000001
    • Paymt Date: 5/16/16
    • Debit Date: 5/16/16
    • Posting History: value paid without bill
    • Beneficiary: IRRF PCC
    • Original value: 1,000.00
    • Value Paid: 1,000.00


    Note

    Field Value Paid represents the payment value stated on the bill. Pay attention to this field, as it causes bank account activity and, if wrong, the bank reconciliation will be inconsistent. It also determines the posting condition in the following criteria:

    Scenario 1:

    Partial Posting:
    Bill in the amount of BRL 1,000.00
    Field Value Paid = BRL 800.00
    In this case, the bill retains the value of BRL 200.00 to be posted and will have the status in blue, in the maintenance window of the routine.
    Total Posting:
    For total posting, keep the bill value with fines and discounts, if needed.
    Bill in the amount of BRL 500.00
    Field Value Paid = BRL 500.00

    Scenario 2:

    Bill in the amount of BRL 950.00
    + Fine of BRL 10.00
    = Value Paid of BRL 960.00
    Note that the routine turns red in the routine's maintenance window, which indicates a total posting.


    Tax Bill Posting 
    If this bill has generated tax, it is posted automatically with the main bill, according to the nature assigned.

    When there is a reduced Income Tax base, the calculation is performed in the posting.

    When PIS, COFINS and CSLL taxes are set to be withheld at posting, the value considered to check for cumulativeness of values paid follows these criteria:

    • Total Posting: base value of taxes.
    • Partial Posting: base value of taxes in proportion to the value received.

    You can change the due dates of tax bills, IRRF, PIS, COFINS and CSLL when the main bill is posted. This procedure is defined in accordance with the settings of parameter MV_ATVCIMP; that is, when it is set to T, the date change is recalculated based on the posting date of the main bill (third business day of the week after the posting date).


    Example:

    A NF bill due on 3/01/16 that generates taxes due on 3/10/16. If paid on 3/10/16, the due date of the taxes changes to 3/10/16.


    Note

    Data on tax values becomes available when you add a bill to avoid jeopardizing cash flow information.
    This parameter only changes the due date. If there is a partial posting of the bill, the date changes but no tax bill is created based on the difference between the bill and the base values.
    This rule applies to IRRF bills only when the due date of the tax bill is calculated based on the actual due date of the bill. In this case, parameter MV_VENCIRF must be set to V.
    The due dates of tax bills paid before payment of the main bill do not change.
    The due dates of tax bills do not change unless this parameter is set.


    By setting parameters, you can also automatically check taxes (PIS, COFINS and CSLL) generated by bordereau in relation to the minimum withholding value (MV_VL10925).
    Parameter MV_RC10925 performs the automatic check in the PIS, COFINS and CSLL calculation at each cancellation of posting or bordereau.


    Control of Checks Payable
    The features for management of checks payable in the system are:

    • Posting with Check: occurs when selecting the bill for posting. At this point, you must also fill out the field Check No. for the system to generate the check in the bank transaction and in the checks register.
    • Posting without Check: occurs when selecting the bill for posting. You must not fill out field Check No. at this point. While posting, the system generates the record in bank transaction (depending upon the reason for posting) and in the checks register (without the check number). Numbering is done in the routine "Generation of Checks".
    • Posting Checks with Automatic Numbering: occurs when selecting the bill for posting. At this point, you must also fill out the field Check No. with *nnnnn. Actual numbering happens when printing checks through questions Number Automatically? and Number of 1st Check. This option updates bank transaction.
    • Checks on Bills: use this option to generate the check prior to posting; that is, when posting the bill, field Check No. is automatically filled out.


    Note

    In routine Checks Release, the system allows you to release checks generated online in accordance with the setting of parameter MV_LIBCHEQ; thus, when its content is S, checks are automatically released and when it is N, they must necessarily go through this option.
    The bank transaction related to these checks occurs when released online or after the check release procedure.


    Posting of IRPJ of Public Companies 
    Calculate Income Tax at posting for Legal Entity in Financials to make it compliant with Normative Instruction SRF No. 480, which covers the withholding of Income Tax from public companies. To do this, you need to register the Legal Entity Supplier, considering the contents of the following fields: IRRF Calc. = 2 (IRRF Posting and Nature) and Calculate IRRF = Yes, given that both are set to generate IRRF at posting.

    Thus , after activating option To Post, a bill is generated with TX Type (IRF Nature) for the Union Supplier and, in the case of a partial posting, the procedure is the same. Only the value paid is adjusted to keep the partial posting value.

    Use filters to search for information, ordering it in accordance with a given characteristic.
    Example:

    • branch+prefix+bill no.+installment+type.

    When you activate option posting by batch, a window is displayed with information divided between Bank Data, Values and Filtering to identify bills with similar characteristics that you must post.
    After you fill out the data, confirm the procedure.
    Example:

    • Bank: 001
    • Branch: 00001
    • Account: 0000000001
    • No. Bills: 01
    • Batch: 00000001
    • Bills Value: 1,000.00
    • Due Date: 5/16/16
    • To Due Date: 5/16/16
    • From Nature: FIN049 - Nature Without Taxes
    • To Nature: FIN049 - Nature Without Taxes

    Allow cancellation of posting of a bill. When you activate this option, a window is displayed with information on the bill selected. Check and confirm the procedure.
    Example:

    • Number: FIN00011
    • Type: RPA
    • Supplier: FIN022
    • Nature: AUT0000020
    • Issue: 6/17/16
    • Current due date: 6/17/16
    • Bank: C01
    • Branch: 00001
    • Account: 0000000001
    • Receipt Date..:6/17/2016
    • Debit Date:6/17/2016
    • Posting History: value paid without bill
    • Beneficiary: PF - All
    • Posting Reason: Regular
    • Cancel. Hist.: Posting Cancellation
    • Original Value BRL: 2,925.03
    • Partial Paymts: 2,925.03
    • Value Paid: 2,750.03 


    Note

    When the cancellation of a posted bill occurs, the accounting entries are reversed. Add the posting value to the balance of copies pending and the bill is again considered for cash flow.

    Allow deletion of posting of a bill. When you activate this option, a window is displayed with information on the bill selected. Check and confirm the procedure.
    Example:

    • Number: FIN00011
    • Type: RPA
    • Supplier: FIN022
    • Nature: AUT0000020
    • Issue: 6/17/16
    • Current due date: 6/17/16
    • Bank: C01
    • Branch: 00001
    • Account: 0000000001
    • Receipt Date..: 6/17/2016
    • Debit Date: 6/17/2016
    • Posting History: value paid without bill
    • Beneficiary: PF - All
    • Posting Reason: Regular
    • Cancel. Hist.: Posting Cancellation
    • Original Value BRL: 2,925.03
    • Partial Paymts: 2,925.03
    • Value Paid: 2,750.03 


    Note

    When the deletion of a posted bill occurs, the accounting entries are reversed. Add the posting value to the balance of copies pending and the bill is again considered for cash flow.

    Use this option to locate and display accounting entries from the document that originated them.

    This option indicates, through colors, the types of bills available.

    Allow posting a bill through EAI integration.

    Example of Single Message of Manual Posting Payable - FINI080 
    <?xml version="1.0" encoding="utf-8"?>
<TOTVSMessage>
<MessageInformation version="3.000">
<UUID>d0e2b55e-8jss-8s6s-g409-9mswdwh4d9ga</UUID>
<Type>BusinessMessage</Type>
<Transaction>ACCOUNTPAYABLEDOCUMENTDISCHARGE</Transaction>
<StandardVersion>1.000</StandardVersion>
<SourceApplication>RAPOSOT1</SourceApplication>
<CompanyId>T1</CompanyId>
<BranchId>D MG 01 </BranchId>
<Enterprise>D </Enterprise>
<BusinessUnit>MG </BusinessUnit>
<Product name="RAPOSOT1" version="12"/>
<GeneratedOn>2019-08-20T22:49:56Z</GeneratedOn>
<DeliveryType>Sync</DeliveryType>
</MessageInformation>
<BusinessMessage>
<BusinessRequest>
<Operation>AccountPayableDocumentDischarge</Operation>
</BusinessRequest>
<BusinessContent>
<AccountPayableDocumentInternalId>T1|D MG 01|FRG|000000002|A|FT|000000|00</AccountPayableDocumentInternalId>
<InternalId>T1|D MG 01|FRG|000000002|A|FT|000000|00|03</InternalId>
<CompanyId>T1</CompanyId>
<BranchId>D MG 01 </BranchId>
<PaymentDate>2019-08-20</PaymentDate>
<DebitDate>2019-08-20</DebitDate>
<PaymentValue>12345.12</PaymentValue>
<Taxes>
<Tax>
<Tax>IRRF-PF</Tax>
<CountryCode/>
<StateCode/>
<CityCode/>
<CalculationBasis>0.0</CalculationBasis>
<Percentage>0</Percentage>
<ReductionBasedPercent>0</ReductionBasedPercent>
<Value>0</Value>
<Reason>003</Reason>
<Recalculate>true</Recalculate>
</Tax>
</Taxes>
<OtherValues>
<InterestValue>0</InterestValue>
<DiscountValue>0</DiscountValue>
<FineValue>0</FineValue>
</OtherValues>
<CurrencyInternalId>T1|D MG 01|01</CurrencyInternalId>
<CurrencyRate>0</CurrencyRate>
<VendorInternalId>T1|D MG|000000|00|F</VendorInternalId>
<StoreId>00</StoreId>
<PaymentMethodCode>999</PaymentMethodCode>
<CustomPaymentMethod>TST</CustomPaymentMethod>
<BankInternalId>T1|D MG|000|00001|0000000001</BankInternalId>
<FinancialNatureInternalId>T1|D MG 01 |000</FinancialNatureInternalId>
<HistoryText>Valor pago s/ Titulo </HistoryText>
<DischargeSequence>03</DischargeSequence>
</BusinessContent>
</BusinessMessage>
</TOTVSMessage>

    Related Contents