Automatic increament of Batch Num

[Former Member]

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

[Former Member]

Hello Friend,

make a FMS using SBDR table

Select Max(BatchNum) from IBT1 where whseCode = $[SBDR.Whsecode] and ItemCode = $[SBDR.ItemCode]

Here you can take both filter warehouse code and item code and you can also take single whsecode code.
and it is only for single item if item will more then one the FMS will give wrong value because by FMS we can not read row number.

Set this FMS in batch column.


So keep in mind select select one by one option.

Thanks

Manvendra Singh Niranjan

[Former Member]

Dear Manvendra,

Not Working , Giving me error Invalid Column Name WhseCode

Ashish Gupte

[Former Member]

Sorry write Whscode

Select Max(BatchNum) from IBT1 where whsCode = $[SBDR.Whsecode] and ItemCode = $[SBDR.ItemCode]

Thanks

Manvendra Singh Niranjan

[Former Member]

Hi Manvendra,

Can you assist me if want to get next batch number automatically according to Item Group through FMS ?

Regards,

Harshal Makwana

[Former Member]

Is any Update on My question