Bi4Cloud + Xero: Inventory Values

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

Stock on Hand Yes  
Stock on Order    Yes
Stock Committed   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.

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
Have more questions? Submit a request

Comments

Please sign in to leave a comment.

Powered by Zendesk