Page 1 of 1
GM PMs--Need help building a R&R report
Posted:
Wed Dec 16, 2015 1:37 pmby Bailo1
Can anyone help me with this?? Have some extra return reserve (amazing, I know!) that I want to use getting rid of obsolete parts. What I'd like to do is build a report in 6910 that shows me parts that were received more that 17 or 18 months ago and haven't moved since. I thought I knew how to do this but can't figure out the code to use in report generator. Can any of you gurus out there help me out?
Re: GM PMs--Need help building a R&R report
Posted:
Wed Dec 16, 2015 2:52 pmby PARTSPHIL
File name: PRODUCT MASTER
Report type: Sort
Sort by: Age
Sort Seq: choose ascending or descending
Age > (you choose)
QOH > 0
RC = R
COLUMN HEADINGS (what I use)
BIN1;PART#;QOH;COST;AGE;PACK;RC;STS;EXT-VAL
Hope that helps!
Re: GM PMs--Need help building a R&R report
Posted:
Wed Dec 16, 2015 5:05 pmby Bailo1
So age is based on last receipt date? I thought age was based on the date the part initially had activity...
Re: GM PMs--Need help building a R&R report
Posted:
Wed Dec 16, 2015 6:43 pmby Impala67
PARTSPHIL wrote:File name: PRODUCT MASTER
Report type: Sort
Sort by: Age
Sort Seq: choose ascending or descending
Age > (you choose)
QOH > 0
RC = R
COLUMN HEADINGS (what I use)
BIN1;PART#;QOH;COST;AGE;PACK;RC;STS;EXT-VAL
Hope that helps!
What are you using in the : Enter Field(s) to sort by ???
I'm new to this system, but know coding
Re: GM PMs--Need help building a R&R report
Posted:
Wed Dec 16, 2015 7:38 pmby PARTSPHIL
Bailo1 wrote:So age is based on last receipt date? I thought age was based on the date the part initially had activity...
Age is based on last sale date, if I remember right.
Re: GM PMs--Need help building a R&R report
Posted:
Wed Dec 16, 2015 7:40 pmby PARTSPHIL
What are you using in the : Enter Field(s) to sort by ???
I'm new to this system, but know coding[/quote]
I use age to sort by
Re: GM PMs--Need help building a R&R report
Posted:
Wed Dec 16, 2015 9:44 pmby 2longinparts
Matt,
Do a 2248 in Rey&Rey 18 months then do a REAM KPI report to see what is no longer protected.
Re: GM PMs--Need help building a R&R report
Posted:
Thu Dec 17, 2015 2:14 amby Bailo1
Thanks Phil!