WDCi Blogs

Not all data is available through the MYOB UI export data feature. If you want to get more data, you can try the MYOB ODBC Direct. More information about MYOB ODBC Direct can be found here.

In our attempt to rival Universal Studios, we’ve been at it again, creating videos of some of our ReadyMade integration solutions.  Check out our latest video on how easy it is to integrate Salesforce & MYOB.

Want to know more about how to get Salesforce & MYOB talking? contact us or check out our other MYOB demos and information on our website.

Sure, they are not going to win any Oscars, but if you’re interested in Salesforce integration to 2 of the most popular accounting packages around, take a look at our Salesforce to Saasu and Salesforce to MYOB ReadyMade integration solutions.  Oh and yeh, you won’t need a big bowl of popcorn cos they only last a few minutes each.

The first problem that we had while integrating MYOB with another system was importing multiple Cards with the same name into MYOB as different Cards.

In the standard MYOB interface, it allows you to create two new Cards with the same name. However, this is retricted when the cards are created via the ODBC import function. For example:

insert into import_customer_cards (CoLastName, FirstName, InvoiceDelivery)
values ((’Andy’, ‘Cole’, ‘B’), (’Andy’, ‘Cole’, ‘P’))

This import statement will only create one Card “Andy, Cole”. The reason being is that MYOB will create a new card “Andy, Cole” using the first “value” and update the same card again using the second “value”. This is not ideal if we happen to have two customers that have the same name.

To fix this issue, we needed to add the “CardId” field to the import statement as an unique identifier for the cards. For example:

insert into import_customer_cards (CoLastName, FirstName, InvoiceDelivery, CardId)
values ((’Andy’, ‘Cole’, ‘B’, ”), (’Andy’, ‘Cole’, ‘P’, ‘0001′))

WDCi is an OEM partner with Talend, the leader in open source integration and ETL.  The Talend ETL tool is used by WDCi in both our consulting and some of our pre-built integration solutions, check out the November edition of the Talend Newsletter .

Many thanks to Solatube for participating as well.  Solatube has worked closely with us to refine one of our solutions (MYOB-Salesforce).  Nothing can replace real use-case details, especially when you are trying to pre-build and package a business process to suit hundreds of organisations.

We have just released a 1.3 version of our Salesforce-MYOB pre-built integration.  The key new features are:

1. Personal Contacts in Salesforce can now be sync’d to MYOB Cards
2. The Salesperson name can be captured in Salesforce and transferred to MYOB to include in Sales Orders/Invoices
3. Duplicate Cards are now handled more gracefully, allowing Salesforce to create duplicate Cards in MYOB

Check out the website for some more detail on how it works.

MYOB Accounting Plus and Premier use an underlying data file to hold the records.

In the current versions this is not a relational databae, making traiditional integration difficult.

MYOB have over the years released a series of ODBC drivers. These have allowed programs such as Word and Excel to extract data and in some cases, insert data to MYOB. WDCi have taken this ODBC driver and created connectors for several integration platforms.

These connectors enable the integration of MYOB into nearly any platform or application, whether hosted or on-premise.

With this framework it is now cost effective to have an online eCommerce site integrated directly with MYOB to post order or invoice data and extract product data. Alternatively you can connect your CRM or ERP system into your MYOB accounting system.

The main objects that are typically integrated are:

- Company and individual contact information

- Product (Item) information

- Opportunity and Sales data to an Orders/Invoices within MYOB

- Shopping cart invoice and payment replication to MYOB

Anything in MYOB can be exposed and integrated to a vast array of applications, once you know how.  For more information contact us or check out our ReadyMade solutions for pre-built MYOB integration solutions.

Our ReadyMade integration tool that takes BC orders and creates MYOB paid invoices is now in beta - woohoo.

Interested in how it works? check out the documentation here.

Want to test it for us, great, contact us to get up and running in minutes.

Got two applications you think we should add to our ReadyMade roadmap? Drop us a line and let us know, we’re listening.

Working on a ReadyMade for Business Catalyst -> MYOB Accounting for cash sales, here’s the basic process:

This is in response to requests to automate the entry of ecommerce sales into MYOB, eliminating the need to manually key in each invoice.  It takes about 2-3 minutes for each invoice to be manually entered into MYOB, for companies entering even 20 invoices this can be painful.

We should be ready to test in early October, let us know if you are interested to participate in our beta cycle?

If you are interested in different Business Catalyst or MYOB integrations that we don’t have on our website, then why not suggest them to us and we can do some research and blog about our plans and findings.

Worked on our roadmap for ReadyMade’s for the rest of the year.  So far I’ve got:

1. Salesforce -> Quickbooks (Australia)
2. Business Catalyst -> MYOB
3. Salesforce -> MYOB Retail Manager
4. SugarCRM -> MYOB

If I’m off the mark it would be great to get input.  We’ve put up a text box here to take input from site visitors, no questions asked.