RE: [development-axapta] Customised Filtering

Wed, 28 Apr 2004 03:16:13 -0700

Hi Harry
 
First thing i m not suggesting that Kamtt should create another field for itemgroup, but from the statement of Kamtt it looks like that they are already using ItemGroup field in SalesLine table. If creation of new field is a problem then might be he can create a new datasource for ItemGroup and then use sysTableLookTable class. but i won't suggest creation of new forms only for look until and unless it cannot be done another way. This is what my personal experience says.
 
What ur opinion.
 
 
 
Regards
 
Amit
 
 

"Deshpande, Harry" <[EMAIL PROTECTED]> wrote:
hi Amit!
 
Interesting!
 
The problem with what you are proposing is ...
 
Either I have to create a field to hold the value of 'ItemGroupId' on salesLine. This field does not serve any purpose after a line has been created and violates the 'Normalization' rule for the data. It also takes up unnecessary disk space.
 
One can also create just an extended data type field on the saleTable form (in the sales line grid). However, this means..if  i specify an item group and go to second line to specify a different item group the first item group changes. This will create confusion for the viewer.
 
This is why I recommended a different lookup form on the ItemId with two tabs like the 'location' look up form.
 
Do let me know if you find some problem with the above thinking.
 
regards
 
harry
-----Original Message-----
From: Amit Jain [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 4:50 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Customised Filtering

Hi
 
For this u must have created a data field for itemgroup in the salesline form. you can anytime override the lookup method of the itemid field in SalesLine datasource to control the way look up behaves. All you have to do is use sysTableLookup Class. Refer Axapta's help for this. If you still face problem then let me know.
 
 
Regards
 
Amit

"Deshpande, Harry" <[EMAIL PROTECTED]> wrote:
hi
 
On second thoughts...
 
It will be better if you could change your look up form on the item id to the format of the look up form on the field warehouse (on salesline). So the new lookup with have two tabs. On first tab show itemgroup and on second tab show related items. this will make things easier.
 
regards
 
harry
 
-----Original Message-----
From: kamtt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 27, 2004 7:18 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] Customised Filtering

Hello,
I am new for Axapta and I have encounter below problem.
In Sales Line of Sales Order, I would like to select an ItemGroup
first and then it will automatically filter and shows for Item
Numbers which are only related to selected ItemGroup.

I don't want to jump to Item Number and filter using standard. In
this way, user need to select ItemGroup first and and it will show
filtered Item Numbers when he dirll down on Item Number field.

Please advice me how to solve the problem.

Thanks in advance,
kamtt

Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs

Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
Yahoo! Groups Links

Reply via email to