Item List Filtering

KARPURSHRIKANT
KARPURSHRIKANT Member Posts: 35
edited 2009-04-29 in NAV/Navision Classic Client
Hi,

Please can anyone help me on the below,

In the Sales Order (form42) There is a field With a "Division Code" this is selectected by a lookup on the Dimension Value.

Now during the Selection of Item in the sales Line thru "Item List" Lookup I would like to filter the Lookup of the "Item List" by the above Division Code. Now in the Item table the DIvision is refered by Name and not By Code.

Please refer the Image Below,


Thanks

Answers

  • jordi79
    jordi79 Member Posts: 280
    Hi,

    The answer is to customise it. So that the item list is filtered based on the dimension value. The complexity will jump in when users change the dimenson value in header after the lines are specified.
  • navuser1
    navuser1 Member Posts: 1,334
    jordi79 wrote:
    Hi,

    The answer is to customise it. So that the item list is filtered based on the dimension value. The complexity will jump in when users change the dimenson value in header after the lines are specified.

    obviously you have to do some customization that can prevent to change the Dimension Value in the Header Part of the form when there is at least one Sales Line/ Purchase Line exist.
    Now or Never
  • Malajlo
    Malajlo Member Posts: 294
    Populate Dimension Code field on OnNewRecord and add another condition in No. TableRel.
    If you change dim val in header, change confirmation ("You have changed Dimension value. Do you want....") to error (or deleteall sales lines).
    If Division code is not the same as Dimension val, add new field in sales line and reffer that field in No. TableRel.

Categories