My accounting business partners are interested in streamlining their process for adding a large number of assets into Lawson. Currently the inventory business partners send a spreadsheet with new asset information to accounting, and accounting adds the assets using AM20.1 and then adds journal entries using AM20.5.
It looks like we can use Excel add-ins to upload large datasets to the asset, item, and book conversion tables and then run AM500 to convert the data. However, I'm not seeing an easy way to auto-create journal entries. I've been playing around with using an upload wizard to mimic the AM20.5 screen, but so far it hasn't worked.
Does anyone have a suggestion for how we might auto-create journal entries to correspond with assets added via the upload wizard?
