Skip to main content
Answer

Duplicate data when retrieving

  • October 30, 2024
  • 3 replies
  • 55 views

Forum|alt.badge.img

Good day im having a problem my record is duplicating and i cant find the reason can anyone help me
 

 

Best answer by Laura03

Hello @jhoncandare04 ,

When I compare your report to the standard AR Aging AR631000.rpx, the last tables are missing a Join field. Try adding back the highlighted join on Account and let us know whether this addition resolves the duplicates.

If the join on account is causing a different problem for you, describe the problem or the need and we will try to help you reach your goals with this report.

Laura

3 replies

Forum|alt.badge.img+8
  • Captain II
  • October 30, 2024

Hi @jhoncandare04 

 

What joins have you added to the report?

 

Aleks


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • October 30, 2024

Hello @jhoncandare04 ,

When I compare your report to the standard AR Aging AR631000.rpx, the last tables are missing a Join field. Try adding back the highlighted join on Account and let us know whether this addition resolves the duplicates.

If the join on account is causing a different problem for you, describe the problem or the need and we will try to help you reach your goals with this report.

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • October 31, 2024

@Laura02 Thank you for your help.