You are viewing limited content. For full access, please sign in.

Question

Question

Invoice automation and upload into SAP

Updated October 1, 2018
asked on October 1, 2018

Good day,

 Our AP would like to automate invoices that they receive from a supplier monthly( they amounts are fixed expect for a few that fluctuate due to rand/dollar value).

They receive invoices in pdf as well as a spreadsheet. The SAP upload is also in excel. The amount on the supplier spreadsheet is VAT inclusive but the SAP upload sheet amount is split into two different codes and the amounts are also split ( 1st amount is without VAT and the 2nd amount is the 15% VAT)

 

Please see the attached spreadsheet - The AP team has to manually populate column J (Supplier code in SAP)and I (GL code in SAP)

Can workflow help us achieve this? I know its possible , i just don't know how/where to start.

Your assistance will be highly appreciated.

Regards,

Pearl

Pearl Masango.xls (83.5 KB)
Download
0 0

Answer

SELECTED ANSWER
replied on October 1, 2018

Once you have the Excel file in Laserfiche, you can use Workflow and a Script activity to interact with the data. However, you'll need to use the Office OpenXML SDK to read the data out of the file. You can simplify things if you can get the data in CSV format. It would be a lot easier to extract, but you'd still need to write code to work with the file contents.

If you search on this site you can find some other suggestions that may or may not be easier for you.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...