Share
ReportDear all,
When we are placing a quote for a customer a single quote can have different product from different supplier.
For instance we can have in the quote :
- product A from supplier A
- product B from supplier B
- product C from supplier C
Actually in order to identifier supplier we are using the vendor name field, but seems it is no so suitable. So my idea is to define an extra field named SUPPLIER_REFERENCE in product form where I can set a Look up field to a supplier name. Then each product will be associated to a given supplier ID
Question 1 :
Does this sounds good to you first ?
Next step is that when a quote is validated by our customer we create an order. The order form is actually reflecting all product that has been part of the quote.
From that order form, I need to run a Report which will build a Process order which will be send to each supplier.
Question 2:
How can I run a report which will then select product from each supplier ? Ideally I could have a report where I have a drop box which display supplier from the order and then when I select a particular supplier, I can fetch product found in the order for this selected supplier. I now how to do that if I have access to full SQL querry but here as it is based on FETCH XML, how can I do that ?
Thanks for your advise and possible sample
regards
serge
*This post is locked for comments
All responses (
Answers (
291,280
