Skip to Content
0

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

Dec 16, 2016 at 06:31 PM

98

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mauro Galimberti Dec 16, 2016 at 07:19 PM
0

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


id-1.png (13.3 kB)
id-1-db.png (20.3 kB)
id-2.png (16.5 kB)
id-2-db.png (44.3 kB)
id-1-unposted.png (30.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jan 19, 2017 at 11:53 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Nilanjan Chatterjee Jan 20, 2017 at 03:29 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded