Solved

Duplicated line items

  • 12 January 2023
  • 2 replies
  • 48 views
P
Rank
Userlevel 3
Badge +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!

icon

Best answer by paula012 23 January 2023, 07:39

View original
1 Attachment

2 replies

P
Rank
Userlevel 3
Badge +1

👍🏻

miguel80
Rank
Userlevel 5
Badge +1

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.

Miguel Q

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