Ad Hoc reports functionally useless!

  • 1
  • Problem
  • Updated 3 years ago
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Old

Company: Allison Reed

There's the "Business report" and the "EDI Report"
  • The Business version shows me an 'invoice' and an 'ASN', and shows the invoice# and Shipment ID under Document ID and says it's "completed"- which means nothing.
  • The EDI version shows me an 810 and 856, and whether it has been acknowledged. That is important!
  • However, there is nothing at all to tie the two together. The only data column shared is "SPS Serial #", which is a random number that doesn't tie in between reports: The two reports, even run for the same time, for just 810s on one and invoices on another, don't match.
  • To make this useful, the Document Identifier should be on the EDI report. The Business report isn't even necessary.
Photo of DM


  • 70 Points

Posted 3 years ago

  • 1
Photo of Katrina Wolyniec

Katrina Wolyniec, Employee

  • 3,762 Points 3k badge 2x thumb

Thank you for the feedback with ad hoc reporting. It is a tool that we have had now for many years and it's part of the reason we are looking forward to the general launch of the New Fulfillment Product.  The new product will replace WebForms and will address many of your concerns.  It has been developed by incorporating customer feedback into the new design from day one.

It is currently in the second stages of release.  We are slowly rolling it out to customers in an effort to ensure that customers have the best experience switching over.  You will receive information about making the change between now and March of 2017.

If you have any further questions about it, feel free to call into the Support Team or speak with your Account Executive about it and we would all be happy to assist.  Thank you for your feedback and know that this is exactly the information we need to continue to improve our products and incorporate new ideas into future endeavors.

Thank you,

SPS Commerce Infinite Retail Power

Katrina Wolyniec

Workflow Analyst I | Fulfillment Support 

P: 1-612-844-2316


[]Support Center – Get Help. Give Help. Share Ideas.

Photo of Tim Smith

Tim Smith

  • 104 Points 100 badge 2x thumb
Hi DM,

One function that does tie the document to its acknowledgement is the "View Visual Dataflow" option. I will note that this only works for individual documents.

For example, if I want to find the FA status on an ASN that we've sent, I can look up the ASN by its shipment ID in the "Business Documents" tab. Once I've located the document, selecting the black box icon (next to the binoculars) displays the visual dataflow, which contains both the document ID and the acknowledgement status.

I hope this helps!

This conversation is no longer open for comments or replies.