cancel
Showing results for 
Search instead for 
Did you mean: 

Formatted Search

Former Member
0 Kudos

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)

Accepted Solutions (1)

Accepted Solutions (1)

former_member201110
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Hi Owen,

In B1 2005A it also returns 0,0. At least since PL32 (didn't tried it in earlier patches).

Regards,

Vítor Vieira

Answers (1)

Answers (1)

Former Member
0 Kudos

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