Skip to Content
0
Former Member
Mar 03, 2009 at 08:22 AM

Query

20 Views

HI all,

Can anyone suggest an SQL for checking the instock in warehouses while creating a marketing document? I mean to say, i have two warehouses for an item A (one default whse and other having stock as well) and i would like to get an alert while adding the sales document to change the whse in case,if the default whse doesnt have any stock!

Thanks in Advance,

Joseph