AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Report Sales Orders...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Report Sales Orders with duplicate "Customer Order NBR."

Acumatica Report Designer
Last Post by LT8675309 5 months ago
8 Posts
2 Users
4 Likes
310 Views
RSS
LT8675309
Posts: 14
 LT8675309
Topic starter
August 26, 2022 4:30 pm
(@ltussing)
Member
Joined: 1 year ago

Hello,

I need to write a report (or GI) that allows me to report if there are more than 1 sales order in Acumatica with the same “Customer Order Nbr.”

I have done similar things a million times in other reporting tools, but I do not know of a method to accomplish this with Acumatica’s report writer.

So I need to run through the SO’s and report Acumatica sales orders and their associated “Customer Order Nbr”, but only if multiple sales orders have the same “Customer Order Nbr.”. 

Anyone have any ideas?

Thanks!!!!

Tim Rodman reacted
7 Replies
Andrew Garcia
Posts: 4
 Andrew Garcia
August 29, 2022 8:11 am
(@agarcia)
Member
Joined: 7 months ago

Not a report, but you could do a version of this by:

1. Grouping results by "Customer Order Nbr."

image

2. Set the "Order Nbr." to aggregate "Count"

image

3. Create a Side Panel for the SO "PL" screen using the Customer Order Nbr. as a filter

image

To achieve something like this:

image

 

Hope this helps. Best of luck!

Reply
LT8675309 reacted
LT8675309
Posts: 14
 LT8675309
Topic starter
August 29, 2022 8:30 am
(@ltussing)
Member
Joined: 1 year ago

Andrew,

Thank you so much for taking the time to respond and for the detailed explanation with screen shots!

This will certainly come in handy in the future.

However, for this requirement, we will have hundreds of Sales Orders and cannot manually run through each looking at a side panel to see if there are duplicates.

I really need the ability to just show/report if there is more than one Acumatica Sales Orders with the same "Customer Order Nbr".

Again, I really appreciate your advice and time.  I just don't think this will give them what they need.

Reply
Andrew Garcia
 Andrew Garcia
(@agarcia)
Joined: 7 months ago

Member
Posts: 4
August 29, 2022 8:51 am
Reply toLT8675309LT8675309

@ltussing No problem at all. Are you looking for a count of all sales orders that share a Customer Order Nbr? Or do you need the detail of which Acumatica Sales orders share a customer number? I can think of a way to see a total count of SOs that share a Customer Order Nbr with at least one other SO, but as far as seeing the detail of what specific SO numbers share a specific Customer Order Number...that could be bit more difficult. Maybe a Pivot Table.

Reply
LT8675309
Posts: 14
 LT8675309
Topic starter
August 29, 2022 8:59 am
(@ltussing)
Member
Joined: 1 year ago

Andrew,

Thank again for taking the time to reply!

I really appreciate you!

 

I need to identify either the "Customer Order Nbr" that is used multiple times so they can search on the Acumatica Sales Orders based on that and delete the duplicate orders.

Or the list of Acumatica Sales Orders with duplicate "Customer Order Nbr" AND report the associated "Customer Order Nbr"

The goal here is to easily identify Acumatica Sales Orders with the same "Customer Order Nbr" so the duplicate orders can be deleted.

Reply
Andrew Garcia
Posts: 4
 Andrew Garcia
August 29, 2022 10:17 am
(@agarcia)
Member
Joined: 7 months ago

@ltussing Oh, I understand. If it were me, I would use the GI that I described before and then create a Shared Filter where the count of the "OrderNbr" field is greater than 1. This will only show you SOs that share a Customer Order Nbr. I'd delete the duplicates using the Side Panel. For monitoring, I'd probably drop a KPI Card on a dashboard that shows the count of results in that GI.

image

^ Shared Filter ^

image

^ Dashboard Card ^

image

^ Dashboard Card Settings ^

If you wanted to get fancy with it, you could only show duplicates of "Open" SOs by replacing the SOOrder.OrderNbr field with the formula:

=IIf ([SOOrder.Status] = 'N', [SOOrder.OrderNbr] , null )

 

Best of luck!

Reply
LT8675309
Posts: 14
 LT8675309
Topic starter
August 29, 2022 5:04 pm
(@ltussing)
Member
Joined: 1 year ago

Andrew, I haven't had time to try this yet but feel confident since you provided such excellent documentation.

Thank You!!!!

I will reply to let you know when I have been successful.

I just didn't want to let this sit without responding since you were so great about responding so quickly to me.

THANK YOU!!

Reply
Andrew Garcia reacted
LT8675309
Posts: 14
 LT8675309
Topic starter
August 30, 2022 10:30 am
(@ltussing)
Member
Joined: 1 year ago

Andrew,

I was able to get this working today and it is exactly what I needed!!!

THANK YOU FOR TAKING THE TIME TO ANSWER!!!!

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 8 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×