Inventory Turns

I know there is a chart in Admin under Dashboards and Pulse Dashboard that shows the Turns per Year by all warehouses or select warehouses.

Where is the information obtained to show this result?

And is there a table that can be sorted by a specific date timeframe and exported?

@spilkington

Hey Steven,

I see the Turns Per Year dashboard that you’re referring to (under Pulse Dashboards). I’m going to reach out to the team internally to see where that information is being pulled from within Cetec ERP.

I’ll be in touch with an update regarding this dashboard & where that data is pulling from.

Thanks,
Cetec ERP Support

Thank you for the update.

@spilkington

Good Morning,

I’ve got an update here for you regarding how we retrieve the data for that pulse dashboard ‘Turns Per Year’ in your environment.

Here’s how we calculate out that data - The turns per year are calculated as: the average daily invoice cost multiplied by 365 (average across the last two months) / inventory value.

Regarding reporting that provides this data, I’m still working on a potential report(s) here for you. I’ll be in touch with another update once I’ve got that information for you.

Thanks,
Cetec ERP Support

@spilkington

Hey Steven,

I’ve got another update here for you regarding potential report(s) here for you.

There currently isn’t an ‘as of’ date for the turns/year data in Cetec ERP. What you’ll need to do is follow the instructions that are provided on this FAQ here to get those calculations - How are Turns Per Year calculated on the Pulse Dashboard?

This requires you calculating out the average daily invoice cost, multiplied by 365 (average across the last two months) divided by inventory value. This is how we retrieve the data for that pulse dashboard.

Apologies on there not being a clear cut report for this. The instructions on the FAQ should be able to provide you what you’re looking for though!

Thanks,
Cetec ERP Support

Thank you for the information! This is very helpful.