MM280

Hi Chris,
I'm new in Lawson. I cannot find the ACT_ACTIVE_BUD field in ACBUDHDR table in Lawson version 9. Please any advise?
Thanks,
Alex.

Alex,

Please start a new thread if not related to my original post regarding MM280 reverse engineering.

Chris

because the MM280 report is so complex in that you can specify certain systems onlt like AP, PO etc we could never get the custom report in crystal to tie out the report in lawson. We actually using the output of MM280 report to feed into crystal and publish it on the dashboard.

We schedule the rpt on lawson to refresh every night and in the report in LBI to refresh a few hours after the canned report in lawson runs.

We were also looking at using back office publishing for this report.

Thanks Ruma. That's the direction I ended up taking as well. No sense reinventing the wheel if it can be avoided.

Hi All

I am new in Lawson and currently on the LBI project team (investigating M3 canned/crystal reports). What is MM280? Is it one of many M3 canned reports (I know it is not a function) and how do I generate it. I believe we are running M3 BE 14.1.2.  Thanks

 

David - The MM280 is the S3 Departmental Procurement Expense Report. I don't believe that there is an equivalent in M3, but I could be wrong.

It is an S3, not M3, report program. =

Ruma, Chris,
Can you tell me step by step how you did it?
Im trying to do the same thing over here.
Appreciate your help.

I wish I remembered! Let me look through some old notes and I will let you know what I find.

The MM280 report can be published on LBi as back office publishing where whenever the job is run on Lawson LBI will publish the report without any manual intervention.

Otherwise you can also schedule the MM280 report to run. Creat a back office crsytal report to feed from the MM280 report and publish the crystal report.

You can then schedule a job using jobsched to submit the job on core lawson and schedule the crystal report on LBi. the output from the MM280 report is taken and fed into crsytal automatically without any manual intervention.

for creating a crystal report using the OLEDB connector connect it to the MM280 job and then publish it to LBI. rerun the job on core Lawson and try viewing it on LBI.

One issue I encountered is that MM280 is a huge report and may take a lot of time to complete. So while testing narrow your filters on the MM280 job to output a small set of data and test it.

Hope this helps.

If you want your MM280 report to be published directly when you run the job on Lawson this is what you would need to do:


create a MM280.cfg file on your $LAWDIR/productline/src directory with the following lines
RUNTIME_XML_ENABLE ON
RUNTIME_XML ON
RUNTIME_LOC_PROP ON
RUNTIME_ADO ON. There is a lot mnore steps to check the ftp directory and the LBi Lawson documents directory to check whether the report on LBI was created. Maybe you can see more kb articles on whether or not the output was created etc since it involves lot more investigation.

In the Knowledge base there are exact steps involved at each step on creation and checking. This will be very helpful.

Thanks Ruma,
I have been surfing the web and knowledgebase.
One of the steps that I have found here in LawsonGuri is to 1. Schedule MM280 report to run (with XML tags) and use the output as datasource for Crystal Reports. I tried doing that and the next step is to double click "ADD A Command", the process says that I should get the "Lawson Query Builder". However I am not, instead Im getting the normal Crystal Reports Command Screen. (Screen that allows you to enter your SQL statement). Any ideas? Im going crazy on this!

Sounds to me like you are missing the OLE DB Object Services connector, which is where you'd normally get the Lawson Query Builder to show up from. Can you check that and post back?

Greg is right.

Check to see whether you have the OLEDB query builder installed. Also chek your version of OLEDB to see whether you have the most compatible version for your LBI RS environment.

I have it installed for sure. I have version 9.0.4. I also successfully querried a few tables.

For publishing in LBI, you'll need it installed twice. Once on where-ever your Crystal Designer is at, and once on your LBI server as well. Otherwise LBI won't be able to pull the data.

So, you're not seeing the OLE DB Query builder (or whatever it's called nowadays) when you're in the designer, then you probably are missing the registry keys that trigger it.
You can manually (and carefully) add the registry keys, but it might be easier to re-install the Lawson OLE DB provider. What version of it, and of Crystal, are you using?

John, Im using Crystal Reports 2008 and Lawson OLE DB Provider ver 9.0.4.

Gregg,
I have both Lawson OLEDB and Crystal Reports 2008 installed on my local machine. I can run the query builder and can successfully query tables and a saved report too. However when I try to create a new report, and create a new OLEDB Connection, with LAWSON OLEDB, I can see the tables, however when I double click on "Add Command" its not showing me the query builder instead its showing the regular command screen.

You would have to login to oledb query builder using your Lawson id. At this point Lawson will check your security to make sure you have access to the tables and report files you are querying.

For LS9 security I do not that for each table there comes files that you would need access to. If you are past this point and know you have access to the files, then click select comand and choose the drop down list on this. when you see the list click on reports to see a tick right next to it.

Then expand you server and you should see Dataareas and Reports. Expand reports and you should see a list of reports that you have run on the system. When you click on the MM280 report this is an XTRA query and you should see the query to execute on the bottom portion of your screen that says report : Here you can click execute and it should show you 5 rows of data from your report.
If you do not see this then there is JOB parameter missing and you would have to work with Lawson support to see where to install it.

If you get all of the above then you know it is not an OLEDB issue and it is a crystal issue.

Hope this helps.

This should be done when the OLE DB provider is installed, but in some instances it isn't.
Go to this URL: https://www.lawsonguru.co...Crystal-Reports.aspx
View the PDF of the attached article. In that article, there is a section called "Don't See the Query Builder?" that shows where/what needs to be entered in the registry. Note that this is an old article, and the registry location has changed with each version of Crystal. For example, in SAP Crystal Reports 2011, it is HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions. And I believe Lawson.LawOLEDBC.3 is now Lawson.LawOLEDBC.4

Thank you all for helping. On the issue with my Crystal Report not showing my Lawson OLE DB Query Builder when I clicked on "Add Command", I tried it with another PC of mine (relatively new) and it worked. It had Crystal 2008 before so I just installed the Lawson OLEd DB.
SO now I am able to run my report (manually).

On to my next challenge: to schedule it to run automatically in LBI, and also of course: to make MM280 run automatically.

Ruma/chris/John/Everybody, Okay guys I need more Help.
I was able to schedule the report to run (in LBI). The challenge is to run MM280 in Core Lawson automatically, with the correct period.
Is there a way to automate the running of MM280? with varying Period? Or Im stuck running MM280 manually?
Please help. Thanks!