how do I figure out what the grp ctl# or the trn ctl# is on a certain invoice.

  • 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

how do I figure out what the grp ctl# or the trn ctl# is on a certain invoice. I have the invoice number 659474-000. amazon is saying we're sending the wrong UPC and I would like to verify that. Can someone help me look into it?
Photo of Amber Johnson

Amber Johnson

  • 410 Points 250 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Zach Johnston

Zach Johnston, Customer Operations Analyst

  • 570 Points 500 badge 2x thumb
Hey Amber!

You are able to access EDI control numbers for specific transmissions using the Adhoc Reporting tool.

Here is a great video that walks you through the utilities of the tool:

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

I think slide 4 will be especially applicable for you in this instance, as it walks through accessing the "view visual dataflow" function, which will allow you to access the EDI data for your invoice after you have located it in the Business Documents tab.

Please let us know if you have any further questions. Thanks!
Photo of Amber Johnson

Amber Johnson

  • 410 Points 250 badge 2x thumb
You answered my question. Thank you. Now I'm wondering if you can look at that specific ASN for me. I am unable to find and/or view what was sent. I am looking for the UPC 765139511925
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Hi Amber,

I will do my best to help here and will loop Zach in if necessary.  I have a few clarifying questions below:
  1. Are we looking at an Invoice or ASN?  The original post mentions Invoice.
  2. Do you have the PO number I can reference?
  3. Who is the Trading Partner?
Thank you!

Jordan
Photo of Amber Johnson

Amber Johnson

  • 410 Points 250 badge 2x thumb
Hi Jordan,

Sorry for the mix-up in the earlier message. We are looking for the ASN. The PO number is 7CW4K4RE. The trading partner is 2 - Amazon Warehouse. 

I am looking for a list of the UPC's that were sent with this ASN. 

Thanks,
Amber
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
No problem at all, I just wanted to ensure we were on the same page!  Last question - is the identifier of the ASN the same as above (659474-000), or is that number different.

Thank you for being patient here,

Jordan
Photo of Amber Johnson

Amber Johnson

  • 410 Points 250 badge 2x thumb
It should be the same number 659474-000

:)
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Thank you Amber!  Unfortunately, I am not seeing that number.  I see the following ASNs that relate to PO 7CW4K4RE:

016478
017121
017260
018063

I also see the Invoices, which are similar to the number above, however not quite exact.  Does this sound right?
Photo of Amber Johnson

Amber Johnson

  • 410 Points 250 badge 2x thumb
Well that is interesting. Here are a few other orders we've been having the same issue with. Maybe we can find the ASN for one of those..

659823-001    3PDVTSOL
659838-001    7CW4K4RE
Both are with the same trading partner... 2 - amazon warehouse
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Hi Amber,

Both of the above POs have Invoices that correspond to the numbers provided.  The ASNs for each are different.  I hope this helps!

Jordan
Photo of Amber Johnson

Amber Johnson

  • 410 Points 250 badge 2x thumb
I am looking for specific ASN information for these two... like a list of the UPCs sent. Can you find that for me?
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
I can look into that.  There are multiple ASNs for the POs, would you like the UPCs from each ASN?

Jordan
Photo of Amber Johnson

Amber Johnson

  • 410 Points 250 badge 2x thumb
That would be fine. 

Thank you!
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Amber,

Just a heads up - I am still working on gathering information here.  It will likely spill into next Monday, does that work for you?  I do not want to keep you waiting if it is critical you get the information today.

Thank you and sorry for the length of time it has taken!
Photo of Amber Johnson

Amber Johnson

  • 410 Points 250 badge 2x thumb
That's no problem. Thank you.
Have a good weekend!

This conversation is no longer open for comments or replies.