cancel
Showing results for 
Search instead for 
Did you mean: 

ScripT lOGIC FOR MULTIPLING TWO ACCOUNTS

Former Member
0 Kudos
77

Hi All,

We need to multiply two accounts using SQL script logic.

Account3=Accoun1*Account2

Accoun1 : Units

Account2 :Price

Account 3:Total

In the above scenerio units will be inout by user through Input schudule,while value of Price will be loaded in account and will not change. and we need calculate Account3(Total) at RUN time.

So Please help me with the script logic code to ge used in default.lgf

Accepted Solutions (1)

Accepted Solutions (1)

i045436
Advisor
Advisor
0 Kudos

Hello,

*WHEN ACCOUNT

*IS u201CAccount1u201D

*REC(ACCOUNT=u201DAccount3u201D, FACTOR=GET(ACCOUNT=u201DAccount2u201D))

*ENDWHEN

Former Member
0 Kudos

we are using this code only , but in reports its not showing the value for account 3 rather it shows 0 for all values , where user is changed has input value for units "account1"

Former Member
0 Kudos

Hi,

If this logic is in default logic file then run the default package once from Data Manager.

regards,

Lokesh Nandula

Answers (3)

Answers (3)

Former Member
0 Kudos

thanks

Former Member
0 Kudos

thanks

i045436
Advisor
Advisor
0 Kudos

Hello,

If you added this code into Default logic and validate and save th elogic, it should work.

You can run the default logic using the Data Manager and have a look to the log file generated into Private Publication to see if the right record is generated for the Account3.

Regards,

Mihaela