Question

How to get the total discount value, according to separate discount codes in the line level Details section's discount with the discount values in the Discount tab to a report?

  • 13 July 2023
  • 0 replies
  • 61 views

Userlevel 4
Badge

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?


0 replies

Be the first to reply!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved