Showing posts with label Macy's. Show all posts
Showing posts with label Macy's. Show all posts

Tuesday, June 2, 2009

Macy's name update

From June 2nd posting by Macy's:
"...as one national Macy's store organization, we are no longer using Macy's East, Macy's West, Macy's Central, Macy's Florida or Macy's Home Store as divisional purchasing entities. Rather, Macy's Merchandising Corporation (MMC), will be the single purchaser in place of those divisional entities. MMC will be using the former Macy's EAST EDI communication Ids and all labels and invoices should reflect our new MMC purchaser name (i.e., MMC or Macy's) in place of the old divisional entities."

This Edisoft template 583(Macy'sEast) for the 4030 version. In Profile, you can change the name. Also, doublecheck the DC and direct to store locations under "Macy's East", to verify that the description and Name 1/2 Fields do not reference Macy's East, but instead the new name. If labels not adjusted by this change, please contact edisoft support to adjust your label template.
As for invoices, I don't believe the name is mapped at any point UNLESS your mapping has it assigned in the N1 BT/ST segments.
Here is an example of how I have set up on the invoice and as you see, no mention of the division name.

N1*BY**92*7368

N1*ST**92*BA



So now that they have one Macy's division(Macy's.com is separate from stores), hopefully they will look at reducing number of direct to store(D2S) ship points.



Friday, May 29, 2009

Macy's ASN Formula for D2S codes

As you probably know by now, Macys has consolidated their EDI under one mapping--the old Macy's East id, which is Edisoft template 583 for the 4030 version.
Macys has at least 17 DC's depending on your setup, each as a 2 letter code---stores are matched to the appropriate 2 letter ship to code in the location setup.
However, there are now 10 direct to store locations. The direct to store locations come in with a 4 digit code, and for the turnaround ASN, Macy's requires you to put "D2S" in the N1 ST field of the 856, even though ship to is actually the 4 digit store code. Obviously matching all the stores to a D2S ship to code doesn't help as you need to differentiate on the labels and in Visual for the shipments.
Paul LeBlanc, the Edisoft formula guru, has posted an excellent guide to formula writing on the http://support.edisoft.com website. I recommend you download it today--tis a must for any serious Edisoft user.
Using that and a little help from Paul himself, what you need to do is:
1. in the mapping screen of Edisoft, where N1 ST code is mapped, paste the following formula. Press enter twice (ignore 17 digit limitation message) and save. Close out and go back in--formula works beautifully!
=IIF(CurDoHead.DCNO=CurDoHead.Shipto,"D2S",CurDoHead.DCNO)

Basically it is checking if the ShipTo code matches the MarkFor code--if so, it puts "D2S", else it puts the original Ship to 2-letter DC code.
Please let me know if you find this helpful.