packaging label

[vertcnc]

I have designed a packaging label in crystal that prints a label for every line item on an order. The problem that I am having is that the field for the Customer Item # is not printing correctly. The customer's Item # prints but is not the # that applies to that particular customer. I suspect it is the linking between the sop table (sop10100) and the customer cross reference table (sop60300) but can't figure it out for the life of me. Any help would be appreciated.

Thanks Tim

 

[jazgeek]

need double link

one to item#
one to customerID from SOP Header

-----------
and they wonder why they call it Great Pains!

jaz

 

[vertcnc]

jazgeek,
I tried that, but get a linking error in crystal.
I have the item # in sop10100 linked to item # in sop 60300. If I try linking the custmr # in 60300 to custmr # in sop10100 this is when i get the error. I am using the following tables sop50200, sop50300,iv00101, rm00102, sop60300, sop 10100,sop 10200.
I am not sure if I really need all those tables I just used the same ones as the packing slip. I use the following fields. Customer name, customer po, unit of measure, quanity,item #, Customer Item #, Item descp, order #

Thanks for the help

 

[jazgeek]

what error?

-----------
and they wonder why they call it Great Pains!

jaz

 

[jazgeek]

I've just tried it on my database

SOP10100 linked left outer join to SOP10200 via SOPNUMBE

SOP10200 linked left outer join to ASILOC50 (7.5 database shows this as the customer item number table) via ITEMNMBR

SOP10100 linked left outer join to ASILOC50 via CUSTNMBR

gives me what I think you're looking for.




-----------
and they wonder why they call it Great Pains!

jaz