Belgin, Thank you for this reply. It looks like the sql error I am receiving is a false positive error. But your reply makes me wonder if I'm interpreting the Title of the report incorrectly. Is the Purchases by Organization Report only for Purchases made by my company?
I was thinking that it would list purchases of my products made by other Organizations. I am in need of a report such as this. One that lists customer name, product, price. Guess I'll have to build from scratch. Thanks again, Case Torres [EMAIL PROTECTED] > -----Original Message----- > From: Bilgin Ibryam [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 20, 2008 11:04 AM > To: [email protected] > Subject: Re: getting same error message on 3 separate > revisions of ofbiz > > Hi Case, > > In latest trunk Purchases by Organization Reports are working. > Not sure that this is your case, but if you create purchase > order w/o supplier party, and then use change party and add a > supplier to the order, the order will be created w/o > BILL_FROM_VENDOR role. And these orders are not shown in > Purchases by Organization Report. > In rev629396 i fixed this bug. > > Some entities (probably OrderReportPurchasesGroupByProduct > entity too) cannot be viewed from webtools. > > Bilgin > >
