Page 1 of 1

Batch change import file?

PostPosted: Tue May 10, 2022 1:46 pm
by PartsDanager
is it possible to do a batch change based on parameters that I might set in a parts search rather than what is on the table in PM? (CDK) Perhaps in a well written english statement?

Re: Batch change import file?

PostPosted: Tue May 10, 2022 7:59 pm
by ehiatt
Ok, now I'm curious. What parameters do you have in mind?

Re: Batch change import file?

PostPosted: Wed May 11, 2022 2:49 pm
by PartsDanager
Here is what I did-

1. ?SELECT PART-NO. WITH P-U AND WITH MNS BETWEEN "5" AND "10" AND WITH O.H. > "0" AND WITH SO BETWEEN "99" AND "105"
2. >SAVE-LIST PM-BATCH-LIST
3. PM, Batch change, F5, review, send to source 101
4. ?SELECT PART-NO. WITH P-U AND WITH MNS BETWEEN "9" AND "12" AND WITH O.H. > "0" AND WITH SO BETWEEN "99" AND "105"
5. >SAVE-LIST PM-BATCH-LIST
6. PM, Batch Change, F5, review, send to source 102
7. ?SELECT PART-NO. WITH P-U AND WITH MNS BETWEEN "10" AND "13" AND WITH O.H. > "0" AND WITH SO BETWEEN "99" AND "105"
8. >SAVE-LIST PM-BATCH-LIST
9. PM, Batch Change, F5, review, send to source 103
10. ?SELECT PART-NO. WITH P-U AND WITH MNS > "13” AND WITH O.H. > "0" AND WITH SO BETWEEN "99" AND "105"
11. >SAVE-LIST PM-BATCH-LIST
12. PM, Batch Change, F5, review, send to source 104
13. ?SELECT PART-NO. WITH P-U AND WITH MNS BETWEEN "0" AND "6" AND WITH O.H. > "0" AND WITH SO BETWEEN "99" AND "105"
14. >SAVE-LIST PM-BATCH-LIST
15. PM, Batch Change, F5, review, send to source 100
16. Congratulations eat a cookie.

Specifically, I'm having the parts move sources based on phase out rather than YRSL. This gives me groups at 6-9 months, 10-11 months, 11-12 months, and over 12.
I somewhat aggressively deescalate the price code per source, and at 11 months make a decision on certain parts per manufacturer return parameters. I process after month end.

Re: Batch change import file?

PostPosted: Wed May 11, 2022 4:46 pm
by ehiatt
Wow, that's an excellent idea. I'm ashamed to admit I have never paid attention to the F5 prompt in PM, but I will now.
Thanks for sharing.

Re: Batch change import file?

PostPosted: Wed May 11, 2022 5:01 pm
by PartsDanager
Thank you! It's a little time consuming (though now I just copy my code from a word doc) You might be using that F5 for something else, just note that I found it necessary to add a MNR > "3" to avoid having New parts no sales (mostly spec orders) from selling aggressively cheap.

Also, SAVE-LIST PM-BATCH-LIST can only hold one list of parts at a time. Make sure to hit F2 to review your list of parts before making any drastic changes. Good luck!