Skip to main content

There is a customized field named "New Discount Code" in the Details section of the invoice. There is a requirement to get the summation of this new "New Discount Code" discount amount with the Discount amount in the Discount tab to the Invoice report. Please check the attachments. Can I know if is it possible?

Discounts in details section
Discounts in discounts tab

I have tried some ways by creating a sub-report. But the expected outcome was not coming. I joined the two tables as follows. Please check the below attachment.

Table Joining in report designer

And grouped by the ARInvoiceDiscountDetail.DiscountID]. The output of the sub report as follows.

Sub report output

Left side of the report shows the discounts in the details section and right side shows the discounts in the discounts tab. But the discount named “SPRING” is missing in the above report. So can I know if is there another way to get the summation of these discounts into the report discount code vise separately?

@malinthawarnakulasooriya08 - were you able to find a resolution to your question above? We are in need of performing this task as well. 


Hi @cihainu,

Yes. As per the requirement, we created some SQL views. For creating custom SQL views, we added some SQL scripts in the Database Scripts section of the Customization Project Editor. Then we were able to grab data for a sub-report by using these created Views and applying some manipulations.

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/   


Reply