|
|
|
|
|
|
3 Replies and 46084 Views
Crystal Labor Utiilization Report to publish in LBI 46084 3
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.&160; This is an old paper report that was earlier published to eBroadCast.&160;
Some user issues were that it could not be effectively exported into an Excel spreadsheet for them to work with more effectively.&160; We have a few different versions of this back office report - one reports the numbers per p...
|
|
|
|
3 |
46084 |
by Jan 1/6/2010 2:05 PM |
|
7 Replies and 50162 Views
Report for LBI reports posted and publishing/Report ID 50162 7
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 |
50162 |
by Greg Moeller10/12/2022 8:48 PM |
|
0 Replies and 1114 Views
Exporting in MS Word format 1114 0
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 |
1114 |
10/3/2022 4:58 PM |
|
0 Replies and 1222 Views
Anyone using IBI to connect to .csv 1222 0
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 |
1222 |
9/23/2022 5:35 PM |
|
2 Replies and 10200 Views
Lawson Table Relationship Question 10200 2
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 |
10200 |
by DataCarniv0r9/20/2022 7:06 PM |
|
1 Replies and 15596 Views
File links from Dashboards 15596 1
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 |
15596 |
by Greg Moeller8/15/2022 7:38 PM |
|
1 Replies and 43913 Views
Disk space used by LawsonDocuments 43913 1
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 |
43913 |
by Greg Moeller9/23/2021 5:15 PM |
|
9 Replies and 43324 Views
Lawson printing 43324 9
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 |
43324 |
by DarrenB1/13/2021 4:36 PM |
|
2 Replies and 36292 Views
PO20 inventory items & MMDIST 36292 2
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 |
36292 |
by Kat V12/14/2020 4:34 PM |
|
1 Replies and 32881 Views
Crystal 2011 Displaying Duplicate Details Liines for Period 2 of 2020 - Leap year 32881 1
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 |
32881 |
by Rajashanmugam6/29/2020 9:13 PM |
|
3 Replies and 34005 Views
Email Job Reports 34005 3
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 |
34005 |
by Ragu Raghavan3/25/2020 6:13 PM |
|
1 Replies and 33498 Views
LBI 10.6 Sorting by Instance Name 33498 1
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 |
33498 |
by Greg Dey11/12/2019 11:49 PM |
|
0 Replies and 2250 Views
Querying a business class 2250 0
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 |
2250 |
8/12/2019 7:27 PM |
|
1 Replies and 29413 Views
MN Wage Theft Reporting Solutions 29413 1
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 |
29413 |
by John Henley7/23/2019 5:46 PM |
|
0 Replies and 2134 Views
Adding PO100 exception message to crytal report query 2134 0
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 |
2134 |
7/17/2019 10:26 PM |
|
2 Replies and 34760 Views
Preserve formatting upon LBI export 34760 2
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 |
34760 |
by JonA7/10/2019 6:48 PM |
|
11 Replies and 44066 Views
Employee work history report 44066 11
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 |
44066 |
by Dave Curtis5/17/2019 6:33 PM |
|
3 Replies and 36466 Views
Adding more users to the sync 36466 3
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 |
36466 |
by Greg Moeller3/20/2019 5:25 PM |
|
1 Replies and 36770 Views
PO31 comments table 36770 1
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 |
36770 |
by NatalieD2/21/2019 5:49 PM |
|
5 Replies and 39377 Views
MA236 criteria. 39377 5
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 |
39377 |
by NatalieD10/22/2018 2:29 PM |
|
0 Replies and 2840 Views
INFOR BI Issue 2840 0
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 |
2840 |
10/22/2018 6:07 AM |
|
0 Replies and 2898 Views
CSV export options not working in 10.6 2898 0
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 w...
|
|
|
|
0 |
2898 |
10/2/2018 3:31 PM |
|
0 Replies and 2440 Views
Crystal Report Paramaters with Encryption 2440 0
Started by JasonP
We have an email notification that goes to users that has an embedded link with dynamic parameters such as so that https://xxx.xxxx.net:9443/efs/FSRemotefsid=RS:RS-HMC Reporting Services:1099&Dobeforeevent=false&Company=10&Vendor=48663&Invoice=1153 Is there a way to encrypt the Company , Vendor, and invoice values and have crystal accepts those.
|
|
|
|
0 |
2440 |
9/28/2018 2:56 PM |
|
0 Replies and 2642 Views
Exporting crystal report in text format? 2642 0
Started by Lance Jurgensen
Am I missing something in my system I don't seem to have an option to export a report run from LBI to Text The output to CSV is similar but it surrounds each line with quote marks. Anyone know of a way around this Thanks, -Lance LBI 10-6-17-0-339 Crystal RAS 2011
|
|
|
|
0 |
2642 |
9/12/2018 8:24 PM |
|
1 Replies and 35040 Views
Summarized Transactions - Payroll 35040 1
Started by O. Johnson
I've been able to write SQL to get from the GLTRANS Summarized Transactions back to the invoices on the AP side, but now being asked to do the same on the PR side. Anyone have any experience in getting from a GLTRANS Summarized Transaction back to the PR transactions that make up the Summarized Transaction Thanks!
|
|
|
|
1 |
35040 |
by Ragu Raghavan9/5/2018 10:53 AM |
|
4 Replies and 38082 Views
LBI and Crystal 2016, Windows 10 (UPDATED) 38082 4
Started by Kelly H
We are in the process of migrating to Windows 10. One concern is that we are all using Crystal 2008 for our LBI reports and Lawson reporting. Our tech person is concerned about Crystal 2008 and Windows 10 not working well together. is anyone using Crystal 2013 for LBI Have there been any issues As of 11/29/17- it appears we can only upgrade to Crystal 2016. Anyone have Crystal 2016 and Windows 10 working with Lawson
|
|
|
|
4 |
38082 |
by SRHarris7/19/2018 4:10 PM |
|
3 Replies and 41535 Views
List of active employees at a certain point in time. 41535 3
Started by agersh
I am looking to produce a list of all employees that had an active employee status at a specific point in time (specific date). For example, all employees that had an active employee status on 10/1/2015. Any idea of the SQL query that would produce these results
|
|
|
|
3 |
41535 |
by agersh6/11/2018 1:32 PM |
|
4 Replies and 42486 Views
Deliver LBI report to Email 42486 4
Started by thummel1
I am exploring various delivery options of LBI reports to customers. One option I am exploring is the ability to deliver a scheduled LBI report to an email delivery device. We currently have that functionality in place for Smart Notes; however, this is not an option for this particular need. I am wondering if similar functionality exists within Reporting Services If yes, are there resources to learn about configuration We are on version 10.6.13.0.326 for reporting services. Thank you!
|
|
|
|
4 |
42486 |
by Dave Curtis5/30/2018 7:00 PM |
|
3 Replies and 37692 Views
Lost Data Settings 37692 3
Started by Katy Prince
Old reports have these data settings: Datasource in Report: Override Datasource Default User ID Default Password Confirm Password When Viewing Report: But when I try to publish a new report all of the above is missing... Anyone else ever run into this See attached.
|
|
|
|
3 |
37692 |
by Greg Moeller4/16/2018 5:05 PM |
|
3 Replies and 47051 Views
Moving Lawson Documents 47051 3
Started by Donna
I write reports and publish them but have never set up LBI. We have new administrators and are not sure how to point LBI from one location to another to find the Lawson Documents folder. We have done all the back up and copying for the folder but are looking for some guidance on the LBI technical side. Thank you. Donna Shelton
|
|
|
|
3 |
47051 |
by Donna4/12/2018 7:05 PM |
|
2 Replies and 35843 Views
QLIK 35843 2
Started by Donna
We are in the process of implementing QLIK. We currently use LBI and Crystal Reports but will be moving some of our reporting over to QLIK. QLIK will be used at our hospital for some EPIC, Clarity, Lawson and other hospital subsystems.reporting. If anyone else especially in healthcare is using QLIK or in the process of implementing QLIK we would like to make contact with them and maybe eventually create a Lawson QLIK forum.
|
|
|
|
2 |
35843 |
by Nabil3/20/2018 2:55 PM |
|
1 Replies and 37200 Views
Convert PR261 to easy to read format 37200 1
Started by thummel1
Has anyone had the need to replicate the PR261 report but in LBI, with the goal of being to be able to read it in a simple format, export to Excel, and run any necessary calculations against the fields for auditing purposes Our payroll department uses this report to ensure the taxable wages are appearing correctly, but the format is not ideal for auditing purposes. Payroll has requested a format that would display one row per employee, with each deduction code appearing in it's own column with ...
|
|
|
|
1 |
37200 |
by Jason Beard3/9/2018 8:22 PM |
|
1 Replies and 38201 Views
Upgrade for LBI v10 - Infor BI, BIRST or other 38201 1
Started by NatalieD
October 2016, we upgraded to Lawson v10 and LBI v10. We report heavily on operational/detail level data throughout our Supply Chain department. We primarily use Crystal Report files posted to LBI to facilitate data dumps and summary information to our end users (data to review and update inventory reorder theory, item conversions, etc). We regularly use Lawson Add-ins for large record changes so our field demand for reporting is quite large. For years we have struggled with record limitations in...
|
|
|
|
1 |
38201 |
by Nabil2/7/2018 8:15 PM |
|
2 Replies and 27289 Views
Lawson Smart Reports - LSR Designer 27289 2
Started by dkester
I'm new to LSR and LSR Designer. We're just starting to test some of our reports using LSF Designer and unable to get a template created for PR260. I've been using the user guide, LSRDUG_10.0.3.0_W_01 to configure the designer but still unable to link the report to a template. The default, CU201 that INFOR provided looks pretty straight forward, but I'm unable to get another template setup. My goal is to create a barebones report for PR260 and apply our company logo, nothing fancy or complic...
|
|
|
|
2 |
27289 |
by dkester1/10/2018 8:55 PM |
|
3 Replies and 42028 Views
LBI vs. Infor Birst 42028 3
Started by Nabil
Infor is promoting Birst as the LBI replacement. They said (in a Demo) that Infor Reporting is not the future direction and LBI is to be replaced by Birst. I'm wondering if any of you are considering this move We are just short of 200 Crystal Reports and some 30-40 Smartnotes. All of these will need to converted to Birst reports or Alerts. Thanks, Nabil
|
|
|
|
3 |
42028 |
by Jeremy1/2/2018 4:57 PM |
|
0 Replies and 2286 Views
Output to CSV does not retain 2286 0
Started by thummel1
Since our upgrade to v10, we have several scheduled reports in LBI that are not retaining their output type settings. One specific report is set to save in CSV format in the Report Options, with the default Output Type saved as Comma Separate Values (CSV) and only Comma Separated Value is checked in 'Allowed Output types'. Yet when the report runs on the schedule, the scheduled instances are generating in RPT format. I've tried deleting the schedule and adding back in, deleting the report an...
|
|
|
|
0 |
2286 |
12/1/2017 1:36 PM |
|
10 Replies and 42933 Views
LBI Schedule Disappear Randomly 42933 10
Started by Dave Curtis
Over a year ago we started having this random issue with LBI report schedules randomly disappearing. We have tried to find a reason why and tie it to some event but have not been able to. What is additionally head scratching is that not ALL of the schedule is gone. If I look in the table that has the schedule triggers (ejs_triggers: This is the info on the second part of the schedule with delivery info etc.) I will find the schedule but the actual schedule in ejs_cron_triggers is gone. So ...
|
|
|
|
10 |
42933 |
by Joan Herzfeldt11/22/2017 2:15 PM |
|
8 Replies and 35324 Views
Report will not burst 35324 8
Started by Donna
This is very strange. I have another version of the same report with the same bursting rights structure that runs successfully but the newly published report runs if I remove bursting rights but displays as a blank repot once bursting rights are added. We even republished the report with a new report ID but it will not burst or even display any data once the bursting is added.
|
|
|
|
8 |
35324 |
by Donna10/11/2017 9:15 PM |
|
0 Replies and 2928 Views
Survey Functionality 2928 0
Started by thummel1
I am wondering if Lawson V10 has the ability to create a survey for employees in Employee Self Service
|
|
|
|
0 |
2928 |
9/5/2017 6:09 PM |
|
3 Replies and 43075 Views
Remove MNR PO Lines from Report 43075 3
Started by brupp
Hello - I have a Crystal Report of open PO lines where PO qty < Received qty & have been asked to only include those lines without an invoice matched to the line. I found POLINE.MATCHED_NO_REC but do not understand the numeric values & they're not listed in the guru data dictionary. Does anyone know the values & their meaning, & will setting this field achieve the desired result in my Crystal Report Thanks.
|
|
|
|
3 |
43075 |
by Kat V9/5/2017 12:18 PM |
|
0 Replies and 2803 Views
Infor Enhancement to APAUDIT 2803 0
Started by NatalieD
Currently, when we audit changes to our AP10.1 and AP10.2 address changes using APAUDIT, the table also shows address changes to PO10. Auditing AP10.1 and AP10.2 address changes is required by our internal audit department. We utilize field ID's 5, 6, 7, 8, 9, 10, 11, 12, 18, 19, 20, 21, 22, and 23. We are showing false audit findings due to the merged data in APAUDIT. Please reference Infor incident 10826136 for troubleshooting with Infor tech and their test findings. Currently no way...
|
|
|
|
0 |
2803 |
8/21/2017 10:51 AM |
|
15 Replies and 35892 Views
Guru Data Dictionary 35892 15
Started by FireGeek21
Does anyone know information about accessing the data dictionaries on here Going to Tech -> Data Dictionary -> clicking on 9.0 for tables, getting an error - 404 - File or directory not found. They have been helpful for us in the past. Thanks!
|
|
|
|
15 |
35892 |
by John Henley8/3/2017 6:29 PM |
|
1 Replies and 38474 Views
UTC Conversions on Date Range Functions 38474 1
Started by Joan Herzfeldt
I'm accessing a database that has dates stored in UTC so even though 'an action was taken' on 6/30/2017 20:12:00 Central time (where I'm located) , due to the conversion to UTC this record does not show up on the report if I use ' in the LastFullMonth' because it converts to 7/1/2017 01:12:00 UTC. I know how to replace LastFullMonth with two separate date parameters. What I want to know is... Is there a way to convert any of the 'Date Range Functions' (ie: LastFullMonth) to take the time zone...
|
|
|
|
1 |
38474 |
by John Henley8/3/2017 2:29 PM |
|
7 Replies and 34161 Views
LBI On Demand-passing in authuser value 34161 7
Started by petec
We are using the LBI RS ers/ersRequestHandler.jsp to create report bookmarks in Portal for remote EMSS users. Has anyone been able to use &SelFormula or perhaps &LawUserID to pull the authuser value (user who has logged in) For example, if user 3436 logs in, I want that valued passed as a parameter into the LBI\Crystal report so the user only sees their data. Let me know. Thanks. (need it for Portal and eventually workspace, these users won't have LSO).
|
|
|
|
7 |
34161 |
by Who Da Philly7/20/2017 12:21 PM |
|
0 Replies and 2348 Views
ReportWriter GL Income Statement 12 Mo. 2348 0
Started by Ron Soclof
How is it best to create formulas to have columns for the 11 prior months to CPAMT. I tried CPAMT-1 which just subtracts 1 from the current period total. I tried CP-1 which displays the prior month number I was trying to get the previous months totals for those prior months. Thanks
|
|
|
|
0 |
2348 |
6/27/2017 2:50 PM |
|
2 Replies and 35903 Views
LBI Server Out of Memory 35903 2
Started by thummel1
We have been experiencing a routine weekly outage with LBI. Users receive the message 'LBI Server Out of memory'. We were informed that it could be due to the volume of activity on the RAS Server, and suggested remedies included changing reports to not open in a Crystal Report viewer so that it bypasses the RAS Server. That was done on the reports that seemed most problematic yet the issue continues. Another suggestion was to rebuild more complex reports residing in Crystal in other systems ...
|
|
|
|
2 |
35903 |
by Greg Moeller5/30/2017 8:46 PM |
|
1 Replies and 43188 Views
LBI Delete Parameter Values 43188 1
Started by Katman
When updating an LBI report, I cannot delete a value in the parameters drop down list. Steps to Recreate (See attached image): Edit LBI Report Click Maintain Parameters under Data Filtering Select Parameter to update In Available Values box, check the value you want to delete. Click Delete button. Nothing happens. I am the report owner. I have also logged in using Lawson master account. I still cannot delete a value from the list. &91;img&93;/Portals/0/...
|
|
|
|
1 |
43188 |
by Katman5/30/2017 5:54 PM |
|
2 Replies and 32930 Views
Verifying LBI Maintain Rights 32930 2
Started by ALB
We are moving from on-premise to the Cloud without realizing that we were expected to maintain LBI security from that initial cut. We have some reports which are bursted. It appears that some people were partially set up. Does anyone have any SQL they use to confirm LBI Rights match
|
|
|
|
2 |
32930 |
by Joan Herzfeldt3/21/2017 12:38 PM |
|
6 Replies and 35177 Views
Framework Services Tools Dashboard 35177 6
Started by Robby
I can un-check the 'All' box, but can't save it. In our dev version which is 10.0.0.134, I can, but only if I 'play' with the IE compatibility settings. I've got a ticket in with Infor, but the development team says that it is working as designed. That's a terrible design! And what did they do between 10.0.0.134 and 10.4.0.0.190 that limited this ability. Anyway, who else is running 10.4.0.0.190 and what are you doing One of my thoughts was - perhaps there's a setting during installation th...
|
|
|
|
6 |
35177 |
by ALB3/20/2017 3:25 PM |
|
7 Replies and 39612 Views
LBI Tools Tab Reporting My Reports 39612 7
Started by Donna
We have tried creating new lists maintaining existing lists and have not been successful in allowing both of us access to all the reports. I have access to all of my reports and all reports for any prior LBI administrators including Lawson but cannot see the reports she has published to LBI. The new LBI administrator can see some of my reports and all of her reports but there are gaps. Our IT department and Lawson support can't seem to figure this out either but it causes some time consuming ...
|
|
|
|
7 |
39612 |
by lmackin3/1/2017 5:17 PM |
|
1 Replies and 39194 Views
LBI Backoffice to GL90 security 39194 1
Started by texasInstruments
Has anyone been successful in securing GL90 when used as a destination from LBI Backoffice RW100 reports drill around We need to be able to limit by accounting unit based on what rights they have in LBI when they arrive at the GL90 form from LBI. Currently, a user can type in different accounting unit numbers and inquire on GL90 to see information that they are not given in LBI rights. We have tested security rules that do limit access based on a security group value but I am thinking that w...
|
|
|
|
1 |
39194 |
by texasInstruments2/20/2017 9:17 PM |
|
0 Replies and 3086 Views
Paramertized Crystal Reports freezes 3086 0
Started by anatoli.s
Hi lawson gurus, We are using Crystal Report with parameters, and sometimes user is not able to open that report (the reports stuck at 'Please wait' before showing parameters page). ERS log shows the CrystalEngine exceptions (the sample exception text below), and I assume that could be fixed by Guest user re-configuration (details at http://www-01.ibm.com/support/docview.wssuid=swg21443725) However, I didn't find any similar options in Lawson Reporting Services Administration. Could you a...
|
|
|
|
0 |
3086 |
2/14/2017 11:49 AM |
|
1 Replies and 32525 Views
Embed <LAW> tag 32525 1
Started by Katy Prince
I took the training on this so long ago and I can't remember how to embed the <LAW> tag in a Crystal Report so that I can burst it in LBI.
|
|
|
|
1 |
32525 |
by NatalieD2/8/2017 3:14 PM |
|
1 Replies and 41662 Views
Report 41662 1
Started by kweixel-eb
I'm not an admin, but in accounting with some database programming experience. I've been using the S3 Query Wizard, but would like to do aggregate functions on large data sets (>1million txns). Is there a free report writer that works with Lawson Or, is there another way to do this Thanks
|
|
|
|
1 |
41662 |
by dcaiani2/6/2017 2:08 PM |
|
3 Replies and 37898 Views
Item Locn usage using ICHISTORY - date range? 37898 3
Started by NatalieD
I am attempting to rewrite an existing report that calculates the usage for all items at location with SOH >0. It's using the ICHISTORY table and is YTD data only. I've been requested to make this a rolling 12 month scheduled report. The Usage field is a case formula (see below). I'm not sure how to correct to allow for the months from the year prior to the parameter year. As in, if they enter parameter year = 2016 and parameter month = 1, how can Feb-Dec 2015 be included to make the 12 month...
|
|
|
|
3 |
37898 |
by NatalieD2/3/2017 6:35 PM |
|
1 Replies and 30462 Views
Edit Report List under Maintain Reports 30462 1
Started by Donna
We are using the Maintain Reports All list because we have multiple LBI administrators who cannot see each other's reports but we need the report number that LBI assigns when you publish a report displayed in the list. We are looking for a way to add the report number to the list.
|
|
|
|
1 |
30462 |
by NatalieD2/3/2017 2:17 PM |
|
1 Replies and 42204 Views
Infor BI versus LBI versus other solutions 42204 1
Started by CMNew
Does anybody have experience using Infor BI versus Lawson BI We purchased Lawson BI but have'nt implemented it. Our rep is recommending that we switch to Infor BI instead and maintains that Lawson BI wont continue to be supported. We have another team here who thinks we should ditch the Infor solution entirely and start using Tableau instead which the company has'nt purchased yet but they have researched it and think its a preferred solution for reporting all round Any thoughts or input i...
|
|
|
|
1 |
42204 |
by Randy1/24/2017 6:10 PM |
|
0 Replies and 2375 Views
Cleanup user rights 2375 0
Started by Xin Li
We have a lot users used to be LBI users. Even though they are no longer LBI users, their user rights are still left behind in LBI. Is there any simple way to remove their user right in LBI
|
|
|
|
0 |
2375 |
1/17/2017 3:10 PM |
|
0 Replies and 2862 Views
LBI report linked to Excel file 2862 0
Started by NatalieD
Has anyone successfully linked an Excel file to a published LBI report We regularly use Crystal Reports linked to an Excel file to help pull reports for a specific set of items. We populate the Excel file with the list of items and then run the file which is linked by the field. I've been trying to publish a report to LBI that would allow our end users to populate an excel file and then run a report off LBI (avoiding the need to have Crystal Reports but giving them the flexibility to run ...
|
|
|
|
0 |
2862 |
1/16/2017 1:41 PM |
|
1 Replies and 40480 Views
Change user language in LawsonFS database 40480 1
Started by TRK
Hi forum When creating a new user in LBI, the default language is for some reason set to Danish :blink: As we are a company with locations several places in the world it would be much more beneficial if the language was English. How to either set the default language for new users to English or to update the language preference directly in the database See attachment of the setting in question in the web interface. Thanks in advance, Thomas
|
|
|
|
1 |
40480 |
by TRK12/28/2016 8:06 AM |
|
1 Replies and 34307 Views
Crystal Report does not run 34307 1
Started by ALB
There are a few Crystal reports which do not run and displays the message 'The report you requested requires further information.' It prompts for the user and password. There is only one data source, and it has been overridden with an ODBC connection used by other reports. It works for some people but not others. How can this be resolved
|
|
|
|
1 |
34307 |
by Jimmy Chiu12/23/2016 1:16 PM |
|
4 Replies and 29592 Views
Republishing reports not working LBI 10.6 29592 4
Started by Lance Jurgensen
We have a new LBI 10.6 install, data migrated from 10.4 and then upgraded. Pretty much everything is working except we can not republish reports. The screen is just a bunch of empty boxes and not all labels are visible etc. See attachment for details. Anyone seen this after an upgrade Thanks, -Lance
|
|
|
|
4 |
29592 |
by Jimmy Chiu12/23/2016 1:09 PM |
|
3 Replies and 40574 Views
Enhancement requests 9809 & 9813 - suggest you vote! 40574 3
Started by NatalieD
ER 9809 Description Currently there is no way to report by either group, list, or attribute. It would be helpful to export this information to Excel to help with analysis and maintenance. Proposed Solution Add capability to extract/report on LBI reports by group, list, or attribute. Adding capability to export this information to Excel would be useful. ER 9813 Description Add capability to search for LBI reports. Allowing search by wildcard would be very useful. Right now looking...
|
|
|
|
3 |
40574 |
by Kelly H12/23/2016 1:03 PM |
|
1 Replies and 38045 Views
Crystal Report - Help Adding Fields to Existing Query 38045 1
Started by Chris-T
Good afternoon, Let me start by stating that while I'm a DB person at my local hospital, I have never worked with Lawson data before. I've been requested to create an employee history report and thanks to the talented folks here, I have very nearly what I need. Would someone be able to assist me in adding two fields to this query - I'm looking to add the employee's prior supervisor and current supervisor (much like the current position and prior position). I believe the d...
|
|
|
|
1 |
38045 |
by Jeff Shumate11/28/2016 11:42 PM |
|
4 Replies and 36616 Views
RNI Crystal 36616 4
Started by Mark Silva
Which tables and fields are best and any joins to create a crystal report to display RNI. We can see PORECLINE ENT-REC-QTY – the Receipt Quantity on PO30 MAINVDTL ENTERED-QTY – The Invoice Quantity on MA43 POLINE VBUY-UNIT-CST – The PO Line Unit Cost So we know if we take Receipt Quantity less Entered Quantity we get RNI Quantity. We can take this against PO Line Unit Cost to get RNI amount. B...
|
|
|
|
4 |
36616 |
by JonA11/28/2016 6:57 PM |
|
0 Replies and 2929 Views
Report will not pull up 2929 0
Started by ALB
There is one person who is having an issue pulling up any Crystal reports. The pop-up flashes a URL with the web server and another with the LBI server. I noticed the error logs have: The Viewer could not be created because the Device Client type is not supported How do you resolve that issue
|
|
|
|
0 |
2929 |
11/23/2016 7:44 PM |
|
0 Replies and 2512 Views
Determine if an employee received a promotion/demotion 2512 0
Started by agersh
I have been asked to build a Crystal Report to track employee status, position, department changes, and promotions/demotions for a select group of employees. Using the HRHISTORY table I am track an employee’s status, position and department changes. But I am having trouble determining what to look at to determine if an employee received a promotion/demotion.
|
|
|
|
0 |
2512 |
11/17/2016 7:01 PM |
|
0 Replies and 2474 Views
Need GLTRANS and FBDETAIL view 2474 0
Started by Donna
I am preparing a crystal report that uses GLTRANS for the expense column and provides totals by system code that tie back to all the sub systems. The report also displays budget in a sub report at the account level but the report performance is terrible. There is a significant percentage of accounts that do not have expense transactions but are budgeted. Does anyone have a view or sql query that might be helpful in obtaining all the populated records for each table The view does not nee...
|
|
|
|
0 |
2474 |
11/16/2016 3:30 AM |
|
11 Replies and 40422 Views
Searching for BANK-STATUS field 40422 11
Started by ric9d
Hello all, I am looking for the BANK-STATUS field for my report. Please help as I dont know where to get it from (table and field names pls!). The possible values are 'Reconciled', 'Issued', etc. THANKS! Ric
|
|
|
|
11 |
40422 |
by Greg Dey11/11/2016 10:00 PM |
|
9 Replies and 35311 Views
LBI to Infor BI 35311 9
Started by Greg Moeller
Just got an email from my PM stating we need to get to Infor BI for Lawson. A PDF attachment to this email indicates How to move from LBI to Infor BI for Lawson A migration consists of two parts: • A license migration, and • a technical migration. License migration Customers just need to provide the existing LBI and Viewpoint license SKUs to their sales reps. There is a standard conversion document available that provides the resulting Infor BI for Lawson licenses...
|
|
|
|
9 |
35311 |
by Vijay S11/8/2016 1:28 PM |
|
1 Replies and 35251 Views
POAGMTPART 35251 1
Started by NatalieD
Hello - I'm trying to build a crystal report that will show the contracted price for an item based on the IC12 location company. We have instances where we have more than one vendor agreement based on one for a specific participant company. When I pull the contract tables in (POVAGRMTHD, POVAGRMTLN and POAGMTPART) they report duplicates the item for every possible contract. I'm trying to narrow down to have it only show the vendor agreement based on the location company using the agreement parti...
|
|
|
|
1 |
35251 |
by Joan Herzfeldt11/3/2016 2:41 PM |
|
3 Replies and 35823 Views
Unable to view LBI Report 35823 3
Started by Vijay S
All, We went to LBI 10.2 , RAS - 11. When we try to publish a report , we are getting message published successfully, But when we Run the report , we are getting the following error: ------------------------------------------------------------------------------------------ | | 'com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: The system cannot find the path specified. ---- Error code:-2147467259 &91;CRSDK00000000&93; Error code name:failed' ...
|
|
|
|
3 |
35823 |
by Vijay S10/25/2016 1:10 PM |
|
6 Replies and 40308 Views
Crystal Report for PO23 Orphaned Items 40308 6
Started by brupp
Hello - I have a Crystal Report for POINTERFAC with ORIGIN_CD=IC to catch those items that do not add to or create a PO due to having the wrong replenishment vendor (or whatever the reason). It works fine except for 6 items that I cannot find either in PO23 or on a PO100 error report. I just need them to go away & cannot figure out the required action in Lawson. Any ideas Thanks.
|
|
|
|
6 |
40308 |
by brupp9/16/2016 7:00 PM |
|
0 Replies and 2892 Views
Parameters and Scheduled Instances 2892 0
Started by thummel1
Hi, I am working in Lawson version 9.0.1. Can a scheduled report have parameters added to it For instance, we have a scheduled report that contains many employee demographics. The end users would like the ability to select the Employee Last Name and/or Employee ID so only those matching records will display, versus the alternative of exporting a large report and filtering/sorting for the needed record. I know there is the option within LBI to create a parameter, and I tested this option ...
|
|
|
|
0 |
2892 |
9/12/2016 5:38 PM |
|
6 Replies and 41356 Views
Cross Reference All LBI Reports to Security 41356 6
Started by ALB
Is there a way to create a list of all LBI reports and the security tied to each Some of our security is by individual user and some by groups.
|
|
|
|
6 |
41356 |
by ALB8/19/2016 3:42 PM |
|
5 Replies and 41857 Views
Internet Explorer 11 and LBI Version 9.0.4 41857 5
Started by Fred Pinto
Hi Everyone, I just upgraded a user from XP to Win7 and now their BI web page is all screwed up. I tried the compatibility view but I get the same screen. I've attched a screen shot. Any ideas
|
|
|
|
5 |
41857 |
by Fred Pinto8/10/2016 2:34 PM |
|
1 Replies and 34264 Views
Crystal Reporting in the Cloud 34264 1
Started by imty
Hello All, We currently use Crystal Reports with Lawson for financial reporting. Our current Production database is on a dedicated in-house server. The reports seem to run fine in this environment. We are now migrating to the Cloud and have modified the data source for all CR to point to the Cloud database. The database is called the LSLMDB in the Cloud Server. We are noticing a drastic drop in the run time of some reports especially ones where data is being retrieved for both the current and...
|
|
|
|
1 |
34264 |
by Jimmy Chiu8/5/2016 5:47 PM |
|
4 Replies and 36216 Views
Crystal report not refreshing 36216 4
Started by BMcKay
1. Modified Crystal report, did save without data 2. Republished on dashboard via LBI>Report Details 3. LBI>Report Details>Data Settings, chose the datasource and entered user id/password. Now I go to Dashboard, click on report and it has old data in it. I'm new at both Crystal and LBI. Beth
|
|
|
|
4 |
36216 |
by NatalieD7/28/2016 1:25 PM |
|
2 Replies and 37199 Views
LBI 10.5 37199 2
Started by LoriN
Has anyone moved to Infor BI for Lawson Version 10.5 or 10.6 I am trying to determine what the migration process is for this. I know we need to fill out an order form to switch from LBI to IBI. I have tried to get additional information from our Account Exec, but not had much luck with the information I am looking for. I see that LBI 10.4 is end of maintenance on 2/28/17. What was the process like for conversion Did you need to have consulting, or was the conversion fairly seamless. ...
|
|
|
|
2 |
37199 |
by Greg Moeller7/27/2016 2:52 PM |
|
3 Replies and 40648 Views
Updating user rights in LBI within IE11 40648 3
Started by Kelly H
We recently upgraded to IE11 and since then we can't update user rights in LBI. When we use IE9, it still works fine. Has anyone else experienced this and figured out a work around The only work around we have right now is to reimage a machine and put IE9 on that machine rather than IE11. And so far this is the only issue we are having in IE11 that we have found so far.
|
|
|
|
3 |
40648 |
by Greg Dey7/7/2016 1:46 PM |
|
1 Replies and 32917 Views
Bursting Reports on Dashboard 32917 1
Started by Maria
We currently have several reports on our LBI dashboard that are bursted by user (LAWSONRS_CurrentUser). When a user runs the bursted report, it displays data that is assigned to them however, when they click on the refresh button in the report (after it ran the first time), they are prompted to select a user name (making the bursting obsolete). This allows them to view data of the entire organization since they are able to select any user in the drop down menu. Has anyone ever experie...
|
|
|
|
1 |
32917 |
by Dave Curtis6/30/2016 1:04 PM |
|
3 Replies and 37514 Views
Refresh RS SN FS Databases 37514 3
Started by Giulia
We have upgraded our LBI to 10.4 and our Lawson to 10. We are currently testing and plan to go live in May. In the mean time we are adding Reports and Smart Notes in our current production databases and publishing them to dashboards. To avoid manually keeping the two databases in sync (creating and publishing these new items in both environments), is there a tool or script that will refresh the upgraded RS SN and FS databases with the current production RS SN and FS databases without impacting t...
|
|
|
|
3 |
37514 |
by Greg Moeller6/28/2016 3:40 PM |
|
2 Replies and 30768 Views
ICTRANS Location w-Name 30768 2
Started by brupp
Hello - I have a Crystal Report with ICTRANS.FROM_TO_LOC & I need to add the name of the location to the report. Sometimes this is a par location & sometimes it is a requesting location. It is working with our par locations that have IC81 headers using ICLOCATION, but I'm losing the requesting locations since those are in RQ01/REQLOC. Any suggestions My knee jerk reaction is to add our req locs to IC81 as a header only but I believe these will create ghost IC02's which may cause an en...
|
|
|
|
2 |
30768 |
by brupp6/17/2016 12:17 PM |
|
0 Replies and 3985 Views
Item/Vendor report 3985 0
Started by NatalieD
I'm trying to write a Crystal Report that has ITEMMAST and POITEMVEN to show all the items in the item master as well as any PO13 information. When I pull in APVENMAST to pull in the vendor name I have to filter out a specific vendor group. When I do this, it eliminates any IC11 records that don't have a PO13. Any suggestions SELECT 'ITEMMAST'.'ITEM_GROUP', 'ITEMMAST'.'ITEM', 'ITEMMAST'.'DESCRIPTION', 'ITEMMAST'.'DESCRIPTION2', 'ITEMMAST'.'INVEN_MAJCL', 'ITEMMAST'.'INVEN_MINCL', 'ITEMMAST'....
|
|
|
|
0 |
3985 |
6/16/2016 7:26 PM |
|
1 Replies and 33277 Views
7.1.5 Lawson Insight GL / Fin. 33277 1
Started by edj
Using an old Lawson Insight version, 7.1.5 on iSeries/AS400. A user was recently changed from an AP group to Financial/GL but something must have been missed because while the user can run a financial report, they cannot view it so as to move it to an active print outq. I am not very familiar with Lawson user setup, and anyone that was has moved on. I'm out of ideas as to where or how this permission/authority is granted. I can view the spooled output in the outq and move it to print, but the u...
|
|
|
|
1 |
33277 |
by edj6/14/2016 4:08 PM |
|
3 Replies and 34268 Views
Excel Exports format incorrectly in LBI 34268 3
Started by Donna
It has always been a challenge to get some of our more complex reports to export with correct EXCEL formatting in LBI but now newly published reports have some real issues with the columns when exported. It appears that the exported report totally ignores the columns in the published Crystal report. These same reports export beautifully when directly exported from Crystal to Excel outside of LBI. I reached out to a peer who is also a consultant and he is having the same problem. Reports that...
|
|
|
|
3 |
34268 |
by Donna6/2/2016 7:26 PM |
|
2 Replies and 40686 Views
PO Spend Validation 40686 2
Started by NatalieD
Hello - Any thoughts on the best approach or screen in Lawson to help validate a PO spend report Ideally I would like to be able to have a number I can compare the amount of PO spend within a time period.
|
|
|
|
2 |
40686 |
by NatalieD5/19/2016 2:02 PM |
|
5 Replies and 41854 Views
Crystal Par Stock Out Report 41854 5
Started by bcarmichael99
I am looking for a way to use a crystal report to show when items stock out for our par locations. I have tried querying multiple different ways but everytime I do, it throws off the number because we have updated the par level. I need a way to include whatever the par level was at the time the count was completed. Any help would be greatly appreciated.
|
|
|
|
5 |
41854 |
by JonA5/18/2016 3:47 PM |
|
1 Replies and 41116 Views
Oracle ODBC Driver Configuration Error 41116 1
Started by JonA
I'm trying to set up my my ODBC connection for Crystal on a new pc (Windows 7, Oracle version 12.1.0) but I'm getting this error: Testing Connection SQLState=08004 &91;Oracle&93;&91;ODBC&93;&91;Ora&93;ORA-12154: TNS:could not resolve the connect identifier specified When I compare the ODBC driver config and tnsnames.ora file to my current pc (Windows XP, Oracle version 11g) they look identical. And my connection test is successful on this pc. Any ideas
|
|
|
|
1 |
41116 |
by JonA5/12/2016 6:28 PM |
|
2 Replies and 37878 Views
Table Joins - MMDIST & GL 37878 2
Started by brupp
Hello - I am trying to build a Crystal Report for Inventory transactions - I have everything in place except for descriptions for AU's. I have GLMASTER, GLNAMES & GLCHARTDTL available. I'm only getting results for one of our companies. I've played with the joins but no success. Perhaps I'm missing a parameter - any suggestions
|
|
|
|
2 |
37878 |
by brupp5/9/2016 2:47 PM |
|
2 Replies and 35957 Views
Items and unit price 35957 2
Started by Deleted User
Hello - I am trying to build a Crystal Report for all IC11 items along with their unit price. .What table can I use for unit price If I use ICTRANS I get multiple records for same item with different unit price. Thanks for your help.
|
|
|
|
2 |
35957 |
by Kat V5/9/2016 12:53 PM |
|
2 Replies and 39698 Views
IC11 and vendor data 39698 2
Started by NatalieD
I'm trying to create a Crystal report that will list ALL of my IC11 records and then list the PO13 records for the item. I have itemmast leftouter to POITEMVEN and am OK. When I try to link APVENMAST to POITEMVEN to get the vendor name. We have two vendor groups and one has to be filtered out - this seems to be the when I loose all IC11 records that do not have PO13 records (no vendor group). If I remove the vendor group record select, the report duplicates based on the vendor ID if the vendor n...
|
|
|
|
2 |
39698 |
by NatalieD5/6/2016 11:11 AM |
|
|
6 |
45302 |
by Lance Kelley5/3/2016 6:59 PM |
|
1 Replies and 42132 Views
need documentation on publishing on LBI 42132 1
Started by NatalieD
Hi! I am new to LBI and I'm having trouble understanding how the rights for each user and group relates to how a report is published and linked on LBI. Does anyone have any documentation they would be willing to share to help me out I've been able to republish and keep everything going but I'm having trouble with setting up published reports to get the published report match the rights to the dashboard it is linked. LBI Reporting Services 10.1.0.0.110 Much appreciated!
|
|
|
|
1 |
42132 |
by JonA4/22/2016 12:24 PM |
|
1 Replies and 8207 Views
Future of LBI 8207 1
Started by Kelly H
We are currently on LBI 10. In the past we have heard issues around some functionality going away in LBI 11. There is a post on the Lawson community pages that talks about lBI moving to OLAP instead of Crystal Has there been any road maps shown that indicate where LBI is headed
|
|
|
|
1 |
8207 |
by Shane Jones4/16/2016 10:50 AM |
|
|
1 |
29082 |
by mikeP4/14/2016 2:32 PM |
|
1 Replies and 38884 Views
Print to a network printer? 38884 1
Started by Lance Jurgensen
I have a request to print a scheduled report on a network printer and I am finding the 'documentation' lacking on Infor Extreme... I have the device type setup and I can see the HelloWorld....pdf files getting created in the temp directory. Getting 'Unable to retrieve content from '{0}'. when running the delivery test.
|
|
|
|
1 |
38884 |
by Lance Jurgensen4/6/2016 2:56 PM |
|
9 Replies and 38113 Views
Links on dashboard (LBI) will not launch 38113 9
Started by JonA
We have a couple users that when they click on the links on one of our LBI dashboards, nothing happens. If they log into a different pc it works fine. So this leads me to think it's a setting on the pc. IT has verified that Lawson security, IE version and compatibility settings are fine. The links on other dashboards work as expected. Anyone have a similar issue
|
|
|
|
9 |
38113 |
by Ethan3/23/2016 9:28 PM |
|
5 Replies and 36334 Views
PERSACTION Report build 36334 5
Started by thummel1
Has anyone attempted to build a report using the PERSACTION table that would list all employees in the table, that includes their current demographic information (e.g. current Process Level, Dept, Job Code, User Level, FTE, others...) and also display the same demograhpics of what they are transferring to (new Process Level, Dept, Job Code, User Level, FTE, others... ). The table appears to be built in a way that is not very conducive to easy reporting. The goal of this report is to replace a...
|
|
|
|
5 |
36334 |
by Dave Curtis3/23/2016 11:36 AM |
|
6 Replies and 31021 Views
Crystal and PRSAGDTL.EFFECT_DATE 31021 6
Started by Maria
I am tying to pull the max EFFECT_DATE frm the PRSAGDTL table in Crystal and cannot find a formula or command that will do this. Does anyone have any ideas or has had an issue with this that can help me out. I would appeciate any and all help.
Thanks
Maria
|
|
|
|
6 |
31021 |
by mikeP3/21/2016 4:18 PM |