Subreport works for Invoices but not Credit Memos
Our AR Invoice report uses a subreport to get the descriptive information to print in the body of the Invoice. We do not print the description from every line item and in the case of Invoices with Installment Terms, we print the information from the master invoice on the child invoices instead of the one line description that is on the generated child invoices.
The subreport works just fine for Invoice type documents. For Credit Memos, the subreport prints blanks. I thought it might be that the parameters passed to the subreport might not be working correctly, but in my testing, I was not able to identify if that was the cause or not. I modified the sub report to print the parameters, but couldn't get that to work either.
Hit a dead end. Looking for ideas on how to diagnose the problem.
Can you attach the .rpx file?
Invoice and subreport attached.
Finally got a chance to look at this again. ALL CRMs in the database have NULL as the value for MasterRefNbr. Any other ideas?
The only other thing that I can think of is the filter in the subreport. Are you sure that Credit Memos have COMMENT items on them?
Hmmm, so it definitely has to do with passing the parameters.
Using the same CRM that you tested with, can you try changing the formula below temporarily to remove the IsNull so it only has the following:
Also, if you could email me credentials to the environment that you are using, I could try testing on my end.
Thanks for sharing. I guess that makes sense.
=[@DocType] was probably passing something like "Credit Memo" and =[ARInvoice.DocType] was probably passing something like "CRM".