0

Create vendor invoice PDF on SFTP through macro

Wim_ki 2 weeks ago updated 1 week ago 2

Hi all,

we have a small macro that runs monthly to force status of some vendor invoices to BILL RECEIVED.

We implemented this so we could keep the payment due dates of the vendor invoices consistent. However, when we change the status to BILL RECEIVED by using a macro, the final PDF files are not created on the SFTP server.

Since there is no option in XTRF to download all invoices at once (as there is for client invoices), we grab them from the SFTP, but due to this, we need to manually change the status for each invoice from the UI.

Does anyone know how to trigger the PDF creation on the SFTP server through a macro?

I asked the support desk, but unfortunately it would require extra time on their side and paid developer support :(

Thanks in advance.

Wim

Hi Wim, 

I am unsure if this is applicable, but maybe you can find a way of utilizing the automatic provider invoicing - we do it this way. When the periodic job creates invoices with BILL_RECEIVED status, it is created properly in the SFTP server.

Hi Bartosz,

Thanks for your idea, but we are unfortunately not using the automatic provider invoicing at this moment. But good to know that it does this with the periodic job!