Re: [Axapta-Knowledge-Village] How i can find the sum figures with a specific month and year combo

Anyone knows what is the functionality of LedgerJournalEngine On Thu, 10 Mar 2005 04:59:16 -0800 (PST), Varden Morris <[EMAIL PROTECTED]> wrote: > As far as I know Axapta does not allow you to use function calls in the > WHERE clause of a select statement. You can get around that by using the >

Re: [Axapta-Knowledge-Village] How i can find the sum figures with a specific month and year combo

As far as I know Axapta does not allow you to use function calls in the WHERE clause of a select statement. You can get around that by using the select statement syntax of your back end database as follows. I am using Microsoft SQL.   static void SumByYearANDMonth(Args _args){    Connection  con

[Axapta-Knowledge-Village] How i can find the sum figures with a specific month and year combo

Hi Guys, I have a tricky prob i want to calculate the sum of a field based on the month and respective year. viz. i want what is the sum that have been calculated in the month 6,7,8,9 ... for the year 1995,1996,1997... or more explictly like 6/1995,7/1995,8/1995.or