Create Document With Only Items of Seller

bucobill

I have an order that has multiple items with different item owners. We need to send a document with only the items that were sold by that item owner (vendor).

We have no issue sending via email however the document we generate has all items listed for all vendors not just the vendor who owns the item. We only want to send the items in the emailed document to the vendor that owns the item.

The process we use currently is:

Find Item Where Item.CompanyName=Item.Vendor.CompanyName And Item.State='Sold' ORDER BY Item.ItemName IN BATCHES OF 1

(This is only returning 1 item per document and not all items for the vendor, however this does return the vendors item and not other items not owned by the vendor.)

Then we perform the Send function.
Which works to send out the document.

We have also tried TAKE BEST 1
We also tried ORDER BY Item.CompanyName TAKE BEST 1
We also tried ORDER BY Item.CompanyName IN BATCHES OF 1

Hopefully someone can help. I really do appreciate it.

ACDC

I don't know if this makes sense, each item has an owner reference.If you create an attribute on the owner object related to the Item reference the items will be grouped on each owner. This way it will be simpler to send an email FOR EACH owner based on your sort criteria for the items.

bucobill

OK. I found a solution, however it has it own issues. It is sending out an email with all of the items but it is sending out an email for each of the items sold in a countdown style. SO the first order might say 4 items with description of each and the second will have one less and so on.

FIND Item WHERE ThisItem.Product.Vendor.CompanyName=Item.CompanyName AND Item.State='Not Sent' ORDER BY Item.Product.Vendor.CompanyName

If Item.Sent='Not Sent' Then SEND Order TO Item.Product.Vendor ThisItem.State='Sent'

Then as far as displaying the item we are using a document with Determined at Run Time and then inserting that document with the items listed into the Order Summary document using a query of
Item.Product.Vendor.CompanyName=Item.CompanyName
AND Item.State='Sent'

This displays all of the items. Now what I need to do is send only one email to the vendor that owns all products. I have tried to make a reference attribute of item in vendor however this created a new issue of Multiple Allowed even though MA wasn't selected in the attribute and the attribute was only peer with no reference in item. I then reversed and went the other way and still got the same issue.

I think I need to say something like"Find Vendor WHERE Item.Product.Vendor.CompanyName=Item.CompanyName IN BATCH OF 1" Then send email from that but I tried something like this and when I did I got a gray reference issue box when I tried to send the email.

I know this is a little confusing but I tried to go into a decent amount of explanation to receive help.