Query to get Fixed assets in v10

Do you have access to the 4GL code? if yes, ask users to identify the forms/reports (AM20.2, AM270 etc.) that has this information. You can then look at the code to figure out where the information is coming from.

Do you have access to IP designer? You can use the BUILD function in the Query node to look at the table fields and related tables. This assumes you know the primary table that is being referenced ( I think AMASSET in this case).

If you bring up a screen in Portal, place cursor in a field, CTRL - SHIFT - O, will give you some idea (does not work all the time) of which DB field the information is coming from.

There is usually documentation available showing all the tables updated/referenced by a form or report. For example: https://www.lawsonguru.co...0/programs/AM20.html

Thank you Raghu!!

I don't have access for 4GL. Do you know what are all forms we need to look for these fields?

Here is the documentation
https://docs.infor.com/he..._10.0.x%2Findex.html


I would start with AM20 and look at related forms. Or ask somebody from the Finance department that uses the AM module. They should know which forms/reports they use.