Lawson Add-ins for Microsoft^® Office Files

don.peterson@us.lawson.com

Here are some worksheets that have already been set up for uploading.  Most of these are for those forms where it is more difficult to figure out what fields, some hidden, you need to include.

The upload worksheet examples work on the setup we have on our sales laptops and may need a little adjusting to work on the specific setup, data and environment, you have at your location.  So you will want to create your own Upload Wizard mapping to match the version of Lawson you have installed.  The fields you map to are in the second line of the column headings.

For the self-contained examples (at the bottom to this site), your development staff members can take a look at the source for the examples and see how I did those and they can modify them to make them work on your environment if they don't right "out-of-the-box".  They can view the code that I wrote into the worksheets by selecting View | Toolbars | Visual Basic from the Excel menus.  They can also use the same techniques to make other worksheets that you may need.

Those added or updated in the past month are indicated by white text on a green background in the left column.

Standard Disclaimer

We are providing these examples to you free of charge.  These are not delivered by Lawson and there is no support available for these examples.  You may, however, engage a Lawson Service Consultant, for a fee, for assistance if necessary.

---

Midwest Lawson User Group Member Examples
MWLUG Examples	This .zip file contains examples provided by various members of the Midwest Lawson User Group that show how they make use of the capabilities of the Add-ins.  (File size:  1.6 MB)	MWLUG Examples
Upload Wizard Formatted Worksheets (last updated June 1, 2009)
Lawson Form ID	Brief Description	Link
AC10.1	Activity	AC10.1
AC20.1	Activity - Life Only Budget	AC20.1
AC20.3	Activity - Period Budget	AC20.3
AC21.1	Live Only Budget Change Order	AC21.1
AC41.1	Activity Resource Time Entry	AC41.1
AM05.1	Accounting Group - Default Loss Account	AM05.1
AM20.3	Asset Items - Serial Number	AM20.3
AM20.4	Books - Adjustment Date	AM20.4
AM20.5	Asset Journal Entries	AM20.5
AM30.1	Transfers	AM30.1
AM99.1	Transaction Balance Update	AM99.1
AP16.1	Vendor Bank	AP16.1
AP16.1	Vendor and Vendor Bank (includes AP10.1)	AP16.1
AP20.2	Taxed Invoice with User Field from Sub-Form AP22.4	AP20.2
AP30.1	Invoice Maintenance with User Field from Sub-Form AP30.5	AP30.1
AP30.3	Payment Schedule Adjustment - Provided by Linda Carlton, Walking-Stick Consulting Group	AP30.3
AP45.1	Reportable Income Adjustment	AP45.1
AP52.1	Invoice Interface upload with AP52.3 Distribution Interface	AP52.1
AP52.9	Invoice Conversion Comments	AP52.9
AR10.1	Customer	AR10.1
AR12.1	National Account	AR12.1
AR12.2	National Account Speed Entry	AR12.2
AR80.2	Transaction Application Reversal	AR80.2
AR97.1	Interface Transaction - Lawson 8	AR97.1
AR97.1	Interface Transaction - Lawson 9	AR97.1
BN18.1	Benefit Options Amounts and Benefit Options Rates from BN19.1	BN18.1
BN32.1	Employee Benefit Changes	BN32.1
BN47.1	Beneficiaries - Provided by Charlene DeVoe, Lawson Software	BN47.1
BR53.1	Product Deferred Revenue Schedule	BR53.1
BN72.1	Retiree Benefit Entry - Add	BN72.1
BN72.1	Retiree Benefit Entry - Change	BN72.1
CB20.1	Bank Transaction Entry	CB20.1
CB20.1	Bank Transaction Entry - Release - Lawson 8	CB20.1
CB80.1	Bank Transaction Adjustment	CB80.1
ED49.1	E-Procurement User Attributes	ED49.1
FB20.1	Budget Upload	FB20.1
GL00.6	Move Detail Account	GL00.6
GL10.1	Company	GL10.1
GL16.4	Detail Account Values by Attribute	GL16.4
GL20.1	Accounting Units, Accounts	GL20.1
GL20.2	Posting Accounts	GL20.2
GL20.2	Posting Accounts - Activity Setup	GL20.2
GL20.7	General Ledger Attributes - Provided by Linda Carlton, Walking-Stick Consulting Group	GL20.7
GL40.1	GL Journal Entry with Journal Header GL40.2	GL40.1
GL60.1	Chart Interface Maintenance	GL60.1
GL61.1	Accounting Unit Interface Maintenance	GL61.1
GL65.1	Transaction Interface Maintenance	GL65.1
GL90.4	Reconcile Transactions	GL90.4
HR06.1	Job Code	HR06.1
HR06.1	Job Code - Change	HR06.1
HR10.1	Data Item Attributes - Address	HR10.1
HR11.1	Employee Benefit Dates	HR11.1
HR11.1	Employee Pay Rates	HR11.1
HR11.1	Employee User Fields (See next section below for instructions and worksheet)
HR13.2	Employee Dependent Benefits	HR13.2
HR13.4	Retiree Dependent Benefits	HR13.4
HR15.1	Applicant User Fields - 10 User Fields or Less	HR15.1
HR15.1	Applicant User Fields - More than 10 User Fields	HR15.1
HR15.2	Alphanumeric User Fields - Position - 10 User Fields or Less	HR15.2
HR15.2	Alphanumeric User Fields - Position - More than 10 User Fields	HR15.2
HR20.1	Employee Additional Contact Numbers	HR20.1
HR54.1	Employee History Correction - Adding	HR54.1
HR54.1	Employee History Correction - Change and Delete	HR54.1
HR55.1	Employee Group Definition	HR55.1
IC15.2	Bins	IC15.2
IC81.1	Cart / Par Location	IC81.1
IC82.1	Par Location Item Mass Change	IC82.1
LP70.2	Manual Transactions by Plan Structure – Provided by Charlene DeVoe, Senior Lawson Business Consultant	LP70.2
LP88.1	Length of Service Hours	LP88.1
MA43.6	Service Agreement Detail	MA43.6
MA43.7	GL Distribution	MA43.7
MA54.3	Invoice Line Detail	MA54.3
PA04.5	Alpha Field Values - Change / Delete	PA04.5
PA16.1	Company Property – Add	PA16.1
PA16.1	Company Property - Change	PA16.1
PA22.1	Certifications	PA22.1
PA22.1	Certifications – Deleting	PA22.1
PA26.1	Review – Initial	PA26.1
PA31.1	Applicant	PA31.1
PA49.1	Employee Tests	PA49.1
PA49.3	Applicant Tests	PA49.3
PA50.1	Personnel Action Setup	PA50.1
PA52.1	Individual Action - Employee Change - Lawson 9	PA52.1
PA52.1	Individual Action - Job Code - Lawson 9	PA52.1
PA52.1	Individual Action - Pay Change	PA52.1
PA52.1	Individual Action - Position Change - Lawson 9 - Provided by Sheila Romane, Providence Health and Services