Solved

Packing slip duplicate line are appearing

P
Rank
Userlevel 3
Badge

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.

icon

Best answer by ejmillar 6 May 2024, 14:18

View original

6 replies

P
Rank
Userlevel 3
Badge

Hi,

 

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

 

 

manikantad18
Rank
Userlevel 7
Badge +12

Hi @psoni1585 Please try below suggestions once 

 

Acumatica Functional Consultant
P
Rank
Userlevel 3
Badge

Hi @manikantad18 ,

 

Thanks

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

 

 

 

P
Rank
Userlevel 3
Badge

Hi @manikantad18,

 

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

Appreciate your help.

 

Thanks 

1 Attachment
ejmillar
Rank
Userlevel 4
Badge

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.~
P
Rank
Userlevel 3
Badge

Hi @ejmillar,

 

Appreciate your help

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

 

Thanks :-)

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