Can Bi4Cloud report Inventory Levels ?
|Stock on Hand||Yes|
|Stock on Order||Yes|
Xero provides basic Inventory
Items can be Purchased, Sold and Inventory can be tracked
Xero provides no Goods Receipting - when a Purchase Order converts to a Bill then the Item is considered to be in Stock - receipted.
Xero provide no Stock Release/ Shipped - when a Quote is converted to an Invoice the Item has been released.
Bi4 Inventory can report on
- Stock On Hand (SOH)
- Stock On Order ( PO Outstanding)
- Committed Stock ( Quote Outstanding)
Because the Committed Stock can be determined the reports that provide Inventory vs Sales or Inventory Cover provide information of actual outward stock movement.
The Inventory Report show Committed to Sell, On PO and can calculate Available. That is fine for a static position but it does not take into account the sales velocities.
The Inventory Cover Report looks at Sales in the last 8 weeks and the last 20 weeks and provides an estimate of the weeks of cover before a stock-out. The two time periods used for analysis provide for fast moving ie an 8 weeks horizon or slower moving ie. a 20 week horizon.
See also Sales vs All Inventory Reports here