Skip to main content
Answer

Invoice Report has duplicate lines, but not sure what is causing the issue

  • September 5, 2023
  • 3 replies
  • 290 views
A
Varsity I
Forum|alt.badge.img

Hi,

 

When a client is generating an invoice from the Invoices screen (SO303000), the result shows duplicate lines.

The odd thing is that it doesn’t occur for all invoices, just a select number of them, so it could be the joins, but then it could be something else, and I am out of ideas of what I can look at.

I tried things like changing the groupings, comparing a problematic invoice with one that works, but still couldn’t find anything that would be the problem.

I have attached the report file below. Are you able to spot something that could be causing this occasional issue?

Let me know if I can provide any further information.

 

Kind regards,

Andrew

Best answer by AndrewA

Hi @dcomerford , thanks for your response. Turns out the issue was with a join between the ARTran and SOOrder tables, which led to the issue of the SOOrder and SOOrderShipment join that you mentioned. I amended both these joins and it has now been resolved.

 

Kind regards,

Andrew

1 Attachments

3 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • dcomerford
  • Captain II
  • September 5, 2023

Had a very quick look but try making these two joins a left join as if you have a BAccount with more than one location (you could use tle location in the joint) or a Sales Order with more than one Shipment then it will give duplicates.

 

Dermot Comerford
Laura03
Chris Hackett
A
Varsity I
Forum|alt.badge.img
  • AndrewA
  • Author
  • Varsity I
  • Answer
  • September 6, 2023

Hi @dcomerford , thanks for your response. Turns out the issue was with a join between the ARTran and SOOrder tables, which led to the issue of the SOOrder and SOOrderShipment join that you mentioned. I amended both these joins and it has now been resolved.

 

Kind regards,

Andrew

D
Chris Hackett
dcomerford
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 7, 2023

Thank you for sharing your solution with the community @AndrewA!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
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