JC Penney 1

[Databaseguy]

Anyone trading with them ?

If so, what Translator are you using ? How do you generate 856s, 810s etc ?

We are currently using ASN Plus by GEIS, and migrating towards EDISoft.

Problem is, neither has a solution for "Bulk" shipping, which has an ASN structure of SOIP (in lieu of SOPI).

Anyone else ?

Tyrone Lumley

 

[zedsded]

Using GENTRAN by Sterling, JCP is a ton of headache to deal with. You should be able to get template/mapping from your translating software tech-support or your accounting system software vendor. In our case, I just request for it (but of course, doesnt always work). Im still trying to comply with the 4030 version with JCPenney. Let me know if u need more help, I know I do.
GOOD LUCK!

 

[Databaseguy]

Thanks. Just rec'd the template for the SOIP structure from EDISoft, which will allow us to comply with bulk.

Are you guys part of the TMS ? (Dynamic routing). Do you print your UCC 128s before or after receiving routing instructions (754)

Thanks Again.

Tyrone Lumley

 

[zedsded]

Sorry, got too tied with EDI headache.
No, I am not in TMS, although I do print UCC128 per Supplier Route Guide (JCP internet) and not 754.Are you having problems with these?
How's the SSC shipping and addressing rules affect your EDI system? any confusion? I am!
Would it be easier (if applicable to us) to use TMS?
Thanks a lot.

 

[Databaseguy]

The problem with TMS is when you print the labels. If you print them ahead of time, and JCP changes the routing instructions, you have to re-print the UCC-128. If you wait until you recieve the routing instructions via the 754, you have a time crunch for printing and applying the labels.

SSC is relatively easy. Instead of one PO per store, you get one PO for several hundred stores.

Yes, JCP is a huge headache. How are your chargebacks with them ?

Tyrone Lumley

 

[zedsded]

Chargebacks? I dont even wanna think about it 'coz i might lose my job . it seems like they actually have a strategist to "legally' impose chargebacks on their partners.
SSC: I guess it is easier for you (or I just dont get it), my route guide directs me to PEPS for an S2M4 order - Do you know what goes on ZONE H of UCC?
(store/unit AND SSC ADDRESS)
EX: 08236 (store#) - that belongs to SSC 94417
something rd.
Buena Park, CA 90602 (address for SSC)
is this right?
THANX!

 

[Databaseguy]

I've heard they do have strategists for chargebacks.

Zone H should be the Mark For (Z7) store number and the the SSC address. Your example is correct.

Tyrone Lumley

 

[zedsded]

Thank you, SIR!

 

[ls62]

Hi,

I'm coming in a little late in this thread, but I've been dealing with JCP edi for around 10 yrs. Here are a couple suggestions I have:

1) Ucc labeling: Be sure to follow their guidelines. They are a real pain getting the label approved and expect you to have everything in the right places and in the right proportions. Save yourself some frustration and be sure all dimensions and measurements meet or exceed their specs. I found that instead of telling you 'all' the problems with your label , they'll tell you 1 and then after you resubmit they'll tell you another.

2) Chargebacks: Oh boy. Unfortunatly like many retailers it seems like they make money just from charging back their suppliers. There are SO many charge backs its unbelievable. Make sure your routing is correct, asn's are sent timely, and you REALLY need to have some sort of Quality Assurance program setup to verify your shipping 100% correct based on order. Its really hard to argue shortages, overages, subs without some proof on your end.

3) SSC's: Be sure to watch edi 864's for address changes. They add stores to SSC's now all the time. Each supplier has routing based upon you location, so you may ship some stores to peps and others direct to store or ssc. The edi 850 indicates if it ships to SSC (different #'s for N1 ST and BY). I don't remember which is which offhand.

Also, I don't know what business your in, but with SSC's you can ship bulk, or they can send you po's by store with it shipping to a SSC. Basically I think the SSC is just a mini distribution center. All our po's are by store, different PO per store.

4) TMS: We don't use it, so I can't help you there. We print 128 label when carton is packed based upon routing table we have setup. If you want more info on how we did it let me know.

Hope this helps some.

LEE

 

[zedsded]

