Featured
Students and Educators
Discuss MYOB software with other students and educators. Get everything you need for your MYOB learning journeyPayroll
This is a hub to discuss everything about PayrollOther MYOB Software
Discussion and questions for other MYOB products.
Latest topics
Adding new Custom Table Schema with MySQL
Hi guys, I am trying to add a new Custom Table Schema. I have just moved to using MYOB Acumatica for my local instance with MySQL dbase. I was previously using Acumatica with SSMS. Now, I am having trouble adding Custom Table Schema, when I try to add, all the tables are in small beginning letter which is odd and when I add it, it will come up with an error and can't publish. Please, can you enlighten me what needs to be done and what am I missing? I didn't have this kind of issue with Acumatica and SSMS. Should I go back to using Acumatica instead? Thank you!
2025.3 API issues AccountRight Premier SE
Hello Since this update (that strangely didn't automatically update on our server) we are having ongoing issues with poor or most commonly no connection to our online shop (Web Ninja). The issue has been ongoing since 17th April and both Web Ninja and our IT have re-installed the software and the API, where the connection to the webstore works, then disconnects. In the last 5 years, this has happened a few times with a new version update for AccountRight but its usually fixed by restarting the appropriate services on the server. But not this time. Any know issues?
Cancelled subscription
I have used MYOB Essentials for many years until finally cancelling the subscription in June 2023. I made a few data exports for various financial years but forgot to include a data export related to payroll. Is there a possibility to still get access to this data? I am willing to re-subcribe to the equivalent of Essentials. Please advise. Kind regards, Bas
Cash Purchase , Freight for the Purchase
Purchased 425 jeans from Blue Ridge Denim, a premium-quality jeans manufacturer in Italy, paid in cash. Each unit costs $215, excluding GST. In addition to this, $32 (including GST) per unit was paid to Nigel Forwarders for shipping the inventory to Auckland. I want to keep the entries separate so payment can be made to blue ridge and Nigel Forwarder separately. Kindly advice how to post this. In case of cash purchase of Inventory, first passed a bill and on the same day recorded payment. is that correct way . If i do spend money inventory selection and item list selection is not available.Company files api endpoint returning []
As per the documentation, I am using the endpoint https://api.myob.com/accountright to get a list of all the company files associated to my account. When I log in online to https://app.myob.com/#/businesses I can see 2 businesses: Clients business who invited me as a File User and Administrator roles MYOB & Shared Sandbox 19 which MYOB invited me I can authenticate myself using the Get Access Code endpoint and using the scope sme-company-file but the company file endpoint keeps returning an empty array of []. When I add &prompt=consent to the end of the Get Access Code endpoint, both businesses show up in a dropdown box and it asks me to connect to either of the businesses to allow Subscription details. I can successfully connect for #1 my clients business account, but when trying #2, it says You must be an Administrator to connect. Contact your Administrator. If I try without the &prompt=consent I can still connect successfully with the responded code, but the result is the same with an empty array of [] when trying the company file access point.
MYOB Version 23 upgraded to Version 30.30. But unable to create new login icon with version 30.3 to open upgraded data files.
We have upgraded from MYOB Version 23 to Version 30.30. But everytime click on the log in icon to log into new file, it is always open by MYOB Version 23 app, but this older version unable to open upgraded data files. How can I create an login icon that could open directly to the new files?Creating Visual Studio Packages from a REST Schema - problems
I am writing software for a Myob-Acumatica user. I am using the Integration Development Guide 2025 R1. I have been able to download swagger.json using something like: https://MyUser.myobadvanced.com/entity/default/23.200.001/swagger.json?company=TestCo (MyUser has replaced the actual company reference) Following the instructions on page 51 of the documentation, I uploaded swagger.json to: https://editor.swagger.io The first line of the JSON file was, "swagger: '2.0'". I found that I needed to convert to OpenAPI 3.0 so that the .json file was error free in the editor. As per the documentation instructions I generated the client (step 5) as c# The csharp-client-generated.zip file was duly downloaded to my computer and contained two Visual C# projects, IO.Swagger and IO.Swagger.Test. I unzipped the file and loaded the solution into my Visual Studio 2022 (Version 17.12.3). However, the application build process is unsuccessful because many if not all the .cs files contain constructors with parameters that are repeated. For instance, in the model folder is a file called ACAInfoDetail.cs which has a constructor that looks like this: public ACAInfoDetail(StringValue coverageType = default(StringValue), StringValue healthPlanType = default(StringValue), StringValue coverageType = default(StringValue), StringValue healthPlanType = default(StringValue), Guid? id = default(Guid?), long? rowNumber = default(long?), StringValue note = default(StringValue), Dictionary<string, Dictionary<string, CustomField>> custom = default(Dictionary<string, Dictionary<string, CustomField>>), string error = default(string), List<FileLink> files = default(List<FileLink>)) : base(id, rowNumber, note, custom, error, files) The first and third parameter both have the same variable name StringValue coverageType Why does the generated client have this problem and what changes do I need to make to successfully build this application?
Problem with orderby on JobRegister query
I use the .NET SDK in a custom reporting application. The client using it makes extensive use of Jobs in the MYOB usage, and there are a small number of top-level jobs that represent their operational departments. Most of these have a number of sub-Jobs down to 2 or 3 levels deep. Every transaction is assigned to a Job. I recently had to make a query to the JobRegister endpoint, and I wanted to order the results by Account/DisplayID and then Job/Number. My filter string looks like this: $filter=Year eq 2024 and Activity ne 0&$orderby=Account/DisplayID,Job/Number This is rejected by MYOB with Bad Request. I have not been able to come up with a syntax that MYOB will accept, so I am obviously missing something here. If I remove the orderby part, it works fine. I have used orderby in many other queries, but I have not had to specify the field in a nested way as above. So, what am I doing wrong here? Thanks.
MYOB PowerBI/Power Query connection
Hi All, I have seen some conflicting information on this so would love to hear exactly what the situation is from someone who knows. I used to use an ODBC link to access the back end of MYOB with Excel. It appears this is no longer supported and I now need to subscribe to a 3rd party software like CData. Is this correct? A lot of Chat GPT responses are telling me to access the database via the MYOB API but this requires authenticating with https://secure.myob.com/oauth2/v1/authorize to retrieve an access token so this does not appear to be viable without a custom build interface. Given that all I am looking for is to build Power BI reports or Excel reports, I am looking for any of the following: The details of a MYOB ODBC connector A method of parsing my MYOB credentials through an Excel data link A work around to obtain an access token without creating a custom built interface so that I can utilise the MYOB API A recommendation for a well priced 3rd party MYOB connector Thanks, SteveFull-time Under 18 Employee Super
Hi, we have a full-time employee working 38 hours a week. Every week, I record his pay and get a warning that we don't need to pay super and when I check his pay the super is not automatically calculated. I enter it in manually. The payroll category I used is Superannuation Guarantee and his pay is set-up as a salary with 38 hours per week. He is set-up the same as all other employees, the only difference is he is under 18. Thanks
Developer Update March 2025
Developer Update March 2025 AccountRight 2025.2 has now been released. Please update your app to the latest version. You can find out more about the new version of AccountRight 2025.2 at our blog here. As new versions of AccountRight are released, we also decommission older versions. If you are currently on version 2025.1, you will need to update by March 25 2025**. You can find out more about updating to the latest versions here. ** All dates are indicative only and subject to change.Issue with MYOB Business API: 409 Conflict when sending multiple POST requests
This is not a support request, it is more like an issue I recently encountered, and since I could not find any documentation about it in the API docs, I thought I'd post it here to save other developers time in the future. Undocumented limitation with MYOB Business API: 409 Conflict on sending multiple POST requests in parallel Issue Summary While integrating with the MYOB AccountRight API, I encountered an issue when creating new Bills via the API. When submitting multiple POST requests in quick succession, some of them intermittently fail with a 409 Conflict error. The error message returned is: "An Update operation requires the latest RowVersion for each of the existing entities being modified." This is unexpected behavior since this error message is typically associated with PUT requests (updates), not POST requests (new record creation). Expected vs. Actual Behavior Expected Behavior: Each POST request should successfully create a new Bill, returning the newly created Bill’s details. Actual Behavior: Some POST requests fail with a 409 Conflict error, while others succeed. Resubmitting the same failed request later often results in a successful response, without any changes to the request payload. Steps to Reproduce Send multiple POST requests to create Bills in rapid succession (e.g., five requests in parallel). Observe that some requests fail with a 409 Conflict error while others succeed. Resubmit the failed request later - it may succeed without any modifications. Analysis The error message suggests that MYOB is incorrectly treating some POST requests as PUT requests, possibly due to an internal concurrency issue. This behavior is undocumented, and no clear explanation is provided in the API documentation. Possible causes include: Concurrency limitations within the MYOB API when processing multiple requests simultaneously. Internal caching or sync delays causing some transactions to be misclassified as updates. Thread safety issues where parallel requests interfere with each other. MYOB API Support Response After raising this issue with MYOB API support, it was confirmed that the API does not handle multiple simultaneous POST requests to the same database correctly. Their recommendation was to add a delay between each request to ensure successful processing. "We have had requests to open this up, but we would need some significant updates to be able to do so. Going forward, you will need to provide space between each call." Workaround To avoid encountering this issue, implement the following workaround: Send requests sequentially, ensuring each request completes before sending the next. Introduce a delay of a few seconds between consecutive POST requests. Implement automatic retries with exponential backoff when encountering a 409 Conflict error. For example, in a microservices-based architecture, detecting this specific error and retrying after a short delay can help mitigate the issue. Conclusion This undocumented limitation can cause unexpected failures when batch submitting Bills via the MYOB API. Until MYOB updates their API to handle parallel requests correctly, developers should implement sequential request processing or introduce delays to ensure reliability. Hopefully, this post saves others time troubleshooting similar issues!AR 2025 converting Order to Invoice via API
Hi Folks I have just, yesterday, been asked to add another component to my integrator (web - integrator - myob file ). I think I know the answer i.e. the API doesn't permit patch updates but there might be a component I haven't forseen. My integrator takes Orders from a web cart - processes them and sends them to MYOB as a double component. Sales order - either on an account or paid for by a guest account by credit card. An order which uses the components from the inventory system ( an in house admin component) - if there aren't enough inventory it will create a B Order - and will check inventory before each new orders to see if any B Orders can be filled - if so it DELETES the B Order and lodges a Sales invoice for the in house - component use. ( complex - but it works beautifully) This was all set in place because human admin staff were dropping the ball in the factory and Orders/BOrders/inventory was a shambles. The latest ask - is again because human staff majorly DROPPING THE BALL. When an order is completed - the SALES ORDER for the client - which are mostly account customers - needs to be converted to an invoice and sent out to the customer - last month $170,000 of completed work NOT invoiced - yep!!!! I have been asked to add feature to do this. Questions I don't think there is a simple way via an API endpoint to convert an order to an invoice - I think I need to DELETE the ORDER and resend as an INVOICE ?? - no matter - I do this for a B Order anyway. You cannot DELETE an Order if a payment has been applied to that Order - ?? (MYOB has an awful way of applying a payment to an order that completely jams it so even if you delete the payment you cannot delete the order - the only way around this appears to be NEVER APPLY A PAYMENT to an ORDER - ( have done this successfully for another client this method) - you put the monies into a liability account ( or asset - doesn't matter - naming it correctly so it can be traced) - when an order is filled you convert the Order to a Sale - THEN apply payment as the ORDER has a NB: line - payment has been received etc. Thoughts, ideas? The Doc
