How are data saved for Flow by Natures (FINC022)?

01. QUESTION:

How are Investments/Loans data saved for the Flow by Natures (FINC022)?

02. ANSWER:

Upon adding Investments/Loans (FINA171) or Redemptions/Payments (FINA181), the data are saved to tables FIV, FIW and FJV, which are responsible for displaying the data in Flow by Nature Query (FINC022).

The currency used in these transactions is that of the bank/agency/account (table SA6) linked to the transaction made, even if a different currency was entered when the investment/loan was added (EH_MOEDA).

03. OTHER INFORMATION

Through parameter MV_FINATFN you can disable the saving of data to tables FIV, FIW and FJV while online. 

Thus, to display data in the query of Flow by Nature (FINC022), you need to run the routine of Balance Recalculation by Nature (FINA800).