on 08-03-2012 8:40 AM
Dear Friend,
When we do goods receipt for large No. of Item (for ex: 5000 item ) with serial number assigning through xls sheet in DI API. Assigning serial no for item in for loop.
Same time we do goods Issues with Batch no. for Large no. of item . Goods issue posting is completed very quickly but Goods Receipt posting is not completed when assing Serial no.
Some time document is added successfully.
Some time System is getting Hanging.
How do handle the this type of problem.
Please help me.
Regards,
K Sakthivel
Hi,
Adding a serial number takes more time because several (sql) checks need to be made. Upon goods Issue the serial numbers already exist, so it does not require as much work/time.
Adding 5000 new serial numbers will take so much time that it is easy for some other process to run at the same time, due to which deadlocks can occur, hanging the sytem.
Have you tried creating the goods receipt before or after business hours, when no one else (including any add ons) is using the system?
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The problem is that adding 5000 serial numbers is simply going to take time. There is no way around that.
So there really are only 4 possible solutions:
Regards,
Johan
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
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.