Hi Leslie,
I am VERY new to MS GP. Currently, I am working with GP 2010 with IM 10. I am not not familiar on SOP integration, but I am trying to tackle an important issue with short time constraints. I hope if you could guide me to the right places where I can get solution or quick answer to my issue.
Here is my scenerio:
I have a SOP Header table with columns as Type, Type ID, Customer ID, Batch ID on a single row.
So my header data is like this:
Type = 2, TypeID = STD, CustomerID = DS-ABC, BatchID = SHIP
Then, I have a SOP Line table with minimum required columns such as Customer ID, Doc Numbers, Order Numbers, Item, Qty, Shipping Address ID, ship info.
So my SOLine data looks like this:
CustomerID = DS-ABC, DOCNo = DS-123, Order No = 123, Item = xyz, Qty = 1, Ship Address ID = 123, etc
CustomerID = DS-ABC, DOCNo = DS-123, Order No = 123, Item = qrs, Qty = 2, Ship Address ID = 123, etc
CustomerID = DS-ABC, DOCNo = DS-123, Order No = 123, Item = ghi, Qty = 3, Ship Address ID = 123, etc
CustomerID = DS-ABC, DOCNo = DS-789, Order No = 789, Item = abc, Qty = 1, Ship Address ID = 456, etc
CustomerID = DS-ABC, DOCNo = DS-789, Order No = 789, Item = jkl, Qty = 2, Ship Address ID = 789, etc
data source relationship is CustomerID (SOPHeader) --> CustomerID (SOPLine)
If you notice the first 3 rows are within the same doc numbers, but with different item # and qty. When I run GP IM, I have a single document number with all the items in one. What I am trying to achieve is to have DocNo DS-123 to have 3 items , and DS-789 to have 2 items imported.
I also tried using table SOPLine as a single data source, but I recieved a duplication error from IM.
Do you know what I have missed or solution to this?
Thanks in advance.
Best Regards,
Ken
