If I understand you correctly, you can are trying to create an inquiry form
that will display sum qty of sale line group by item group. This inquiry
form is then called from sales order.
That can be achieved by creating view of three tables, salesline,
inventtable and inventitemgroup.
This view is then put as form datasource with grouping is set to per
itemgroupid.
Override executequery method of the datasource to make a group by and filter
salesline based on the caller (salestable). Also specify sum of the qty
field in the query.
Regards,
Agus
On 4/26/06, icham icham <[EMAIL PROTECTED]> wrote:
>
> Hello all,
>
> I must create a form called since the customer order
> form which must contain the sum of the quantities (of
> sales lines ordered by item group) by "item group"
>
>
> for Ex :
> Item Group "Parts" = 10
> (line1 qty=3 + line3 qty=7
> line1 and line3 belong to the same item group)
>
> Item Group "Lamps" = 13
> (line2 qty=11 + line4 qty=2
> line2 and line4 belong to the same item group)
>
>
> Plz anyone could give me year program example for
> this. I don' T know how to do that
>
> Thank you ;)
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> Sharing the knowledge on Axapta.
> Visit www.frappr.com/axapta for axapta friends.
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Sharing the knowledge on Axapta.
Visit www.frappr.com/axapta for axapta friends.
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
