Skip to main content
Answer

Reports - Combine multiple Dropship reports in one report

  • August 2, 2021
  • 3 replies
  • 187 views

deebhane
Semi-Pro I
Forum|alt.badge.img+1

Hi Team,

We have  a requirement  to print multiple dropship order into a  single reports. 

Example 

There are  three Dropship PO, where each order is having 5 items. When a report is generated, we would  like to see all the 15 items in single report / page. 

In other words, we are looking for a way to send items as a  dataset to reports for displaying all the items at once. 

Thanks 

Deebhan 

 

 

 

Best answer by Neil Cantral

Do the POs you want to display all share a the same value in a field (i.e. Vendor Ref Nbr, Sales Order Nbr, Ship-to Location, created date)? If you do have a field that is reliably unique to a batch of POs I’d recommend using that field as a parameter that is then used as a filter on the report.

Here’s an example of a report that uses the invoice batch nbr to show all invoices in a batch on a single report.

 

3 replies

Neil Cantral
Jr Varsity I
Forum|alt.badge.img+3
  • Jr Varsity I
  • Answer
  • August 2, 2021

Do the POs you want to display all share a the same value in a field (i.e. Vendor Ref Nbr, Sales Order Nbr, Ship-to Location, created date)? If you do have a field that is reliably unique to a batch of POs I’d recommend using that field as a parameter that is then used as a filter on the report.

Here’s an example of a report that uses the invoice batch nbr to show all invoices in a batch on a single report.

 


Forum|alt.badge.img+8
  • Semi-Pro I
  • August 2, 2021

hi @deebhane,   As @Neil Cantral mentioned remove the Filter in PO report that shows only the specified PO. Instead add a new Parameter for the Common reference# between these dropship orders.

Thanks


deebhane
Semi-Pro I
Forum|alt.badge.img+1
  • Author
  • Semi-Pro I
  • August 3, 2021

Thanks @niel72  and @ChandrasekharM. I understood your suggestion, we created a POC and able to get the records.