Accessing Inventory Items with the API

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
The_Doc
Ultimate Partner
1,537 Posts
Ultimate Partner
Australia
Ultimate Partner

1,537Posts

236Kudos

162Solutions

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

 

MYOB inventory.jpgAPI inventory.jpg

2 REPLIES 2
Hannah_B
MYOB Moderator
142 Posts
MYOB Moderator
Australia
MYOB Moderator

142Posts

33Kudos

25Solutions

Re: Accessing Inventory Items with the API

Hi @The_Doc

 

Thanks for reaching out, I can see there is a request with the API team which we will continue to investigate this for you.


Thanks,
@Hannah_B


MYOB API Specialist


MYOB API Support Centre|MYOB App Marketplace|MYOB AccountRight API Endpoint Doc's



Did my answer help?


Mark it as a Solution

The_Doc
Ultimate Partner
1,537 Posts
Ultimate Partner
Australia
Ultimate Partner

1,537Posts

236Kudos

162Solutions

Re: Accessing Inventory Items with the API

Hi @ Hannah Yes thank you - by luck the recent 2021.6 upgrade fix this bug in the API. However, by fixing this bug it unfortunately laid bare a basic fundamental flaw in the AccountRight Accounting logic. I will create a new ticket for this - see if AccountRight Support will grab this curly flaw. The Doc

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post