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 withhttps://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, Steve
Developer Update November 2024
AccountRight 2024.10 has now been released. There are no changes to the MYOB Business/AccountRight API with this release. Please update your app to the latest version. You can find out more about the new version of AccountRight 2024.10 at our blog here. As new versions of AccountRight are released, we also decommission older versions. If you are currently on version 2024.9, you will need to update by November 26 2024. You can find out more about updating to the latest versions here.
ABA File $$$ does not match Nett
We have an issue with our two most recent pay periods. The ABA uploaded file is $900.00 more than the total Net Pay on the payroll Activity Summary. We have isolated the error - which was due to an entry on the employee card file under payment details. Pay is split between three accounts - one was entered as 100 percent instead of $100.00 Our employee has been overpaid $900.00 per week for two weeks. How is this possible??? Is there no check on the ABA total$ compared to the Nett Pay$$$$ We have our own internal checks and fortunately will be able to resolve with this employee -
Changing Superannuation when creating a new super payment
On the Cretate super payment page, I get the option to make a super payment, but the Superannuation Fund has changed details (following a merger), and the super fund shown is the old one. - Under Payroll settings/Superannuation funds created a new super fund for the new details. - Under Payroll settings/General Payroll information I made the new fund the default Superannuation fund. But even after changing the default super fund, I still get the old fund showing on the Create Super Payment page and list to be paid. (see attachment) How do I change the super fund that automatically shows up the Create Super Payment list? I'm stuck. Can't make super payments. Tried deleting the option (to tick) on the Create Super Payment page. But to no avail. Nothing in the help secton
Returned Super Contributions
Hello How can I identify who returned super payments belong? We have 3 returned payments from Mercer Super and the totals do not match my reorts for Superannuation payments by Fund. the Super fund or clearing house has not sent through a notification, the first we were aware of this was during bank reconciliations.
MYOB Invoice APP
Hi MYOB Team We have Accounts Right 2024.8.1.5 running on our laptop - $141.00 pm We run a mobile SERVICE industry business with iPhone & iPad away from the office. Last Thursday the old version of the MYOB Invoices App stopped working on our Apple Devices. I installed the new MYOB Invoice App - I can see our paid and outstanding invoices but cannot create a new invoice as our contacts won’t update. Error message "Something's gone wrong. Tap below to try again. click on TRY AGAIN. and receive the same error message. We need the MYOB app to work flawlessly to operate our business as carrying a laptop in our vans is not an option. Any advice would be appreciated Thanks RobynMYOB Accounting
Hi there I have an MYOB Accounting version 14. I would prefer to use this for a very small business that I have, issuing approx 2 invoices each quarter. I cant seem to have it activated. Can you help please. Since it was first purchased Ive used it for the same business. Had a break and am intending to start using MYOB Accounting again. Can you please help activate my file.Import / Export data sales to Myob
Hi Team, Please help me to understand how to import data sales from excel report to Myob System with import / export proccess . I need to be simple about entry data sales and bank . I have tried to post with TXT file which was downloaded from system, when the update data imported , status is invalid and error. Can you inform the right step of proses import / export data? I using Myob AR as attached The import log sign is the same in notification folder(not changed), event i have re-import data or other data. Awaiting for your reply this email. Best regards, SinCannot get Authentication to work on Windows Forms Desktop app
I am struggling to get through Authentication. Can someone please help me. I am writing a Window forms desktop application which needs to interface with MYOB (cloud) to create contacts and raise invoices. I cannot get past the Callback. I am using the Myob AccountRight API SDK. I have been unable for support to show me a working example of such a call back. I have tried so many combinations. Here is my code (is VB .net - but C# is also ok) using Call back is registered appropriately My code is as follows: Dim configuration = New ApiConfiguration(clientid, clientsecret, redirecturi) Dim oauthService = New OAuthService(configuration) Dim logina As New OAuthLogin Dim respstring As String = logina.GetAuthorizationCode(configuration) I get the myob login screen. I get the 2 factor authentication screen. Then it transfers control to my callback. What was the callback supposed to do? My variable “repstring” returns an empty string. I know it is supposed to be the code to be passed to the outhService.GetTokens I have tried saving it with Javascript in the page - but all i get is "java script errors" - even though the callback works in a browser. That is where I am up to now. This is why I asked for an example of the callback html – so I could see what it was supposed to do – so I could do it - in my setting Any assistance will be greatly appreciated.
