Adding Contact Name in Foreign exchange loss

[abdulbari]

this request created because of this topic

Request for Detailed Trial Balance Report

our external audit requested a Detailed Trail Balance where all the accounts should appear instead of the control account total or group account total. in order to do this request it is done manually in excel sheet. such as all the account under cash on hand , cash at bank, accounts receivable, accounts payable and other control or group account should appear in the report. we would like to know if this request could be achieved by the system. if not is it possible to add it in the ideas group

when I extracted the data for supplier and customer to excel to prepare detailed trail balance I was struggling when I filtered the transaction based on customer or supplier name specially who has other currency other than the base currency so I have to find out the main transaction keep in mind that the auto generated forex transaction it doesn’t have reference no. it was a bit difficult to find out to match the balances based on supplier or customer ac from the general ledger summary.

please find samples from general ledger summary

as you can see customer or supplier name is not listed in the foreign exchange gain or loss transaction due to that it is difficult to find out which forex entry for which customer or supplier due to that I would suggest the system should capture the customer name in the contact name so it will appear and filtered if it is exported to excel