Hello,
is there any way to change the view in the lookup item field for the line items by order entred, i want to add the User category value 3, order by it and put it in the first column of my view, and set it by default for all user or other way take a smartlist and put it in this view.
thanks,
*This post is locked for comments
Hi Leslie,
if you take a look at my first pic, you'll find the lookup field for item number in sales transaction entry goes to items, this is what i called items lookup field.set up default view works fine with GP2013, not in GP2010R2, i try also the Smartsort, is a best tools, you can custom your sort and map smartlist.
thanks
ok, good thanks a lot for your a help, i find also the smartsort software is amazing, you can add your smartlist as view, but i don't find the items lookup field, thanks again.
Unfortunately, in GP 2010, set as a default view doesn't include any additional sorts. This feature has been added later on.
Therefore, you will not be able to achieve this through the out of the box functionality of Dynamics GP.
Not strange, you are on GP 2010. Right ?
Something strange i don't find this field in my sql table structure (ASI_Additional_Sort)
Run the following script in your test environment, you should first add the "User Category 3" into Advanced Lookup setup.
Fill in the company id parameter for the test company, to check the company id for your test company, run the following script;
SELECT CMPANYID, CMPNYNAM FROM DYNAMICS..SY01500
INSERT INTO [DYNAMICS].[dbo].[ASIEXP99]
([CMPANYID]
,[USERID]
,[FORMNAME]
,[Default_View]
,[ASI_Favorite_Type]
,[ASI_Additional_Sort])
VALUES
(
#companyid
,'sa'
,'IV_Item_Number_Lookup'
,1
,4
,21
)
GO
we don't have the modifier module, i don't think that it was any changes before, could you send me the insert or update line that u wish me to run against my sql table for the sa user.
Okay then,
I hope you could limit down the possibilities of having this as inactive, any previous VBA modifications on the system for instance. Because I can see in the Smart List favorite table records associated with sa and other GP users, which means that it has been working fine.
In your case, I would try to insert the record manually (on the company test environment) in the table for a certain user and check the look up window.
Your feedback is highly appreciated.
it's gray in the live environement GP2010R2, but i have tested in my test lab environement GP2013, isn't gray, it works fine.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (