Posts Tagged ‘MYOB integration’

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 on my machine, I created a new System DSN with the ODBC driver. As soon as I clicked…

Read More

MYOB & database.com come together to expose MYOB data to the cloud

Thinking about a cloud database?  Why not look at database.com, if you are a Salesforce developer or you are familiar with Salesforce, you’ll find it simple to use.   Check out a brief summary of some recent work we have completed using database.com  to expose MYOB Accounting data to the cloud https://wdcigroup.net/wedidintegration_myob_databasecom.html.

Read More

MYOB Integration: Extracting total sales data

Here’s a couple of examples you might find helpful if integrating with MYOB. The following query extracts the total sales from July 2011 to June 2012. SELECT SUM(TotalTax + TotalLines – TotalDiscounts) As TotalSales from Sales WHERE InvoiceDate BETWEEN ‘2011-07-01’ AND ‘2012-06-30’ +——————+ |    TotalSales   | +——————+ |      29223.5     | +——————+ You can…

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…

Read More

Using Salesforce & MYOB, need to sync Items to Products?

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…

Read More

Get the popcorn, sit back, relax and watch our videos.

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…

Read More

MYOB Integration Tips

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 restricted when the cards are created via the ODBC…

Read More

WDCi featured in Talend Newsletter

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…

Read More