With Sage Accpac ERP version 5.3B and later you can create financial statements where you can drill down to see the detailed transactions making up the balance.

This is done using the FRTRN and FRTRNA functions in the spec area of the statement - as per the figure below.

Once you have defined the column with the new function run the statement using FR View.  Cells with the red mark on the upper right hand corner can be used for drilldown.

Right-click on a results cell, then choose FR Drilldown from the ensuing drop-down menu. The original transaction details will appear in a separate window.

 Double click on the transaction you want to drill down on and a new window will open showing the GL transaction that created this entry.

 For transactions originating in the subledgers you can further use the drill down icon (located at the right of the entry number) to see the original entry (AR Invoice, AP Invoice etc).  

 For more information about Sage Accpac ERP contact us at (416) 490-1339