Solved

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

  • 28 December 2022
  • 5 replies
  • 210 views
J
Rank
Userlevel 3
Badge

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.

icon

Best answer by Raj Gopinathan 29 December 2022, 18:40

View original

5 replies

V
Rank
Userlevel 7
Badge +11

Hi @jeewanishalika20 

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

Regards,

VijayKumarU
J
Rank
Userlevel 3
Badge

Hi VijayKumarU,

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

Thank you

1 Attachment
R
Rank
Userlevel 3
Badge

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

J
Rank
Userlevel 3
Badge

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.

R
Rank
Userlevel 3
Badge

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.

 

 

 

1 Attachment

Reply


Terms & ConditionsCookie settings
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