Compiere Treasury Management Customizations

Treasury Receipt, Manage Treasury, Average currency and Monetary items, Calculate Revaluation, Post Treasury management, Daily Average and Revaluation of Monetary items, Get Currency Queue Report, Daily Average report, Unrealized forex gain/loss report

Treasury Receipt
To capture Loan borrowed from Bank and Share holder. Document number will be entered by the user. Validation for Document Number is done. Both VND and Foreign currency loan can be accounted.

Manage Treasury
To account for Bank loan repayment, transfer of cash from one bank to other, Bank withdrawal, Interest Income and Deposit. In TM line user will enter the corresponding GL account. Bank account sequence will be generated based on bank account selected in the header.

Post Treasury management
To post FC currency forex real rate with average rate on sell and to post average rate for transfer.

Manage Average currency
For all Foreign currency Average Currency will be calculated on daily basis. Based on the Average currency all out transactions will be posted. Forex gain loss will be calculated based on the Average Currency.

Manage Monetary items
To define Monetary items for which revaluation to be done on the Month end and Year end.

Calculate Revaluation
For all the Monetary items system should calculate to Revaluation. Revaluation entry to be created and posted at the end of the month. The same entry to be reversed at the beginning of the month.

Post Daily Average
To set the daily average rate calculation process and update average currency before posting FC transactions.

Post Revaluation of Monetary items
To post Revaluation of monetary items

Currency Queue Report
To Display average currency details for each FC

Daily Average report
To list the daily FCIN, FCOUT and Average currency for cross verification

Unrealized forex gain/loss report
Report to list unrealized forex gain/loss in all the transactions

compiere_upgrade

Leave a Reply

Your email address will not be published. Required fields are marked *