Integration: ODBC Driver for AccountRight
I've installed AccountRight2012, but there is no ODBC software that accompanies the installation. I use ODBC heavily to extract data into Excel, Access etc for additonal mining and reporting. Hence, I will not upgrade until this functionality is available. My apologies if this has been answered previously. "ODBC Driver for AccountRight 2012"17KViews3likes14CommentsAPI: Customer Cards - ItemPriceLevel write access
Hi, We've just recently migrated from v19 to Account Right Premier 2016.2. We have historically been able to import customer cards into MYOB v19 via ODBC and have now employed a third party tool that uses the API to AR2016. The tool has had difficulty updating the ItemPriceLevel of Customer cards. I have had feedback from the tools developer that this field is read only in the MYOB documentation - WHY? Is this correct? We offer discounts to our members and therefore want to distinguish this automatically when raising invoices to select the correct discounted price. If this field is truly read only, can it be changed to writeable in the next release/update? Regards, Don. "IMPORT CUST CARDS - Item Price Level Field"3.4KViews0likes2CommentsAPI v2 rate limits
Hi guys, I have some questions about the rate limits for the API. Here is the context connected with my questions. On the one hand, I've seen the post from the 2018 where the next limits were exposed in scope of the one API key: - 5 requests per second - 50.000 requests per day. On the other hand, I can see the specs where limit is defined as 1.000.000API calls per day: https://developer.myob.com/program/developer-program-details/ As a result, I have the following questions: 1) Did I get it correctly that limits are bound to the API key not to the account which issued that one? 2) What is the relevant requests limit per day (for the 1 API key) by default? 3) What is the actual/relevant requests limit per second/minute (for the 1 API key) by default? Could share the latest details please? Regards, OlegSolved3.2KViews0likes1CommentAPI: Provide both GST-exclusive and -inclusive line values
Speaking to other developers recently, we would all like to see the API transaction endpoints include both incl. and excl, line amounts. At the moment (API v2, AR 2017.2), a single amount field is provided, which can be either inclusive or exclusive according to the value of the "istaxinclusive" flag. As many of us know, GST values are rounded on a line by line basis so that the GST calculation on the total is always correct; however, this is a complex calculation which we should not have to be expected to replicate when far simpler solution is available. DeveloperJack,KeranM3.1KViews6likes1CommentAPI: Date Modified - Void Transactions
Hi API Team, We have reporting solutions which pull transactions at detail levels. In order to make that as fast as possible we have an archive function which keeps a history of data and only pulls transactions which have changed. At this point the date of change for most transactions is the start of the current financial year. What we would like to do is only pull transactions which have changed since the last time a get data was run. To do this we would require a Date Modified field added to all transaction records which is available to filterin the api.In addition to make it work we would also need to know if a transaction has been deleted so rather than deleting a record from a table, keep it but add anisDeleted field and mark it as true or false or something similar. Thank you Jeff Jeff Stephenson BCom | MYOB Professional Developer | Solution Architect Accounting Addons - 1300 ADDONS | (1300 233 667) jeff@accountingaddons.com.au|accountingaddons.com.au Excel Add-on Solutions, Consulting, Training, Customisation & Support BudgetLink|ExcelReportLink|ODBCLink|DirectDebitsLinkAPI: Add Recurring Transactions
Hi API Team We have a Cash Flow Pivot report which aims to replicate the missing Cash Flow Report from MYOB v19 We are able to pull enough sales and purchases data to calculate expected customer receipts and and supplier payments based on terms but we are missing the recurring receive money, spend money transactions and other recurring transactions. If you could add recurring transactions to the API we would be able to complete the report and help customers who rely on it in v19 to migrate to ARL. Cheers Jeff "Add Recurring Transactions into the API"1.8KViews5likes0CommentsHow append new line to the order by api ?
Hi there, I use the myob api to do the data push in myob a few weeks. But now a update order lines requirement needs to implement update/add / delete order lines. About the add new line to a exits order, I search the documents and here. But no clear answer for this. How to append new lines to a exits order ? Thanks.1.2KViews0likes4CommentsCompany File ID/URI keeps changing.
Can you please explain why the URI /Company File ID keeps changing on my MYOB database? This causes my website sync software to complain with this error in the MYOB API log file: “[Message, The company file can't be found. It might have been deleted.][Message, The company file can't be found. It might have been deleted.]” Problem is I understand this may happen if I upgrade MYOB, however I have not done any upgrades and have remained static on the following 2019.2.1 build 2019.2.22.5066. Here is the history of the changing URI just in this last month: 28th August changed from below to - http://localhost:8080/AccountRight/2ab71849-bff8-4aff-b95c-d1e6d1af0252 27th August changed from below to - http://localhost:8080/AccountRight/0255fb97-0f46-451b-b141-d72f493104c1 8th August changed from below to - http://localhost:8080/AccountRight/3a7f1309-0a7f-4f08-9d61-113771fb74f9 2nd August changed from (no record) to - http://localhost:8080/AccountRight/fca4d9a0-9094-46e1-984e-0eba05af8c80 SOOOOOO FRUSTRATING!1.1KViews1like2Comments