Drillable Trial Balance

From ADempiere
Jump to: navigation, search
This Wiki is read-only for reference purposes to avoid broken links.
  • Right click and zoom from any number to get a report of trx making up the number

Trial balance drillable.jpg

  • Click on Zoom button to open the document for a particular line (use table+record_id to open the document directly).

Trial balance drillable2.jpg

  • Possible to add different filters but presently hard-coded.

Trial balance drillable3.jpg

  • The report shows the opening balance at the selected start date and all trx since
  • The payment column is virtual and finds the Payment linked to the Allocation that is shown.
  • "Zoom" in HTML mode shows the spyglass and opens the related document immediately
  • the opening balance date is a trick!
  • It is a virtual column that says MyDate equals DateAcct but if "Table" is null then subtract one day then everything sort by date nicely.

Trial balance drillable4.png