WDCI Blog...

Prevent Concurrent Data Modification

By TIM | Jun 23, 2011

Applications such as Quickbooks or Saasu have a mechanism to prevent cocurrent edit. If you plan to integrate with Quickbooks or integrate with Saasu, this is the mandatory field when you are performing an update call: Quickbooks uses a field called EditSequence Saasu uses a field called LastUpdatedUid   This field value is automatically updated…

Read More

Dynamics GreatPlains Integration: Item Price Structure

By TIM | Jun 15, 2011

An Item in Dynamics GreatPlains can have one or more different types of ‘Price Level’. One of the complicated types of Price Level is the Price Method. This component is crucial if you are integrating Dynamics GreatPlains with other applications:     So what does this Price Method define for an item’s price? Basically, it…

Read More

Quickbooks Integration: Transactional Data Model

By TIM | Jun 9, 2011

If you are integrating with Quickbooks (desktop version), here we have an example of the transactional data model of the objects that can be integrated.   A customer object can have one or many transactions (Sales Order, Invoice, Sales Receipt) A transaction object can have one or many items. A Sales Order can be converted…

Read More

Dynamics GreatPlains Integration: Data Model

By TIM | Jun 1, 2011

If you are integrating with Microsoft Dynamics GreatPlains, this is the high-level data model for the finance module: A customer object is a company. It doesn’t have an independent contact object. A customer can have many addresses. Inside each address, you can keep track of contact name. A customer can have many sales entries (Invoice…

Read More

QuickBooks Integration: Transaction (Sales Order, Invoice) Counter

By TIM | May 25, 2011

When creating a transaction in QuickBooks, a transaction number will be generated followed by the last transaction created. In most of the applications, transaction number has to be unique and is not allowed to be modified to prevent duplication and confusion. However, in QuickBooks, transaction number is allowed to be modified which means that when…

Read More

Magento Integration: Synchronise Product Data

By TIM | May 19, 2011

In Magento, one SKU can have different product names. For example: If you have two different store views, you can have your product name in two different languages English: Table Spanish: Silla   To do this via the Magento Core API, you will need to: Create the product using the catalogProductCreate function (default values) Update…

Read More

Netsuite Integration: Session Limits

By TIM | May 18, 2011

A given standard Netsuite user login is limited to two sessions at the same time, one through the front-end (UI) and one through the web services.   For example, if someone attempts to log in from two different browsers at a time by using the same login user, the login from the second browser will…

Read More

Aprimo Integration : Retrieving a Digital Asset

By TIM | May 14, 2011

Aprimo has a sophisticated data model to handle Digital Asset. You can retrieve from the API directly. Before you do that, you should understand the following data structure:   Activity Each activity can have one or more digital asset. You can add an existing digital asset or promote from existing attachment.     AssetVersion Each…

Read More

Extracting Data from MYOB : Total Sales

By TIM | May 11, 2011

  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

Magento Integration: Access to web services

By TIM | May 4, 2011

In order to access Magento web services API, you will need to do the following: Log in with a username and API key. This username is not the same as the username that you used to log in to the admin backend of the store. You will need to create an API user and role…

Read More