Transcript Teknikdag i Ballerup

1
Copyright © 2011 Lawson. All rights reserved.
Teknikdag i Ballerup
Jesper Lyngsø, Solution Design, Lawson Software
2
Copyright © 2011 Lawson. All rights reserved.
Agenda
 Sikkerhedsopsætning i M3
 CRS006……
 MNS410……
 LSO
 Jobscheduler
 JAVA
 System stamdata/parametre





CRS704
Crs900
Crs999
MNSxxx
Nummerserier
 Database struktur i M3
 SQL updatering med livrem og seler
 MI Tester og Movex Data Import
 Smart DataTools
 Svar på dagens spørgsmål
3
Copyright © 2011 Lawson. All rights reserved.
Lawson Smart Reports
Name
Ole Rasmussen
Global Director Product Management
[email protected]
Background
 Key pain points with our current M3 Reports
Existing M3 reports are unattractive and inflexible.
Unsure what reports are available as standard.
Content of M3 reports can’t be easily exported or distributed.
Easier to work with, extend and modify
Simpler to use interactively in LSO
 We have a strong reporting platform within LBI
 We have a strong User Platform in Smart Office
Lawson Smart Reports
Lawson Smart Reports (LSR)
 LSR provides a flexible framework to generate, view, manage, extend and
distribute M3 reports directly in Smart Office and a Web browser.
Business benefits
 Lower implementation costs
 Over 600 beautifully formatted reports as standard
 Flexible delivery of reports
 Preview of reports
 Easy export to Excel, Word, PDF, etc
 Customize reports without programming
 Add fields to reports via APIs
 Modify layouts
 Report catalog and archive
 Report browsing and searching
 Access to historic reports
New format
Old format
Lawson ViewPoint
Ole Rasmussen
Global Director Product Management
[email protected]
New Business Intelligence Application –
Lawson ViewPoint
 Design & Deploy Analytical
Applications
 Tool for designing highly interactive,
visually rich dashboards
 Supports 18 langauges
 Deploy Web or Lawson Smart Office
 Mashups in Lawson Smart Office
 Leverages Lawson Business Intelligence
 Foundation for packaged S3 industry
analytics
 Designed for Users
 User can personalize the dashboards
through filters, conditional styling, user
calculations and visualization choices
 Self Service
 Collaborative
 Comments, attachments, discussions
provide qualitative and subjective context
around business performance
Lawson ViewPoint– View with Collaboration
Interactive
chart
Filters
Interactive grid
(pivot table)
Related
Links to other
relevant information
Discussion
thread
collaboration
Lawson Process Automation for M3
Lawson Process Designer (LPD)
 Approve customer
12
Copyright © 2011 Lawson. All rights reserved.
1. Model
Lawson Process Automation (LPA)
 Enterprise class Business Process
Management (BPM) application
 Automate, control, and measure business
processes that span:
 Systems to systems
 People to systems
 People to people
 Multi-step, multi-level, human review and
approval workflow
 Start flows on any event in M3 using
EventHub
 Integrated to LSO
 Reduce or eliminate need for Lawson
application modifications
13
Copyright © 2011 Lawson. All rights reserved.
Event trigger og MeC’en
Komma
Speditør
Booking
CMR
Hent info
XML
Kunde
M3
Opdatering
XML
MeC
Translatør
XML
XML
Int M3
Trigger:
DO receive
PO receive
DeliveryIssued
ReleasePick
ShipClosed
ShipIssued
ShipInv
Etc…
14
Copyright © 2011 Lawson. All rights reserved.
ASN
SSCC
Procesflow
Flad fil
Skat
Told
Event Hub with Event Analytics
LES
Subscriber
MEC
M3
Publisher
Event Hub
Subscriber
LPA
Subscriber
Subscriber
Event
Analytics
Publisher
Grid
15
Copyright © 2011 Lawson. All rights reserved.
UPP News
 LSO 10.0.1 – New skin
 Improved support for virtualized environments
 Login control to LSO
 Spell check in text blocks
 M3 Net Extensions Manager
 LES 10.0.0 – Faster
 Performance enhancements
 Search Improvements
 LIM
 DAF 10.0.0 – Mobile access
 Mashup Designer 10.0.1 – WYSIWYG
 Custom List Design
 Personalizations on/off
 New Controls
 WebServices
16
Copyright © 2011 Infor. All rights reserved.
Agenda
 Sikkerhedsopsætning i M3
 CRS006……
 MNS410……
 LSO
 Jobscheduler
 JAVA
 System stamdata/parametre





CRS704
Crs900
Crs999
MNSxxx
Nummerserier
 Database struktur i M3
 SQL updatering med livrem og seler
 MI Tester og Movex Data Import
 Smart DataTools
17
Copyright © 2011 Lawson. All rights reserved.
Permissions – Basic
• Permissions are generated for a program and user
Permissions Setup (SES400)
Role X
Permissions (SES401)
User 3
User 2
User 1
Function X
 Create
 Change
