General Ledger Report with transaction detail and Supplier balance.

REQUIREMENT

The client requires to get a standard report that shows the details of General Ledger, its related transaction, Entity related to transaction and Balance of Entity.

Filter the report based on the Entity, Ledger account,Transaction Type and Subsidiary.

SOLUTION

In this case we can choose General Ledger Report and customise the report to get the desired result.

Steps

1. Go to Report>Financial>General Ledger>Customize
2. Under Edit Column
   1. In Add Fields; Click on transaction
      1. Entity Line
      2. Select Name
   1. In Add Fields; Click on transaction
      1. Vendor
      2. Click on Current Balance
3. Under Filter
   1. In Add Fields; Click Transaction
      1. Transaction Type.
      2. Long Name
   1. In Active Account Type;
      1. Click Name(GL-Style)
   2. In Add Fields; Click Transaction
      1. Entity Line.
      2. Select Name
4. Click on Save Button.