GM PMs--Need help building a R&R report

[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?

[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!

[Bailo1]

So age is based on last receipt date? I thought age was based on the date the part initially had activity...

[Impala67]

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

[PARTSPHIL]

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.

[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

[2longinparts]

Matt,
Do a 2248 in Rey&Rey 18 months then do a REAM KPI report to see what is no longer protected.

[Bailo1]

Thanks Phil!