Question

Invoice API - Create PDF

  • 18 July 2022
  • 3 replies
  • 196 views

Userlevel 5
Badge +8

Does anyone know if there is a way to call into IFS via API to generate the Invoice PDF? We currently email our customers their invoices but we would like to have our customers get a copy of their invoice on-demand via our website. Thus the idea would be to call IFS via API and generate or pull the archived PDF. 


3 replies

Userlevel 6
Badge +12

I don’t know about invoices, but you can print Purchase Orders through methods discussed here:

 

We successfully did something of this nature to generate a purchase order PDF then attach it to an Outlook email for a user to manually send wherever they wished (required a custom integration written in C#, of which we are doing many).

 

Good luck,

Joe Kaufman

Userlevel 3
Badge +10

Did you check the Interface browser?  https://servername:48080/interfacebrowser/#/

Otherwise the pdf is stored in the table/view pdf_archive_tab/pdf_archive.

 

SELECT p.pdf

  FROM ARCHIVE a JOIN pdf_archive p ON a.result_key = p.result_key

 WHERE report_id = 'CUSTOMER_ORDER_IVC_REP'

   AND a.notes LIKE '%Order No: ' || '&ORDER_NO' ||'%'

Userlevel 3
Badge +10

It also occurs to me that depending upon your requirements you could also use a report rule.

Reply