Substitution Table Question

Baxter assigns account numbers based on the customer's shipping address so one account is standard across all divisions. We EDI to Baxter and have 5 divisions set up in ED40 for our main medical center all using the same account number. Where you run into trouble with this is with the inbound transmissions. For setting up Baxter the Lawson trading partner setup guide shows a Purchase From substitution table entry for the 855s and 810s. Since Baxter is sending the same account number in N1ST04 for any division, how does Lawson know which to substitute? So we just don't enter anything in ED40 for inbound Purchase Froms for Baxter. Generally speaking, all you really need in ED40 for inbound transmissions are entries for company and vendor.

Thanks John!

I have an additional substitution table question. I have a vendor who would like to use the N2 line instead of an SDQ line to gather "Deliver to" information which they need for desktop delivery. Is there a way to map the "deliver to" field from the RQ to the 850 EDI outbound file? We currently have a requesting location that shows up in the N2 line in segment 1.  I cannot see a substitution value in ED40 for this but we would like to try and map the deliver to field that shows in segment 23 son the SDQ line to show in the N2 section in segment 2.

Not sure if you can do that through the Substitution Table (ED40). We had a vendor that we had to make changes to the Perl script so that the values were in the right segments. Not the best way to handle it, but it worked. Of course the next time you update EDI you will have to reapply the changes.

We had to move it for Cardinal - we are using GHX's map and to make the reqloc appear where the ship to normally does is two part.

1. Turn on the substitution:
List Name: TPID_O_DEPT_SHIPTO
Lawson Value: COMPANY (We use Company 1 - value is 0001)
External Value: ON

2. Put in all the req locs with the regular tpid-o-dept

 

3. if you are using an exchange line GHX, you'll need to board all the req locs as accounts with them.

I have the reqloc on the N2 line but I need the actual text value from the "deliver to" that normally shows on SDQ segment 23.  I think the challenge may be it's not in the POEDI header so I can't map it to the N2 segment based on what infor support said.  I don't really understand the substitution tables that well so I could have misunderstood what he was trying to tell me.  

 

Is there a way to get that value to show up on the header line of the POEDI file?  I thought about the perl script change, and I don't really want to have to make a custom script for one vendor.