Skip to Content
avatar image
Former Member

Journal Entries SAP BPC ISSUE

Hi experts

I am using The below logic script to effect the profit of the year in rhe balance sheet by any transaction that happen on the Income statement

// This script contains the logic which is executed whenever data is entered and sent

*XDIM_MEMBERSET CATEGORY = Actual

*XDIM_MEMBERSET ENTITY = CSO

*WHEN ACCOUNT.ACCTYPE

*IS "INC"

*REC(FACTOR=1,ACCOUNT="000210000201")

*ELSE

*WHEN ACCOUNT.ACCTYPE

*IS "EXP"

*REC(FACTOR=1,ACCOUNT="000210000201")

*ENDWHEN

*ENDWHEN

the problem is i have posted 4 entries and each one of them is balanced and totally sure that its balanced

but when the 4 entries are posted the system seems that it refuse one of them or something and there is a difference in the balance sheet

It seems that the logic script when i post 2 Entries it duplicate the first 1

Example

I have posted the entry A

so the logic script effect the balance sheet by the entry A

then i post entry B so the logic script effect the balance sheet by A again and then B

so how the make the Logic script just effect the balance sheet by only new entries ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Oct 18, 2015 at 04:07 PM

    Can you explain script calculation logic in words with some sample? Why do you check for ACCTYPE? Is it default.lgf?

    The script text is strange, but it's impossible to correct without clear requirement!

    And please, read: How To: Ask questions about Script Logic issues

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2015 at 04:38 PM

    My requirement is to post the changes on the P/L to the retained earning in the balance sheet by default

    Add comment
    10|10000 characters needed characters exceeded

    • Sorry, what do you mean by "the logic script just duplicate the first Adjustment as it was posted in the first time and it post it again in the second time"

      What do you mean - "script work fine " and "do the second Adjustment"

      Looks like I will be unable to help without real screenshots of your system!

  • avatar image
    Former Member
    Oct 18, 2015 at 07:24 PM

    Hi Vadim

    I did exactly what u told me

    i simplified the process as much as possible and that's what i found

    the script logic when i post the first journal A = 200

    it use the 200 correctly and post it to the Gl 000210000201 = 200

    but when i post the second journal B =300

    it use the 300 and post it to Gl 000210000201 =300 with out summation  200+300

    it suppose to be 500 but it just erase the old value (200) and post the new value 300

    so how to make the logic sum new values with old values

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      first i posted 4 journals and there is no problem with them

      i am trying to make the logic to run by default but i face the same issue

      when i ran the logic using Data package it worked correctly

      *XDIM_MEMBERSET CATEGORY = Actual_IFRS

      *XDIM_MEMBERSET ENTITY = CSO

      *XDIM_MEMBERSET AUDITTRAIL = Journal_Entries

      *WHEN ACCOUNT.ACCTYPE

      *IS "INC","EXP"

      *REC(FACTOR=1,ACCOUNT="000210000201")

      *ENDWHEN

      we need it to be automatically so we need it to run by default

  • avatar image
    Former Member
    Oct 18, 2015 at 04:35 PM

    here its numeric example to see what happen

    total assets =2000

    liability = 1000

    retained earning = 1000

    so Balance sheet = 0

    net income = 1000

    if i posted entry A

    dr expense 500

    cr account payable 500

    it will be like this

    total assets =2000

    liability = 1500

    retained earning = 500

    so Balance sheet = 0

    net income = 500

    the logic script as i told u take the changed that happened on P/L account and post it to retained earning

    the problem come when i post second entry B

    it just duplicate first one (A)

    i tried to post journal B first then A and i found that B is duplicated

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2015 at 04:59 PM

    account based calculation will take all the amount of the net income and i don't want this for financial wise

    i only need to post the changes (journal Entries ) on the P/L GL to the retained earning

    Only the changes cause i already take the all amounts before and consolidate it with some Adjusments

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2015 at 07:34 PM

    Just to be more accurate

    Gl balance  = 5000

    journal A = 1000

    logic change Gl balance to 6000

    Journal B = 3000

    Logic change Gl Balance = 8000 but it suppose to be 9000

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 18, 2015 at 08:10 PM

    first i posted 4 journals and there is no problem with them

    i am trying to make the logic to run by default but i face the same issue

    when i ran the logic using Data package it worked correctly

    *XDIM_MEMBERSET CATEGORY = Actual_IFRS

    *XDIM_MEMBERSET ENTITY = CSO

    *XDIM_MEMBERSET AUDITTRAIL = Journal_Entries

    *WHEN ACCOUNT.ACCTYPE

    *IS "INC","EXP"

    *REC(FACTOR=1,ACCOUNT="000210000201")

    *ENDWHEN

    we need it to be automatically so we need it to run by default

    Add comment
    10|10000 characters needed characters exceeded

    • You have to read my document about default.lgf - the script works differently!

      How-To: Write default.lgf

      Read about sign conversion!

      SignedData_Result = if(Result.ACCTYPE=INC,LEQ, -1, 1) * Function(if(Argument1.ACCTYPE=INC,LEQ, -1, 1) * SignedData_Argument1, if(Argument2.ACCTYPE=INC,LEQ, -1, 1) * SignedData_Argument2, ...)

      That's the reason why I told you to test on the EXP type accounts!

      Your script is correct for DM package, but for default.lgf it has to be like:

      *XDIM_MEMBERSET CATEGORY = Actual_IFRS

      *XDIM_MEMBERSET ENTITY = CSO

      *XDIM_MEMBERSET AUDITTRAIL = Journal_Entries

      *WHEN ACCOUNT.ACCTYPE

      *IS "INC"

      *REC(FACTOR=-1,ACCOUNT="000210000201") // -1!!!!

      *IS "EXP"

      *REC(FACTOR=1,ACCOUNT="000210000201")

      *ENDWHEN

      Or  the opposite depending on ACCTYPE of 000210000201!

      What is the ACCTYPE of 000210000201?

  • avatar image
    Former Member
    Oct 19, 2015 at 09:17 AM

    the acctype of 000210000201 is LEQ

    and for ur info when i post 5000 the logic use the 5000 correctly but when i post another 3000 the logic remove the 5000 and post the 3000

    so it erase the old balance of the GL and post the new one

    Add comment
    10|10000 characters needed characters exceeded

    • I am unable to understand what you are doing without a lot of screenshots... All steps!

      And start with 2 accounts of type EXP - ONLY 2 accounts!

      And create 2 journals for the same account from 2.

      POST REAL SCREENSHOTS!

      Do you understand me?

  • avatar image
    Former Member
    Oct 19, 2015 at 11:47 AM

    the first screen shot is for below 2 expense acc

    0252121000_C - National Organization for social Ins 0311010100_C - marcel

    when i posted 500 on 0252121000_C the logic worked fine and posted the 500 to 000210000201

    but when i posted 1000 to 0311010100_C the logic erased the 500 from the gl 000210000201 and posted the new amount only ( 1000 )

    it must be 500+1000


    3333.png (178.1 kB)
    Add comment
    10|10000 characters needed characters exceeded