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.

Welcome

This blog is about using Edisoft Merchant EDI software, EDI and retail/CSG in general.
I am not an Edisoft employee--merely a customer for 8 years and a fan of their software. I use the software on a daily basis to communicate with many major retailers.
Every day is a new challenge in the world of B2B, and I will share the ways my team meets those challenges. Hopefully others along the way will join in with their own tips.
More on Edisoft at www.Edisoft.com and their excellent support site is http://support.edisoft.com/