Bi4Cloud + Xero: Inventory Values

logo-xero-60.pngCan Bi4Cloud report Inventory Levels ?

Stock on Hand Yes  
Stock on Order    Yes
Stock Committed for Sale   Yes

 

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.

Screen_Shot_2020-05-11_at_9.42.49_am.png

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.

Screen_Shot_2020-05-11_at_9.43.31_am.png

See also Sales vs All Inventory Reports here

 

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Ask the BI4 Community
Need help using this report or feature?