Skip to main content
Answer

Packing slip duplicate line are appearing

  • May 6, 2024
  • 6 replies
  • 146 views
P
Varsity I
Forum|alt.badge.img

Hi,

I'm seeking assistance with an issue regarding duplicate lines generated in the packing slip report. The problem arises when linking the ARTran table to the SOOrderShipment table.

I have attached the packing slip report for reference. Could someone please provide guidance on resolving this issue?

 

Thank you in advance for your assistance.

Best answer by ejmillar

The table SOOrderShipment is the table which is causing duplicates.

If you delete the following relationships the duplicates will be removed:

SOOrder Left Join SOOrderShipment

ARTran Inner Join SOOrderShipment

 

SOShipment should join to SOOrderShipment on the following:

ShipmentType, ShipmentNbr

 

 

6 replies

P
Varsity I
Forum|alt.badge.img
  • psoni1585
  • Author
  • Varsity I
  • May 6, 2024

Hi,

 

I’m not able to attach file and it’s giving this message. how can i attached the .rpx or zip file

 

 

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @psoni1585 Please try below suggestions once 

 

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
P
Varsity I
Forum|alt.badge.img
  • psoni1585
  • Author
  • Varsity I
  • May 6, 2024

Hi @manikantad18 ,

 

Thanks

I’ve changed the join as per your advice, but still it’s print duplicate lines in the report.

 

 

 

P
Varsity I
Forum|alt.badge.img
  • psoni1585
  • Author
  • Varsity I
  • May 6, 2024

Hi @manikantad18,

 

I’ve attached packing slip rpx file for your reference.

Appreciate your help.

 

Thanks 

1 Attachments
ejmillar
Varsity II
Forum|alt.badge.img+1
  • ejmillar
  • Varsity II
  • Answer
  • May 6, 2024

The table SOOrderShipment is the table which is causing duplicates.

If you delete the following relationships the duplicates will be removed:

SOOrder Left Join SOOrderShipment

ARTran Inner Join SOOrderShipment

 

SOShipment should join to SOOrderShipment on the following:

ShipmentType, ShipmentNbr

 

 

Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
Manikanta Dhulipudi
Chris Hackett
charliefitzgerald13
P
Varsity I
Forum|alt.badge.img
  • psoni1585
  • Author
  • Varsity I
  • May 8, 2024

Hi @ejmillar,

 

Appreciate your help

Now this issue has been solved after changing the join to SOShipment and SOOrderShipment.

 

Thanks :-)

Chris Hackett
ejmillar
Terms & ConditionsCookie settingsAccessibility statement
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