1,445
*This post is locked for comments
Thank you so much for such a prompt reply! I will test and see what I come up with!
Have a great weekend!
Hi Crystal, when we do this internally, we use the following scripts:
--POP - AFTER POSTING POP INVOICE:
update pop30330
set serltnum = 'new serial'
where itemnmbr = 'your item' and serltnum = 'old serial'
--SOP:
update sop10201
set serltnum = 'new serial'
where sopnumbe = 'invoice number' and itemnmbr = 'your item' and serltnum = 'old serial'
You would really need to check to make sure this works in your environment. This has only been tested for our specific workflow/environment. :-)
Victoria, how would I go about #2? I have a need for a mass lot # cleanup each month and I would love a faster way of going about it. Can you please point me in the direction of doing this in SQL? The "bones" of a SQL scrpit would help, I can probably tweak the details to my needs.
Thank you in advance!
Richard makes some great points about reviewing your processes. However, if you absolutely have to change the serial or lot numbers after the fact, I can think of two options:
1. Buy Blue Moon's Serial Number Edit: http://www.bluemoonisv.com/productDetails.php?product=Serial_Number_Edit. This will give you a way to change the numbers directly in GP, but may not be cost effective if this is not needed very often.
2. Change the numbers directly in SQL. This is not for a typical end user and you have to make sure that you're updating the serial number in all the tables that have it, so some research and testing would be needed. This would not be my first choice, but I have done this in the past with no issues.
Sounds like you may have over engineered the sales process following a TITWWHADI process ("this is the way we have always done it"). Review the reasons for this process and see if there is not a better way to record your purchases/sales and capture the information. Often old processes are put in place due to short comings of the old system. Then when a new system is put in, no one thinks to change processes.
Do the branches have Internet access? You can install a terminal server and give them access. Even if they are overseas. And if you only have one or two branches, you may not need the terminal server.
No, the assumption is that when you receive the parts, you know the lot or serial numbers. Receiving is normally performed by a clerk in the shipping/receiving area that has access to the physical parts. That is why there is a PO receiving process separate from the invoice match process.
Is there a problem where you cannot access the lot/serial numbers on receipt?
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,401
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