Copy
Delete
Display
Program P1
 Create
 Change
Copy
Delete
Display
Functions
(MNS110)
Function X
 Program P1
Each function ‘holds’
the program to be
called when the
functions is activated.
Permissions – Inheritance
• Individual programs that will inherit permissions setup from a function can be defined in MMS112.
Permission Setup (SES400)
Permissions (SES401)
Role X
User 3
User 2
Program 2 and 3
inherits the setup
User 1
Function X
 Create
 Change
Copy
Delete
Display
Functions
Programs per Function
(MNS110)
(MNS112)
Function X
Function X
 Program P1
 Program P2
 Program P3
Those programs inherit
the permissions setup
from the function
Program P1
 Create
 Change
Copy
Delete
Display
Program P2
 Create
 Change
Copy
Delete
Display
MNS112 is enabled per function
via option 13 in MNS110
Program P3
 Create
 Change
Copy
Delete
Display
Permissions – Direct program setup
• Permissions can be applied directly to programs with panels for user interactions. This only applies if the
program does not exist as a function.
Permissions (SES401)
Permissions Setup (SES400)
Role X
Normal setup
(per Function)
Direct program setup.
User 3
User 2
User 1
Function X
 Create
 Change
Copy
Delete
Display
Program 4
Create
Change
Copy
 Delete
Display
Functions
Programs per Function
(MNS110)
(MNS112)
Function X
Function X
 Program
P1
 Program P2
Program P1
 Create
 Change
Copy
Delete
Display
Program P2
 Create
 Change
Copy
Delete
Display
Program P4
Create
Change
Copy
 Delete
Display
Permissions – Least restrictive principle
• Least restrictive principle applies if a user is connected to several roles.
Permissions (SES401)
Permissions Setup (SES400)
Sales clerk
Function X
 Create
 Change
Copy
Delete
Display
Buyer
Function X
Create
Change
Copy
Delete
 Display
John Smith is, at
the same time,
connected to the
roles ‘Sales
clerk’ and
‘Buyer’
John Smith
Program P1
 Create
 Change
Copy
Delete
 Display
Program P2
 Create
 Change
Copy
Delete
 Display
Program P3
 Create
 Change
Copy
Delete
 Display
MNS150 - Users (persons)
(company independent)
Set up workflow
MNS110 - Functions
(company independent)
MNS405 - Roles
(company independent)
= New in V13
CAUTCHK – Authority check
Permissions
per user and program
CMNPUS
SEMNGPER
Manage permissions
SES900
Auto-job
MNS410 – Roles per user
(company independent)
SES400 – Permissions setup
Permissions trigger
MSE900
Auto update
Permissions – Set up workflow
System parameter setting to activate Permission’s
0 = Permission’s are not activated => SES003 is used by the authority check program
1 = Permission’s are activated => SES400 is used by the authority check program
24
Copyright © 2011 Lawson. All rights reserved.
LSO
25
Copyright © 2011 Lawson. All rights reserved.
Agenda
 Sikkerhedsopsætning i M3
 CRS006……
 MNS410……
 LSO
 Jobscheduler
 JAVA
 System stamdata/parametre





CRS704
Crs900
Crs999
MNSxxx
Nummerserier
 Database struktur i M3
 SQL updatering med livrem og seler
 MI Tester og Movex Data Import
 Smart DataTools
26
Copyright © 2011 Lawson. All rights reserved.
Job Scheduler
 SHS030 Jobplanlægning
 SHS010 Schedulerede Job
27
Copyright © 2011 Lawson. All rights reserved.
SQLstatement til SHS010
 Skærmbillede selektering ved schedulering i Java
select * from mvxemad.cshlin where slcono=600 and slfnid='OIS180'
order by slbjno
28
Copyright © 2011 Lawson. All rights reserved.
Agenda
 Sikkerhedsopsætning i M3
 CRS006……
 MNS410……
 LSO
 Jobscheduler
 JAVA
 System stamdata/parametre





CRS704
Crs900
Crs999
MNSxxx
Nummerserier
 Database struktur i M3
 SQL updatering med livrem og seler
 MI Tester og Movex Data Import
 Smart DataTools
29
Copyright © 2011 Lawson. All rights reserved.
Cross- og hjælpeprogrammer i M3
30
Copyright © 2011 Lawson. All rights reserved.
Nummerserier
 Nummerserier
CRS165 Genrel og global
MFS165 Fakturanummerserie (division)
31
Copyright © 2011 Lawson. All rights reserved.
Agenda
 Sikkerhedsopsætning i M3
 CRS006……
 MNS410……
 LSO
 Jobscheduler
 JAVA
 System stamdata/parametre





