Could you do an outer join to the ProdGrup table?
I think this way, if there is no product group, you
should get an unknow value in that field, as well as
show all invoices.
Tim Care
Electro Chemical Finishing
I think this way, if there is no product group, you
should get an unknow value in that field, as well as
show all invoices.
Tim Care
Electro Chemical Finishing
----- Original Message -----
From: "Urban, Kenneth" <kurban@...>
To: <vantage@egroups.com>
Sent: Tuesday, October 10, 2000 5:04 PM
Subject: [Vantage] Report Builder credit memo question.
> I'd like to throw out an invoicing report question for some
> enlightenment... Here is our situation:
>
> I have a report that summarizes dollars invoiced by product group by
> month. The joins are pretty simple:
>
> Customer to InvcHead
> InvcHead to InvcDtl
> InvcDtl to ProdGrup
>
> My problem is this: Although there are credit memos in the InvcHead
> table (as evidenced by InvcHead.CreditMemo and InvcHead.InvoiceSuffix
> fields), none of them are being calculated as part of the product group
> totals by month.
> Some digging turned up that rather than issuing the credit memos to
> a sales order, my folks are issuing miscellaneous credit memos to the
> customers, to avoid doing sales-order-line-by-line credits (which don't
> really work for us). Thus, since there isn't a product group, the credit
> memos are being ignored. Any way around this problem?
>
> We are on 4.0.
>
> Kenneth E. Urban
> Manager, Information Systems & Technology
> Major Industries, Inc.
> 7120 Stewart Avenue
> Wausau, WI 54401
> (715) 842-4616 voice
> kurban@...
>
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
>