Inventory Analysis Report
I'm trying to find or create a report in AccountRight to help us with our obsolete stock analysis. Could anyone tell me if it's possible to create a report that shows the current stock on hand and th...
Forum Discussion
As Yanike_S indicated a number of the MYOB Addon solutions can assist with more Advanced reporting over Sales, Inventory Margins etc.
As an example our solution BI4Cloud Business Intelligence comes with standard Inventory reports that show Inventory on Hand on Order etc and compare this to past Sales activity monthly and also showing the Number of weeks since each item was Last Sold. You can sort by or Filter by the Last Sold weeks to immediately see a list of all potential Obsolete stock, then export this to Excel.
See this link for more details on this report - https://support.bi4cloud.com/hc/en-us/articles/203688480-Item-Sales-v-All-Inventory-Track-Inventory-against-Sales-History-
Other reports also calculate Inventory cover or Turnover to show items that may still be selling occaisionally but are moving very slowly.
There is a free trial on our website BI4Cloud.com, feel free to use the trial to produce your Year End Obosolete Inventory reports.
If you really are a Part Detective you may also find our Sales & Margin reports will help you discover may other hidden issues like low margin Customers or which Salesreps are not generating as much Margin as others??
See these links for more ideas -
- https://support.bi4cloud.com/hc/en-us/articles/360000133116-Sales-Understand-your-Margins
- https://support.bi4cloud.com/hc/en-us/articles/203477724-Sales-Which-Customers-have-Stopped-buying-
Hope this helps.