B1UP: Acccount Balance Report fail after you turn on the 'Do not perform a 'Verify Database' on report load' option in B1UP 2018.08 or higher

For context on what "Do not perform a 'Verify Database' on report load" option is please see here

Q: How is the error presented?
A: When you use the B1 Print and Delivery - Account Balance it will show this error if you do an email action:

or if you preview it the error will look like this

Q: What is wrong?
A: This happens due to one of Account Balance data sources are doing a SELECT * FROM OCRD ... and at the same time was created on a designed against a database that has some UDFs on OCRD table that your customer's system does not have.

+

Q: How to fix it?
A: Please open the Crystal Report in the Report Designer and edit the data source. Instead of SQL statement SELECT * FROM OCRD WHERE CardCode = '{?CardCode}' write

MSSQL

SELECT
T0.CardCode,
T0.CardName,
T0.Address,
T0.ZipCode,
T0.City,
T0.Country,
T0.LangCode,
T0.Currency
FROM OCRD T0
WHERE T0.CardCode = '{?CardCode}'

HANA

SELECT
T0."CardCode",
T0."CardName",
T0."Address",
T0."ZipCode",
T0."City",
T0."Country",
T0."LangCode",
T0."Currency"
FROM "OCRD" T0
WHERE T0."CardCode" = '{?CardCode}'

***

NB: THis is fixed automatically in the new Out of the Box Crystal in B1UP 2018.08 and higher