Hello, I am new to Axapta so please forgive me if this is an easy
question.
I am trying to make a calculated field and a group by in the same
query. This is the query I'm trying to reproduce in Axapta:
SELECT Sum(SalesLine.RemainSalesPhysical*SalesLine.SalesPrice),
SalesLine.salesID FROM SalesLine GROUP BY SalesLine.salesID;
If you don't understand that, I'm trying to retrieve the total
amount for all the physical remaining on each sales order. I am
open to an easier way to do this if anyone knows of one.
I am trying to use as little code as possible in my reports but am
willing to use code if that is the only way to accomplish this.
Thanks in advance for any help!
Ryan
| Yahoo! Groups Sponsor | |
|
|
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.
