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
Comments
0 comments
Please sign in to leave a comment.