SV: [development-axapta] Need some help with getting data about sales orders that have already shipped.

2008-06-19 Thread Søren Ager
Den 13. juni 2008 14:15 skrev development-axapta@yahoogroups.com: I know where to get the Requested Ship Date, but I can't seem to figure out where to find the date that an order was actually shipped. InventTrans.DatePhysical (the link is InventTransId)

[development-axapta] Re: How to add a space in btw in the Voucher Number by using Job

2008-06-19 Thread L Kalaiarasi
Hi, Voucher number is available only in ledgerjournaltrans. You can try with this code static void add_VoucherSpace(Args _args) { LedgerJournalTable _ledgerJournalTable; LedgerjournalTrans _ledgerJournalTrans; ; ttsbegin; while select forupdate _ledgerJournalTrans where

[development-axapta] URGENT: Ax 3.0 - Ax 2009 upgrade: Ax 3.0 AOS issue

2008-06-19 Thread Abdul Kadar
Hi team, nbsp; I am working on upgrading from Ax 3.0 SP3 to Ax 2009.nbsp; While setting up an environment for Ax 3.0 SP3 3-tier (AOS and application in one machine, and database in another machine), the AOS is not starting up.nbsp; In 2-tier configuration it was working fine.nbsp; I tried

Re: [development-axapta] Re: Problem running Dynamics AX DB Upgrade Preparation

2008-06-19 Thread david santoso
Hi Vanessa, J, Steffen, I also have a same error when running AxDbUpgrade.exe do you guys already got the solution ? Did the solusion change the sql version (standard or higher version) work ? Cheers, David S On Tue, Mar 25, 2008 at 6:42 PM, steffendenize [EMAIL PROTECTED] wrote: ---

[development-axapta] Re: How to add a space in btw in the Voucher Number by using Job

2008-06-19 Thread L Kalaiarasi
Hi, Can you try out this?. Anyway it is not recommended to change the voucher for posted entries as you need to change multiple tables. static void add_VoucherSpace(Args _args) { LedgerJournalTable _ledgerJournalTable; LedgerjournalTrans _ledgerJournalTrans; ; ttsbegin; while select forupdate

AW: [development-axapta] Problem with simple report.

2008-06-19 Thread jesper.joergensen
Hi Try using the AX Standard way of getting an query for inventory on hand. You will find that on the table InventDim. Query query; QueryRunqueryRun; inventDimParm inventDimParmCriteria; inventDimParm inventDimParmGroupby; InventDim

Re: [development-axapta] Re: Problem running Dynamics AX DB Upgrade Preparation

2008-06-19 Thread Steffen Denize
Hi David Yes, changing the SQL-version to a std. or higher version did the trick for me. Cheers, Steffen 2008/6/18 david santoso [EMAIL PROTECTED]: Hi Vanessa, J, Steffen, I also have a same error when running AxDbUpgrade.exe do you guys already got the solution ? Did the solusion