Skip to Content
0
Former Member
Nov 25, 2008 at 04:41 PM

Cross Applications - Logic

23 Views

Hi All!

I am trying to use a script for calculate a new record with the cost of goods (quantity * unit cost). I am using two applications: sales and prices_costs with the following dimensions:

- Sales (category,customer,entity,family,rptcurrency,salesaccount,salesorg,subfamily1,time)

- Prices_Costs (category,customer,entity,family,salesaccount,time)

Here it is my script logic (located in the default.LGF of sales application):

*LOOKUP PRICES_COSTS

*DIM COGSAMOUNT:SALESACCOUNT="COGSAMOUNT"

*DIM BUDGET:CATEGORY="BUDGET"

*DIM NA:ENTITY="NA"

*DIM NA:CUSTOMER="NA"

*ENDLOOKUP

*SKIP_DIM=RPTCURRENCY,SALESORG,SUBFAMILY1

*WHEN SALESACCOUNT

*IS "COGSAMOUNT"

REC(EXPRESSION=%VALUE%GET(SALESACCOUNT="COGSAMOUNT"))

*ENDWHEN

*COMMIT

But this is not working...

Any help is appreciated!

Regards, Fred