Wayfair missing invoices and requests for retransmission.

  • 1
  • Problem
  • Updated 3 years ago
  • Solved
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 periodically get requests from Wayfair that have a list of invoices they say they have never received.  When I check our systems I show that we produced and sent the invoice.  I can see  them on webforms also.

What I would like is an end to end trace on the following PO#s

PO CS37942348 recieved 7/3
              1 shipment  7/7
              invoice ACR00412545 sent 7/8 (we have retransmitted it 4 additional times the last being 12/11)
PO CS38234951 Received 7/13  
              2 shipments 7/14 & 11/24
              2 invoices
                 ACR00415187  7/14
                 ACR00475872  11/24   (this is the one they say they did not get we retransmitted on 12/11)
Photo of Thomas Harbert

Thomas Harbert

  • 92 Points 75 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Tim Smith

Tim Smith

  • 130 Points 100 badge 2x thumb
Hello Thomas,

You have the ability to confirm delivery of an outbound document such as an invoice using the Adhoc Reporting Tool, which you can access through the "Reporting" tab in your WebForms Portal. I've included a link to a training video below:

https://supportcenter.spscommerce.com/spscommerce/topics/video_ad_hoc_reporting


We can confirm delivery using a functional acknowledgement. Here is a walkthough specifically for obtaining a functional acknowledgement:

1. In the "Business Documents" tab of the Adhoc Tool, set a date range in the "Start Date" and "End Date" fields that match the date you sent your invoice. Next, enter the invoice number in the "Document Identifier" field and hit "Search". This will bring up your invoice.

2. Once you've located your document, select the icon that looks like three linked boxes ("View Visual Dataflow"). This will open a new window that shows your document as three unique boxes.

3. Locate the box on the far right: this represents the EDI document sent to Wayfair. Obtain the serial number (in this case, 3107120976) from the top-left corner of this box.

4. Now that we have the serial number for the EDI document, return to the main page in Adhoc and select the "EDI Documents" tab. Set your search dates and enter the serial number (3107120976) in the "SPS Serial #" field.

5. Once you've located the EDI document, refer to the "Ack Status" tab. If you see a value of "Accepted," your trading partner has acknowledged receiving you document and has returned an EDI functional acknowledgement confirming receipt.

6. To obtain the functional acknowledgement as proof of delivery, select the binocular icon near "Accepted". This will bring up the EDI functional acknowledgement, which you can use as proof that your trading partner received your invoice.

Here is the functional acknowledgement that Wayfair returned for invoice ACR00475872 sent on 12/11/2015:

ISA*00*          *00*          *01*112084681      *12*8435536700     *151211*0952*|*00403*000053732*0*P*>
GS*FA*112084681*8435536700*20151211*0952*53469*X*004030
ST*997*57447
AK1*IN*37992
AK2*810*37992
AK5*A
AK9*A*1*1*1
SE*6*57447
GE*1*53469
IEA*1*000053732


Please note that functional acknowledgements act as proof of receipt and do not guarantee that Wayfair successfully processed your invoice. If, for instance, your invoice is out of balance, Wayfair may return a separate document such as a text message advising that the invoice was not processed. I would recommend checking your inbox to ensure that no notifications were sent by Wayfair.

This conversation is no longer open for comments or replies.