Skip to Content
avatar image
Former Member

calcaccount procedure - account transformation business rules

Hi I have a question concerning the calcaccount procedure.

I already made some Cashflow accounts

I already filled in some lines in the account transformation business rules

But now I was wondering how to run these business rules:

I have made the following calcaccount logic, but when I run it I get nothing for the moment

*XDIM_MEMBERSET INTCO=GLTOT

*XDIM_MEMBERSET GROUPS=C_WDP

*XDIM_MEMBERSET ENTITY=E_TOTAL

*IGNORE_STATUS

*RUN_STORED_PROCEDURE = SPRUNCALCACCOUNT([FINANCE],[%CATEGORY_SET%],[C_WDP],[%SCOPETABLE%],[%LOGTABLE%],[CF])

*COMMIT

I don't have a clue if this logic is even correct or not

Please help me

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 24, 2008 at 09:51 AM

    Hi Benjamin,

    Below a working example:

    *run_stored_procedure=spruncalcaccount('finance','%category_set%','LC','%scopetable%','%logtable%')
    *commit
    

    Hope this helps,

    Alwin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Alwin,

      I tried this but it doesnt work

      *XDIM_MEMBERSET INTCO=GLTOT

      *XDIM_MEMBERSET GROUPS=C_WDP

      *XDIM_MEMBERSET ENTITY=E_TOTAL

      *IGNORE_STATUS

      *RUN_STORED_PROCEDURE = SPRUNCALCACCOUNT([FINANCE],[%CATEGORY_SET%],[C_WDP],[%SCOPETABLE%],[%LOGTABLE%])

      *COMMIT

      I have the following in the formula log:

      Start time --->3:36:33 PM - Date:9/24/2008 (build code:254)

      ****************************************************************************************************

      User:WDP\Administrator

      Appset:WDP_ONTWIKKELING

      App:FINANCE

      Logic mode:1

      Logic by:

      Scope by:

      Data File:

      Debug File:D:\BPC\Data\Webfolders\WDP_ONTWIKKELING\FINANCE\PrivatePublications\Administrator\TempFiles
      DebugLogic_7_.Log

      Logic File:D:\BPC\Data\WebFolders\WDP_ONTWIKKELING\FINANCE
      ..\AdminApp\FINANCE\Calcaccount.lgx

      Selection:D:\BPC\Data\WebFolders\WDP_ONTWIKKELING\FINANCE\PrivatePublications\Administrator\TempFiles\FROM_7_.TMP

      Run mode:1

      Query size:0

      Delim:,

      Query type:0

      Simulation:0

      Calc diff.:0

      Formula script:

      Max Members:

      Test mode:0

      Is Modelling:1

      Number of logic calls:1

      -


      Call no. 1, logic:D:\BPC\Data\WebFolders\WDP_ONTWIKKELING\FINANCE
      ..\AdminApp\FINANCE\Calcaccount.lgx

      -


      signeddata is YTD

      -


      Building sub-query 1

      -


      Query Type:0

      Max members:

      Executing SPRUNCALCACCOUNT [FINANCE],[ACTUAL],[C_WDP],[SPSCOPE_312035],[SPLOG_394894]

      SPRunCalcAccount Version 2.06

      2 Rows Calculated

      2 Rows Updated

      Time to run stored procedure:26.5 sec.

      call 1 completed and data posted in 26.7 sec.

      Run completed in 27.3 sec.

      ****************************************************************************************************

      End time --->3:36:59 PM - Date:9/24/2008

      As you can see he doenst post records to the cashflowaccounts..

      Do you know what is wrong?

  • avatar image
    Former Member
    Sep 24, 2008 at 02:11 PM

    Hi Benjamin,

    From your logfile I can see that the sp has calculated two records.

    Executing SPRUNCALCACCOUNT FINANCE,ACTUAL,C_WDP,SPSCOPE_312035,SPLOG_394894
    
    SPRunCalcAccount Version 2.06 
    2 Rows Calculated 
    2 Rows Updated 
    

    So it seems to work. You now have to research the calculated records by looking at the account transformation rules and the created records in SQL. I mostly do this by optimizing the application (lite) so that the wb table has no records. Then I enter amounts in the source accounts/subtables, run the logic and then look to the wb table to see what records are created.

    By the way, the lines

    *XDIM_MEMBERSET INTCO=GLTOT 
    *XDIM_MEMBERSET GROUPS=C_WDP 
    *XDIM_MEMBERSET ENTITY=E_TOTAL 
    
    
    *IGNORE_STATUS 
    

    are totally irrelevant and can be removed, the sp calls don't look to these lines.

    Alwin

    Add comment
    10|10000 characters needed characters exceeded