Can B1 Calculate My Inventory Turns by SKU?

[Former Member]

This seems to be one of the most basic reports any company that holds inventory would want to run, but I can't figure out how to get B1 to give me this information.

I'm running B1 2005 SP 01 PL 31.

[former_member583013 · Accepted solution]

Hello Derek,

SBO out of the box does not have a report for this.

How to go about getting this report would depend on what your basis for calculation would be.

If you are trying to do annually, then one of the metrics would be to calculate the

TOTAL COGS

-

---

= No of TURNS

AVG INVENTORY COST

Thanks

Suda

[Former Member · Accepted solution]

Right, the overall math is elementary, but it isn't so easy to calculate it by SKU. It seems like it should be included where B1 calculates the average inventory value based on a user selected term (daily, weekly, monthly) by SKU.

Does XL Reporter have a report like this built? I'd rather not build it from scratch, seeing as there must be hundreds of companies out there that need and probably already have a solution.