Partner Zone

Accessing Inventory Items with the API

2 REPLIES 2
The_Doc
Ultimate Partner
1,293 Posts
Ultimate Partner
Australia
Ultimate Partner

1,293Posts

283Kudos

141Solutions

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
Hannah_B
MYOB Moderator
124 Posts
MYOB Moderator
Australia
MYOB Moderator

124Posts

27Kudos

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,293 Posts
Ultimate Partner
Australia
Ultimate Partner

1,293Posts

283Kudos

141Solutions

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

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