By using this website, you agree to our Terms of Use (click here)
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?
At first glance, are you sure that it works if MasterRefNbr in the screenshot below is blank, but not null?
I'm wondering if it could be blank on a Credit Memo and a blank value gets passed to the Subreport since technically it isn't NULL.
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?
I tested the subreport using "/Frames/ReportLauncher.aspx?ID=AR641005.rpx". When I ran it with a CRM that had a COMMENT item code, it did return data in the subreport correctly. When I ran the main report for the same CRM, no data in the subreport. Again, it works fine for INV documents.
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:
=[ARInvoice.RefNbr]
Also, if you could email me credentials to the environment that you are using, I could try testing on my end.
Acumatica support found the answer. Here are the parameters I was passing to the subreport from the main:
DOC TYPE "=[ARInvoice.DocType]"
REF NBR "=IsNull( [ARInvoice.MasterRefNbr], [ARInvoice.RefNbr] )"
Here's what works:
DOC TYPE "=[@DocType]"
REF NBR "=IsNull( [ARInvoice.MasterRefNbr], [@RefNbr] )"
@dws253 Thanks for offering this solution! We got our subreport to show credit memo data, so thank you!
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".