Skip to main content

Hello

I can’t figure how to import data into accounting vouchers using the API”s. 

First I looked at the  VoucherHandling API but there are only GET functions and some PATCH but no POST to insert data in the Voucher entity.

I suppose that this table is protected and I tried to use the ExternalVoucherHandling to insert data in the ExternalVoucheSet as the file import in IFS does.

There is a POST function to insert lines in the ExternalVoucheSet but it ends up with the following error:

":"ORA-20111: ExtLoadInfo.FND_RECORD_NOT_EXIST: The Ext Load Info does not exist."

 

So I supposed that I needed to create first an ExtLoadInfoSet as a title for the lines.

In this API there are no POST functions with a json payload but a function called ExtLoadInfo_DoCreateVoucher.

I have tried to call this function with 2 parameters:  Company = XXX , LoadId=2 but I get this error:

Payload: {"error":{"code":"ODP_RESOURCE_NOTFOUND","message":"Resource not found."}}

 

This seems to indicate that the function does not exist either in the API or in the Oracle package being called.

 

I am completely stucked with these errors and my question is:

Does anybody knows how to import data into the accounting tables (voucher otr hold table) using Rest API. ?

It seems to me a very standard need and I hope someone has the answer.

Thank you for your help

JanickF

 

 

 

 

Hi 

In similar quest here. Trying to figure out if there is anything ready-made to import vouchers to IFS accountig rules. Either directly of via the External Vouchers. Happy for any hint.

 

Cheers Jarek

Hi Jarek

I think that there is no way to import a voucher using  IFS API .

We finally used the extarnal voucher import from text files.

So we had to generate an import file following the required format and then import manually those files.

This is not so bad as many controls are being made when importing and this assures that the final input is correct.

 

If you need more details, please ask.

Regards

 

 

Thanks! Will consider. Strange to hear anyway, considering all the API rhetorics

Hi @janickf  @jaryskorys 

 

Have you tried importing them in batch mode instead of manually?

I’m looking for…

 

Thanks Regards

Hi jgiroud

No, because the accounting people are satisfied with the manual process.

We have developed different applications to generate compatible files from different data sources (Sage payroll, Notilus expense reports, supplier invoices, etc..) and the manual process has validation steps insuring that the input is correct.

 

Regards

Probably a good strategy to make the things simple. One question on top though. Have you met any performance and size limitations? Maximum reasonable number of voucher lines/headers etc?

We usually process a few hundred lines vouchers and have not notices any performance problems.

It is very quick and straightforward.

The difficulty in creating the input file is to split correctly the different records ( I, P, T) for each tax code. 

IFS will reject an input if the tax codes are not split correctly,.

Hi, 

Nearly every one of my client’s use the IFS external voucher functionality (with a client / user defined template).     The STDVOU template would be copied to a My_VOU type template where the attributes such as company and other would be identified as the attributes.  Commonly the delimiter would be changed to comma to better support CSV.   The voucher file can be hundreds / thousands / tens of thousands of lines.   I believe I tested a 100K file for a large volume test.  File can be multi-company, but file must balance per company.  It’s also very flexible in terms of voucher output (one voucher or many per file). 

Not API, but it works very easily and is used by most clients. 

Process can be automated. 

Best regards. 

Thomas

Hi, 

Nearly every one of my client’s use the IFS external voucher functionality (with a client / user defined template).     The STDVOU template would be copied to a My_VOU type template where the attributes such as company and other would be identified as the attributes.  Commonly the delimiter would be changed to comma to better support CSV.   The voucher file can be hundreds / thousands / tens of thousands of lines.   I believe I tested a 100K file for a large volume test.  File can be multi-company, but file must balance per company.  It’s also very flexible in terms of voucher output (one voucher or many per file). 

Not API, but it works very easily and is used by most clients. 

Process can be automated. 

Best regards. 

Thomas

Hi @Thomas Peterson,

 

How is this process automated? We are using Boomi to import the external voucher file but what would be the steps to automatically create the voucher? Thank you in advance.

External files can be initiated manually or automatically as a scheduled process.  The option you may want to review is batch mode.    

The external voucher parameters than drives the process / steps that are automated. 

Reply


Terms & ConditionsCookie settings