[Axapta-Knowledge-Village] Axapta will be phased out after 2 years?

2005-03-13 Thread Koh Meng
Hi all, I heard a news from my friends working in MBS Canada that Axapta will be phased out after 2 years.  May I know is this true or just another grapewine?    __Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http:/

Re: [Axapta-Knowledge-Village] Select where with a filter

2005-03-13 Thread Subrahmanyam Mamidi
Padmaja,   Try this   'select LedgerTrans where LedgerTrans.Accountnum >= 1000 && LedgerTrans.AccountNUm <=2000 && LedgerTrans.TrandsDate= 1\1\2004 && LedgerTrans.Voucher  like  'F111* ';   Thanks, Subbu     Padmaja Iyingar <[EMAIL PROTECTED]> wrote: Hi ,   I am trying to select Sum of  account

RE: [Axapta-Knowledge-Village] Onhand on particular date

2005-03-13 Thread Tony Depalo
Title: Message "InventGroupPhys" is one example based on "as at date" Tony -Original Message-From: Nitesh [mailto:[EMAIL PROTECTED] Sent: Monday, 14 March 2005 2:49 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: Re: [Axapta-Knowledge-Village] Onhand on partic

Re: [Axapta-Knowledge-Village] Onhand on particular date

2005-03-13 Thread Nitesh
Hi Harry, Please tell me the name of that report.   Regards Nitesh - Original Message - From: Harry Deshpande To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, March 14, 2005 1:35 AM Subject: RE: [Axapta-Knowledge-Village] Onhand on par

[Axapta-Knowledge-Village] Select where with a filter

2005-03-13 Thread Padmaja Iyingar
Hi ,   I am trying to select Sum of  accounts's AmoustMST for that particular Voucher series.     ///For example I want to sum up all accounts only for the voucher F111*.   I can not do a substr in the select WHERE clause as its a database field.     'select LedgerTrans where LedgerTrans.Accoun

RE: [Axapta-Knowledge-Village] Onhand on particular date

2005-03-13 Thread Harry Deshpande
Hi Nitesh   This is a standard report in Axapta   Regards   harry         Harry Deshpande Senior Consultant CGNZ Middle Market Solutions Website: www.cgnz.com/middlemarketsolutions Ph +64 29 289 9031 Fax +64 9 358 1018   CGNZ Limited and its predecessor organisat

RE: [Axapta-Knowledge-Village] Re: Demand Planner

2005-03-13 Thread Harry Deshpande
Hi Flemming,   I think you are jumping to too many conclusions:   best of my knowledge there are no known bugs in the Demand Planner. Of course you will always find functionality that doesn't suit you needs 100 %, but that can't be classified as a bug. ** Of course I understand that

[Axapta-Knowledge-Village] Re: reporting tool - Oracle Database - Axapta

2005-03-13 Thread audriusci
Hello Willem, We use Business Objects as reporting tool and Sybase IQ as datawarehouse DB. Every night we run data transformation scripts witch transforms data from Axapta Oracle DB to datawarehouse DB. Running reports directly on Axapta Oracle DB is not recomended couse of perfomance proble