Item List Filtering

KARPURSHRIKANT

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

jordi79

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

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.

Malajlo

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.