Bi4Cloud + Xero: Inventory Values

Follow

Can Bi4Cloud report Inventory Levels ?

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