Our customer wants a report comparing budget vs actual along with Commitments for each account by dimension. Is it possible to report on commitments using Sage Intelligence?
Our customer wants a report comparing budget vs actual along with Commitments for each account by dimension. Is it possible to report on commitments using Sage Intelligence?
I'm not aware of anyone but have tried it using the following tables BUD, FISCALYEAR, PERIOD, GACCOUNT , GCOMMITD. You may need to engage a Professional Service team to assist with this.
You can aso check on the S.I KB site for some guidance
kb.sageintelligence.com/index.php
The commitments & budget information can be found in the examples below:
select
LEDTYP_0,CPY_0,FCY_0,FIY_0,ACC_0,BPR_0,CCE1_0,CMM_0,CMM_1,CMM_2,CMM_3
from
SEED.BLACMM
where
CPY_0='ZA10'
and ACC_0='710000'
and CCE1_0='WHS-001'
select
LEDTYP_0,CPY_0,FCY_0,FIY_0,ACC_0,CCE1_0,AMT_0,AMT_1,AMT_2,AMT_3,AMTCMM_0,AMTCMM_1,AMTCMM_2,AMTCMM_3
from SEED.BUD
where ACC_0='710000'
and BUD_0='BZA'
and VER_0='V1'
*Community Hub is the new name for Sage City