Multiple ship accounts storage in Lawson

The AP has limited space for accounts and is usually the bill to account. Where is Lawson can you store multiple ship to accounts per vendor? Am I overlooking the obvious somewhere? PO10 does not have enough room either.

Find more posts tagged with

Infor Lawson Supply Chain Management - Discussion

Comments

jon-athey

This is where AP10.2/PO10.2 comes into play. If a vendor ships to multiple locations within your health system you can build a purchase from location record for each location and assign the ship-to account in the AP10.2 record. Furthermore, if the vendor has multiple divisions, you can also build a record for each division/ship-to. Then assign the purchase from in IC12.2 for each item.

unknown

We store the call in accounts as comments on the PO10. Prior to us having 6 facilities, we were putting them on the PO10 user fields. But as for something that will show on the PO print? Nada.

0712131256598360.doc

StephanieD

Kat,
If you don't setup a separate AP10.2 for each vendor ship to account, what do you do if you're sending EDI PO's to the vendor, how do you get the separate EDI ship to accounts sent in each 850 for each location?
Thanks.

dechevar

We utilize a GHX translation table that stores our Supplier Account number and transmits it when we EDI the appropriate ship-to to which it is tied. Most of the set up is done on the ED40 Translation tables.

I have attached an old EDI set up presentation shared by Norton Healthcare. While the screens are still in LID, the set up is very similar to what we do in portal.

unknown

Thanks... I found that helpful too. You had some EDI setup that I wasn't aware of for 810's.

unknown

We do not build separate AP10.2 records for each ship to location. It would be nice if there were a substitution table similar to the EDI substitution table where the vendor account number could be populated for each IC02 location.

[Updated on 1/29/2014 10:51 AM]

jon-athey

Do you use AP10.2 at all?

kim-gonzalez

We have around 45 ship to locations and use ED40 substitutions for our EDI orders and we set up another set of ED40 records for each vendor/ship to/account which is utilized by PO120 (POIA I believe) to populate the correct ship to account on the printed/faxed PO.

unknown

We use AP10.2 to help default EDI vs non-EDI orders for a vendor and also for vendors with multiple divisions.

unknown

What Sam said!

We use the ED40 to translate the ship to into account number.

List Name: [TPID]_O_SHIPTO
Lawson Value: [FROM-LOC][VENDOR][PURCHFROM][COMPANY]
External Value: VendorAcct#

The hardest part is the spacing - you possibly have trailing spaces on Ship to and Purch From but leading spaces on the vendor number. The field must be 22 characters long (5+9+4+4)

For Owens we had to add another ED40 TPID_O_DEPT and populate all the req locs. Not sure if I'll have to do that for Cardinal yet or not.

The GHX Map is supposed to be getting a bill-only coding as well. Not certain how that will work.

unknown

I've found more information on my ship to mapping - not precisely what you were originally asking for but:

We set up vendors and add a AP10.2 for each separate customer service location. (Medtronic currently has 7. J&J for all the divisions they buy up are relatively small because most of it can go to the main EDI center.) AP sets up vendors based on Tax ID on AP10. We control the Purch Froms.

We have 16 IC02 Ship To/Inventory Locations - that are 7 addresses to the manned receiving docks where the staff have rights to PO30 Receipts. Those docks have ~700 requesting locations (par locs and non stocks) tied under them.

On ED40 TPID_O_SHIPTO is the list name we use to translate the 16 IC02 to 7 accounts. We only board the receiving docks in GHX Registration Center.

For Med-Surg Distribution, they pallet the various req locs together, so we need to transmit the 700 odd locations, not just the 7 docks. We still only have the docks boarded and still use TPID_O_SHIPTO for them.

But we have an additional ED40 list name: TPID_O_DEPT. Using the map from GHX, this additional list puts the reqloc into the N1^ST row on the EDI header.

So N1^ = account boarded with GHX
N1^ST = req loc and because the first row is boarded on Registration Center, the EDI doesn't error on GHX. They don't need the req locs boarded as they consider the N1^ST a passthrough field.

eokoth

Kat - et al- how are you handling the 810s for Medtronic and J&J? We have a unique vendor number per customer service location. The shipto accounts were also unique to the customer service location. This worked great in the past for ED40 and having the correct vendor number interface to AP20. But, now the Vendors are consolidating the shipto accounts for all customer service location. We've had to turn off 810s fro some vendors.

jon-athey

For J&J Healthcare we have one Purchase From built for each ship-to location (4 medical centers). To identify the division we use TPID_O_JJDIV in ED40. This grabs the Mfg/Div on the PO line and translates it to a 2 character J&J division code that goes in PO107.

JJASP = AS (Advanced Sterilization Products)
JJBIOS = BW (Biosense Webster)
JJCODM = CO (Codman)
JJCORD = CC (Cordis)
JJENDO = ES (Ethicon Endo)
JJETHI = ET (Ethicon)
JJMEDI = MI (Medical)
JJMITE = DM (Depuy Mitek)
JJORTH = OC (Ortho Clinical)

For the inbound (855 and 810) we only need one TPID_I_COMPANY, TPID_I_PURCHASE_FROM, and TPID_I_VENDOR for each of the 4 medical centers. We only have one vendor number for J&J. We're not trasacting via EDI with Medtronic.

unknown

My AP doesn't use TPID_I_SHIPTO or TPID_I_PURCHASE_FROM at all. They just have inbound Company, Vendor, Procurement Group (and a couple of add-ons for freight charging vendors).

Apparently J&J works out as - on the AP10.2, they reference pay vendor the vendor ap10.1. So the invoices transmit, translate to that vendor with a PO Number. The PO Number pulls in the PO Vendor and PO Purch From. Matching occurs.

Vendor is paid under the AP10.1 per the setups.

We have 810s from J&J and Medtronic. Medtronic has 7 purch from locations and J&J has 4.

Copyright © 2025 Infor. All rights reserved.