Solved

Only one Charge on Invoice report; should be multiple

  • 1 February 2022
  • 1 reply
  • 63 views

Userlevel 3
Badge +6

Hi all, 

 

I have a customer order that has two charge lines. 

 

Only one the top charge type is appearing on the Invoice operational report. I am using the stock IFS fields for the Charge_type and Charge_Description on my report.

 

Is there a way for me to show both on the customer invoice report?

 

Thanks, 

 

Eli Williams

icon

Best answer by Tracy Norwillo 3 February 2022, 16:32

View original

This topic has been closed for comments

1 reply

Userlevel 4
Badge +11

It’s not clear whether your issue is with one of the invoice reports provided by IFS or if you created a custom report on your own.   

I’ll start with the easiest:

If you created your own layout, a common reason why you’d only see the first record is not placing the field in a table that repeats at the proper level. 

If it’s an issue with one of the provided invoice reports, then I’d first take a look at the report data, typically available in a view with the same name as the Report ID. These views will have the results of report runs identified by a unique result_key.

If only one charge is in the view, take a look at the invoice itself to see why the record is not sent to the report. 

If both charges are present, I’d then look for conditions in the appropriate layout section to see if there is a table or row condition that may be suppressing records based on a certain condition. 

If it’s an issue with conditions, you’d need to circle back to the actual invoice and seek to understand why the record is set to not appear on the report.