Hi @BenjaminCrisman! We used a sub report to get those line details and now it’s working fine. but we couldn’t find the root cause for that issue. thanks for the comment.
Hi @BenjaminCrisman! yes, we have tried that as well. but still results are the same!!!
Hi @DavidEichner,Thank you for the guidance. I will try that way.thanks again,regards.
Hi @meganfriesen37,Thank you. I will try that.
Hi @manikantad18 ,I will try that way. thank you.
Hi @sweta68 Please find the report attached below. kindly rename the filename extension.Thank you.
Hi @darylbowman, These are the Messages from the report. Thank You.
Hi @darylbowmanIs there a workaround to solve this problem that you know of using report designer?Thank you.
Hi @darylbowman Did you mean this one?=[APPayment.CuryOrigDocAmt]
these are all the fields that show that number. no field contain Clnt().
Hi @darylbowman in the reportFooterSection2 there is a variable that contains Clnt()used to display the Amount in words. is there a way i could fix this?
Hi @darylbowman I was able to resolve the issue by replacing the CInt() with CDec(). thank you for your guidance. didn’t know where to look :) Thanks again.Regards
Do not know why… but restarting the computer solved the issue for me.
Hi @dcomerford,Thank you for your explanation. appreciate your help.
Thanks very much for the help @manikantad18 and @Laura02.So if i join ARTran to ARInvoice, should I be able to display [ARTran.InventoryID] ?
Thank you @manikantad18. I will try this.
@manikantad18 Thank you. I’ll take a look
Hi @Sagar Greytrix, Thank you for replying. Since this is a pop-up window, there's no "Tools" option available. However, if I close the window and trace it from tools, there are no errors showing.
Hi @jinin, thank you for the reply. This record comes from the Service Contracts screen. Even when creating these records, there are no errors shown.
HI,case update: we have found that the error is coming from a field in Customers -> GL Account by tracing back to every form that we can think of.Thank You.
Hi @kudzaim20, one way is that you can use a sub-report to get tax records to display in the main report.define desired fields (TaxID and TaxAmount). and put the sub-report into your main report. here is the result. then you can use your formula to get the sum and add to the total. hope this helps :)
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.