Skip to main content
Answer

2022 R2 build Multiple Generic Inquiries Error: incorrect syntax n ear '1000'. Incorrect syntax near ')'.

  • May 22, 2023
  • 2 replies
  • 122 views

Forum|alt.badge.img

I installed the 2022 R2 build on my local Demo install and we also have it in an upgrade sandbox we are testing.  I have several Generic Inquiries that came with Acumatica that all have similar errors.

Error:  incorrect syntax n ear '1000'.  Incorrect syntax near ')'.

  • Reclassifications by Period
  • Unprocessed GL Transactions with High Scores
  • Open Anomalies by Confidence

What needs to be done to get these errors to go away?  Is something not enabled that should be with this new release?

 

Best answer by hkabiri

@sheilao08  These GIs are related to Anomaly Detection which require the GL Anomaly detection feature enabled and score being calculated. All these GIs should have a condition for the ML Score which is not calculated. You can ignore them or have it added to the license and check it.

2 replies

hkabiri
Acumatica Moderator
Forum|alt.badge.img+8
  • Acumatica Support Team
  • Answer
  • May 22, 2023

@sheilao08  These GIs are related to Anomaly Detection which require the GL Anomaly detection feature enabled and score being calculated. All these GIs should have a condition for the ML Score which is not calculated. You can ignore them or have it added to the license and check it.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • May 22, 2023

@hkabiri Thank you, I figured it may be related to some new features and need to be enabled for it to work. Thank you.