Forum Discussion
Help
Hi in the above, i have in yellow a material with the same code coming from two suppliers and in blue i have a amaterial which have different code and is coming from different buyers. I have...
1. Duplicated the column
2. Splitted that Material Copy column and Transformed to be upper text to mach your Vendor Upper Text-
3. Duplicated the vendor, splitted it too
4. Finally said if there is a match, then use the new material column, if no, the original.
Now you can use this Mat column for calculation.