Find Invoice # based upon SPSKEY# from daily report

  • 1
  • Question
  • Updated 3 years ago
  • Answered
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

We received a daily transmission report that shows status of our 810 transmissions for the previous day and it showed three documents that were "Unacknowledged".  I have the SPSKEY # but no Invoice # is shown on the report.  How do I find out what our Invoice # is based upon the SPSKEY #?
Photo of Marc Durand

Marc Durand

  • 100 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Dillon Barmore

Dillon Barmore, Employee

  • 180 Points 100 badge 2x thumb
Hi Marc! 

Great question.

Are you currently using SPS's Adhoc reporting? Using Adhoc Reporting Tool, you can view the raw EDI data and often times the Document # (aka AppKey) associated with the SPSKEY.

Adhoc provides a live look-in on your document flow, errors, data, etc. If you are not yet setup and wish to be, please provide your WebForms portal username and I can get you started. Please see the below link which provides training for utilizing this great resource! 

http://www.brainshark.com/spscommerce/AdHocReporting
Photo of Marc Durand

Marc Durand

  • 100 Points 100 badge 2x thumb
Thanks Dillon.  I appreciate the response.  I was abvle to find what I need through the Adhoc reporting tool.  

I might suggest that SPS add more related fields to the daily reporting; like invoice #, BoL #...  That would help with quick reference on issues.

Thanks again, 
Marc D.

This conversation is no longer open for comments or replies.