Skip to main content
Solved

Output error with GI


Forum|alt.badge.img

Still trying to fully understand the workings of the GIs.

I have a GI that is working in our sandbox system, but when I create it in our live system, I receive the following error:

 

Any assistance on this would be greatly appreciated.

Best answer by Naveen Boga

Hi, @KempOdell68  As I informed you earlier, please add the aggregate function i.e.SUM to the Debit Amount column, which will solve the problem.

 

Please find the screenshots for reference.

 

 

 

 

View original
Did this topic help you find an answer to your question?

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • June 28, 2022

Hi @KempOdell68  It seems you missed the Aggregate Function in the Results tab. 

If this does not solve the problem, please share the XML format of the GI.

 

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 24 replies
  • June 28, 2022

@Naveen Boga , here is the xml.


Vinay Koppula
Semi-Pro II
Forum|alt.badge.img+1

@KempOdell68 I just reviewed your XML and observed that the issue is with Debit Amount Column. 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • Answer
  • June 28, 2022

Hi, @KempOdell68  As I informed you earlier, please add the aggregate function i.e.SUM to the Debit Amount column, which will solve the problem.

 

Please find the screenshots for reference.

 

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings