Skip to Content
avatar image
Former Member

BPC MS 10.1 Journal Script logic: automatic calculation of I_NONE from Intercompany codes

Dear All,

In Manual Journal Entries must be booked including possible impact on I_NONE (third parties).

We want to use the script logic “Journal.LGF” in order to calculate the Intercompany code I_NONE automatically and we wrote these rules:

*WHEN INTERCO

*IS <> "I_NONE"

*WHEN AUDITID.DATASRC_TYPE

*IS "M"

*REC(FACTOR=1,INTERCO="I_NONE")

*ENDWHEN

*ENDWHEN

*COMMIT

The system runs without problem during the “posting Activity”. We have some problems during the “Unposting activities”.

Some people are using this automatic logic in the journal script?

Thank you for your help

Regards

Mauro

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 16, 2016 at 07:19 PM

    Details of the error:

    Journal ID n° 1:

    Values in the Data Base

    The system has created the record “I_NONE” for the item “1212020” with the value -96037 (value of the Intercompany detail)

    Journal ID n° 2:

    Values in the Data Base

    Final sum by account

    The figures are correct.

    Unposting journal ID n° 1:

    For the account 1212020 the system should be “unpost” only the value 96.037. The problem is that the system is unposting all the values in this account

    Thanks

    mauro

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 11:53 AM

    Journal.lgf works with the final values in the cube after posting journal, not with the values in the journal.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2017 at 03:29 AM

    Hi Mauro,

    You should scope all the dimensions to %DIMNAME_SET%, to get better results. Also, please note what Vadim has mentioned. Script logic will work on all the data which is scoped by your scoping statements.

    Add comment
    10|10000 characters needed characters exceeded