Journal.Lgf taking last record for posting record ...

former_member291708 · ‎2018 Nov 23

Hi Experts,

I have below script in JOURNAL.LGF and while doing journal posting from front end it is moving only last journal record which I am posting to account 2941000.

Logic for below code is I am moving data from node INCOME_STATEMENT to Retained earning account (i.e. 2941000) and at the same time defaulting the values to FUNC_AREA, INTERCO & PROFIT_CTR.

*XDIM_MEMBERSET ACCOUNT AS %PL%=BAS(INCOME_STATEMENT) //No scope change, just fill variable %PL%
*FOR %P%=%PL% //separate WHEN/ENDWHEN for each P&L account
*WHEN ACCOUNT
*IS %P%
*REC(EXPRESSION = [ACCOUNT].[INCOME_STATEMENT], ACCOUNT = 2941000,FUNC_AREA = F0000, INTERCO = I_NONE, PROFIT_CTR = 2651000, FLOW = BALANCE)
*REC(EXPRESSION =

([ACCOUNT].[INCOME_STATEMENT],[FLOW].[BALANCE])-([ACCOUNT].[2941000],[FLOW].[OPE]), ACCOUNT = 2941000,FUNC_AREA = F0000, INTERCO = I_NONE, PROFIT_CTR = 2651000, FLOW = F_ACurPerErngs)
*ENDWHEN
*NEXT

Current Result

Below is the test case. I am posting record for 3000000 and it is taking the same value and posting it to 2941000.

Expected result.

While posting value in any account of base member BAS(INCOME_STATEMENT) it should take total value of INCOME_STATEMENT and same should be posted to 2941000. In the above case it should be 11000.

former_member186338 · ‎2018 Nov 26

Just tested in my system - everything is working correctly. And I recommend you to reproduce my test in the copy of ENVIRONMENTSHELL:

JOURNAL.LGF:

*XDIM_MEMBERSET ACCOUNT AS %PL%=BAS(PL600)
*FOR %P%=%PL%
  *WHEN ACCOUNT
  *IS %P%
    *WHEN AUDITTRAIL
    *IS <> Other
      *REC(EXPRESSION= [ACCOUNT].[PL600], ACCOUNT = BS212,AUDITTRAIL=Other, INTERCO = ThirdParty)
    *ENDWHEN
  *ENDWHEN
*NEXT

Before posting Journal:

Posting Journal:

Result:

Everything is correct!

After unposting journal I am back with:

former_member186338 · ‎2018 Nov 23

When you post the journal - you are posting not the final value but the delta to be added to the existing value.

Journal.lgf is working with the final value after addition.

Please provide a sample with journal posting:

1. Post some value without Journal.lgf (empty - commented!)

2. Show result.

3. Unpost Journal

4. Uncomment Jornal.lgf

5. Post again

6. Show results

former_member291708 · ‎2018 Nov 26

Hi Vadim,

Below is the test result for your above mentioned points

First of all below screen shot is of the current data

1) Post some value without Journal.lgf (empty - commented!)

I have posted the additional value of "3000" to account 3004100 with commenting Journal.LGF

2) Show result. Below is the result.

Value increased for account 3004100 from 19000 to 22000. However as a result of commenting no values changes have been done to account 2941000

3. Unpost Journal

I did the same

4. Uncomment Jornal.lgf

I did this too.

5. Post again

Posted the same journal again

6. Show results

Conclusion:

It is taking the total amount of the account in which I am posting the journal and copying the same to account 2941000.

Let me know your input. 🙂

former_member186338 · ‎2018 Nov 26

First - don't use RSA1 to show data, use BPC report! Very hard to read! Dimension names are not clear, record aggregation required etc...

Please show the same using BPC report with all dimensions clear! Also show INCOME_STATEMENT value in the report.

Second - use simple script:

*XDIM_MEMBERSET ACCOUNT AS %PL%=BAS(INCOME_STATEMENT) //No scope change, just fill variable %PL%
*FOR %P%=%PL% //separate WHEN/ENDWHEN for each P&L account
*WHEN ACCOUNT
*IS %P%
*REC(EXPRESSION
 = [ACCOUNT].[INCOME_STATEMENT], ACCOUNT = 2941000,FUNC_AREA = F0000, 
INTERCO = I_NONE, PROFIT_CTR = 2651000, FLOW = BALANCE)
*ENDWHEN
*NEXT

Read: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

former_member291708 · ‎2018 Nov 26

Hi Vadim,

Below is the test result for your above mentioned points

First of all below screen shot is of the current data

1) Post some value without Journal.lgf (empty - commented!)

I have posted the additional value of "3000" to account 3004100 with commenting Journal.LGF

2) Show result. Below is the result.

Value increased for account 3004100 from 19000 to 22000. However as a result of commenting no values changes have been done to account 2941000

3. Unpost Journal

I did the same

4. Uncomment Jornal.lgf

I did this too.

5. Post again

Posted the same journal again

6. Show results

Conclusion:

It is taking the total amount of the account in which I am posting the journal and copying the same to account 2941000.

Let me know your input. 🙂

Journal.Lgf taking last record for posting record in script logic

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (5)

Answers (5)