on 11-27-2008 10:29 AM
hi all
i have created two sales users
sales1(he sales only stationary)
sales2(he sales Computer Products like printers,Monitor..)
warehouses 1,2,3,4,5,6,7
when sales1 login and raises the A\R Invoice, while entering line item warehouse he should get only the warehouses 1,2,5
when sales2 login and raises the A\R Invoice, while entering line item warehouse he should get only the warehouses 3,4,6,7
how to make the different formatted search for the same field when the user changes(sales1,sales2)
Hi Mohanapriya,
You used to be able to use
select $[USER]
in formatted searches to return the UserID (from OUSR) of the current user. You could then use this to modify the results returned by the formatted search.
However, this appears to be broken in 2007A and always returns 0
I don't know of any other way to return user specific results unless you write an addon.
Kind Regards,
Owen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mohanapriya,
If you create an sql Function that will take as parameters the itemcode of the line and the userid of the document and will return the desired warchouse codes that you want, it will work.
Hope it helps,
Kind Regards
George Christodoulou
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.