tag:blogger.com,1999:blog-7144297722159423617.post7550131754368693705..comments2024-02-05T03:31:31.327-06:00Comments on Redbeard's Blog: Sales Reporting for Vendor ItemsAnonymoushttp://www.blogger.com/profile/09322326253271593170noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7144297722159423617.post-79663235149926387442015-11-02T18:04:47.441-06:002015-11-02T18:04:47.441-06:00Hey Vaidhyanathan!
You're point is correct. T...Hey Vaidhyanathan!<br /><br />You're point is correct. That being said, the purpose of this report typically would be to provide a particular vendor with data on items they supply, so when the SmartList or SSRS report is run, the user should restrict the output to the particular vendor, which would resolve the problem.<br /><br />As an aside, since there are multiple vendors of for some items, it is important to let the client know, the report contains data, which isn't vendor specific.Anonymoushttps://www.blogger.com/profile/09322326253271593170noreply@blogger.comtag:blogger.com,1999:blog-7144297722159423617.post-87101165504754642902015-11-02T00:46:16.643-06:002015-11-02T00:46:16.643-06:00Hi Harry. I have written similar view to one of my...Hi Harry. I have written similar view to one of my customers. However, that view returned duplicate entries if same product is purchased from more than one vendor. <br /><br />Either the logic of purchasing same product from more than one vendor is wrong OR we may have to modify this view to check who's the primary vendor for this product and take that vendor into consideration.<br /><br />Not sure if you have faced similar challenges before.Anonymoushttps://www.blogger.com/profile/08463813476117822392noreply@blogger.com