How do I report off of a "derived" field, specifically app.pmt-status?

You can add the logic of creating the derived field on your report. This is what you can do:

- login to lid
- dbdef
- select product line and AP system code
- F6 (select files)
- type in your file name: APPAYMENT
- find the field you are looking for then F6 for the definition

This is the definition:

if (open pmt) then "OPEN"
else if (paid pmt) then "PAID"
else if (draft cancel) then "CNCL"
else if (void cash) then "VOID"
else SPACES
 

Open pmt is a condition defined on the file and the way you can get the defnition is by:

.When at the file level use > F6 and optiona C for Conditions.
 

 

appayment.pmt-status is not an available field in crystal so i need to know the fields lawson used to derive the value.  how do i find that?

You have to look at Ruma's responses.
First, look at the definition of the derived field--the 'OPEN' status is based a record condition.
Second, look at the conditions assigned to that table, and it shows that "Open pmt" is:
When Rec Status < 3
Or((Cbbankinst->Bank Inst Ty = "D" )
And ( Rec Status = 4 ))

So, you would need to duplicate that logic in your Crystal report, either using Record selection or a derived field.

There's another handy way to see how a derived field is defined.  I'm a big fan of it.  It's called the Derived Field Report.  Go into LID and type 'derfldrpt'.  Sorry, it's an old-fashioned command-line utility, but its report is excellent, since it contains all of the derived fields in an entire file, or in an entire product line. 

How exactly do you do this?  Would this give me definitions for the derived fields such as current actual amount etc.

If you are using the Lawson OLEDB provider, derived fields are included.
If you are using a native provider, you have to find out how the derived field is defined, and duplicate that logic as a formula in Crystal.
Here's an example:
https://www.lawsonguru.co...te-employee-age.aspx

My issue right now is finding how the derived field is defined.  Is this information held anywhere in a LAWSON table?

We are not using OLEDB but I am thinking that may be a possibility?  Can you point me to any documentation on OLEDB versus ODBC?

Thanks,
Julia

We typically write our reports off views so anyway to access the derived fields from a view.  I know I can recreate the logic but then if the derived field changes I need to change my view and would prefer it to be seamless.

Any ideas?

Julia

most derived fields are logical, some are defined in the Lawson documentation.

You can use the Lawson command-line utility, derfldrpt.

Comparing Lawson OLE DB and ODBC methods for loading Lawson data into Crystal Reports
Article ID:126572
Description:
Can you compare the Lawson OLE DB and ODBC methods of accessing/loading Lawson data into Crystal Reports?
Resolution:
There are several methods for loading Lawson data into Crystal Reports. The two primary ways to load data into Crystal Reports are: 1.       Using the Lawson OLE DB Connector. 2.       Using a native database driver or an ODBC driver. There are appropriate times to use each of these data load methods. Use the information outlined below to help you determine which method to use in particular situations. Issues to consider when selecting a data source type: 1.       Security 2.       Speed 3.       Ease of use Lawson OLE DB for Object Services ·         Uses Lawson Security - LAUA ·         Presents Lawson relationships, conditions, and indexes ·         Allows for reporting off Lawson Reports and Forms ·         Presents derived fields from Lawson business logic ·         Slower database (DB) connection ·         Proprietary; uses DME/AGS/Xtra ·         Limited linking options ODBC / Database Driver ·         No Lawson LAUA Security; database security only ·         Requires more Lawson database knowledge ·         Allows for faster server side processing ·         Not all fields available, only database fields ·         Faster DB Connector ·         Uses Standard SQL ·         Linking by matching field names

Thank you that is useful.  One last question where can I get the Lawson OLE DB driver - do you need to download it?

Julia

sorry, don't know. I plagiarized the above from our I.T. Analyst.

Yes, the Lawson OLE DB driver is downloadable on mylawson.com. Go to My Products -> Products Available for Download and select OLE DB Object Services - S3 and Landmark.

You have to purchase the OLEDB provider; it is also included as part of LBI.

Hi,

I am new to Infor and I was wondering if 'derfldrpt' works in Landmark as well as it does in Lawson? Wheni I went into LID and typed the command on the S3 test database I got what I expected. However when I tried the same command on the Landmark test server I kept getting the message 'ksh: derfldrpts: not found'. I have spoken with the Unix guys and they do not have an explanation. I would appreciate any help you could give me because I really need to know the logic behind the derived fields.

Thanks

Regenia

Regenia, I think you would need to use the Landmark configuration console and look at what are called "calculated fields".