x Want to participate? Join the group to interact

Sage 100

Reporting and Analytics Sage intelligence add functions

Sage intelligence add functions

Posted By KathyW 5 months ago

SI has a function for "GLActual" that nets the debits and credits.

Is it possible to add 2 different functions to get the debit and credit separately?

the data exists in the actuals currently included sub report.

0 Doc102208 5 months ago

Are you wanting a report like the Trail Balance?
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel
0 KathyW 5 months ago in reply to Doc102208

yes, but the client wants the debits & credits separated.
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel
0 Debbi_S 5 months ago

I use 2 columns

In the debit column =if(GLActual.....)>=0,GLActual(...),o)

in the credit column =if(GLActual.....)<0,GLActual(...),o)
Cancel
Vote Up 0 Vote Down

Reply

Verify Answer

Cancel