View Full Version: Upload Expense Reimbursements

LawsonTalk > Financials (GL, AR, AP, ..) > Upload Expense Reimbursements



Title: Upload Expense Reimbursements


lmckenn - March 27, 2008 07:56 PM (GMT)
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

SAH - March 28, 2008 11:22 AM (GMT)
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.

stevel - April 1, 2008 09:41 AM (GMT)
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

Milo - April 2, 2008 02:58 PM (GMT)
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".


lmckenn - April 3, 2008 06:12 PM (GMT)
Thank you everyone,
I appreciate your input.

lmckenn




Hosted for free by InvisionFree