• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums User Experience Lawson Add-Ins for Microsoft Office

Uploading Assets-AM20

 2 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
itsjustme
Advanced Member Send Private Message
Posts: 40
Advanced Member
8/8/2008 11:02 AM

We have a need to upload about 700 assets. The upload for AM20.1 only allows 8 at a time and each different asset data is in another column of one row rather than a row for each asset data.

Does anyone know of a way to upload this information more efficiently?

Thanks

Dave

John Henley
Send Private Message
Posts: 3351
8/8/2008 12:19 PM

Here's an article you might find useful: Uploading to Asset Management using Lawson's Excel Add-In

You might also want to do some surgery on your spreadsheet to get it into one row per asset (have you ever used the "Paste Special | Transpose" option in Excel?)  Remember that the best way to use the Excel Addins Upload Wizard is to always think in terms of uploading against Row 1.

Thanks for using the LawsonGuru.com forums!
John
itsjustme
Advanced Member Send Private Message
Posts: 40
Advanced Member
8/8/2008 6:54 PM
Thanks, I read the article, since we are trying to correctly update the AM system from erroneous data in PO and AP Module in this instance, I wasn't sure how the AM15 would go. The invoice for the assets is in there, but it is not against the actual line items we want in AM. (Buyer put all the assets as $0 cost, and put all the costs against 1 PO Line that they could make progressive payments against. No thought or questions were asked, and a couple payments have already been made.)
I have not use the Transpose option, will look into that as well.
Thanks for your suggestions...