v2021.4: Cost of sales API error when # of items per selling unit > 1

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.
Mike_James
Ultimate Partner
5,857 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,857Posts

1,026Kudos

756Solutions

Solved: Go to Solution

v2021.4: Cost of sales API error when # of items per selling unit > 1

In version 2021.40, incorrect cost of sales figures are being reported through the API, where the number of items per selling unit is not 1. For example, a product where this number is 1000 reports a COGS of $23.95, whereas the correct figure per the UI is $23,945.20. 

 

This is affecting gross margin reporting via the API. Whilst we can correct for it, there is some loss of accuracy and therefore external reports will not agree to UI reports. Could you please investigate urgently and advise when this will be fixed. 

 

Various screenshots are attached.  


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

API COGS error (endpoint line detail).jpg
API COGS error (recap journal).jpg
API COGS error (Item detail).jpg
4 REPLIES 4
Tana
MYOB Moderator
43 Posts
MYOB Moderator
MYOB Moderator

43Posts

92Kudos

3Solutions

Re: v2021.4: Cost of sales API error when # of items per selling unit > 1

Hi there Mike and appreciate you reaching out.

That definitely is something we will want to investigate, can we please get a more detailed trace of your call via a support ticket: https://developer.myob.com/contact/

If you could provide the full endpoint + request and response headers, URI, API key and RequestID with the above ticket we will look into it right away.

Can I also confirm, that all reporting via the AccountRight UI in this regard appears correct, and only the display via the API is incorrect?

Appreciate your co operation.
Kind regards


Thanks,
@Tana


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

Mike_James
Ultimate Partner
5,857 Posts
Ultimate Partner
New Zealand
Ultimate Partner

5,857Posts

1,026Kudos

756Solutions

Re: v2021.4: Cost of sales API error when # of items per selling unit > 1

Hi Tana

 

Yes, all reporting via the UI is correct. 

 

I will prepare the requested details and file a support ticket asap.


Regards, Mike (mike@datawise.co.nz)
DataWise Limited (www.datawise.co.nz), developers of:
DataWise ProActive - Custom Reporting from MYOB programs
(MYOB Business, including AccountRight Live, AccountRight v19.x and exo Payroll)

Bulk download of attachments (more details...)

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

1,537Posts

165Kudos

162Solutions

Re: v2021.4: Cost of sales API error when # of items per selling unit > 1

Hi @Mike_James 

 

Wow - good one Mike - made me sweat a bit then - but luckily all my items per selling unit = 1 but a good heads up.

 

Thanks.

 

Regards The Doc

brunob
MYOB Product Manager
39 Posts
MYOB Product Manager
MYOB Product Manager

39Posts

8Kudos

3Solutions

Accepted Solution Solved

Re: v2021.4: Cost of sales API error when # of items per selling unit > 1

Hi @Mike_James ,

 

Thank you for raising this with us. We have addressed the issue, now the cost of sales is reported accurately with any value under the item's unit of sale (i.e. greater than 1). Please let me know any issues.

 

Warm regards,

 

Bruno 

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