We have changed the quote and sales order item description slightly for marketplace items (QUDET<12>/SODET<12>) so we need to convert all existing quotes and sales orders for part number "MP" to the new format when we go live with the new site. I have already modified the label description output for marketplace items so labels will print properly.
New IIUTIL CONVERT.MP.DESC:
- SELECT QUDET WITH ITEM.NBR = "MP"
- Description 1 (QUDET<12>[1,25])
- Desc1 holds the bag size dimensions. It is missing the depth dimension. It's current format is ZT 8x10x4 and it needs to be converted to ZT 8X0X10X4
- Description 2 and 3 (QUDET<12>[26,50])
- Change 'Anti Static, Pink' to 'AS,AFPAS,MILSPEC,TINT,PNK' if found in desc2
- Change 'Anti Static, Clear' to 'AS,AMF,MILSPEC' if found in desc2
- Change all spaces to commas (with the exception of the space in 'Hang Hole')
Next,
- SELECT SODET WITH PART.NBR = "MP" (regardless of status)
- Description 1 (SODET<12,1>) *** note SODET is multi-valued instead of 25 char each
- Desc1 holds the bag size dimensions. It is missing the depth dimension. It's current format is ZT 8x10x4 and it needs to be converted to ZT 8X0X10X4
- Description 2 and 3 (SODET<12,2> : SODET<12,3>) concatenate together for INDEX
- Change 'Anti Static, Pink' to 'AS,AFPAS,MILSPEC,TINT,PNK' if found
- Change 'Anti Static, Clear' to 'AS,AMF,MILSPEC' if found
- Change all spaces to commas (with the exception of the space in 'Hang Hole')
- Once all changes are made, replace SODET<12,2> with first 25 char and SODET<12,3> with remainder (if any)
To Test:
- This can be tested on the LIVE account on the CE TRAINING MACHINE. After the next deployment to training (which you s/b doing on Tuesday), you can execute the IIUTIL to test. I can show you how to create some QUDET/SODET records on DEV.DATA in the old format if that will help with the initial test.