P
prana1
Here's a little ditty I am working on - an automating project and getting
pretty far.
i have a table of values, invoice information - dates, payment amounts,
vendor names and the like.
What I'd like to do is create a file that AP can use to enter the
information into SAP.
This file has to be a spreadsheet, that has some of the data from 1 table,
and a 'vendor number' which is from another table.
I think I can do that part, it's just saving it as a spreadsheet, and
marking these items eitther in the table or somewhere else, so they don't get
processed again in the future (unless I choose to do so).
After, I intend to open Outlook, attach the spreadsheet and then send it to
AP.
Does anyone have an idea on the best way to accomplish this? Keep in mind,
I am not a coder, and taking a class..
pretty far.
i have a table of values, invoice information - dates, payment amounts,
vendor names and the like.
What I'd like to do is create a file that AP can use to enter the
information into SAP.
This file has to be a spreadsheet, that has some of the data from 1 table,
and a 'vendor number' which is from another table.
I think I can do that part, it's just saving it as a spreadsheet, and
marking these items eitther in the table or somewhere else, so they don't get
processed again in the future (unless I choose to do so).
After, I intend to open Outlook, attach the spreadsheet and then send it to
AP.
Does anyone have an idea on the best way to accomplish this? Keep in mind,
I am not a coder, and taking a class..