Assistance Required with Report Configuration and Data Accuracy


Hello Community,


I'm currently working on generating a printable report formatted as a table. I've successfully linked the detailed information to the main object report. However, I have a couple of questions:

  1. Do I need to use out-of-the-box columns to retrieve data, or can  the report just include custom fields?
  2. Most of my custom fields populate correctly, but I'm encountering an issue with the 'Supplier' column, which is a lookup linked to the Account section. I've verified the database to confirm the data is correct, so I'm puzzled about the problem here.

I'm including images of the report setup and output, along with the data that should appear in the printable version.

The main object in the report is "Purchase Approvals," and the supplier location can be either Local or Foreign.




Below is what the output should be like in the supplier name 

Like 0




1. You can add any column to the report, both OOTB and custom.

2.1. We recommend that you try to re-add the table to the report and check the behavior again, perhaps the problem is in the incorrectly displayed table.

2.2 Check that there are no columns with the same titles in the table you are displaying, you may be displaying different columns.

If the problem is still present, we recommend contacting technical support,

I hope this helps to solve the problem.

Best regards,

Show all comments