Remove hardcoded values for InfoInvoiceWindow (BPartnerID / IsSOTrx) and InfoPaymentWindow (IsSOTrx)

Hi ,
The patch removes hardcoded values and replace them with default values on the InfoColumn

Regards,

Nicolas

hi

After upgrade to 7.1z we recognize frequent parsing error message in log, would be greate fix it.

GridField.defaultFromSQLExpression: (IsVendor) - Default SQL variable parse failed: @SQL=SELECT CASE '@IsSOTrx@' WHEN '' THEN '' WHEN 'N' THEN 'Y' ELSE 'N' END AS DefaultValue FROM DUAL [322]

thanks.
norbert

Hi

looks me there is oracle syntax? (i mean DUAL) in Postgres migration scripts.

norbert

Hello Norbert,

AFAIR, the table DUAL has been added years ago in PG schema, so migration script can be registered using the same query

Nicolas

Hello Nicolas.

thanks. an error log is reproducible in the latest 7.1z test.idempiere.org - then another parsing issue exists.

GridField.defaultFromSQLExpression: (IsVendor) - Default SQL variable parse failed: @SQL=SELECT CASE '@IsSOTrx@' WHEN '' THEN '' WHEN 'N' THEN 'Y' ELSE 'N' END AS DefaultValue FROM DUAL [322]