Product:

Microsiga Protheus

Occurrence:

Example of Investment and Loan Booking

Step by step:

The booking of Investments and Loans in the system occurs in two stages. When adding them and monthly, interests and taxes are booked, using the routines "Miscellaneous/Accounting/Inv/Loan Approp." and "Miscellaneous/Accounting/Shares Approp."

For all standard entries, SEH fields must be used, since it displays specific fields for accounting operations.

In investments of Investment Funds per Shares, income tax is withheld by tax authorities. This is why you must run the investment by shares booking routine ("Miscellaneous/Accounting/Shares Approp.") always in the last business day of the month, so the system can also calculate Income Tax and deduct the calculated value of balance in investment shares. If you do not do this, there will be a difference in the balance of investment shares between the system and the Financial Agent where the investment was made.

LP 580 – Addition of Investment/Loan

Example of LP configuration:

Account: If(SEH->EH_APLEMP=”APL”, “Investment Account”, “Loan Account”)

LP value: SEH->EH_VALOR

History: If(SEH->EH_APLEMP=”APL”, “Financial Investment”, “Bank Loan”)

LP 581 – Deletion of Investment/Loan

Example of LP configuration:

Account: If(SEH->EH_APLEMP=”APL”, “Investment Reversal Account”, “Loan Reversal Account”)

LP value: SEH->EH_VALOR

History: If(SEH->EH_APLEMP=”APL”, “Deletion of Financial Investment”, “Deletion of Bank Loan”)

LP 582 – Monthly booking of Investment interest/taxes and Loan Interest.

·   The interest value is updated in field EH_VALJUR

·   The Income Tax value is updated in field EH_VALIRF

LP value: If(SEH->EH_APLEMP=”APL” .And. SEH->EH_TIPO $ GetMv(“MV_APLCAL4”) ,SEH->EH_VALJUR,0)

History: If(SEH->EH_APLEMP=”APL” .And. SEH->EH_TIPO $ GetMv(“MV_APLCAL4”), “Bank Loan Interest”,"")

LP 584 – Reversal of monthly booking of Taxes of Investments by Shares

LP 585 – Redemption of Investment/Loan

Seq. 01

LP value: SEH->EH_VALJUR

History: If(SEH->EH_APLEMP=”APL”, “Financial Investment Interest”, “Bank Loan Interest”)

Seq. 02

LP value: SEH->EH_VALIOF

History: If(SEH->EH_APLEMP=”APL”, “Financial Investment IOF”, “Bank Loan Interest”)

Seq. 03

LP value: If(SEH->EH_APLEMP=”APL”,EH->EH_VALIRF,0)

History: If(SEH->EH_APLEMP=”APL”, “Income Tax on Financial Investment”, “”)

LP 586 – Reversal of Redemption of Investment/Loan

Seq. 01

LP value: SEH->EH_VALJUR

History: If(SEH->EH_APLEMP=”APL”, “Reversal of Financial Investment Interest”, “Reversal of Bank Loan Interest”)

Seq. 02

LP value: SEH->EH_VALIOF

History: If(SEH->EH_APLEMP=”APL”, “Reversal of Financial Investment IOF”, “Reversal of Bank Loan Interest”)

Seq. 03

LP value: If(SEH->EH_APLEMP=”APL”,EH->EH_VALIRF,0)

History: If(SEH->EH_APLEMP=”APL”, “Reversal of Income Tax on Financial Investment”, “”)