Trial balance Report with Transaction Journals,Memo,Line Memo,Entity

SCENARIO

The Client require to get a traial balance that shows Memo, Line Memo and entity name in of Journal transactions only.

SOLUTION

We have to customise a Trial Balance Report.

Navigation:

Report>Financila>Trial Balance>Customize

Provide a name for the Trial balance

Under Edit Column Subtab

From Add Fields Select following columns:

  • Trial Balance: Date
  • Trial Balance: Document Number
  • Trial balance: Transaction Type: Long name
  • Trial balance: Line Memo
  • Trial balance: Memo
  • Trial balance: Entity Line: Name

Under Filter Subtab

  • Under Add Fields,
  • Trial balance:Transaction type: long name
  • Select equal to Journal

Save the report

Leave a comment

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