Skip to main content
Answer

Duplicated line items

  • January 12, 2023
  • 2 replies
  • 95 views

Forum|alt.badge.img+1
A
B
C

Hello,

Somebody please help,

Above here is a caption of my report details for SO. These are details of only 1 SO. In A and B, you could see that I have fields with redundant data- the same gross amt, total/item, invoice nbr, and unit price. But the [net sales] in A shows that they’re not the same inventory item, which is also shown in C, they are two totally different item. But why is my report using only the first inventory item details (except net sales)? Anyone who has an idea, please?

If this would be needed, please kindly see my report file to view tables and relationships. I appreciate the big help!

Best answer by paula012

👍🏻

2 replies

Forum|alt.badge.img+1
  • Author
  • Semi-Pro II
  • Answer
  • January 23, 2023

👍🏻


miguel80
Semi-Pro III
Forum|alt.badge.img+3
  • Semi-Pro III
  • January 30, 2023

Hi,

First thing that I would suggest is to add OrderType to these relations in the report:

  • ARTran - SOOrder
  • SOOrder - SOOrderShipment

Also, this relationship seems weird to me:

Because you’re using a field from the same table (SOOrder).

 

I hope this helps.