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 :)
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 @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 @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.
@manikantad18 Thank you. I’ll take a look
Thank you @manikantad18. I will try this.
Thanks very much for the help @manikantad18 and @Laura02.So if i join ARTran to ARInvoice, should I be able to display [ARTran.InventoryID] ?
Hi @dcomerford,Thank you for your explanation. appreciate your help.
Do not know why… but restarting the computer solved the issue for me.
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
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?
these are all the fields that show that number. no field contain Clnt().
Hi @darylbowman Did you mean this one?=[APPayment.CuryOrigDocAmt]
Hi @darylbowmanIs there a workaround to solve this problem that you know of using report designer?Thank you.
Hi @darylbowman, These are the Messages from the report. Thank You.
Hi @sweta68 Please find the report attached below. kindly rename the filename extension.Thank you.
Hi @manikantad18 ,I will try that way. thank you.
Hi @meganfriesen37,Thank you. I will try that.
Hi @DavidEichner,Thank you for the guidance. I will try that way.thanks again,regards.
Hi @BenjaminCrisman! yes, we have tried that as well. but still results are the same!!!
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.
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.