Skip to main content
Answer

Output error with GI

  • June 28, 2022
  • 4 replies
  • 59 views
K
Freshman I
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.

 

 

 

 

Kemp

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 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.

 

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
K
Freshman I
Forum|alt.badge.img
  • KempOdell68
  • Author
  • Freshman I
  • June 28, 2022

@Naveen Boga , here is the xml.

1 Attachments
Kemp
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. 

 

Vinay Koppula
Chris Hackett
K
Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Naveen Boga
  • Captain II
  • 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.

 

 

 

 

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Chris Hackett
K
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved