Document Processing Error - Invoice error

  • 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: 4412428

Hi -We received this error when trying to invoice Sports Authority.  I think the wrong customer may have been the address field the first time we hit save.  But it's been fixed and we've tried sending it several times and it keeps getting rejected.  Can you help?
Thanks
Marcia

SPS Commerce was unable to successfully process the following document:

Serial Number: PCL2578253950

Document Originator: Pioneer International Corp
Document Recipient: Sports Authority Inc
Document Type: 810

ShipToLocationNumber: 841
InvoiceDate: 2015-07-09
PurchaseOrderNumber: 934289
PurchaseOrderRelease: 71870
VendorNumber: 024706
ShipToLocation: TSA - Direct Import
InvoiceNumber: 1500136A

InvoiceNumber:1500136A  If [AddressTypeCode] has data then [Address1] is mandatory 
Photo of MARCIA LINCOLN

MARCIA LINCOLN

  • 1,074 Points 1k badge 2x thumb

Posted 3 years ago

  • 1
Photo of Zach Johnston

Zach Johnston, Customer Operations Analyst

  • 570 Points 500 badge 2x thumb
Good morning Marcia, thanks for your post!

I have reviewed the failed invoice and it appears to be missing some ShipAddress information. I compared the invoice data to a successful Sports Authority invoice of yours (Invoice #1500135D) and determined that the ShipAddress, ShipCity, ShipState and ShipZip are missing from the data.

Once you add values for these fields to the invoice within Netsuite you should be able to resend successfully. Please let us know if you have any further questions. Thanks!
Photo of MARCIA LINCOLN

MARCIA LINCOLN

  • 1,074 Points 1k badge 2x thumb
That's where we are having trouble.  We don't see any empty fields that require address, city, state or zip.  Could it be because we are using a custom pull down field to select the customer?
Photo of Zach Johnston

Zach Johnston, Customer Operations Analyst

  • 570 Points 500 badge 2x thumb
Hi Marcia,

I don't believe that is the issue, as the successful invoice that I referenced above uses the same custom form (Pioneer TSA Invoice). Are you able to reference that successful invoice and see where the address, city, state and zip were populated within Netsuite?
Photo of MARCIA LINCOLN

MARCIA LINCOLN

  • 1,074 Points 1k badge 2x thumb
yes, we've been doing side by sides with other TSA successful invoices.  They look identical from this end.  Very confusing.  I even created a new invoice without attaching it to the exiting sales order and it errored out too. NetSuite said it was a dupe invoice number (even though it errored out, so I used 1500136AA.  I'm stumped.  
Photo of Zach Johnston

Zach Johnston, Customer Operations Analyst

  • 570 Points 500 badge 2x thumb
Hi Marcia,

Do you have default addresses set up for each TSA location within Netsuite? There may not be actual address fields that you enter when creating the invoice, but if the location for this invoice does not have complete address information associated with it within Netsuite the custom form would not have an address to reference when compiling the data to send to our system. Let me know if this helps, thank you!
Photo of MARCIA LINCOLN

MARCIA LINCOLN

  • 1,074 Points 1k badge 2x thumb
Hi Zach - I'm unsure about the initial set up of these accounts as I was not present for them. 

I was so stumped and getting desperate - all I could do was delete the invoice(s), reverse the fulfillment and bring the sales order back to original approval status - I literally started over again.  It worked.  It's a good day.
 
Thanks for your help.  I know I will need to understand the set up as we are going live with several more accounts this year.
Thanks
Marcia
Photo of James Wanke

James Wanke, Employee

  • 110 Points 100 badge 2x thumb
Good morning Marcia-

It sounds like Zach was able to point you in the right direction here. If you're still seeing ongoing issues, or issues with your other partners, please let us know and we can certainly help out!

Have a good day,
James
Photo of MARCIA LINCOLN

MARCIA LINCOLN

  • 1,074 Points 1k badge 2x thumb
Thanks very much I appreciate your help!

This conversation is no longer open for comments or replies.