Forum: Lawson Business Intelligence/Reporting/Crystal

To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
137 Subscribed to this forum
Page 1 of 3412345 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Crystal Labor Utiilization Report to publish in LBI    

Started By  Jan
This is a general information question on labor utilization reporting. I'm converting an existing custom Lawson back office report which shows labor utilization by company/cost center/job.  This is an old paper report that was earlier published to eBroadCast.  Some user issues were that it could not be effectively exported into an Excel spreadsheet for them to work with more effectively.  We have a few different versions of this back office report - one reports the numbers per pay period, anot...
3 54034 1
by  JanJump to last post
1/6/2010 2:05 PM

MA236 criteria.    

Started By  T.Welsh
Hello all, I am attempting to write an enhanced version of MA236 in Crystal XI. I aquired code on MA236 using 'bldsh' command but the exact criteria is still unclear to me. I can get within a few records of a perfect match to MA236, but I always end up a few records short and, in addition, get a few that are not in MA236. Has anyone attempted this in Crystal before If so, or even if not, does anyone have a clear set of criteria for MA236 Any help would be GREATLY appreciated. Thank...
5 45751 2
by  NatalieDJump to last post
10/22/2018 2:29 PM

LBI Deployment from DEV to TEST to PROD    

Started By  George Graham
Wanted to start a thread to see what different methods people are using for deploying changes in LBI from a DEV/TEST environment to PROD. There are obviously several key areas that come into play - and this is just a couple of examples to get the ball roilling: 1. Reporting data sources - are they named differently Credentials different from one to the other 2. Published back office reports - differences in product line names and/or IOS services - are you manually changing them when deploy...
16 15307 3
by  consulatantJump to last post
5/8/2023 10:05 PM

Lawson printing    

Started By  JimMNH
For the time being we have asked users to open LBI reports as PDF and then print them. We would like to setup Lawson printing of these reports but this requires the setup and maintenance of printers, drivers, and user access to printers on the server itself. Since we have a hosted Lawson environment this is not trivial. I was wondering what sorts of solutions administrators in this community have utilized for printing of LBI reports that offers the easist setup/access for their user base
9 49085 2
by  DarrenBJump to last post
1/13/2021 4:36 PM

Employee work history report    

Started By  Lance Jurgensen
Hello, New to Lawson and learning the data on the fly. HRHistory is a bit of a conundrum for me yet. I am trying to write SQL for a crystal report that will report a chronological history of an employees work history from Lawson. Similar to the PA340 Action History Listing but with more useful information :-) Basics such as Name, Employee, position, position description, FTE, supervisor, job code, status, date effective for all positions an employee has held. Would be grateful for any...
11 52804 3
by  Dave CurtisJump to last post
5/17/2019 6:33 PM

Report for LBI reports posted and publishing/Report ID    

Started By  NatalieD
I'm trying to create one report that will tell me the location of all my published reports on LBI dashboards and what the correlating publishing numbers. I have two separate reports using ERS_Reports (enter publishing to get rpt name) and ENPBATREE (location of all reports including dashboard and module name) but can't find a way to link them together. Any thoughts
7 60185 1
by  Greg MoellerJump to last post
10/12/2022 8:48 PM

CSV export options not working in 10.6    

Started By  Joan Herzfeldt
Has anyone else had this happen after upgrading to 10.6 (LBI/RAS) In crystal reports you can define the export options under File->Export->Report Export Options. You can tell it to use a pipe (|) as the separator, whether or not to put commas around the data, and how to export page/group header sections. LBI in the Schedule under Bursting and Distribution you can set the output type to CSV and then choose where it outputs. Previously it would use the export options that were saved with th...
0 4476 1
10/2/2018 3:31 PM

INFOR BI Issue    

