API for posting Billing/Accouting Information to SAP ECC6.0

[av_afdeveloper]

Hello,
We are new to Avontus and are in the initial stage of project implementation. While we get on with the database setup, training etc in the subsequent days, one of the objective of this project is: Once the invoice are generated, the billing & accounting info needs to be interfaced to our SAP accounting system.
Is there a standard API in Quantify which can be used to post the invoice details to SAP ? If yes, can we get some information of the structure and method to be used.

Alternatively, please recommend method of data exchange which can be used?

Regards

[AvontusDev]

Hello. Yes, there are two ways to get invoices out of Quantify.

First is via the generic export set in Global Options.

Second option is via the API using C#. You can see our sample code and process on how to synchronize invoices here.

Sample Code to Synchronize Invoices with Accounting Software

Quantify was designed to interface with any software package, accounting software being the most common. For accounting software that doesn’t have an API (surprisingly there’s a lot out there, but we’ll save that topic for a separate post) the simplest way to do this is to export the invoices to a file, then have your end-users import the file. Although this works perfectly fine it’s still error prone as it requires end-users to remember to export, as well as other issues. A better solution is …

To get started you’ll want to download our C# sample project.

Sample C# Project

Quantify must be installed and you’ll need an valid account that has access to jobs. Make sure you can log into Quantify. Set your references to the 3 dll’s in the Quantify install folder. (default c:\Program Files\Avontus\Quantify\

[av_afdeveloper]

Hello,
Thanks for the feedback. From the above response we are not clear which type of integration Avontus can support and the approach.

Please provide clarity and on the below queries:

1. Does Avontus support API integration (REST based API integration) ?
   a. If support by API based integration is available, what is the maximum data size for the API ?
   b. Can avontus consume SAP’s API ? or does SAP has to consume Avontus’s API ?
   c. If we need to consume avontus’s API, please share the API document
   d. What should be the frequency of API integration?

2. Does Avontus support file based integration ?
   a. If Avontus support’s file based integration, can the file be dropped in our SFTP folder (AXWAY TUMBLEWEED) ?
   b. What will be the size of the file ? Any limitations?
   c. What should be the frequency of the file integration ?
   d. If there is any exception in the network connectivity while file transfer, is the application capable to handle such exceptions ?
   e. Do we need to send any response to Avontus ?

[AvontusDev]

Hello.
We have a .NET API. You use C# to interact with Quantify. There is a connection string to set to Quantify Web if you want to connect to a remote server, but you still consume the same .NET objects.

If you want to create the file and drop it in an SFTP folder, you are free to do so but this would be a manual process.

I would HIGHLY recommend you have a developer review our accounting integration documentation as well as use our sample code. Once they do this, they will be able to answer all of your questions.

[av_afdeveloper]

Hello,

We need the API URL/document for SAP integration from Avontus along-with with a sample request and response
Also please share the accounting integration documentation you are referring to in your post? so that we can share with SAP developer and integration team to review

[AvontusDev]

Hello. The posts to the sample code and the integration document are in my original response. Can you see the two links there?

[av_afdeveloper]

HI,
I am writing this program to pull invoice data from your application. I was able to download the code from Sample Code to Synchronize Invoices with Accounting Software
We require the below fields from your invoice object. Can you help us with a field mapping?

Fields Attached:
avontus_api_query.pdf (46.1 KB)

[AvontusDev]

Hello, are you using C# or VB.NET?

[av_afdeveloper]

Hi,
We will be using C# for this

[av_afdeveloper]

Hi,
Can we have your feedback from the last post please?
Please advice how to pull invoice data from avontus and post to sap

[AvontusDev]

Hello. Are you able to get the invoices to load using the sample project for accounting integration? All of the properties you’re needing are there, on the invoice object. This will enable you to retrieve the data from Quantify. You will need a developer that knows how to post to SAP, we cannot help you with that part.

[av_afdeveloper]

Hi,
Just to clarify, we are not looking on details on how to pull data from Avontus.
We have downloaded your sample appl. Attached are the list of fields which we want to pick from your data set. Request if you could please help provide a field mapping for the fields we require.avontus_api_query.pdf (46.1 KB)

[AvontusDev]

Glad to hear you have the sample up and running. You will need to use the Invoice object in that sample code and write those fields to a file, web service, etc. all of those fields are on the invoice object,

We do not have a “data set”, not sure what you mean by that?