Skip to Content
0
Former Member
May 14, 2010 at 08:57 PM

Auto Popluate Warehouse on Sales Order based on User

41 Views

Hello Experts,

Need help on the following scenario:

In one of our client's database ,Every user has a default Warehouse assgined in User Defaults Group ( OUDG).For instance, Manager is asigned Warehouse Code '01' in OUDG.

I would like to create a query and assign a formatted search on Sales Order to Whse column on Order rows so that Warehouse '01' populates automatically when item code changes based on user id. Say a different user X has '02' warehosue assigned in OUDG , when X logs-in on all sales orders rows warehosue '02' should populate.

Any help would be appreciated.

Thanks,

Praneeth

Edited by: Praneeth Putlur on May 14, 2010 10:57 PM