Forum: Lawson Business Intelligence/Reporting/Crystal

 136 Subscribed to this forum
Page 4 of 34 << < 23456 > >>

Topics

Replies
Rating
Status
Views
Subscribers
Last Post

Crystal Report for PO23 Orphaned Items    

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 47481 0
by  bruppJump to last post
9/16/2016 7:00 PM

Parameters and Scheduled Instances    

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 3558 0
9/12/2016 5:38 PM

Cross Reference All LBI Reports to Security    

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 48262 2
by  ALBJump to last post
8/19/2016 3:42 PM

Internet Explorer 11 and LBI Version 9.0.4    

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
49245 2
by  Fred PintoJump to last post
8/10/2016 2:34 PM

Crystal Reporting in the Cloud    

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 39418 1
by  Jimmy ChiuJump to last post
8/5/2016 5:47 PM

Crystal report not refreshing    

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
42638 0
by  NatalieDJump to last post
7/28/2016 1:25 PM

LBI 10.5     

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 44257 2
by  Greg MoellerJump to last post
7/27/2016 2:52 PM

Updating user rights in LBI within IE11    

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 47726 2
by  Greg DeyJump to last post
7/7/2016 1:46 PM

Bursting Reports on Dashboard    

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 38589 1
by  Dave CurtisJump to last post
6/30/2016 1:04 PM

Refresh RS SN FS Databases    

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 43322 3
by  Greg MoellerJump to last post
6/28/2016 3:40 PM

ICTRANS Location w-Name    

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 35835 0
by  bruppJump to last post
6/17/2016 12:17 PM

Item/Vendor report    

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 4830 0
6/16/2016 7:26 PM

7.1.5 Lawson Insight GL / Fin.    

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 39272 2
by  edjJump to last post
6/14/2016 4:08 PM

Excel Exports format incorrectly in LBI    

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 40867 2
by  DonnaJump to last post
6/2/2016 7:26 PM

PO Spend Validation    

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 47274 0
by  NatalieDJump to last post
5/19/2016 2:02 PM

Crystal Par Stock Out Report    

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 48075 1
by  JonAJump to last post
5/18/2016 3:47 PM

Oracle ODBC Driver Configuration Error    

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 48561 0
by  JonAJump to last post
5/12/2016 6:28 PM

Table Joins - MMDIST & GL    

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 45319 2
by  bruppJump to last post
5/9/2016 2:47 PM

Items and unit price    

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 41703 0
by  Kat VJump to last post
5/9/2016 12:53 PM

IC11 and vendor data    

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 47053 2
by  NatalieDJump to last post
5/6/2016 11:11 AM

List of bursting rights, elements and users    

Started by  Donna
What tables have the bursting information fields Thank you. Donna
6 52867 3
by  Lance KelleyJump to last post
5/3/2016 6:59 PM

need documentation on publishing on LBI    

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 48995 2
by  JonAJump to last post
4/22/2016 12:24 PM

Future of LBI    

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 8769 2
by  Shane JonesJump to last post
4/16/2016 10:50 AM

How to add a custom table to lawson data dictionary version 9.0.0.1    

Started by  apsnaveen
How to add a custom table to lawson data dictionary version 9.0.0.1
1 34227 1
by  mikePJump to last post
4/14/2016 2:32 PM

Print to a network printer?    

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 44374 1
by  Lance JurgensenJump to last post
4/6/2016 2:56 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 4 of 34 << < 23456 > >>


RSS Feed Available
Forums Performance Management

Group: Performance Management

Forums
Topics
Replies
Subscribers
Last Post

Smart Notification

189 635 71 RE: SQL Help by  Greg Moeller 11/9/2023 2:49 PM