Forums
 Topics
 Replies
 Last Post
179 Topics and 618 Replies Smart Notification  179  618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
179 618
RE: Deliver LBI report in...
by  Mark Petereit
11/01/2017 6:54 AM
Search this forum:
Search
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 912345 > >>
Topics
 Replies
 Views
 Last Post
3 Replies and 4695 Views Crystal Labor Utiilization Report to publish in LBI    4695  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 4695
by  JanJump to last post
01/06/2010 9:05 AM
8 Replies and 1016 Views LBI Schedule Disappear Randomly  1016  8 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 ...
8 1016
by  CharJump to last post
10/14/2017 7:41 AM
8 Replies and 417 Views Report will not burst  417  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 417
by  DonnaJump to last post
10/11/2017 5:15 PM
0 Replies and 118 Views Survey Functionality  118  0 Started by  thummel1 I am wondering if Lawson V10 has the ability to create a survey for employees in Employee Self Service
0 118
09/05/2017 2:09 PM
3 Replies and 663 Views Remove MNR PO Lines from Report  663  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 663
by  Kat VJump to last post
09/05/2017 8:18 AM
0 Replies and 129 Views Infor Enhancement to APAUDIT  129  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 129
08/21/2017 6:51 AM
1 Replies and 472 Views Lawson Smart Reports - LSR Designer  472  1 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...
1 472
by  Stuart PerkinsJump to last post
08/16/2017 10:38 AM
15 Replies and 1396 Views Guru Data Dictionary  1396  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 1396
by  John HenleyJump to last post
08/03/2017 2:29 PM
1 Replies and 310 Views UTC Conversions on Date Range Functions  310  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 310
by  John HenleyJump to last post
08/03/2017 10:29 AM
2 Replies and 454 Views LBI and Crystal 2013, Windows 10  454  2 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
2 454
by  Joe O'TooleJump to last post
07/28/2017 5:59 PM
7 Replies and 1952 Views LBI On Demand-passing in authuser value  1952  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 1952
by  Who Da PhillyJump to last post
07/20/2017 8:21 AM
0 Replies and 175 Views ReportWriter GL Income Statement 12 Mo.  175  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 175
06/27/2017 10:50 AM
2 Replies and 743 Views LBI Server Out of Memory  743  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 743
by  Greg MoellerJump to last post
05/30/2017 4:46 PM
1 Replies and 397 Views LBI Delete Parameter Values  397  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 397
by  KatmanJump to last post
05/30/2017 1:54 PM
2 Replies and 470 Views Verifying LBI Maintain Rights  470  2 Started by  SurvivorAC 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 470
by  Joan HerzfeldtJump to last post
03/21/2017 8:38 AM
6 Replies and 1494 Views Framework Services Tools Dashboard  1494  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 1494
by  SurvivorACJump to last post
03/20/2017 11:25 AM
7 Replies and 850 Views LBI Tools Tab Reporting My Reports  850  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 850
by  lmackinJump to last post
03/01/2017 12:17 PM
1 Replies and 327 Views LBI Backoffice to GL90 security  327  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 327
by  texasInstrumentsJump to last post
02/20/2017 4:17 PM
0 Replies and 385 Views Paramertized Crystal Reports freezes  385  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 385
02/14/2017 6:49 AM
1 Replies and 474 Views Embed <LAW> tag  474  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 474
by  NatalieDJump to last post
02/08/2017 10:14 AM
1 Replies and 443 Views Report  443  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 443
by  dcaianiJump to last post
02/06/2017 9:08 AM
3 Replies and 989 Views Item Locn usage using ICHISTORY - date range?  989  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 989
by  NatalieDJump to last post
02/03/2017 1:35 PM
1 Replies and 407 Views Edit Report List under Maintain Reports  407  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 407
by  NatalieDJump to last post
02/03/2017 9:17 AM
1 Replies and 585 Views Infor BI versus LBI versus other solutions  585  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 585
by  RandyJump to last post
01/24/2017 1:10 PM
0 Replies and 332 Views Cleanup user rights  332  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 332
01/17/2017 10:10 AM
0 Replies and 394 Views LBI report linked to Excel file  394  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 394
01/16/2017 8:41 AM
1 Replies and 582 Views Change user language in LawsonFS database  582  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 582
by  TRKJump to last post
12/28/2016 3:06 AM
1 Replies and 750 Views Crystal Report does not run  750  1 Started by  SurvivorAC 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 750
by  Jimmy ChiuJump to last post
12/23/2016 8:16 AM
4 Replies and 945 Views Republishing reports not working LBI 10.6  945  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 945
by  Jimmy ChiuJump to last post
12/23/2016 8:09 AM
3 Replies and 692 Views Enhancement requests 9809 & 9813 - suggest you vote!  692  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 692
by  Kelly HJump to last post
12/23/2016 8:03 AM
1 Replies and 689 Views Crystal Report - Help Adding Fields to Existing Query  689  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 689
by  Jeff ShumateJump to last post
11/28/2016 6:42 PM
4 Replies and 1193 Views RNI Crystal  1193  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 1193
by  JonAJump to last post
11/28/2016 1:57 PM
0 Replies and 507 Views Report will not pull up  507  0 Started by  SurvivorAC 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 507
11/23/2016 2:44 PM
0 Replies and 378 Views Determine if an employee received a promotion/demotion  378  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 378
11/17/2016 2:01 PM
0 Replies and 457 Views Need GLTRANS and FBDETAIL view  457  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 457
11/15/2016 10:30 PM
11 Replies and 2043 Views Searching for BANK-STATUS field  2043  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 2043
by  Greg DeyJump to last post
11/11/2016 5:00 PM
9 Replies and 3503 Views LBI to Infor BI  3503  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 3503
by  Vijay SJump to last post
11/08/2016 8:28 AM
1 Replies and 701 Views POAGMTPART  701  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 701
by  Joan HerzfeldtJump to last post
11/03/2016 10:41 AM
3 Replies and 718 Views Unable to view LBI Report  718  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 718
by  Vijay SJump to last post
10/25/2016 9:10 AM
6 Replies and 929 Views Crystal Report for PO23 Orphaned Items  929  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 929
by  bruppJump to last post
09/16/2016 3:00 PM
0 Replies and 459 Views QLIK  459  0 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.
0 459
09/14/2016 12:40 PM
0 Replies and 397 Views Parameters and Scheduled Instances  397  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 397
09/12/2016 1:38 PM
6 Replies and 959 Views Cross Reference All LBI Reports to Security  959  6 Started by  SurvivorAC 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 959
by  SurvivorACJump to last post
08/19/2016 11:42 AM
5 Replies and 1129 Views Internet Explorer 11 and LBI Version 9.0.4  1129  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 1129
by  Fred PintoJump to last post
08/10/2016 10:34 AM
1 Replies and 1134 Views Crystal Reporting in the Cloud  1134  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 1134
by  Jimmy ChiuJump to last post
08/05/2016 1:47 PM
4 Replies and 1811 Views Crystal report not refreshing  1811  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 1811
by  NatalieDJump to last post
07/28/2016 9:25 AM
2 Replies and 836 Views LBI 10.5  836  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 836
by  Greg MoellerJump to last post
07/27/2016 10:52 AM
3 Replies and 1031 Views Updating user rights in LBI within IE11  1031  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 1031
by  Greg DeyJump to last post
07/07/2016 9:46 AM
1 Replies and 927 Views Bursting Reports on Dashboard  927  1 Started by  Basia 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 927
by  Dave CurtisJump to last post
06/30/2016 9:04 AM
3 Replies and 1008 Views Refresh RS SN FS Databases  1008  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 1008
by  Greg MoellerJump to last post
06/28/2016 11:40 AM
2 Replies and 994 Views ICTRANS Location w-Name  994  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 994
by  bruppJump to last post
06/17/2016 8:17 AM
0 Replies and 784 Views Item/Vendor report  784  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 784
06/16/2016 3:26 PM
1 Replies and 964 Views 7.1.5 Lawson Insight GL / Fin.  964  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 964
by  edjJump to last post
06/14/2016 12:08 PM
3 Replies and 946 Views Excel Exports format incorrectly in LBI  946  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 946
by  DonnaJump to last post
06/02/2016 3:26 PM
2 Replies and 819 Views PO Spend Validation  819  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 819
by  NatalieDJump to last post
05/19/2016 10:02 AM
5 Replies and 1017 Views Crystal Par Stock Out Report  1017  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 1017
by  JonAJump to last post
05/18/2016 11:47 AM
1 Replies and 1078 Views Oracle ODBC Driver Configuration Error  1078  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 1078
by  JonAJump to last post
05/12/2016 2:28 PM
2 Replies and 839 Views Table Joins - MMDIST & GL  839  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 839
by  bruppJump to last post
05/09/2016 10:47 AM
2 Replies and 950 Views Items and unit price  950  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 950
by  Kat VJump to last post
05/09/2016 8:53 AM
2 Replies and 787 Views IC11 and vendor data  787  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 787
by  NatalieDJump to last post
05/06/2016 7:11 AM
6 Replies and 1874 Views List of bursting rights, elements and users  1874  6 Started by  Donna What tables have the bursting information fields Thank you. Donna
6 1874
by  Lance KelleyJump to last post
05/03/2016 2:59 PM
1 Replies and 859 Views need documentation on publishing on LBI  859  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 859
by  JonAJump to last post
04/22/2016 8:24 AM
1 Replies and 1077 Views Future of LBI  1077  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 1077
by  Shane JonesJump to last post
04/16/2016 6:50 AM
1 Replies and 800 Views How to add a custom table to lawson data dictionary version 9.0.0.1  800  1 Started by  apsnaveen How to add a custom table to lawson data dictionary version 9.0.0.1
1 800
by  mikePJump to last post
04/14/2016 10:32 AM
1 Replies and 851 Views Print to a network printer?  851  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 851
by  Lance JurgensenJump to last post
04/06/2016 10:56 AM
9 Replies and 1433 Views Links on dashboard (LBI) will not launch  1433  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 1433
by  EthanJump to last post
03/23/2016 5:28 PM
5 Replies and 1202 Views PERSACTION Report build  1202  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 1202
by  Dave CurtisJump to last post
03/23/2016 7:36 AM
6 Replies and 3878 Views Crystal and PRSAGDTL.EFFECT_DATE  3878  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 3878
by  mikePJump to last post
03/21/2016 12:18 PM
1 Replies and 745 Views MSCM Signature  745  1 Started by  john5 I have a request for data from MSCM to show deliveries, show it was delivered to and also the signatures that were captured. I can gather all the needed data, I see the bitmap field for the signature but want to convert that to the signature to show on a report. Has anyone done this that can share some thoughts on how to code this Thank You.
1 745
by  Greg MoellerJump to last post
03/10/2016 10:23 AM
5 Replies and 945 Views Report for LBI reports posted and publishing/Report ID  945  5 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
5 945
by  DonnaJump to last post
03/03/2016 2:56 PM
0 Replies and 649 Views AP150 invoices put on hold  649  0 Started by  Deleted User Hello all, I am looking for the logic(criteria) for invoices put on credit hold on AP150 for my report. Please help as I dont know where to get it from (table and field names pls!). Thanks
0 649
02/29/2016 7:33 AM
3 Replies and 1164 Views PERSACTION-Position Number?  1164  3 Started by  thummel1 I am building a report designed to show various field that will be changing in the PERSACTION table. One of the fields I need to display is the Position Number, before and after. I can see where the 'After' is (PERSACTION.NEW_VALUE_7), but I am not sure the best way to display the 'before'. I can see the Process Level and Department as their own data fields, but not Position, which is important because an employee can have up to 5 positions. Any suggestions on how to display (e.g. data field...
3 1164
by  pbelskyJump to last post
02/03/2016 5:03 PM
3 Replies and 1216 Views Freight Data Output to Text File  1216  3 Started by  JonA I need someone well versed in SQL to check my script for syntax and structure. I can read scripts and understand for the most part what a script was designed to do but this is the first one I've built. I created this one by starting with Crystal and reverse engineering other examples and lots of Google searches. The purpose of this script is to create a text file of freight expense history (we use AOC codes) for the past 7 days and file name should be MIDMIC-COMP-YYYYMMDD.txt where YYMMDD is ...
3 1216
by  JonAJump to last post
02/03/2016 2:08 PM
4 Replies and 1137 Views Dashboard Missing  1137  4 Started by  Kelly H We have users that have been able to see one of the dashboards in LBI for quite some time. All of the sudden some of them cant see it. But some are able to. I have checked the sharing on the dashboard,as well as the various reports within the dashboard. The user is a part of a role that has access to that dashboard. I tried adding just his user ID to that access, but it still didnt work. He has tried it in IE and Chrome. It was initially one user, but now we have an another user state they also ...
4 1137
by  Kelly HJump to last post
02/02/2016 2:38 PM
0 Replies and 707 Views MA236 Criteria  707  0 Started by  Kidd Kasper Hello all, I have resources that would like to have a Crystal Report in LBI that essentially duplicates MA236. I've tried to pick through the logic of the program to pull all the criteria that it's using. Although I know programming logic in general, I've never learned Cobalt. What I have thus far is: apinvoice.rec_status in (0,1) apinvoice.match_status in (0,1) apinvoice.invoice_type not in ('C', 'D', 'R') apinvoice.mtch_proc_type in ('R', 'A') mainvdtl.r_status = 0 mainvdtl.matche...
0 707
01/27/2016 10:08 AM
2 Replies and 1172 Views SQL query of AP230  1172  2 Started by  Deleted User Can anybody share with me SQL query of AP230 Thanks a lot
2 1172
by  klemmyjbJump to last post
01/14/2016 1:41 PM
2 Replies and 1487 Views LBI Utilization  1487  2 Started by  thummel1 Hi, We are in the process of preparing for an LBI upgrade. As part of preparations, we would like to understand LBI report utilization, that is, how frequently are our 400 LBI reports in Production being used. Knowing this information will help us better prepare and prioritize our work. Is there a feature in LBI that will tell us how often each report is utilized, and perhaps by which Users or which User Security Groups Thank you!
2 1487
by  Greg MoellerJump to last post
01/12/2016 3:47 PM
1 Replies and 1247 Views SQL Query of GL90  1247  1 Started by  PeshWen I have the below query and I can't seem to get the description of the inventory items. I'm mimicking GL90 can anyone help SELECT GLT.TO_COMPANY AS 'Co' ,CASE WHEN GLT.SYSTEM = 'AP' THEN(VEN.VENDOR) ELSE('N/A') END AS 'Vendor' ,CASE WHEN GLT.SYSTEM = 'AP' THEN(API.VOUCHER_NBR) ELSE('N/A') END AS 'Voucher' ,GLT.ACCT_UNIT AS 'Dept' ,GLT.SYSTEM AS 'System' ,GLT.ACCOUNT 'Account' ,GLC.ACCOUNT_DESC AS 'Acct Description' ,CASE WHEN GLT.SYSTEM = 'AP' THEN(APD.ORIG_BASE_AMT) ELSE...
1 1247
by  LesleyJump to last post
01/11/2016 10:23 AM
1 Replies and 1134 Views User cannot access her report  1134  1 Started by  Donna Hi, The user has access to everything in the dashboard and module as well as the report but is not allowed to access the report after the v10 upgrade. She was running it prior to the upgrade. The user is both a report user and a member of a role on the report and on the dashboard published report. She can run anything else on the dashboard except this report. The default permissions are set up correctly. Error message is 'you do not have access to view the latest instance of this re...
1 1134
by  DonnaJump to last post
01/06/2016 11:01 AM
6 Replies and 1740 Views Lost Report Connection  1740  6 Started by  Katy Prince The Crystal Reports that I published into LBI were working fine then all of a sudden stopped working and started asking for credentials. Then they still won't run. I have other Crystal Reports that run fine (coming from a different database, not infor/Lawson). AND all of my smart notifications are working fine.
6 1740
by  DonnaJump to last post
01/06/2016 10:46 AM
3 Replies and 1408 Views Export of user rights?  1408  3 Started by  Greg Moeller Looking for anyone with experience in exporting existing LBI rights. We are in the middle of configuring our upgrade including a server update and a platform upgrade. We have a lot of rights and would hate to manually enter all of them again.
3 1408
by  Greg MoellerJump to last post
01/05/2016 8:48 AM
0 Replies and 1027 Views Parameters in LBI  1027  0 Started by  thummel1 Hi, I am using Crystal Reports (which is reading from a table in MS Access and is not an approved Data Source in LBI) to generate an LBI report. Because the report is using a data source that is not approved for distribution, the end users can only view it by selecting 'View this Instance' in the LBI report. I would like to add a parameter that allows the end-user to select multiple Process Levels. I have tried to add an LBI parameter, but it seems to only allow one Process Level and not multipl...
0 1027
12/23/2015 3:03 PM
4 Replies and 2528 Views Record selection formula - unexpected results  2528  4 Started by  JonA I've got a report that links MMDIST ==> POLINE (ROJ) and POLINE ==> MAINVDTL (ROJ). I'm looking for all invoice payments for PO lines charged to our supply accounts, grouping the data by whether the line is associated with an agreement or not. The end result is a graph that shows contract/non-contract supply spend for the health system. My issue is that MMDIST has multiple posting types resulting in duplicate data. I found if I eliminate all data with a posting type of H1 I'm left with g...
4 2528
by  mikePJump to last post
12/21/2015 3:16 PM
0 Replies and 896 Views Lawson Financials AR Report  896  0 Started by  AnnePep Hello, I am working on a report that I want to show the date an Acounts Receivable invoice was paid or 'applied'. Is there any system time stamp anywhere in Lawson with this information The only dates I see are deposit_date and gl_date on the ARAPPLIED record. These are driven by user input I believe. We wanted to create a metric using the date an invoice was acutally marked 'Paid' in the system (order to cash KPI) Has anyone created this What tables are you using Thank you for an...
0 896
12/21/2015 8:59 AM
3 Replies and 1302 Views Dashboard Access Rights  1302  3 Started by  Katy Prince I've set up a new dashboard and am trying to grant access rights to a group of users and it isn't working. Is there somewhere else that I need to grant dashboard rights other than in LBI when setting up the user access
3 1302
by  Katy PrinceJump to last post
12/02/2015 9:37 AM
1 Replies and 915 Views Oracle OLE DB datasource report to be changed to SQL datasource  915  1 Started by  Donna We were able to change the LBI Crystal reports that use the Lawson tables from the version 9 Oracle database source ODBC connection to the new version 10 SQL database source connection but we still have some SQL reports, OLE DB reports and some Lawson Standard reports. Has anyone else dealt with these reporting issues
1 915
by  DonnaJump to last post
11/30/2015 3:39 PM
2 Replies and 1143 Views Can you query this in LRS?  1143  2 Started by  Ronnie I have been asked to check into querying our LRS for some info. We are wanting to see what users are tied to all of our reports. Sure I could go into each report and look and see what users and roles are assigned, and then go into security and see who is assigned to each of those roles, BUT we have almost 600 reports I have to query through. I have found the LRS database and tables, but I do not find the info where it shows what users and roles are assigned to the reports.
2 1143
by  Joan HerzfeldtJump to last post
11/17/2015 8:40 AM
4 Replies and 1439 Views Is it possible to use Crystal Enterprise instead of embeded Crystal RAS with LBI  1439  4 Started by  David Britton We currently use the embedded Crystal RAS that came with LBI to run Crystal reports for Lawson 9.0.1. We are currently upgrading to Lawson 10 and LBI 10. We have purchased Crystal Enterprise (SAP 4.1 Enterprise BI Suite) to use as a 'global' reporting solution. Is it possible to configure LBI to use our Enterprise server rather than the embedded RAS Looking at the configuration steps for LBI 9.0.1 I found a requirement for Crystal Enterprise 10 Embedded Edition or Crystal Report Se...
4 1439
by  petecJump to last post
11/06/2015 1:40 PM
0 Replies and 820 Views Essbase api  820  0 Started by  brooke Does anyone have the essbase api for AIX
0 820
11/02/2015 9:56 AM
8 Replies and 1810 Views LBI Report Utilization  1810  8 Started by  thummel1 Hi, We are in the process of preparing for an LBI upgrade. As part of preparations, we would like to understand LBI report utilization, that is, how frequently are our 400 LBI reports in Production being used. Knowing this information will help us better prepare and prioritize our work. Is there a feature in LBI that will tell us how often each report is utilized, and perhaps by which Users or which User Security Groups Thank you!
8 1810
by  DonnaJump to last post
10/09/2015 11:05 AM
3 Replies and 1718 Views Which database tables are used for storing LBI report dashboard group hierarchy data?  1718  3 Started by  mlarson I'm new to LBI and trying to find out where report dashboard group hierarchy data is stored. For example, if I had a reports dashboard for clients and on that dashboard there are different groups containing links to run crystal reports. I found a good start for what to look for in the data dictionary on this site (https://www.lawsonguru.com/GuruContent/datadict/ios803/tables/index.html) but there is no data for these tables in my database.
3 1718
by  DonnaJump to last post
10/09/2015 11:00 AM
4 Replies and 2216 Views what table contains dashboard info  2216  4 Started by  Deleted User What table in the LBI database contains the info that shows what dashboards and or modules a report id is linked on
4 2216
by  DonnaJump to last post
10/07/2015 12:49 PM
9 Replies and 2547 Views Employee work history report  2547  9 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...
9 2547
by  Lance JurgensenJump to last post
09/24/2015 1:25 PM
1 Replies and 1145 Views LBI Utilization  1145  1 Started by  thummel1 Hi, We are in the process of preparing for an LBI upgrade. As part of preparations, we would like to understand LBI report utilization, that is, how frequently are our 400 LBI reports in Production being used. Knowing this information will help us better prepare and prioritize our work. Is there a feature in LBI that will tell us how often each report is utilized, and perhaps by which Users or which User Security Groups Thank you!
1 1145
by  Chris MackleyJump to last post
09/14/2015 12:39 PM
0 Replies and 992 Views Wildcard in LBI report name  992  0 Started by  Joan Herzfeldt I use the device type 'Network Drive' to export files and place them in the exact folder another system uses to import the file. My problem is several systems need the files named specifically with the current date in the name. I know the Report Name is what's used for the file name when it's exported, which I don't like but can live with. So far I've been able to work around it, but now I have a system that needs the Date FIRST, ugh. Does anyone have a solution for adding dates to the filen...
0 992
09/04/2015 10:18 AM
6 Replies and 1869 Views Using Lawson Report as a data source in Crystal  1869  6 Started by  Kelly H We are trying to use a Lawson report as a data source in crystal. We have the URL and are able to publish that to LBI. But ultimately we would like to use the report to create a larger report in Crystal which we could then publish in LBI. Is there a way to tie this report to the tables in Lawson via Crystal to create the larger report Any thoughts or suggestions anyone has would be appreciated.
6 1869
by  Greg MoellerJump to last post
09/03/2015 1:47 PM
0 Replies and 912 Views SCM Reporting - Cycle Count Variances  912  0 Started by  Robby Since this is a reporting question pertaining to SCM, I posted in both places in hopes of finding someone who knows just what I need! I'll let you know up front, I'm new to reporting for Supply Chain, so if this is too easy of a question....don't hold that against me! The business wants me to create a report (custom, of course!) to highlight the cycle count variances. Apparently, Lawson only tells you 0 (zero) variance if your count is greater than the expected count. But, here's...
0 912
07/31/2015 12:07 PM
2 Replies and 1359 Views Issue with PDF reporting  1359  2 Started by  Tony Scott Hi, We are using Lawson Portal 9.0.1 at our workplace and we always have issue with report not showing proper format in pdf. When we run report using RW100 and then go to view options PDF-landscape, it does not show all the columns in the report. I am attaching a file that shows example of this on page 1. To fix this, we use a cumbersome approach, where we open the print folder, locate the jobname, change the font type, orientation, scaling to display all the columns and format properl...
2 1359
by  Tony ScottJump to last post
07/20/2015 9:34 PM
8 Replies and 14263 Views How 2 Convert Quartz Scheduler date/times?  14263  8 Started by  Milo Tsukroff I'm writing some Crystal reports that hit the LBI table.&160; I want to know when reports are scheduled to run, and when they ran, etc.&160; I can build performance metrics against this once I can get this info.&160; Apparently the Quartz Scheduler stores date/time as a number using its own Java method.&160; The fields in question are in EJS_TRIGGERS -- NEXT_FIRE_TIME, PREV_FIRE_TIME, START_TIME, etc.&160; Does anyone know the algorithm to use to convert these times&160; I&160;see big m...
8 14263
by  Greg MoellerJump to last post
07/15/2015 9:36 AM
4 Replies and 1150 Views Crystal report reading a csv file  1150  4 Started by  DV I have a Crystal report that reads Lawson files and a .csv file. When I publish it to LBI it asks for User Id and password regardless of the options I choose in Data Settings. I have done this with .xls files and there is an option in Crystal under Verify Database for Secure Login and I make sure that is unchecked but I don't get that option in this report.
4 1150
by  DVJump to last post
07/14/2015 12:17 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 912345 > >>


RSS Feed Available