Skip to main content
Answer

Combine report for multiple sales order

  • May 25, 2023
  • 2 replies
  • 163 views

param2022
Jr Varsity II
Forum|alt.badge.img

How can we combine all the sales order report (so641010) within a specific date range. I want to merge so641010 report based on a date range on order date. If five order are placed on a particular date I want all 5 report for individual sales order (so641010) to be combined in a single one. Any ideas how it can be achieved ?

Thanks

Best answer by Naveen Boga

Hi @param2022  Below post will be useful in terms of combining the multiple reports.

In case of your requirement, you just need to loop through all the orders and get the report and combine them.

 

 

Hope this helps!

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • May 25, 2023

Hi @param2022  Below post will be useful in terms of combining the multiple reports.

In case of your requirement, you just need to loop through all the orders and get the report and combine them.

 

 

Hope this helps!


miguel80
Semi-Pro III
Forum|alt.badge.img+3
  • Semi-Pro III
  • May 29, 2023

Hi,

I would copy the report as a new one and change the parameters from “OrderID” to a date range. If you leave it at that you will get a report that lists every sales order in a separte format. If you want everything listed together then you can proceed to change the grouping condition and modify the details so that it is presented the way you want it.

If you think this might work, we can explore it further.