Add shortcut dimension to sales header table

Sapphire123

Hi All,

A customer on ver 5.0 requires one of the shortcut dimension to be inserted on the Sales Order (ie, Sales Header table); and its value to default from the customer. (The same way the Global Dim1 and Global Dim2 behaves)

I'm not sure how many objects this change may affect; if anyone has made such a mod, please suggest the best way to do it.

Any suggestion is appreciated.

tinoruijs

Maybe you could use Developers Toolkit to search for "Shortcut Dimension 1 Code" or "Dimension".
Then you'll see where the field is used.

pri_1_ranjan

you can set the 'Dimesion' as same code in Default dimension setup of the Customer.

Sapphire123

Hi,

I think I got a start on this by looking how the other Globals behave - however, i need some help defining the 'table relation' property of the new field 'Shortcut Dimension 4' that I added in the Sales Header table...

The SQL Query that im' trying to convert is this to a table relation is..

Select dimension value.code
From dimension value, general ledger setup
Where dimension value.dimension code = general ledger setup.shortcut dimension 4;

currently, i've hardcoded this as,
"Dimension Value".Code WHERE (Dimension Code=FILTER(AREA))

But - I'm trying not to hardcode dimension value - 'AREA'..:|