Linha Microsiga Protheus - Inglês

Páginas filhas
  • Accounting of Monetary Variation - FINA350 - Financials - P12

Versões comparadas

Versão antiga 3

changes.mady.by.user Andrea Paula Justino dos Santos

Gravado em

comparado com

Nova versão Atual

changes.mady.by.user Andrea Paula Justino dos Santos

Gravado em

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

Accounting of Monetary Variation - FINA350 - Financials - P12

...

Índice

01. OVERVIEW

When there are transactions in foreign currency in the Financials environment, the entries must be monetarily adjusted to calculate the difference between the issue date and the base date of pending bills in hard currency. This difference is the monetary variation, which must be entered in Accounting.

Use this process when you need to account the currency variation in the period in which the bill was posted (day-day).

02. EXECUTION

To account the the indexation:

  1. Find these options in the Financials module menu: Miscellaneous > Accounting > Indexation Accounting (FINA350)
  2. On the homepage, a description of the routine is displayed.
  3. Click "Parameters" The system displays the parameter screen.
  4. Configure them according to the field help instructions.
  5. Notice the following parameters:
    1. Accounting by ? The system allows control of the monetary variation by Customer/Supplier in addition to individual control (by bill). allows reconciliation between the Subsidiary Ledger and the Ledger. 
    2. Currency sales rate? Currency rate for the adjustment in the bills receivable.
    3. Currency acquisition rate? Currency rate for the adjustment in the bills payable.
  6. Check the parameters and confirm them. The system goes back to the routine description screen.
  7. Confirm to start processing. 

03. PARAMETERS APPLIED

...


Deck of Cards
effectDuration0.5
historyfalse
idsamples
effectTypefade
Card
defaulttrue
id1
label

...

Parameters

Question

Description

Portfolio ?

Select if the portfolio to be considered for the calculation of the monetary variation will be receivable, payable or both.

Currency ?

Select the currency to be used for the calculation of the monetary variation. Bills in currencies other than the selected one will be disregarded when processing the calculation.

Display Entries?

Select "Yes" so accounting entries are displayed at the end of the transaction. Otherwise, select "No".

Group Entries?

Select "Yes" so entries related to the same account are grouped in a single entry. Otherwise, select "No".

Account by?

Enter whether the monetary variation will be calculated by "Bill", making the entry "bill by bill" or by "customer/supplier", where the total of each customer or supplier will be calculated and entered.

MV on bill with rate contracted ?

Enter whether there will be the calculation of monetary variation for bills that have a contracted rate. The monetary variation of these bills will not be made based on the rate contracted, but based on the difference of daily rates.

Future issue bill ?

Select "Yes" to consider bills whose issue date is later than base date.

Currency sales rate?

Enter the sales rate of the currency selected, which is used to calculate indexation.

Currency purchasing rate?

Enter the purchasing rate of the currency selected, which is used to calculate indexation.

Consider Advance Payments ?

Select (Yes) to consider prepayment bills (RA/PA).

Card
defaulttrue
id2
labelParameters (SX6)

Parameter

Description

Default Content

MV_CTBFLAG

It allows the recording of accounting flags to be contracted within the transactions of the  SIGACTB  or not.

F

MV_CNFI350

It indicates whether monetary variation of provisional bills must be accounted by the Management of Contracts module.

T


04. ENTRY POINTS

Below is the list of entry points available in the  Accounting of Monetary Variation (FINA650)routine:

Entry Points

Note

F350CONF

It enables you to confirm whether you want to run the accounting of monetary variation. 

Document: {+}https://tdn.totvs.com/x/RE36Hg+

F350SE1

It validates each bill receivable information, which will be part of the indexation. 

Document: {+}https://tdn.totvs.com/x/V1H6Hg+

F350CM

It enables you to edit the value of the variation that will be accounted for the accounts receivable.

Document: {+}https://tdn.totvs.com/x/dGD6Hg+

F350GE1

It enables you to manipulate the variable VALUE, which will be updated in the accounting and recording of the indexation of the accounts receivable.

Document: {+}https://tdn.totvs.com/x/FmH6Hg+

F350CM2

It enables you to edit the value of the variation that will be accounted for the accounts payable.

Document: {+}https://tdn.totvs.com/x/VVj6Hg+

F350GE2

It confirms the selection of the bill for accounting.

Document: {+}http://tdn.totvs.com/pages/viewpage.action?pageId=6071024+

05. STANDARD ENTRY

SE

Generator Fact

ON  (FINA350)

OFF (CTBAFIN)

598

Monetary Variation - Accounts Receivable


Yes

No

599

Monetary Variation - Accounts Payable


Yes

No

Informações
titleImportant!

Both in the variation and in the indexation, we have the option to be an ACTIVE or a PASSIVE adjustment/variation.

Active = Positive valuePassive = Negative value

Because the negative values are not saved in the accounting, the configuration of the standard entries must use the ABS() function. Example: CT5_VALOR = ABS(VALOR)



06. EXAMPLE OF USE

Consider the addition of a bill payable in the amount of $ 2,350.00 in currency 2, informing a conversion rate of 2.1400 in the field Currency rate  (E2_TXMOEDA) on March 20.

Monetary variation routine run on April 30, with the following purchasing conversion rate: 2.0800.

The rate entered is used for conversion, resulting in a monetary variation of  -141.00 in relation to the strong currency.

...

Then, the acquisition rate of 2.0800 entered in the Accounting of Monetary Variation is saved in the field "Indexation Rate" (E2_TXMDCOR) of the bill payable and used as base for the next monetary variation calculation.

On May 31, the monetary variation routine is executed with the following conversion rate: 2.1300.

The rate entered is used for conversion, resulting in a monetary variation of  117.50  in relation to the strong currency. 

  • Calculation formula:{2.1300 - 2.0800)*2,350.00} = 117.50 

The system updates the field Indexation Rate (E2_TXMDCOR) of the bill payable with the acquisition rate of 2.1300 that will serve as base for the next monetary variation calculation.

07. OTHER INFORMATION

Informações
titleImportant!
  • Based on the rates entered in the questions "Currency sales rate ?" and "Currency purchasing rate?", the routine will update the E1_TXMDCOR and E2_TXMDCOR fields. 
  • In case of new processing of the FINA350 routine, if the bill has outstanding balance, the new calculation of the variation will use the content of these fields, and not the bill addition rate, as entry rate.
  • The  FINA350  routine will account posted records.
  • At each processing, records are generated in the Financial transaction tables (SE5/FK1/FK2).
  • The routine underwent a revision in the concept of currency recording in the E5_MOEDA, FK1_MOEDA and FK2_MOEDA fields, where it began to save the strong currency instead of the bill currency - as the value of the variations is in relation to a strong currency.
Informações
titleIntegration with

...

Easy Export Control

This routine makes the calculation of the exchange monetary variation available when the routine Accounts Receivable  has information of exchange reference date and exchange reference rate.

...