Solved

Output error with GI


Userlevel 1
Badge

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.

icon

Best answer by Naveen Boga 28 June 2022, 18:41

View original

4 replies

Userlevel 7
Badge +17

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.

 

 

Userlevel 1
Badge

@Naveen Boga , here is the xml.

Userlevel 5
Badge +1

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

 

Userlevel 7
Badge +17

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


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