Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
woserialno table
10-28-2014, 11:53 PM,
#1
woserialno table
I recently discovered on lot controlled items if I did partial receipt that this table was getting deleted even though I didn't complete the total Qty. The culprit seems to be in a hidden variable was using locale_number_format and the value to compare it to was numeric. So php thought 15 > "1,000" was true and deleted my woserialno. I was able to fix that. Now however I have had a few times where the user received the full W/O quantity but for one reason or another we wanted to back out some or all or the receipt. This can't be done because the woserialno record is gone.
Does anybody see any issues (performance, other) with NOT deleting the woserialno records at work order receipt time?

Andrew
Reply
10-29-2014, 11:31 AM, (This post was last modified: 10-29-2014, 11:34 AM by phil.)
#2
RE: woserialno table
Can't we get the info from the stockserialmoves table? Looking for stockmoves type WO Receipts?
We wouldn't want duplicate serial nos for WO manufactured items - this is a hazy memory for me I could be talking gibberish here!!
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
10-29-2014, 11:02 PM,
#3
RE: woserialno table
What I was trying to say Phil is that as it is currently written if the flag for assigning serial numbers at w/o create time is set then one you complete the required qty you can't complete any more in a second step or back it out. Because the W/O receipt program loops through the woserialno table at the start to build the inputs for Qty's to be received. If woserialno was deleted then you can't back some out. I have been inserting one in the database in these cases to trick the system.
I guess the best solution might be wait and delete the woserialno table at W/O Close, because then we know we are really done with it.
Reply
10-30-2014, 05:15 AM,
#4
RE: woserialno table
I see yes makes sense.
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
11-14-2014, 07:46 PM,
#5
RE: woserialno table
I am not getting it.. can you please elaborate more.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)