Started By  vip1982
Hello Everyone, I would appreciate your support into the issue below, INFOR till now didnt solve it for us. We have installed the following: 1) Infor Business Vault Enterprise Edition 11.3.2 2) Infor BI OLAP Server (64 bit) 11.0.0.365 3) Infor LN Analytics Foundation 10.5.2 We are using Infor LN FP9. We have 2 companies: 222 and 333. Company 222 has common Master data in it which is shared with company 333. We have published all the data referring the document 'Infor_LN_I...
0 4223 2
10/22/2018 6:07 AM

PO20 inventory items & MMDIST    

Started By  NatalieD
Hello All - Wondering if any of you have and experience pulling the accounting information for PO20 lines for inventory items. We have always used MMDIST - as referenced on the PO20 lines MMD-ACCOUNT, etc. Recently realized that some items in our custom query were not pulling. In chat with Infor, they stated that all PO lines account and accounting unit fields referencing MMD on the PO20 screen will be in MMDIST except for inventory items. They referenced IC04 for the IC12 to get the correct ...
2 44359 2
by  Kat VJump to last post
12/14/2020 4:34 PM

PO31 comments table    

Started By  NatalieD
Anyone know what table houses the comments made on PO31 I know L_HPCR is for PO20 - need to query PO31 comments.
1 44566 1
by  NatalieDJump to last post
2/21/2019 5:49 PM

Adding more users to the sync    

Started By  Greg Moeller
I remember a LONG time ago, where we ran into a limit on how many users we could sync to LBI from LSF. I think we've hit that limit again, and was wondering if anyone here remembered where to change it at Any help would be appreciated! TIA, -Greg
3 44430 1
by  Greg MoellerJump to last post
3/20/2019 5:25 PM

Preserve formatting upon LBI export    

Started By  thummel1
We would like to be able to export existing LBI reports, (or set them to open directly as Excel (.xlsx)) so that the columns are sized according to the data in each column. The purpose of this is so that the end user does not have to spend the extra time re-sizing the columns to see all the data in each column of the Excel spreadsheet Is there a way to do this if the report is coming from Crystal I have tried changing some settings in the Export options within the Crystal report, which works...
2 42416 2
by  JonAJump to last post
7/10/2019 6:48 PM

Adding PO100 exception message to crytal report query    

Started By  katiepdx
I want to include the Reason for Exception in one of my Crystal report. This is the exception message from PO100 Error report. Any one know if this information stay somewhere in any of Lawson tables Thanks,
0 3774 1
7/17/2019 10:26 PM

MN Wage Theft Reporting Solutions    

Started By  thummel1
I am wondering what other Minnesota organizations have implemented as a reporting solution for the new MN Wage Theft Reporting laws that went into effective on 7/1/2019 Has anyone heard if Infor is working on a reporting solution All responses are welcome.
1 36568 1
by  John HenleyJump to last post
7/23/2019 5:46 PM

Querying a business class    

Started By  Casy
We pull data from the SQL database for our Landmark environment. There is a field that we were unable to locate a table for and according to support, this field is only located in the audit log. The instructions provided on how to query the audit log are convoluted at best. Is anyone aware of a table that houses the below: Business Class: Employee Form Name: Terminate BusFormAttribute Name: Employee_reason_code Any idea if it truly does ONLY exist in the audit log We are on V10 Lan...
0 3788 0
8/12/2019 7:27 PM

LBI 10.6 Sorting by Instance Name    

Started By  dcaiani
We recently upgraded to LBI 10.6 from 10.4. In each version up until 10.6 you could sort reports via the Instance Name, now in 10.6 you cannot. So we publish about 15 RW100 reports each month and keep the historical instances on LBI for 24 months. Each month the instance name is renamed in this format 'fiscal year period number actual month & year' (for example FY19 Period 04 January 2019). That way we could sort descending by instance number and it keeps the most current version on top ...
1 39877 0
by  Greg DeyJump to last post
11/12/2019 11:49 PM

Email Job Reports    

