Hi All,
I’ve been asked to create a BAQ/report on slow moving stock (Anything that hasn’t moved in 2 years) but but can’t seem to figure out the best way to do this. Does anybody
have such a report/BAQ that they would share? Any help would be much
appreciated
Regards
Jack
There is already a Slow Moving Stock report under Material Management > Inventory Management > Reports. It requires you to set up a Stock Provision Report Format Code where you can define your time buckets and which transactions you consider “movement” – for example, do you want to only consider when parts are sent to customers/jobs, or should you also consider when parts are received or moved within the warehouse?
If, for some reason, you need to create your own BAQ for this, I would start by loading Part records and then looking for the latest PartTran record after filtering by PartTran.TranType to only include the transaction types you consider movement.
5 Likes
I took a look at our configuration and the operation of the canned report. There was a learning curve. First was the Time Period setting itself. Found KB in Epicare that talked a little about that one. Once you see it once, it makes sense, easy. Provision Rate was a little more tricky for me. I had not been exposed to this in prior lives. But it was not necessary to make things show on the report, only to show value.
I was able to eliminate the stuff with recent transactions, like so,
1 Like
Can someone explain ‘Provision Rate’ better? I found KB, but it’s still not clear to me.
I’d like to show all parts that haven’t had movement within the bucket time period, and I’m not sure what various percentages would change.
From KB0041108:
The numerical value in Provision Rate is calculated as a Percentage
Note: Provision Rate is used as a percentage and calculated against the Extended Cost of the part. The report will get the current on hand quantity and current unit price of the part, calculate the Extended Cost and the Provision Rate is a percentage of that Extended Cost.
The Caption is what prints out on the report as a column heading
The Transactions tab is to select the type of transactions you would like the report to look at
In the case of MONTH as the Time Modifier
Time Period:
- to 1 (Today + 1 Month) with Provision Rate of 10%
- (2nd Month) with Provision Rate of 20%
- (3rd Month) with Provision Rate of 30%
I’ve got 942 pages of noise:
Provision Rates allow you to gradually reduce the value of your slow-moving stock based on how long it has sat. For example, you may want to reduce that value by 20% every year until the parts haven’t moved for 5 years, so you set your provision rates as 0%, 20%, 40%, 60%, 80%, and 100%.
When you run the report, it will show your total “reserve” amount based on the provision rates. That gives your Finance team an easy way to see what the inventory reserve and reserve charge for the month or quarter should be. You may also set the rates so you are prioritizing stock that has sat longer from an operations perspective. By setting the rates on the older buckets higher, those values jump to the top when sorting by slow moving $$.
If you’re looking for a report that shows the total slow-moving amount, you would want to leave the rates all at 100% so you see the total amount of stock you have on-hand which hasn’t moved in your time period. This is one reason why there are multiple stock provision codes: the Finance team may want to set a gradual provision schedule but your Ops team might want to see a total amount so they can work toward that.
1 Like