Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Bank statement : Error on BeginningBalance when creating a bank statement with empty BankAccount field

Description

GridField.defaultFromSQLExpression: (BeginningBalance) - Default SQL variable parse failed: @SQL=SELECT COALESCE(MIN(CurrentBalance),0) FROM C_BankAccount WHERE C_BankAccount_ID=@C_BankAccount_ID@

Environment

None

Attachments

1

Activity

Show:

Nicolas Micoud March 5, 2018 at 9:23 AM

Default value is @SQL=SELECT COALESCE(MIN(CurrentBalance),0) FROM C_BankAccount WHERE C_BankAccount_ID=@C_BankAccount_ID@

Is should be
@SQL=SELECT COALESCE(MIN(CurrentBalance),0) FROM C_BankAccount WHERE C_BankAccount_ID=@C_BankAccount_ID:0@

Fixed

Details

Assignee

Reporter

Labels

Priority

Created March 5, 2018 at 9:20 AM
Updated May 1, 2018 at 1:46 PM
Resolved March 5, 2018 at 8:23 PM