We have a customized report done through Report Writer that someone no longer here did. Right now the budgets from a Prime Change Order are not adding into the Budget line. How do I get this report to work?
We have a customized report done through Report Writer that someone no longer here did. Right now the budgets from a Prime Change Order are not adding into the Budget line. How do I get this report to work?
This is a pre-built calculated field already in Sage. You just have to add the cost code detail
[Select Sum(BdgLin.TtlBdg) From BdgLin Where BdgLin.RecNum = {ActRec.RecNum}] + [Select Sum(PrmChg.CstAmt) From PrmChg Where PrmChg.Status = 1 and PrmChg.JobNum = {ActRec.RecNum}]
Char - Can you please tell me what I'm doing wrong in order to have the Budget calculate correctly by adding the Change Order Budget to the Original Budget to get my report to come out?
Right now it is pulling the original budget totals plus change order budget totals, NOT per cost code. It looks like it probably needs an inner join formula. Do you have a Sage Consultant? I'm not great at inner joins, but Pam Schulz or Walt Matheison are. You will need to contact one of them to modify your report for you for a fee. Sorry. You can email me directly and I could forward to them.
Thank you for your help.
Hi Cindy L, if the above suggested answer helped, please do mark it as verified (by clicking the "more" button) for the benefit of others in this forum :). Thank you!
If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey
*Community Hub is the new name for Sage City