Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
woserialno table
10-28-2014, 11:53 PM
Post: #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
Find all posts by this user
Quote this message in a reply
10-29-2014, 11:31 AM (This post was last modified: 10-29-2014 11:34 AM by phil.)
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
10-29-2014, 11:02 PM
Post: #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.
Find all posts by this user
Quote this message in a reply
10-30-2014, 05:15 AM
Post: #4
RE: woserialno table
I see yes makes sense.

Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Visit this user's website Find all posts by this user
Quote this message in a reply
11-14-2014, 07:46 PM
Post: #5
RE: woserialno table
I am not getting it.. can you please elaborate more.
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)