Case Study# 8

QAD Concur Interface

Objective – A interface was developed in Progress 4GL to interact between QAD and the Concur system for the processing of invoices with no associated Purchase Order and for non-Inventory related purchases. Invoices are processed in Concur and information passed to QAD. This will include:

1. 1.Voucher details to create Supplier Invoices in QAD
2. 2.GL detail to be used in the creation of Supplier Invoices

The interface was developed using a combination xml file and direct web service call
architecture where QAD ERP exports the Supplier and Purchase Order information and
imports the concur payment file to create Supplier Invoices.GL Transactions are generated from the Supplier Invoice based on GL Account Codes supplied from Concur in the Interface File.

Highlights –
1) Supplier data is exported in tab delimited format and transferred to Concur servers via a
direct Web Service call
2) In a similar fashion Purchase Orders data was transferred to Cocur Servers
3) While processing Supplier Invoices, Concur system drops the Payment data in XML file
format that is then processed into QAD using Supplier Invoice API.