Jeff_AccAddons
Valued User
Joined 14 years ago
User Profile
User Widgets
Contributions
Re: Custom report
Hi Bec, You can use power query in Excel to join tables of data together If you are trying to find customers linking back to suppliers who you they have bought from then you can do something like start with sales by Item and then get the last supplier for an item or the default supplier and then join them https://odatalink.com provides a way to get suppliers and customers and Item sales into Power query where they can be joined Jeff82Views0likes0CommentsRe: Customer invoice reports
Hi lyndor You can get that raw data out of MYOB via https://odatalink.com It provides an invoices end point which includes all the fields provided by the Invoices end piont in the MYOB API https://developer.myob.com/api/myob-business-api/v2/sale/invoice/ The data comes in via Power Query and in there the data can be transformed to filter a particular customer and to return that tax inc amount Jeff201Views0likes0CommentsRe: Failed to fetch data error in MYOB for Excel addin
Hi Tehrani, If you can't get this to work, try https://odatalink.com It works by pulling data into Excel via power query which is a bit different but you should be able to get the data your after. It doesnt require an add-in to be installed but is a direct connection via the Odata connector in Excel JeffRe: Power BI Connect to MYOB Accountright
Hi Rosco, The accepted solution was posted in 2020 and there are now dedicated connectors for Power BI If you click the link below you will find them https://www.myob.com/au/apps/search-results?query=power%20bi&tasks=advanced-reporting&products=accountright Jeff920Views0likes1CommentRe: Allocating superannuation and work cover to job numbers
Hi Ben The only way Ive found to archive the result of allocating superannuation and workcover to jobs is by creating a separate General Journal Entry that credits the total split to no job and then has a separate debit line for each job. To calculate the splits you can run a profit and loss by job for the period and then identify the wages accounts to be split to work out the percentage splits. If you have many you could transform and summarise the data to provide the values your after. If you have many and want to automate it further you can access MYOB data directly using a connector like OdataLink Jeff465Views0likes0CommentsRe: Can i access myob db tables usin api
Hi deeppatin The Add-in OdataLink can provide data in a format that you can queried live from SQL https://www.myob.com/au/apps/products/odatalink Here's a video on how to connect using it https://odatalink.com/tutorials/integrate-myob-or-xero-with-sql-server-using-odatalink-clr/ Jeff1.5KViews0likes1CommentRe: MYOB Dashboards
Hi Doc An alternative could be to create the charts in Power BI, publish online and then and share them with the director which could be viewed on a mobile Power BI's Odata feed connector can be used to to pull live MYOB data via OdataLink A scheduled refresh can be setup so that the data is updated overnight1.2KViews0likes1Comment