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"
API: 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"API: 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,KeranM
API: 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"