Started By  JonA
Looking for a way to auto-email the report output for a recurring job. With much of our staff working from home they can't see the EDI PO acknowledgements that print off 3 times a day. Is there a way I can capture that report as attachment in an email and send it to all buyers
3 41127 0
by  Ragu RaghavanJump to last post
3/25/2020 6:13 PM

Crystal 2011 Displaying Duplicate Details Liines for Period 2 of 2020 - Leap year    

Started By  cpaine216
I am not sure why this happening. We query the oracle data manually and do not get duplicate data. The same report executes fine for 1/2020, 3/2020, and any other months in 2020 but when we run for february we get double lines on the detail line. I have been googling leap year issues or issues with crystal reports 2011 and 2/2020 but cannot come up with anything - has anyone experienced this behavior
1 39119 0
by  RajashanmugamJump to last post
6/29/2020 9:13 PM

Disk space used by LawsonDocuments    

Started By  Greg Moeller
What are others doing for the ever-increasing disk space used by the LawsonDocuments and Archive folders I'd be interested in hearing all different opinions and comments.
1 51783 1
by  Greg MoellerJump to last post
9/23/2021 5:15 PM

File links from Dashboards    

Started By  Greg Moeller
What is the secret to getting links like the following to open up with Edge and/or InforOS. FILE:///P:/GHS/Lawson 10 - Upgrade/Team Areas/Accounts Payable/Lawson 10 procedures/AP EDI Scripts Pretty sure they were working with IE. Do I have to go through and replace all blanks with 20 and such
1 23509 1
by  Greg MoellerJump to last post
8/15/2022 7:38 PM

Lawson Table Relationship Question    

Started By  DataCarniv0r
Hello, I'm new to Lawson data. I have been provided 5 Lawson tables and only 5 tables in a data warehouse to report from. I'm hoping to get help understanding how to link them including which fields to link on, any composite joins, etc. I found some ERD's online, but couldn't find one that would fully visualize what I'm trying to do. The tables I need to link for reporting include: APINVOICE APDISTRIB APPAYMENTS APVENMAST TERMS Help appreciated. Thank you! Trevor
2 17938 1
by  DataCarniv0rJump to last post
9/20/2022 7:06 PM

Anyone using IBI to connect to .csv    

Started By  Greg Moeller
Is there anyone out there that's using IBI to connect to a .csv file as a datasource How do I set that up
0 2879 1
9/23/2022 5:35 PM

Exporting in MS Word format    

Started By  TBonney
Does anybody know if there is a way to force LBI to save exported documents in either .doc or .docx format instead of .rtf format when choosing Microsoft Word (editable) as the export format option When exporting the documents, even though choosing MS Word a the export format, the file type that it saves the file as is actually .RTF instead of either .doc or preferably .docx. We have been asked to use .doc/.docx because the documents saved in .rtf file format take up so much more space than ...
0 2724 1
10/3/2022 4:58 PM

Report Not bursting    

Started By  Greg Moeller
We've got a report that we can get to burst in our LBI Test environment, but not in our LBI Production environment. It's the SAME report. We've compared all of the setups including the backend data-sources. They seem to be identical. We're running the same version of LBI in Test and Prod: 10-6-27-0-400 The report in Prod runs everyday... just returns everything in a .pdf attachment vs just the stuff that the users are concerned with in a .pdf attachment. We just can't seem to get...
1 2715 1
by  Keith AnetsbergerJump to last post
2/1/2024 5:09 PM

Domain Name Change    

Started By  Greg Moeller
Our domain name needs to change and was hoping I could get some advice on how to EXPORT the LBI delivery devices. There's an Import option there, but no export.
1 1542 1
by  Greg MoellerJump to last post
3/5/2024 9:33 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 1 of 3412345 > >>


RSS Feed Available

Group: Performance Management

Forums
Topics
Replies
Subscribers
Last Post
189 635 14 RE: SQL Help by  Greg Moeller 11/9/2023 2:49 PM