Skip to main content
Solved

How to resolve the duplicate lines issue when customized the AR invoice/memo report?

  • 28 December 2022
  • 5 replies
  • 247 views

Forum|alt.badge.img

Hi,

I have customized the AR invoice report using acumetica report builder.

I want to add bank details of the relevant invoice details in AR invoice report.

In this case we customized existing standard AR Invoice report with adding cashaccount payment details table.I joined the cash account table and cashaccount payment method details table below like that.

 

Before the joining report output is shown like that.

 

But, After the cashacount table and cashaccount payment method detail table are joining .Report’s item details lines are duplicated.

 

Can you help to remove above duplication.

Best answer by Raj Gopinathan

Hi @jeewanishalika20 

Attached herewith is the updated report definition file.

A couple of changes I made:

  • Updated Relationships in the Build Schema section. 
  • Added a Filter on CashAccountPaymentMethodDetail.DetailID to get the Account Number as shown in screenshot below (based on SalesDemo data). Please update the filter to meet your requirement.
  • Removed the additional grouping I suggested earlier.

Hope this helps.

 

 

 

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • December 28, 2022

Hi @jeewanishalika20 

Please attach the .rpx file of your customized report to check this further.

Regards,


Forum|alt.badge.img

Hi VijayKumarU,

Here i have attached my rpx file with zip file for your reference

Thank you


Forum|alt.badge.img

Use grouping… Try adding another Grouping for Payment Method ID.


Forum|alt.badge.img

Hi @Raj Gopinathan ,

We already have ‘groupinvoice’ group with existing report.

As you said I added the payment method detail column field into this groupinvoice group.

Now Report line items are not duplicated.

But still full report is duplicated.

Above highlighted invoice number is duplicated few times.

Below I have added my report designer view for your reference.

 

Can you help resolve this issue.


Forum|alt.badge.img
  • Jr Varsity II
  • 23 replies
  • Answer
  • December 29, 2022

Hi @jeewanishalika20 

Attached herewith is the updated report definition file.

A couple of changes I made:

  • Updated Relationships in the Build Schema section. 
  • Added a Filter on CashAccountPaymentMethodDetail.DetailID to get the Account Number as shown in screenshot below (based on SalesDemo data). Please update the filter to meet your requirement.
  • Removed the additional grouping I suggested earlier.

Hope this helps.

 

 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings