Discarded Stock

andrew-warden

hi

A user has created an invoice with serial items and then created a credit note  for the same items   and has noted that the items are now discarded instead of return to stock

Is there a way for the items to be reinvoiced with the available serial numbers

Thanks in advance 

Andrew

richardd

Hi Andrew,  opera always defaults to discarded stock.  I'm sure I logged an enhancement Years ago but nothings been changed.  We had a customer who made this mistake all the time so wrote some bespoke to correct all the required tables.  You could try receipt the stock back in using the same serial numbers but i've got a feeling Opera won't allow this so you would need to change the serial number slightly. Add "." to end

Your only other option is to update the tables manually. If they are just using serial and not batch you'll need to update the records in the following tables. Our customer only every sold qty's of 1

Regards

Rick

UPDATE ctran SET ct_type="T" WHERE ct_type="W" 
UPDATE cserno SET ce_issued=.F. WHERE ce_issued=.T. 
UPDATE cserno SET ce_discard=.F. WHERE ce_discard=.T. 
UPDATE cname SET cn_freest=cn_freest+1 WHERE cn_ref=lStockRef
UPDATE cname SET cn_INSTOCK=cn_instock+1 WHERE cn_ref=lStockRef
update cstwh set cs_freest=cS_freest+1 
update cstwh set cs_instock=cS_instock+1