Solved

Manual Supplier Invoice api

  • 14 January 2022
  • 6 replies
  • 436 views

Userlevel 1
Badge +3

How to create Manual Supplier Invoice using PLSQL Script

icon

Best answer by SumanIFS 17 January 2022, 13:48

View original

This topic has been closed for comments

6 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 5
Badge +9

There are standard external file template for Supplier Invoice

Userlevel 7
Badge +18

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

Userlevel 1
Badge +3

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

Userlevel 1
Badge +3

I have resolved and complete the manual supplier invoice including GL Posting using PLSQL Script.

This program has been made for Automation to Complete Purchase Order to Supplier Invoice booking with a one click customization.    

Userlevel 7
Badge +18

Hi, 

Just FYI, typically, we would consider self-billing functionality for that use case, automate a AP invoice due to PO arrival.  Self-billing does have some limitations, but it is a common solution where needed. 

Best regards, 

Thomas