CRS704
Crs900
Crs999
MNSxxx
Nummerserier
 Database struktur i M3
 SQL updatering med livrem og seler
 MI Tester og Movex Data Import
 Smart DataTools
32
Copyright © 2011 Lawson. All rights reserved.
Database struktur i M3
 Relations DB (”ingen” redundante data)
 Filnavne
Logiske filer
XXXXXX
XXXXXXYY
 Logik i filnavne
OOHEAD
OOLINE
 Feltnavne
Order Header
Order Line
XXYYYY
 Transaktionsdata adskilt fra stamdata
MMS002 er en smutter.
 MetaDataPublisher
33
Copyright © 2011 Lawson. All rights reserved.
SQL med livrem og seler
 Select til tjek
 select oborno, obponr, obitno, oborqt, oborqa, obrnqt, obrnqa, obalqt, obalqa, obplqt, obplqa, obdlqt, obdlqa, obivqt,
obivqa, oborst from mvxddta01.ooline where obcono=1 and oborno='0044139951' and obponr=10
 Allokeringsfelterne
 update mvxddta01.ooline set obrnqt=0, obrnqa=0, obalqt=0, obalqa=0 where obcono=1 and oborno='0043606000'
and obponr=70
 Plukkelistefelterne
 update mvxddta01.ooline set obrnqt=0, obrnqa=0, obplqt=0, obplqa=0 where obcono=1 and oborno='0044139951'
and obponr=10
 Leveringsfelterne
 update mvxddta01.ooline set obrnqt=0, obrnqa=0, obdlqt=0, obdlqa=0 where obcono=1 and oborno='0043219647'
and obponr=100
 Update af header
 update mvxddta01.oohead set oahocd=1, OAJNA='LAWJL', OAJNU=1 where oacono=1 and oaorno='0044139951‘
 Genberegning af ordre
 Åbn OIS100
34
Copyright © 2011 Lawson. All rights reserved.
Agenda
 Sikkerhedsopsætning i M3
 CRS006……
 MNS410……
 LSO
 Jobscheduler
 JAVA
 System stamdata/parametre





CRS704
Crs900
Crs999
MNSxxx
Nummerserier
 Database struktur i M3
 SQL updatering med livrem og seler
 MI Tester og Movex Data Import
 Smart DataTools
35
Copyright © 2011 Lawson. All rights reserved.
MI Tester
36
Copyright © 2011 Lawson. All rights reserved.
Movex Data Import
37
Copyright © 2011 Lawson. All rights reserved.
Find felt til MI program
SQLstatement til at finde input eller output felter
select flminm, fltrnm, fltrtp, flflnm, flflds, flfrpo, fltopo,
flleng, fltype, flmand from mvxddta90.cmifld where
flflnm='ALMT'and fltrtp='O‘ order by flminm, flfrpo
38
Copyright © 2011 Lawson. All rights reserved.
Agenda
 Sikkerhedsopsætning i M3
 CRS006……
 MNS410……
 LSO
 Jobscheduler
 JAVA
 System stamdata/parametre





CRS704
Crs900
Crs999
MNSxxx
Nummerserier
 Database struktur i M3
 SQL updatering med livrem og seler
 MI Tester og Movex Data Import
 Smart DataTools
39
Copyright © 2011 Lawson. All rights reserved.
LWS Environment Prerequisites
Server side
7.1 Apps
LWS Server
Client side
with ”Deployed” web services
(SOAP/Http)
•Excel 2003
•MS SOAP Toolkit (Supplied)
•Converter program, downloaded
•The excel template.xls and data sheet (supplied)
(A valid M3 user account)
Lawson M3
Solution
Excel into M3 via Converter tool
Svar på dagens uafklarede spørgsmål
 Rynkeby
 Er deaktivering af ”MFORMS://xxxxxx” i LSOen mulig?
 Det er ikke muligt, bør klares med security opsætningen
 Indeksering af ex: MHS850 filerne til LES brug?
 Dette kan gøres via LCM (Life Cycle Manager)
 De ønske filer ”knyttes” til indekseringen (crawl)
 I LIM knyttes eller udvides så til ”LES Interest Center”
 Hvad bruges?:
 CRS995 Fix program til GL (General Ledger)
 AMS100 benyttes i forbindelse med arkiveringsmodulet TAM
 MTS043 Test af ”egne” MashUp Bookmarks
 Hartmann
 Opdatering af valuta på ordre hoved ”OOHEAD”?
 Ikke muligt hvis der er oprettet linier på ordren
 GLS037 records usynlige lige efter oprettelse, men bliver så pludselig synlige?
 Ingen af vores FAM konsulenter havde et svar, men måske noget med periodisering /tidszone. Men det kræver nok yderligere
analyse
 MacBaren
 Antal faneblade åbne i Lawson Smart Office?
 Det findes ingen parameter til dette i LSO opsætningen
42
Copyright © 2011 Lawson. All rights reserved.