remittance advice

  • 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

I need to see the format of the 820 Remittance Advice Web Form - i.e. what columns of data will be included so we can prepare for when we go-live at the end of the month.  I watched the video on Remittance Advice but it didn't even show a picture of it.  Thanks.
Photo of Kristine

Kristine

  • 112 Points 100 badge 2x thumb

Posted 3 years ago

  • 1
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Good morning Krisiine,

Apologies for slow response.  Do you mind providing me with the retailer you will be receiving the 820s from?  Also, I am guessing you will be downloading to CSV and that is the format you would like to see?

Thank you for your post!

Jordan
Photo of Kristine

Kristine

  • 112 Points 100 badge 2x thumb

Hi Jordan

We're a new SPS customer going live in 2 weeks.  We will be receiving 820s from many different retailers (Macy's, Nordstroms, Dillards, etc); I'm assuming the format will be mostly the same.  CSV will be great.

I just need an idea because we have to prepare to manually enter them into our Oracle system since these had to be webforms for now instead of EDI directly into the system.  And we were told we wouldn't have an advance 'test' file to look at.

The video for the Product Activity Report  had a picture of the report, but the Remittance Advice video did not.

Thanks,
Kristine

Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Definitely, very understandable.  The formatting is generally the same, however there can be 1-off situations.  This is not the case for the majority of retailers, however.  Let me do some digging here and see what I can find.  I will follow-up with you here with any updates!

Thank you for your patience!

Jordan
Photo of Jordan

Jordan, Software Engineer

  • 7,480 Points 5k badge 2x thumb
Good morning Kristine,

Good news - I was able to track down some info on the Remittance Advice and downloading formats.  It appears that all of your current Trading Partners use the same CSV formatting (big win!).  I have an example file with test data that I can provide you with.  I will reach out offline to get this over to you.

Thank you again for your patience, please let me know if there is anything else we can help with to make this implementation go smoothly!

Jordan
Photo of Kristine

Kristine

  • 112 Points 100 badge 2x thumb

Thanks Jordan!

This conversation is no longer open for comments or replies.