Skip to main content
Solved

Duplicate Sales Order Created


Forum|alt.badge.img
  • Jr Varsity III
  • 65 replies

Hello, 

We have noticed after creating a sales order that a duplicate is now showing up. It has all the exact same information. Same Reference number, same shipment number, same payment information. 

I added a note to one of the orders and it showed up on both orders, so they are linked together somehow. Therefore, I don’t want to try and just delete one, since it will most likely delete both. 

However, when I look at the customer account, only one order shows up. 

 

Does anyone have any ideas on how to address this duplicate order issue? 

 

Thank you!

Best answer by brendan91

The order is showing up on this generic inquiry twice because of some minor issue with the generic inquiry. You may have 2 payments on the order or some other field that can have multiples. 

A quick fix is to group the GI on the order number. 

 

View original
Did this topic help you find an answer to your question?

6 replies

brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • Answer
  • April 6, 2023

The order is showing up on this generic inquiry twice because of some minor issue with the generic inquiry. You may have 2 payments on the order or some other field that can have multiples. 

A quick fix is to group the GI on the order number. 

 


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@bclark , the issue is with your generic inquiry that shows a list of orders. That generic inquiry probably has another table added (like SOLine). Hence, the data can be duplicated (triplicated, quatricated, etc.)

If you can go to Customization > Edit Generic Inquiry on the Sales Orders list screen, and then share a screenshot of the RELATIONS tab, I would be able to give you more precise info.


estebanperalta54
Captain II
Forum|alt.badge.img+4

Hi @bclark this looks like there is an issue your Sales Order GI. If you export your GI as XML and share it with we can explain why it’s duplicating.


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • April 6, 2023

Thanks everyone for the quick replies. 

@Yuri Karpenko  here is the screenshot of the Relations tab: 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 65 replies
  • April 6, 2023

@estebanperalta54  Here is the XML export. 


Yuri Karpenko
Captain II
Forum|alt.badge.img+6

@bclark , thank you! Based on this screenshot, it can be a number of things, but most probably, you have duplicates because of ARPayment or SOAdjust.

Unless you really need ARPayment and SOAdjust in this GI, I would recommend removing them. If you do need them though, go to GROUPING tab, and set up grouping by SOOrder.OrderType and SOOrder.OrderNbr.

Hope this helps.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings