Prev
Next
Forums Financial Management Lawson S3 Financials

Uploading to Asset Management using Lawson's Excel Add-In

 2 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
John Henley
Posts: 3353
11/3/2008 3:21 PM

    We've found some limitations using the Excel Add-In's Upload Wizard in Asset Management because Additions, Adjustment, Transfers and Disposals often prompt new forms after the first record is entered onto the first form. Our way around this is to not use the standard entry forms, but some alternate forms.

    Read Uploading to Asset Management using Lawson's Excel Add-In.

    Thanks for using the LawsonGuru.com forums!
    John
    Dave Mitchell
    Advanced Member
    Posts: 18
    Advanced Member
    11/3/2008 3:21 PM
      Actually, when adding assets with an Inservice Date in a prior year, the best way is to use the AM20.2 - AM20.5 forms, along with a download from AM20.4, so that LTD depreciation is correctly recorded in the GL and matches AM20.4. Dave Mitchell
      Dave Mitchell
      Advanced Member
      Posts: 18
      Advanced Member
      11/4/2009 5:56 PM

        I have an entire process detailed in some spreadsheets (1 for Large Quantity PO's, taking into consideration prior year inservice dates, etc).  Dave