we are planning to reduce the amount of data entry involved in
keying expense reimubursements on the AP20 screen.
We currently use a modified excel worksheet for our employees
to submit their expenses -- is there any way to have this excel
report uploaded to the AP20 without rekeying to an "Addin" ?
Thank you,
lmckenn
Although I'm not familiar with AP, I would think if your excel spreadsheet contains all of the required fields formatted for AP20 data, with appropriate permissions, there should be no issue just opening that file and uploading with add-ins. You would need to map the columns the first time, then save the upload format to be used over and over.
| QUOTE (lmckenn @ Mar 27 2008, 11:56 AM) |
we are planning to reduce the amount of data entry involved in keying expense reimubursements on the AP20 screen. We currently use a modified excel worksheet for our employees to submit their expenses -- is there any way to have this excel report uploaded to the AP20 without rekeying to an "Addin" ?
Thank you,
lmckenn |
Have you considered using AP520 to bulk upload them rather than doing them individually?
It will probably require a process change for the business but you can upload thousands in one go that way....
Steve
Yes, we do that in our Lawson setup, import hundreds of invoices into AP520 & process from there. The only difficult part is getting the incoming file to hold data correctly.
The whole interface process is detailed in the "Lawson Supply Chain Management Conversion Guide".
Thank you everyone,
I appreciate your input.
lmckenn