Microsoft Addins for Lawson

1
Microsoft Add-ins for Lawson
Microsoft Add-ins for Lawson
2
Microsoft Add-ins for Lawson
Microsoft Add-ins for Lawson
Or . . . wow management by getting more work done
in the same amount of time
3

• DG traditionally opens 500-700 new stores a year.

4

• DG traditionally opens 500-700 new stores a year.

• Every new store has to be added to GL20, GL08,
  AM08, and HR02.

5

• DG traditionally opens 500-700 new stores a year.

• Every new store has to be added to GL20, GL08,
  AM08, and HR02.

• Approximately 20 total fields to fill out for
  each new store

6

• DG traditionally opens 500-700 new stores a year.

• Every new store has to be added to GL20, GL08,
  AM08, and HR02.

• Approximately 20 total fields to fill out for
  each new store

• Used a combination of Excel formulas, a basic
  macro, and MAI Upload Wizard to significantly
  increase efficiency and reduce keying errors

7
-----Original Message-----From Liz Parker
Sent Thursday, December 01, 2005 403 PMTo
Annetta Miller Barbara Smith Carla Buher
Charles Roberts Christi Vincent Christie
Delozier Darryl Schoonover David Vaughan Diane
Kittrell Doug Druen Elaine Taylor Emily
Snyder Gabriel Pratt Gary Bishop Gary Hudson
Glenn Woodson Jennifer Turner Jenny Shoemaker
Jon Rogers Keesha Grady Laurie Wells Lawson
Linda Medley Lois Williams Mark Smith Martha
Carter Michele Oakes Mike Smith Perry Brawner
Real Estate Field Reps. Rose Shinkle Russ
Worsham Sheila Scull Sherry Harbin Sid
Aultman Sue _at_ Dualite Tami Crosley Trent
NapierSubject New Store Update
10424  Nashville TN     (Hwy 79) 10425  Morganto
wn WV (275 West Main Street) 10426  Knoxville TN 
(995 Greensburg Pike) 10427  Columbus OH (1450
SR 28)
8
-----Original Message-----From Liz Parker
Sent Thursday, December 01, 2005 403 PMTo
Annetta Miller Barbara Smith Carla Buher
Charles Roberts Christi Vincent Christie
Delozier Darryl Schoonover David Vaughan Diane
Kittrell Doug Druen Elaine Taylor Emily
Snyder Gabriel Pratt Gary Bishop Gary Hudson
Glenn Woodson Jennifer Turner Jenny Shoemaker
Jon Rogers Keesha Grady Laurie Wells Lawson
Linda Medley Lois Williams Mark Smith Martha
Carter Michele Oakes Mike Smith Perry Brawner
Real Estate Field Reps. Rose Shinkle Russ
Worsham Sheila Scull Sherry Harbin Sid
Aultman Sue _at_ Dualite Tami Crosley Trent
NapierSubject New Store Update
10424  Nashville TN     (Hwy 79) 10425  Morganto
wn WV (275 West Main Street) 10426  Knoxville TN 
(995 Greensburg Pike) 10427  Columbus OH (1450
SR 28)
9
(No Transcript)
10
(No Transcript)
11
(No Transcript)
12
(No Transcript)
13
Do NOT close the Upload Wizard window!
14
(No Transcript)
15
(No Transcript)
16
(No Transcript)
17
(No Transcript)
18
(No Transcript)
19
Query Wizard
20
Query Wizard

• Use Application option only when you cant use
  the Database Tables option

21
Query Wizard

• Use Application option only when you cant use
  the Database Tables option

• Good way to get data from custom tables that you
  may not be able to get any other way

22
Query Wizard

• Use Application option only when you cant use
  the Database Tables option

• Good way to get data from custom tables that you
  may not be able to get any other way

• Take advantage of built-in options to subtotal
  and sort

23
Query Wizard

• Use Application option only when you cant use
  the Database Tables option

• Good way to get data from custom tables that you
  may not be able to get any other way

• Take advantage of built-in options to subtotal
  and sort

• Use to duplicate basic Lawson reports (GL200,
  GL220, HR202, etc.) especially if the end-result
  is to get those reports into Excel

24
Different terminology, Different security
25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
(No Transcript)
29
Questions?