Skip to Content
Former Member
Dec 25, 2011 at 03:08 PM

Automatic increament of Batch Num


Dear All,

I want a query or stroe procedure for the following:

We are in the manufacturing

so we have different department which we had mapped as warehouse and WIP items are make.Whenever material is receiving from one department we are creating one batch and having 24 warehouses

so i need a query or store procedure to increament last batchnum of that warehouse automatically.(I am aware with the standard increament of Batch)

So that user can have less data to enter

Thanks in advance

Ashish Gupte