Bi4Cloud + Xero: Inventory Values

Follow

Can Bi4Cloud report Inventory Levels ?

Xero provides basic Inventory functionality.  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 Inventory Release/ Shipped - when a Quote is converted to an Invoice the Item has been released.

Bi4Cloud Inventory can report on:

• Stock (Inventory) On Hand (SOH) 
• Stock (Inventory) On Order (PO Outstanding)
• Committed Stock (Inventory) (Quote Outstanding)

The Committed Stock (Inventory) is determined from the outstanding Quotes.

Bi4Cloud has several Inventory reports including:

• Inventory
• Inventory vs Sales
• Inventory Cover 

The Inventory Report shows Committed ( Orders / Quotes), On PO and calculates Available. These value are a static position and 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