News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... GP 18.3 recurring GL b...

Finance | Project Operations, Human Resources, ...

Unanswered

GP 18.3 recurring GL batch error when posting 'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.'

(0) Share

Report

Report

Posted on by Kaylasch

245

Upgraded to GP 18.3, and now intermittently when the customer posts a recurring GL batch, they get the following messages:

[Microsoft][SQL Server Native Client 10.0][SQL Server] Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.’

The stored procedure aagCreateRecordsInaaGL returned the following results: DBMS: 512

They have AA installed. This happens across multiple companies, but cannot be reproduced on demand.

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (0)

Becky Berginski on at

Like (0)

Report

RE: GP 18.3 recurring GL batch error when posting 'Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.'

Hello Kaylasch,

Thank you for using Community Forums. My name is Becky and I will assist you.

This usually indicates some type of corruption in the data, most often a special character in an ID field.

This will require looking at your data. I suggest you open a support incident so your data can be reviewed.

Becky

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans