Skip to main content
Solved

FBQL-Statement does not work in newer version. What am I doing wrong?

  • December 8, 2022
  • 4 replies
  • 109 views
L
Freshman I

 I wanted to show the sums by InventoryItem on screen CR304000, using the following view.

public SelectFrom<CROpportunityProducts>.LeftJoin<InventoryItem>.On<InventoryItem.inventoryID.IsEqual<CROpportunityProducts.inventoryID>>.LeftJoin<INItemClass>.On<InventoryItem.itemClassID.IsEqual<INItemClass.itemClassID>>.Where<CROpportunityProducts.quoteID.IsEqual<CROpportunity.quoteNoteID.FromCurrent>>.AggregateTo<GroupBy<INItemClass.descr>, GroupBy<INItemClass.noteID>, Sum<CROpportunityProducts.curyExtPrice>>.OrderBy<INItemClass.descr.Desc>.View InventoryClassSummed;

This worked fine in a previous version, but now I get an error message:

Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.

Does anyone know, why this does not work anymore?

Best answer by Fernando Amadoz

 @larabierbaum please test this simplified version of a customization package.

Make sure your package is not published, and any customized DLL references are removed.

Let me know if this package produces the error too.

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

4 replies

Fernando Amadoz
Jr Varsity I
Forum|alt.badge.img+2

@larabierbaum 

In which Acumatica version are you getting the error?
I just tested it in 22.204.0019 and got published without issues.

L
Freshman I
  • larabierbaum
  • Author
  • Freshman I
  • 4 replies
  • December 8, 2022

@Fernando Amadoz 
I’m using version 22.114.0029. I don’t get an error at publishing either but when I try to view the screen CR304000.

Fernando Amadoz
Jr Varsity I
Forum|alt.badge.img+2

 @larabierbaum please test this simplified version of a customization package.

Make sure your package is not published, and any customized DLL references are removed.

Let me know if this package produces the error too.

1 Attachments
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
L
Freshman I
  • larabierbaum
  • Author
  • Freshman I
  • 4 replies
  • December 9, 2022

@Fernando Amadoz 
Okay, so I used your package and added the grid on the screen and it does work in normal Acumatica. It’s probably an error in the German version then.
Thank you for your help

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
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