Accessing Inventory Items with the API
Hi MYOB
I am choosing to send this problem to the open forum as I have sent it to developers - had it acknowledged - told it was escalated but never heard anything further. The API has bugs people - lots of them some we developers can work around and some we cannot. Amongst other bugs I have found and written code around - here is a bug that I cannot write code around. And it is nasty.
Inventory item have Quantity on Hand, Current Value, Average Cost (which is Current Value / QOH), Committed, On Order, Available Available = QOH + QOO If you are not using the API there is no problem - however, I have a client with a live website that sells these inventory items in a live website and the quantity available and the Average Cost is used live to update 3000 products in a live website.
The interface between the MYOB live file and the live website updates every hour during the working week; because staff are placing orders from other branches (that are not going through the web - so the inventory perpetual is changing constantly. And also new stock comes in. But for some reason - the API gets it wrong for 2 - 10 different items on a constant basis. I get a warning by email when an item has an average price of ZERO - and this warning was intended to tell me that staff have entered a new item using inventory update and the quantity > 0 but the Avg price is zero - so this item will not be loaded to the website for sale until Avg price > 0 However, things have changed and the API is reporting Avg Price 0 on working items being sold and - and this might be 1 or 2 items but I have up to 10 - just pop up with Avg 0.
Check the items and I found that API was reporting incorrectly.
This is causing grief MYOB and the script you run over the file doesn't do anything.
MYOB have you an answer.
The only solution is when this happens is for me to toggle the item off on the web so it is not for sale until the MYOB file corrects itself - which it does.
Please MYOB address this bug!!!
The Doc
