This report shows domestic currency balances from AA ledger broken by original transaction currency. If a portion of account balance in AA ledger is related to a foreign currency values from CA ledger are also shown.

The report will not show opening balances for P&L accounts as setup by GLG automatic accounting instructions. Also if an account has no values to show in the report (no opening balance, no transactions) it can be hidden in the printout if requested.

The output of the report is a CSV file that can be processed in MS Excel.

The solution is designed to allow editing of Tax Point Date in the Tax File and related Account Receivables and/or Payables records. Standard application does not allow these kind of changes hence the modification. To ensure data security a Change Log is created for every line in the Tax File that was modified. The previous value of the date is kept in the log file along with the name of the user who modified the record.

The mass tax point update program allows to perform batch changes in Tax File. This program also writes to the Change Log file. It uses UDC to setup rules behind the tax point date change.

The report is a clasic version of a Trial Balance report with four types of aggregations added. It can show all details of an account balance down to subledger by default. Aggregations include: category code, object and subsidiary account or business unit and category code or business unit, object account an sunsidiary account. The report may include any of the category codes for account master.

The output of the report is a CSV file that can be processed in MS Excel.

This program is used for bank account FIFO valuation. The product was developed based on JD Edwards end-user needs and should be considered as polish (and not only) best business practices. It allows to decrease time and cost associated to this manual, human prone errors activities usually done on side in MS Excel. Solution allows to:

Adjustment of PLN value of transactions in a monetary account by adding an applicable amount of exchange rate differences calculated using FIFO method.

Full flexibility of exchange rate differences calculation in cases where the balance character changes overtime from positive to negative (for overdrafts) by calculating the differences:

for money outflows only when the balance before transaction is positive and only to the balance amount
for money inflows only when the balance before transaction is negative and only to the balance amount
Ability to start calculation at any given time by averaging exchange rate for all transaction posted before a specified date in the past. The cut-off date is user definable.

Automatic creation of supporting journal entries in general ledger for amounts calculated.

Detailed transaction posting of amounts calculated by every detailed transaction that caused exchange rate differences.

Analysis of exchange rate differences amounts based on a detailed calculation report.

 - FIFO account valuation