Skip to main content
Solved

Manual Supplier Invoice api

  • January 14, 2022
  • 6 replies
  • 591 views

SumanIFS
Do Gooder (Partner)
Forum|alt.badge.img+3

How to create Manual Supplier Invoice using PLSQL Script

Best answer by SumanIFS

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

This topic has been closed for replies.

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
 


HoiJewelP
Sidekick (Partner)
Forum|alt.badge.img+9
  • Sidekick (Partner)
  • 75 replies
  • January 14, 2022

There are standard external file template for Supplier Invoice


Forum|alt.badge.img+19
  • Superhero (Employee)
  • 1111 replies
  • January 14, 2022

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


SumanIFS
Do Gooder (Partner)
Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • 2 replies
  • Answer
  • January 17, 2022

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


SumanIFS
Do Gooder (Partner)
Forum|alt.badge.img+3
  • Author
  • Do Gooder (Partner)
  • 2 replies
  • January 22, 2022

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.    


Forum|alt.badge.img+19
  • Superhero (Employee)
  • 1111 replies
  • January 23, 2022

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