on 10-29-2015 10:30 AM
Hello experts,
One of my new client manages his items by batch number.
He is asking if the generation of the batch number can be automatic, in a way that the end-user don't have to write in the batch number field manually.
For him, he is suggesting that the good receipt number should be automatically assigned as batch number when we are receiving goods.
Kindly advice if this is possible or not, so that I can also explain to the client.
Best regards
Cedric K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
By any chance, is there someone who was able to do this?
Best Regards
Cedric K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cedric,
Try below query.
This query will be based on Ware house and Itemcode.
Select Max(BatchNum) from IBT1 where whsCode = $[SBDR.Whsecode] and ItemCode = $[SBDR.ItemCode]
Thanks,
Harshal Makwana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Harshal,
Thanks for the helpful answer, but this is issue which occurs now; if I execute the formatted search, it puts the previous batch number i used, and that will be the same batch number which is going to be used for all future transactions for the specified item and specified warehouse.
I'm actually expecting this to be cumulative number on the company level. Every time an item managed by batch number is received in the stock, let the batch number be the next number, regardless the item or the warehouse.
Best regards
Cedric K
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.