Is62,
Thank you very much for the info. Was wondrin' even if i get 864 - do i still need to pay attention to the web postings of new address assignments/changes? Or just follow what i get on 864s?
thanx again.
ZED

 

[ls62]

Zedsded,

I have our system automatically update store addresses from the 864. I believe that they are both the same, although the ones on the web site seem to be posted prior to the date they are to take affect. The 864's seem to be transmitted when they are actually to be changed (or a day in advance). We usually update from the 864's (which our system generates a report) and then we go to the web site and look for the confirmation and print it out to distribute to our shipping dept, mostly so they are aware there are some possible routing changes to look for.

Depending upon how you do routing you have to be careful because if you determine routing when order comes in it may change by time you actually ship the order because of these address changes. When we receive these address changes we run a routine that updates/checks all JCP order routings based upon new address.

Our situation may be different than your's, we ship orders daily for stores either direct,to SSC or to PEPs. So.. we may get orders in on one day routed to goto the store, but before we ship them JCP sends 864 and wants it to goto a SSC. You have to check for this!

LEE

 

[zedsded]

LEE,
I really apprecite all your inputs i'd like to send you a sample PO, if you dont mind. I think we are actually trading with them in the same manner. Need some friendly clarification on some addresses (jcp is too confusing to talk too-seems deliberate).
I'll be instructing our order entry person to make some changes on our accounting system based on your input (which was my first thought- I just needed another opinion)

thank you very much.
ansidomain@msn.com

 

[ls62]

zedsded,

Sure, send me the sample and questions. I emailed you offlist to your msn.com address, so you can mail me back or post the info here. Doesn't matter.

LEE

 

[Databaseguy]

I've got code for reading the 864 and updating you DB. The follwing is for adding the "First" list JCP sends you.

Public Sub Read864()
'---------------------------------------
'Read 864                              -
'3/10/2003                             -
'Tyrone Lumley                         -
'Loops through a list of raw documents -
'And populates a store table with the  -
'Results                               -
'---------------------------------------
On err goto err_hand
Dim rstRaw As New ADODB.Recordset ' Table with list of raw document names
Dim rst864 As New ADODB.Recordset 'Table to add JCP Stores to
Dim strDocument As String 'Document name
Dim strDir As String 'Directory
Dim strDelimiter As String 'Delimeter
Dim strReason As String 'reason 01, 02 or 05 not used yet
Dim strAddress As String 'Address
Dim strCity As String ' City
Dim strState As String ' State
Dim strZip As String 'Zip
Dim strStoreName As String ' Store name (not always there)
rstRaw.Open "qselNewStoreList", CurrentProject.Connection, adOpenDynamic, adLockOptimistic
rst864.Open "tblJCPStores", CurrentProject.Connection, adOpenDynamic, adLockOptimistic
strDir = "\\dellserver\Users\Public\782002\GEDesktop 624 On\" 'Changfe this as required
strDelimiter = "" 'Delimiter
rstRaw.MoveLast 'Move first and last to get record count
rstRaw.MoveFirst
Do While Not rstRaw.EOF
    strDocument = strDir & rstRaw.Fields(3) 'full path and file name
    Open strDocument For Input As #1 'open the document
        Do While Not EOF(1)
            Input #1, myString 'line of text in document
            myarray = Split(myString, strDelimiter) 'split into an arrary
            Select Case myarray(0)
            Case "BMG"
                strReason = myarray(3)
            Case "N1"
                strStore = myarray(4)
            Case "N3"
            If UBound(myarray) = 2 Then
                strStoreName = myarray(1)
                strAddress = myarray(2)
            Else
                strAddress = myarray(1)
            End If
            Case "N4"
                strCity = myarray(1)
                strState = myarray(2)
                strZip = myarray(3)
            End Select
        Loop
    Close #1
    With rst864
        .AddNew
        .Fields(0) = strReason
        .Fields(1) = strStore
        .Fields(2) = strStoreName
        .Fields(3) = strAddress
        .Fields(4) = strCity
        .Fields(5) = strState
        .Fields(6) = strZip
        .Update
    End With
    strStoreName = ""
rstRaw.MoveNext
Loop
End Sub
err_hand:
debug.print err.num err.desc

Tyrone Lumley