Share
ReportHi folks, GP2010
I have many item numbers with and without quantity that have been mistakenly put into a type 2 (returned). MANY. Can I simply write a SQL query update statement to change the QTYTYPE column value from 2 to 1. This occurred because no one understood to change the drop down from type returned to type on hand. They now understand this, but I'm left with hundreds of parts sitting in limbo out in a type 2.
The GP GUI process to change these qty types is a nightmare, took me 4 hours to "transfer" 17 items using the gui method.
Even after "transferring" the stock to ON HAND, I'm left with all these part numbers (this is just a small subset) with type 2, but zero quantity
ITEMNMBR LOCNCODE BIN QTYTYPE QUANTITY
01060396 401 F2 2 0.00000
01060398 401 J14H 2 0.00000
01060399 401 J14D 2 0.00000
01060641 401 C1 2 0.00000
01050011 401 B10 2 0.00000
01061396 401 C01 2 0.00000
01061646 401 C01 2 0.00000
01061647 401 C01 2 0.00000
04060147 401 D1 2 0.00000
04060148 401 D1 2 0.00000
04060152 401 D01 2 0.00000
04080005 401 G06 2 0.00000
08070040 401 F04 2 0.00000
10060204 401 C01 2 0.00000
10060205 401 C01 2 0.00000
10050200 402 A53 2 0.00000
09100020 402 00 2 0.00000
09110004 402 00 2 0.00000
01080036 402 D9 2 0.00000
10070035 402 00 2 0.00000
Anxiously Awaiting News,
Sheldon
*This post is locked for comments
All responses (
Answers (
4,029
