FORMATTED SEARCH FOR A SEGMENTED CHART OF ACCOUNTS
I'm using SBO 9.1 PL4 and a segmented chart.
I have added a udf field in my marketing document on which i want to populate the available balance using formatted search and the following query
SELECT SUM(T0.DebLTotal - T0.DebRLTotal - T0.FtrODRLSum ) AS 'Budget Balance'
FROM OBGT T0 WHERE T0.AcctCode = $[$39.94.0]
GROUP BY T0.AcctCode
The query does not pick the budget amounts as the code does not pick '-SYS......' codes.
Kindly help me amend it so that it picks the '_SYS.....' codes
I have attached screen shot of both segmented chart screen and normal chart screen
You assistance is highly appreciated