Add shortcut dimension to sales header table

Sapphire123
Sapphire123 Member Posts: 112
edited 2008-04-10 in NAV/Navision Classic Client
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.

Comments

  • tinoruijs
    tinoruijs Member Posts: 1,226
    Maybe you could use Developers Toolkit to search for "Shortcut Dimension 1 Code" or "Dimension".
    Then you'll see where the field is used.
    Tino Ruijs
    Microsoft Dynamics NAV specialist
  • pri_1_ranjan
    pri_1_ranjan Member Posts: 67
    you can set the 'Dimesion' as same code in Default dimension setup of the Customer.
    /PDR
  • Sapphire123
    Sapphire123 Member Posts: 112
    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'..:|

Categories