Posts Tagged ‘MYOB’

WeDid: MYOB to Salesforce

Purpose Migrate data from MYOB to Salesforce Applications MYOB Salesforce Versions AccountRight Premier v19 Salesforce Spring’10 Tool CSV Export and Database Information Customer Card Invoice Item Data Formats Database and CSV Volumes < 5,000 records Error handling Write failed data to external file for further cleansing, fix and reload. Complexity Simple  

Read More

WeDid: MYOB and Business Catalyst Integration

Challenges The user is having difficulties to ensure customer’s information and invoices in MYOB are up-to-date when a sales is closed via the company’s website.   Solution:   Purpose Ensure that the customer information and invoice records are automated and synced into MYOB from website sales (Business Catalyst) Applications MYOB Accounting Premier Business Catalyst Versions…

Read More

WeDid: MYOB and database.com Integration

Challenges To be able to synchronize the on-premise MYOB records to database.com, a hosted environment for easier access.   Solution:   Purpose Synchronize MYOB records into database.com Applications MYOB Accounting Premier Database.com Versions MYOB Version 19.0 database.com Tool Talend Information MYOB Items > database.com Items Object MYOB Cards > database.com Contacts Object Data Formats MYOB database to database.com SOAP XML Volumes 10000/day…

Read More

WeDid: Salesforce and MYOB Integration

Challenges When Opportunities were won in Salesforce there was a manual entry of the Customer details into the MYOB accounting system and a manual update of the Salesforce Opportunity with the Invoice details from MYOB. This resulted in data errors and inconsistency, as well as consuming a considerable amount of time for the accounting staff…

Read More

MYOB: Problem accessing unregistered company file

We encountered an MYOB error saying “[MYOB ODBC] – This company file has not been registered for ODBC Access.” when installing one of our ReadyMade product, RIO Finance desktop client for our customer.     After contacting the MYOB support, we realized that the customer has to contact MYOB team to enable the ODBC access…

Read More

Integrating to MYOB AccountRight

  URL https://myob.com.au/ Description On-premise Accounting Application API Yes, via MYOB ODBC Trial Version with API Access Yes. Protocol Microsoft ODBC Data Format SQL and Stored Procedures Authentication MYOB user and password authentication and/or partner OEM key (if requires writing to MYOB) API Limits No limit. Sample Use Case Salesforce Opportunity > Creates/Updates > MYOB…

Read More

MYOB Integration: AccountRight 2011 ODBC connection error

Recently I was helping my development team to do some testing of our Salesforce-MYOB ReadyMade product to see if it is compatible with the latest ODBC driver “MYOB_AccountRight_2011” released by MYOB. After installing the ODBC driver in my machine, I created a new System DSN with the ODBC driver. As soon as I clicked on…

Read More

Extracting Data from MYOB : Total Sales

There are ways to extract data like total sales from MYOB (Database) and generate this data into useful information for the company. Here is one of the ways. First, we may need to query all the sales data from MYOB by filtering them by type of invoice. The next step, we can sum up the…

Read More