Convert the MP2 vendor.
MP2 vendors are a combination of two unique fields. For example, in MP2 you could have:
|
MP2 Vendor=GRAINGER MP2 Vendor Branch=GREENVILLE |
AND |
MP2 Vendor=GRAINGER MP2 Vendor Branch=ATLANTA |
In HxGN EAM, you may have one field displayed, e.g., GRAINGER would be displayed only once.
Here is an example of how to make the one 30 character field unique:
GRAINGER-GREENVILLE
The total character length is 19. This example works for vendors and vendor branches whose character lengths don't exceed 14. You may separate the values by '-' and still get in the full length of vendors.
The setup would look like this in the grid:
|
Prefix |
Field |
Start Position |
Length |
Suffix |
|---|---|---|---|---|
|
<blank> |
MP2 Vendor |
1 |
14 |
- |
|
<blank> |
MP2 Vendor Branch 1 |
1 |
14 |
Another option is to only have the MP2 Vendor column converted and to remove the MP2 Vendor Branch identification. By choosing to do this, the system will take the first MP2 Vendor record and bring over the detailed information such as address, payment terms, etc. and then not bring over the detailed information for the second MP2 Vendor with the same ID but different MP2 Vendor Branch. This selection would still keep the part/supplier information in tact. Here is an example:
|
Prefix |
Field |
Start Position |
Length |
Suffix |
|---|---|---|---|---|
|
<blank> |
MP2 Vendor |
1 |
14 |
In this example, two vendors would come over as one:
GRAINGER