Question

Manual Supplier Invoice api

  • 14 January 2022
  • 4 replies
  • 71 views

Badge +1

How to create Manual Supplier Invoice using PLSQL Script


4 replies

Hello,
I suppose that you want to prepare some interface to import invoices from other external system.
For that purpose it is better to use External Supplier Invoice functionality.
You have to prepare a file with invoices and import with Assistant.

Best Regards,
Pawel
 

Userlevel 4
Badge +7

There are standard external file template for Supplier Invoice

Userlevel 7
Badge +11

Hi, 

The two most common processes I have seen is 

  1. The external supplier invoice where a file is loaded with N invoices. It allows a configurable templates / numerous options for data structure an processing with / without image data. 
  2. Loading XML - The XML is dropped into an inbox and the message is handled via IFS.  

PLSQL script in my opinion is far less common and probably far more difficult.  The supplier invoice is an extremely large group of code and offers great flexibility / functionality. 

Both input functions above external supplier invoice and XML based message already have the flexibility / data management within the solution.  

If you wish to create a real time interface, I would lean towards the XML. Batch type process, I would lean towards external supplier invoice. It can be automated. 

Best regards, 

Thomas

Badge +1

I have done Manual Supplier Invoice with PLSQL Script Now only remaining posting.

Reply