MYOB is your master database for all product information. This includes stock information. MYOB contains two stock numbers: Quantity on Hand and Quantity Available. Quantity on Hand is the physical stock that you have. Quantity Available comes from a calculation: Available = ‘On hand’ plus ‘On order with supplier’ minus ‘Committed to customer’. You can run a Stock on Hand report to see the two numbers side by side.

By default, we copy the Quantity on Hand field from MYOB to the Stock field in Onsight. Alternatively, we can configure your account so that it is rather the Available field from MYOB that is copied to the Stock field in Onsight. The Stock number will be show in Onsight for all your products and will be used for features such as overselling prevention and flagging out of stock products.

When an order is created in Onsight, it gets sent to MYOB as an order.

a) If you have chosen to use Quantity on Hand in Onsight: the Quantity on Hand field in MYOB is only reduced when the MYOB order is converted into an invoice. A order on its own does not reduce the MYOB Quantity on Hand value. Once you convert the order to an invoice, the Quantity on Hand will reduce in MYOB. This new value will then sync to Onsight.

b) If you have chosen to use Available in Onsight: the Available field in MYOB is recalculated constantly. Available = ‘On hand’ plus ‘On order with supplier’ minus ‘Committed to customer’. Once the order syncs from Onsight to MYOB, the ‘Committed to customer’ number will go up, which will make the Available number go down. This new value will then sync to Onsight.

Now, your Onsight app will show the latest stock numbers from MYOB. This completes the circular flow of stock information between Onsight and MYOB.