>aggregation in views are just based on numerical values.
Nope, you can group on string too. Using the sum field will group your fields. Here's what the view would look like...
SalesTable
|
+-> SalesLine On SalesTable.SalesId = SalesLine.SalesId
|
+-> InventDim On InventDim.InventDimId = SalesLine.InventDimId
Fields :
InventDimId.InventLocationId
SalesTable.DeliveryDate
SalesTable.SalesId
SalesLine.ItemId
SalesLine.SalesQty (Sum Field)
More explanation would be an XPO.
Try it.
Regards,
Steeve...
-----Message d'origine-----
De�: k_otickashka [mailto:[EMAIL PROTECTED]
Envoy�: 14 avril 2004 00:39
��: [EMAIL PROTECTED]
Objet�: Re: RE : [development-axapta] How do I group Items and sum their SalesQty by Delivery date
Also if i use a view how would i group those fields plus I thought
aggregation in views are just based on numerical values.
--- In [EMAIL PROTECTED], "k_otickashka"
<[EMAIL PROTECTED]> wrote:
> What if I wanted to display the Sales item's location that is the
> warehouse and group them that way.
>
> --- In [EMAIL PROTECTED], "Steeve Gilbert"
> <[EMAIL PROTECTED]> wrote:
> > I would create a view that contains SalesTable and SalesLine with
> only the fields needed and use that view in the dataSource of the
> report. That way it would be easy to sort and group in the
report.
> I'm a bit of a view freak, I use view everywhere.
> >
> > Steeve...
> >
> > -----Message d'origine-----
> > De�: k_otickashka [mailto:[EMAIL PROTECTED]
> > Envoy�: 13 avril 2004 16:31
> > ��: [EMAIL PROTECTED]
> > Objet�: [development-axapta] How do I group Items and sum their
> SalesQty by Delivery date
> >
> > I would like to print a report that represents a summary of a
> sales
> > order. In this report I would like each item that is repeated in
a
> > salesLine for each salesorder to be grouped and sum the quantity
> > based on the delivery date of the sales order. EXAMPLE:
> >
> >
> > SALESORDER 1
> > DELIVERYDATE= 16/01/2002
> > SALESLINE
> > =========
> > ITEM= OL-1000
> > QUANTITY = 20
> >
> > SALESORDER 2
> > DELIVERYDATE= 16/01/2002
> > SALESLINE
> > =========
> > ITEM= OL-1000
> > QUANTITY = 40
> >
> > The report should display:
> >
> > DATE 16/01/2002
> > ITEM QUANTITY
> > OL-1000 60
> > ----------------------------------------------------------
> > How can I achieve this?
> >
> >
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
