Skip to main content
Question

TB with Actual Vs Budget side by side

  • November 28, 2025
  • 1 reply
  • 22 views

Good Day 

how can one get the current detailed TB report to display budget columns next to each TB line?

 

1 reply

nickcerri32
Varsity I
Forum|alt.badge.img+2
  • Varsity I
  • December 17, 2025

@sebongile28 Were you able to find a solution for this?  To me there are two obvious options.  Play around with the following and let me know what you came up with.

  1. You can try to modify the Trial Balance Detailed (GL632500) and bring in the corresponding budget for each Account (and subaccount, if using those).  You’ll want to use the GLBudgetLineDetail DAC with the following join and then bring in the Amount or Released Amount field into the report.  
    1.  

  2. The second option would be to create a Financial Statement for this purpose.  You’d configure your row set to pull in all accounts, probably by class, and then your column set would be configured to mimic the Trial Balance column order (Beginning Balance, Debit, Credit, Ending Balance) followed by a column looking at whatever your Budget ledger is. 
    1.