Prev
Next
Forums Lawson Add-Ins for Microsoft Office

Uploading Assets-AM20

Sort:
You are not authorized to post a reply.
Author
Messages


itsjustme











Advanced Member



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











    Senior Member



    Posts: 3348




    Senior Member



    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



      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...
        You are not authorized to post a reply.