How to filter the items specific to the order on lokup

SH2010 · 2016-09-30

when i pick order number on a the Sales form no. 45. I want to look up items. When I click the item look up I want to see only the items that are associated with the order number rec that I have. What code do i put.

Kishorm · 2016-10-03

To extend upon what Mohana has said... you should add a field for "Sales Order Line No." in your table and then lookup that field using a relation as he has described. If you would like to show the actual item no. and possibly description then you can add these fields as flowfields onto your new table and show them on the form too.

SH2010 · 2016-09-30

i mean on a form that is based on sales order form 45

RockWithNAV · 2016-09-30

You want to see only those Items which are associated with your Order??
Can you please make it a level more clear?

manishkutar · 2016-09-30

Hi,

As I understand-
1. You need to only list the items which are related to specific Order
2. You are using NAV older then NAV 2013 version and need changes in Form and not page

Can you please clear on my above understandings? If feasible, please also share the process or scenario you're doing in NAV. For example, you're posting Sales Invoice by receiving Shipments.

SH2010 · 2016-10-03

Yes Manish I am on NAV 2009 Classic .
1. I need to list the items that are related to the specific sales order. - list of the items placed on the order.
2. I am doing a customization for booking trucks to collect goods bought on a sales order. So after placing the sales order in Nav I want link the particular sales order to a booking so that customers can have specific date and time to collect.
3. So on my booking entry form I look up and pick the sales order number from the sales list. Once I have my order number on the next field on the form I want to look up and be able now to pick the products to be picked (because I do booking for prducts because they are collected at different bagging / despatch points) . So I want to allocate the date and time and collection point for the products that are to be collected.
When click look up into the item list I just want to see the products on the order that have not been collected yet.
I hope this clarifies.
5. Thanks

mohana_cse06 · 2016-10-03

You can create a table relation with Sales Line table with field relation of order no selected and Document no. of Sales Line

Kishorm · 2016-10-03

To extend upon what Mohana has said... you should add a field for "Sales Order Line No." in your table and then lookup that field using a relation as he has described. If you would like to show the actual item no. and possibly description then you can add these fields as flowfields onto your new table and show them on the form too.

SH2010 · 2016-10-07

Thanks to all of you guys. I am answered, it worked

How to filter the items specific to the order on lokup

Best Answer

Answers

Categories