Sales Price Table

kwajahathydro

Hi,

When I run sales price table I cant find Global Dimension 1 Code in that table. Our global dimension 1 code is Brands and I would like to add this new field brands to it. How do I do it, is it using Flow Field or how.

If flow field how to write the syntax in the CalcFormula

Pls advise on the above

Regards
KH

Yashojit_Pandhare

Hi,

There are no Global Dimension Fields on Sales Price Table.

Rather add a flow field o Sales Price Table with followig calcformula

Max("Default Dimension"."Dimension Value Code" WHERE (Table ID=CONST(27),No.=FIELD(Item No.),Dimension Code=CONST(BRANDS)))

Hope this works

:thumbsup:

kwajahathydro

Hi,

Thanks!

It worked as what you have suggested.

Regards
KH

slmaluwa

Hi

Is this an Indian localization?

Just wanted to educate my self.

Yashojit_Pandhare

slmaluwa wrote:

Hi

Is this an Indian localization?

Just wanted to educate my self.

It's not localization for sure.

kwajahathydro

Hi,

we are using Nav 2009 SG (SP1)

Regards
KH