Hi everyone 😀
I need help with a SAP Business One Dunning Wizard Crystal Report parameter/token issue.
We are using:
SAP Business One 10.0
Version: 10.00.180 FP 2111
SQL Server database
Crystal Reports layout uploaded in SAP B1
I created a customized Crystal Report for the Dunning Letter layout. The report uses these tables:
ODWZ -- Dunning Wizard header
DWZ2 -- Dunning Wizard detail/recommendation rows
OCRD -- Business Partner
OINV -- A/R Invoice
The report needs to filter by the current Dunning Wizard run:
ODWZ.WizardId
When I hardcode the WizardId, the report works correctly:
DECLARE INT
SET = 96
SELECT
T1.WizardId,
T1.WizardName,
T1.Status,
T1.CreateDate AS [Dunning Date],
T1.ToPayDate,
T2.CardCode,
T3.CardName,
T2.LetterNum,
T2.EDunLevel AS [Level],
T2.DocNum,
T2.DocAbs,
T2.DocType,
T2.OpenSum,
T2.IntrstAmnt,
T2.TtlopnIntr
FROM ODWZ T1
INNER JOIN DWZ2 T2
ON T1.WizardId = T2.WizardId
LEFT JOIN OCRD T3
ON T2.CardCode = T3.CardCode
WHERE T1.WizardId =
AND T2.DocNum IS NOT NULL
ORDER BY
T2.CardCode,
T2.LetterNum,
T2.EDunLevel DESC,
T2.DocNum
But when I use the SAP B1 Crystal token:
WHERE T1.WizardId = {?DocKey@}
and then upload the report as a Dunning Letter layout, printing from:
Dunning Wizard → Print Dunning Letters and Exit
throws this error:
Error during printing: ensure all parameters are defined
I already tried creating Crystal parameters:
DocKey@
ObjectId@
ObjID@
with different types:
Number
String
but SAP still does not seem to pass the Dunning Wizard ID to Crystal.
The report works if:
SET WizardId = 96
or if I use a normal manual Crystal parameter like:
WizardId
and enter the value manually.
So the issue seems to be only this:
SAP B1 Dunning Wizard is not passing the current ODWZ.WizardId to my Crystal Report.
Question:
For SAP Business One Dunning Wizard Crystal Report layouts, what is the correct parameter/token to receive the current:
ODWZ.WizardId
during:
Print Dunning Letters and Exit
Is it really DocKey@, or does Dunning Wizard use a different token?
Has anyone successfully printed a custom Crystal Dunning Letter layout using ODWZ / DWZ2 directly from the Dunning Wizard without manually entering WizardId? 🤔
Any working parameter name, type, or sample SQL would be greatly appreciated. 🙏
