Need more dis option in finance General Ledge Report

DEAR team 

For daily finance query and analysis purposes, we need more data display options in General Ledge Report, or Trail balance report:

1. need to display the account balance for foreign currency business. like, we need to know the account payable balance of EUR currency only. 

2. need to display the account balance for one specific customer or supplier. like we need to know the account payable balance for supplier A; we need to know the advance purchase payment balance for supplier A.