Parts not sold in the last year

[HHOULE (Henry Houle)]

How can I see parts that have not sold in the last year?

[dcamlin (David Camlin)]

My thought would be a BAQ with Part vs PartTran… tran types MFG-CUS, STK-CUS, etc.

Use TranDate to filter.

[jgiese.wci (Joshua Giese)]

BAQ/Dashboard, Invoice detail inner joined to header. Group on part, MAX Invoice Date. Something like that could work too.

^^ Any takers on the reference? huh huh?

[utaylor (Utah Taylor)]

I wish I got into this.

[gpayne (Greg Payne)]

There is a slow moving stock report which I think does what @dcamlin’s BAQ would do. Do an Provisioning code like below. In addition to slow moving there is Excess and Aging, but I don’t know the difference.

[HHOULE (Henry Houle)]

Many thanks Greg

[hackaphreaka (Garret Travers)]

I agree there is more than one way to skin this cat.

FWIW we use the PartTran method mentioned by @dcamlin but I think all 3 options mentioned here are viable.