Re: [development-axapta] Pda with Dynamics Ax
Hi Try this link for the installer https://mbs.microsoft.com/partnersource/downloads/releases/mobilesolutions.htm?printpage=false and this is the help files http://msdn.microsoft.com/en-us/library/cc160851.aspx Cheers, David S On Tue, Sep 2, 2008 at 1:56 AM, pisonnic <[EMAIL PROTECTED]> wrote: > Dear all, > > I have to implement a new functionality "warehouse management". This > improvement we will use with a PDA. > What is the best way to connect the PDA with Dynamics Ax Server and > run automatically the new improvement? With terminal Server? Citrix? > > Thanks in advanced, > > Best regards. > > > [Non-text portions of this message have been removed]
Re: [development-axapta] Serious Recid problems
Hi James, Did you notice that when you upgrade from ax 3.0 SP4 into ax 4.0, you have to run the upgrade column list 9 the purpose to change the recid into int64. My company has upgrade from 2.5 -> 3.0 SP 6 -> 4.0 SP2 for 1 month, and has run the posting confirm smoothly. Cheers, David S On Fri, Aug 22, 2008 at 5:18 PM, James Flavell <[EMAIL PROTECTED]> wrote: > Hi everyone, somethign interesting to share and praying someone might > have > some ideas of how to fix or investigate further: > > In the SalesTable form in the active method for Salestable datasource there > is code that checks whether the Functions button on the header should be > enabled. > > We have the situation that this code returns False even though there is a > RecId for some salestables. We found the KB 930416 which mentions about > similar problem but we have the required hotfix/build and are still getting > a problem. > > What we noticed was if we convert salestable.recid to a boolean first and > then test this it is okay but not if we just do enabled(salestable.recid) > > This does not work: > buttonHeaderFunction.enabled (salesTable.RecId); ->change boolean > > This works (htktestbol is of type boolean): > htktestbol = (salestable.recid); > buttonHeaderFunction.enabled (htktestbol); > > The salestable record having the problem is having a recid value that is a > BigInt (i.e. the recid is too large to fit in an Int) > > We have one more problem that has also appeared and that is for certain > inserts such as posting of order confirmation we get an SQL error (see > below) we are wondering is this also due to the recid not testing as true!? > > SQL error: > Cannot create a record in Confirmation journal (CustConfirmJour). Order > Confirmation: , 20016. The SQL database has issued an error. > operation cancelled > An error occurred durign update > > This error can happen on various tables not just Confirmation journal. > > We tested and found the following results. If we do an AX def export of the > company and then imported into a new company: > 1) if we import in to the same SQL database but just a new company the > problem still happens in the new company > > 2) if we import into a clean SQL database there is no problem > > To us this suggest some issue with RecId (and maybe SystemSequence table or > something that is shared across all companies?) > > Note this is an Ax3.0 SP4 upgraded to Ax4.0 > > Thanks > James > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
[development-axapta] Re: Left Justify Takes Long Time (Upgrade 3.0 - 4.0)
Hi All, I've already found the way to optimize Left Justify Job. 1. After Import LeftJustifyJob.xpo, Klik Display Command button. (Copy the sql syntax) 2. Run AxDbUpgrade Tool 3. Run the sql syntax (no 1) on SQL Query Analyzer (SQL2k) or SQL Management Studio (SQL2K5) It have saved a lot of time..! Cheers, David S On Sat, Jul 5, 2008 at 1:49 PM, david santoso <[EMAIL PROTECTED]> wrote: > Hi Guys, need some help and advice from you. > > When we upgrade from Ax 3.0 to Ax 4.0, we run the left justify xpo files > and it takes 7-8 hours, just for the run that job. > > Is there any tips or trick to optimized this job, run in sql perhaps.? > > Coz my company only have 2 days for upgrade from Ax 2.5 to 4.0 > > Cheers, > > David S > > [Non-text portions of this message have been removed]
[development-axapta] Run DAX 4.0 Sp1 Client on DAX 4.0 SP2 AOS
Hi All, I have installed DAX 4.0 SP 2 for Application, AOS and also Client on Server. I install & run DAX 4.0 with SP1 Client ( actually i forgot to install SP2 Client), i have run with DAX for 1 week and nothing goes wrong. Is that ok DAX 4.0 with SP 1 Client connect to AOS DAX 4.0 with SP 2 ? Did the changes only apply on AOS & application server only ? Any information & suggestion will be helpful. Cheers, David S [Non-text portions of this message have been removed]
[development-axapta] Left Justify Takes Long Time (Upgrade 3.0 - 4.0)
Hi Guys, need some help and advice from you. When we upgrade from Ax 3.0 to Ax 4.0, we run the left justify xpo files and it takes 7-8 hours, just for the run that job. Is there any tips or trick to optimized this job, run in sql perhaps.? Coz my company only have 2 days for upgrade from Ax 2.5 to 4.0 Cheers, David S [Non-text portions of this message have been removed]
Re: [development-axapta] Query sentence or and Like
Hi, I think a lot of people have already asked this question, you should browse this forum. I give you the example code: qbr = this.query().datasourcetable(tablenum(custTable)).addrange(fieldnum(custtable, recid)); range = strfmt('((%1 == \"%2\") || (%3 == \"%4\"))', fieldstr(CustTable,Name),name, fieldstr(CustTable,InvoiceAccount),account); qbr.value(range); Cheers, David S On Thu, Jul 3, 2008 at 6:01 PM, jasuarezh <[EMAIL PROTECTED]> wrote: > Hello, > > I have a problem, I need to create a query with a condition OR, in this > condition have a comparison with Like. > > My query in SQL is: > > select * from TABLA1 where TABLA1.campo1 like '%%' || TABLA1.campo2 > like '%%' > > How I do in Axapta this query??? > Thanks you very much > > > [Non-text portions of this message have been removed]
Re: [development-axapta] Importing data into Invent table.
Hi Tri, The cause, probably because of : - On InventTableModule Table you should create 3 module type (Inventory, Purchase Order, SalesOrder) for each item. - On InventItemLocation Table you should create item with default inventdimid (in ax 3.0 is "Axapta") If you still can't find the item in item form, you can create item manually in item form and compare with yours. Cheers, David S 2008/7/1 <[EMAIL PROTECTED]>: > HI, > > is your InventDim there? (InventItemLocation.InventDimId = > InventDim::findOrCreate(inventDim)? > > Mit freundlichen Grüßen / Best regards / Med venlig hilsen > > Jesper Jørgensen / Abt. NMT-XD > Senior Product Manager > > arvato systems | Technologies GmbH > An der Autobahn 18 > 33311 Gütersloh > > [EMAIL PROTECTED] > [EMAIL PROTECTED] > > > Phone: +49 5242 / 40 80 54 > > Fax: +49 5242 / 40 80 40 > > Mobile: +49 172 / 571 03 34 > > http://www.as-T.biz http://www.as-t.biz/> > arvato systems | Technologies GmbH > Joachim-Jungius-Str. 9, 18059 Rostock > Geschäftsführung: Erwin Pietz, Matthias Moeller > Amtsgericht Rostock - HRB 7497 > > > > "Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und > ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie > sicher, dass die Information in dieser Nachricht ausschließlich an die > adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie > gesendet worden sein, dann informieren Sie bitte umgehend den Absender und > löschen Sie die Nachricht. Vielen Dank." > > "The information in this e-mail and any attachments is confidential. The > information must only be held in areas that have controlled and limited > access to the addressed persons. If this e-mail has been sent to you in > error, please immediately notify the sender and delete the e-mail. Thanks." > > > > > > Von: > development-axapta@yahoogroups.com[mailto: > development-axapta@yahoogroups.com ] > Im Auftrag von Trinadh C > Gesendet: Dienstag, 1. Juli 2008 06:18 > An: [EMAIL PROTECTED] > Cc: development-axapta@yahoogroups.com > Betreff: [development-axapta] Importing data into Invent table. > > > Dear Ali, > We populated the tables (InventTableModule and InventItemLocation) and > tried to import the data in Ax4.0 Sp2. But still the data could be seen only > in the table level. Could you please suggest the process of importing the > data. > > Reply to this mail asap is highly appreciated. > > -- > Regard's.., > Trinadh. > > -- > > THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the > individual > to whom it is addressed. > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
Re: [development-axapta] Re: help with Invalid NumeralsToTxt Result
Hi Wahyu. I'm using Axapta 3.0 SP 6 and it works fine for that function. I'm sure that the cause is convert into max integer value. For example if you declare int i =31131178729; ; info(strfmt("%1", i)); //--> 2147483647 it will return 2147483647 not 31131178729 perhaps you should try to change the datatype into real Cheers, David S On Tue, Jul 1, 2008 at 6:43 AM, J <[EMAIL PROTECTED]> wrote: > It is a known bug in V3. Partnersource has a hotfix: > https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en- > us;901373 > > --- In > development-axapta@yahoogroups.com, > Tony Zeigler > <[EMAIL PROTECTED]> wrote: > > > > Hrm, SP4 isn't the most current, but not sure if the issue would be > fixed by getting current. That would be my first attempt tho - > because I definately got a different result than you did. > > > > > > --- On Mon, 6/30/08, Wahyudin Zakie <[EMAIL PROTECTED]> wrote: > > > > From: Wahyudin Zakie <[EMAIL PROTECTED]> > > > Subject: Re: [development-axapta] help with Invalid NumeralsToTxt > Result > > To: development-axapta@yahoogroups.com > > Date: Monday, June 30, 2008, 3:05 AM > > > > > > > > > > > > > > I'm using axapta 3.0 SP4. > > > > --- On Fri, 6/27/08, Tony Zeigler wrote: > > > > From: Tony Zeigler > > Subject: Re: [development- axapta] help with Invalid NumeralsToTxt > Result > > To: development- [EMAIL PROTECTED] ps.com > > Date: Friday, June 27, 2008, 8:31 AM > > > > This seems to give me the correct answer: > > static void Job1(Args _args) > > { > > ; > > info(numeralsToTxt( 31131178729. 00)); > > } > > > > Not sure why yours would be giving a different answer. (I'm using > 4.0 with current patch) > > > > --- On Thu, 6/26/08, Wahyudin Zakie <[EMAIL PROTECTED] com> wrote: > > > > From: Wahyudin Zakie <[EMAIL PROTECTED] com> > > Subject: [development- axapta] help with Invalid NumeralsToTxt > Result > > To: development- [EMAIL PROTECTED] ps.com > > Date: Thursday, June 26, 2008, 8:41 PM > > > > hi, > > I've a problem with NumeralsToTxt function. i have invoice amount = > IDR 31,131,178,729. i want to convert it to says number, i'm using > numeralstotxt function but the result is wrong. i try to test this > code with job like this. > > > > info(strfmt( "%1",numeralsToT xt(31131178729. 00))); > > > > it says : "Two Billion One Hundred Forty Seven Million Four Hundred > Eighty Three Thousand Six Hundred Forty Seven and 00/100" > > > > is it a bug??? > > > > Thank's for your reply... > > > > Zakie > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > [Non-text portions of this message have been removed]
Re: [development-axapta] Getting Error while opening a report
Hi pranam, I've also had the same experience with you. I just change the printer setting (choose available printer, make sure the printer is available ) And it solve the problem. Cheers, David S On Mon, Jun 23, 2008 at 11:50 PM, Tony Zeigler <[EMAIL PROTECTED]> wrote: > Hrm, I had an issue where a report was writing an error to the file, but > the source of the issue was in custom code. What happened was that the > programmer had output everything to a file in the tmp directory, but the tmp > directory did not exist on this particular server, so it was unable to > create it. When the app went to send the file it ended up sending the error > message instead > > Again tho, this was custom code... > > --- On Thu, 6/19/08, pranam mukher <[EMAIL > PROTECTED]> > wrote: > > From: pranam mukher <[EMAIL PROTECTED] > > > Subject: [development-axapta] Getting Error while opening a report > To: [EMAIL PROTECTED], > development-axapta@yahoogroups.com > Date: Thursday, June 19, 2008, 11:35 PM > > > Hi all > i am getting some strange error whenever i try o open any report in AOT. > attached is the file , which contains a error message. > > it says : Create IC(WinsPool, Microsoft XPS, Document Writer ) > > is it something related to the Printer Setup, or report Setup issues. > pls clarify. > > - - --- > Best Jokes, Best Friends, Best Food. Get all this and more on Best of > Yahoo! Groups. > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
Re: [development-axapta] Report error
Hi Asit, You can use Batch Processing to run the report and may be export to PDF or Txt, just specify batch group, what times, the frequency. And you have to run the batch server in order to run the batch processing. Cheers, DavidS On Tue, Jul 1, 2008 at 9:42 PM, asit nayak <[EMAIL PROTECTED]> wrote: > Hi All, > I have a report where i need to run this report automatically on everyday > on a specific time. > > Please let me know how can i run the report automatically on every day. > > Thanks > Asit > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
Re: [development-axapta] I need Axapta 3.0 sp6
Hi Karani, You can download and find out the fix list ax 3.0 with sp 6 on this link : https://mbs.microsoft.com/partnersource/downloads/servicepack/dynax30_sp6.htm?printpage=false But it requires MBS partnersource / customersource logon Cheers, Davids On 6/18/08, karani_yilmaz <[EMAIL PROTECTED]> wrote: > I now use axapta 3.0 sp4 , how can I find sp6, > What is the fix list for sp6 > Thank you > >
[development-axapta] Upgrade Post-Synchronize Ax 2.5 -> 3.0 Takes Long time
Hi All, I'm having problem with upgrade version axapta from 2.5 to 3.0. Our Platform are SQL 2000 SP 4 and Axapta 3.0 SP 6 (KR1) Our database is 140 GB, and we already shrink the data (limit the transactions) into 90 GB. I've already done the step by step upgrade things until post-synchronize phase. When run the post-synchronize phase, it run batch-processing (we need to open another client axapta to process batch) And when it run Class ReleaseUpdateDB_V30toV30SP method updateCustSalesLinkTable() . it takes more than 2 days and it still running until now (not finished yet). i've already seen inside the method, it will query to tables : CustConfirmTrans CustConfirmjour CustQuotationTrans CustQuotationJour CustPickingListTrans6.582.261 CustPickingListJour 778.989 CustPackingSlipTrans CustPackingSlipJour CustInvoiceTrans 15.920.771 records CustInvoiceJour2.038.269 records And the syntax like this "while select ..." without indexing, so it will take a lot of time for searching each record. Should i upgrade to SQL 2005 for the database server first, Does it matter ? when is the best moment for upgrade ? And can i open more than 1 client to run the batch processing, i think it will perform faster ? Any suggestions, will help a lot. Thanks before. Cheers, David S [Non-text portions of this message have been removed]
Re: [development-axapta] Data Upgrade 3.0 to 4.0
Hi Suneel & Amit, The solution works, so the error "target database is not empty and UNICODE table does not exist" is solve. Cheers, David S On Tue, Jun 24, 2008 at 9:37 AM, david santoso <[EMAIL PROTECTED]> wrote: > Hi Suneel & Amit, > > My Company also want to upgrade from Ax 3.0 to Ax 4.0. > > For this error "target database is not empty and UNICODE table does not > exist" Did the solution works, Suneel ? > > And is there any issue when you do the upgrade ax 3.0 to 4.0, besides this > error ? > > Thanks b4 > > David > > > On Tue, May 20, 2008 at 9:34 PM, amit bhatt <[EMAIL PROTECTED]> wrote: > >> Hi Suneel, >> the problem is there because you have started AX40 services while >> installing Ax40. >> When you install Ax40 plss don't check a checkbox which comes last in the >> instalation wizard, and start Ax40 services only after you have upgraded >> database. >> Thanks >> Amit >> >> >> suneel babu <[EMAIL PROTECTED] > wrote: >> Dear All., >> I had a problem when upgrading Ax 3.0 database to ax 4.0 by using Data >> upgrade tool given in DVD. >> It shows "target database is not empty and UNICODE table does not exist". >> Plz solve my problem. its very urgent. Is there any other way to upgrade 3.0 >> database to 4.0. >> >> >> Thanks in Advance.. >> >> >> Regards., >> Suneel. >> __ >> No Harvard, No Oxford. We are here. Find out !! >> http://ss1.richmedia.in/recurl.asp?pid=500 >> >> [Non-text portions of this message have been removed] >> >> >> >> >> >> [Non-text portions of this message have been removed] >> >> >> > > [Non-text portions of this message have been removed]
[development-axapta] Re: Upgrade Ax 3.0 to Ax 4.0, UNICODECONV table does not exist
Hi All, I've already known what is the cause, "UNICODECONV table does not exist" When I install Ax 4.0 (Application, AOS & Client) i should not "check the Start AOS after finished installed" Cheers, Davids On Mon, Jun 16, 2008 at 3:58 PM, david santoso <[EMAIL PROTECTED]> wrote: > Hi, > > My Client wants us to Upgrade From Upgrade Ax 3.0 SP6 KR 3 to Ax 4.0 SP1 > > I Have Run the Code Upgrade & Database Upgrade. > > But When I run the Dynamics Ax DB Upgrade Preparation tool, I get an error > message saying: > "The target db is not empty, UNICODECONVtable does not exist: please check > the db." > > The target db is created with the installation program as the > implementation > guide instructs. > The UNICODECONV table is missing alright - but why? > > Cheers, > > David S > [Non-text portions of this message have been removed]
Re: [development-axapta] Re: Problem running Dynamics AX DB Upgrade Preparation
Hi Steffen, Thanks for the tips. After i installed Sql Server Standard SP 2, it works now. Cheers, Davids On Thu, Jun 19, 2008 at 4:54 PM, Steffen Denize <[EMAIL PROTECTED]> wrote: > 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 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: > > > > > --- In > > > development-axapta@yahoogroups.com > > > , > > > > > "J" <[EMAIL PROTECTED]> wrote: > > > > > > > > > When running AxDbUpgrade.exe it display the following error: > > > > > === > > > > > Copying tables with 1 thread(s). > > > > > > > > Vanessa, when I got similar errors, I ran the SQL statement through > > > > SQL Server Management Studio and got a much more informative error. > It > > > > should be tremendously more useful than the one you got. > > > > > > > > I have had similar errors when I a) tried to upgrade FRx tables, and > > > > b) used a mapped drive. > > > > > > > > Good luck > > > > J > > > > > > > I got a similar error - it appears that the db upgrade tool only > > > functions probably on a std. version or higher of the SQL-server. > > > When I received that error, I was trying to run the db upgrade tool on > > > a developer ed. of SQL-server. > > > > > > You can identify your SQL version by following these steps: > > > http://support.microsoft.com/kb/321185 > > > > > > Hope it helps, > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > -- > Dynamics AX - blog > http://denizone.blogspot.com > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
Re: [development-axapta] Upgrade steps from Axapta 3.0 SP3 to Axapta
Hi Amit, My Company also wants to upgrade ax 3.0 to 4.0 SP2. I find this useful link on https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID=%7B863D51CC-3127-4E83-94A7-AE95CE9E660D%7D&NRORIGINALURL=/partnersource/resources/support/selfsupport/hottopics/axapta/ax30to40upgrade.htm?printpage=false&NRCACHEHINT=Guest&PrintPage=true&wa=wsignin1.0 Cheers, DavidS On Sat, May 17, 2008 at 8:20 AM, amitjain_in <[EMAIL PROTECTED]> wrote: > Hi, I am upgrading system from Axapta 3.0 SP3 to Axapta 4.0 SP2. Can > anyone give me suggestions on these questions? > > 1. What are hotfixes to apply during upgradation and at what stage? > > 2. Axapta 4.0 is using Active directory, so what needs to be done for > that? I am getting an error that "Database has issued an error in > table sysuserinfo. UserId = 'admin' does not exist." what should i do > in this case? > > 3. There is no runable code in new method of class application. I can > see this is working perfectly fine in 3.0 SP3 environment. When i am > in the 4.0 SP2 environment, everytime i try to compile any object, > it gives me same error as mentioned in point 2. When i try to open a > form from Main menu e.g. Sales order form, nothing happens when i > click that menuitem. Am i missing something? > > This is very urgent, so i would appreciate a quick response. > > Regards > Amit > > > [Non-text portions of this message have been removed]
Re: [development-axapta] Data Upgrade 3.0 to 4.0
Hi Suneel & Amit, My Company also want to upgrade from Ax 3.0 to Ax 4.0. For this error "target database is not empty and UNICODE table does not exist" Did the solution works, Suneel ? And is there any issue when you do the upgrade ax 3.0 to 4.0, besides this error ? Thanks b4 David On Tue, May 20, 2008 at 9:34 PM, amit bhatt <[EMAIL PROTECTED]> wrote: > Hi Suneel, > the problem is there because you have started AX40 services while > installing Ax40. > When you install Ax40 plss don't check a checkbox which comes last in the > instalation wizard, and start Ax40 services only after you have upgraded > database. > Thanks > Amit > > > suneel babu <[EMAIL PROTECTED] > wrote: > Dear All., > I had a problem when upgrading Ax 3.0 database to ax 4.0 by using Data > upgrade tool given in DVD. > It shows "target database is not empty and UNICODE table does not exist". > Plz solve my problem. its very urgent. Is there any other way to upgrade 3.0 > database to 4.0. > > > Thanks in Advance.. > > > Regards., > Suneel. > __ > No Harvard, No Oxford. We are here. Find out !! > http://ss1.richmedia.in/recurl.asp?pid=500 > > [Non-text portions of this message have been removed] > > > > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
Re: [development-axapta] Re: Problem running Dynamics AX DB Upgrade Preparation
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: > --- In > development-axapta@yahoogroups.com, > "J" <[EMAIL PROTECTED]> wrote: > > > > > When running AxDbUpgrade.exe it display the following error: > > > === > > > Copying tables with 1 thread(s). > > > > Vanessa, when I got similar errors, I ran the SQL statement through > > SQL Server Management Studio and got a much more informative error. It > > should be tremendously more useful than the one you got. > > > > I have had similar errors when I a) tried to upgrade FRx tables, and > > b) used a mapped drive. > > > > Good luck > > J > > > I got a similar error - it appears that the db upgrade tool only > functions probably on a std. version or higher of the SQL-server. > When I received that error, I was trying to run the db upgrade tool on > a developer ed. of SQL-server. > > You can identify your SQL version by following these steps: > http://support.microsoft.com/kb/321185 > > Hope it helps, > > > [Non-text portions of this message have been removed]
[development-axapta] Upgrade Ax 3.0 to Ax 4.0, UNICODECONV table does not exist
Hi, My Client wants us to Upgrade From Upgrade Ax 3.0 SP6 KR 3 to Ax 4.0 SP1 I Have Run the Code Upgrade & Database Upgrade. But When I run the Dynamics Ax DB Upgrade Preparation tool, I get an error message saying: "The target db is not empty, UNICODECONVtable does not exist: please check the db." The target db is created with the installation program as the implementation guide instructs. The UNICODECONV table is missing alright - but why? Cheers, David S [Non-text portions of this message have been removed]
[development-axapta] Hot Fix Secondary Currency in Financial Statement
Hi All, I Tried to use the secondary currency when creating a row in my AX4.0Financial statement. 2nd currency entry(IDR) and for home (USD) However i create a row and use column type secondary currency and nothing appears in my Fin statement I've Checked out the hotfix in mbs site, link : https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;931695 But The Link is not longer exist, i've tried to report this link but only for the mbs partner that have credit to download. Have anybody has this hotfix ? please shared with me also, i've project that should be closing last month ( may 2007) Thank's in advance Regards, Davids [Non-text portions of this message have been removed]
Re: [development-axapta] Re: Query Addrange For Array Fields...!
Hi Steeve, Thx For The Answer, But it still not working, still have same error message "Query Extended Range Failure.." On 6/7/07, Steeve Gilbert <[EMAIL PROTECTED]> wrote: > > Just making sure it's not a typo on the message : > > range = strfmt('(((Dimension == "P-001") || ((Dimension[2] == > I guess Dimension should be Dimension[1]. > > Steeve... > > --- In > development-axapta@yahoogroups.com, > "david santoso" > <[EMAIL PROTECTED]> wrote: > > > > Hi All, > > > > i wanna create querybuild datasource using OR for array fields > > > > for ex : > > > > show salestable with dimension[1] = 'P-001' or dimension[2] = 'Q- > 001' > > > > i've try with this code, but it didn't work. > > > > Query q; > > QueryBuildDataSource qbds; > > QueryRun qr; > > QueryBuildRange qbr; > > Range range; > > ; > > super(); > > > > q = new query(); > > qbds = q.addDataSource(Tablenum(SalesTable)); > > qbr = qbds.addrange(fieldId2ext(fieldnum > (SalesTable,Dimension),2)); > > range = strfmt('(((Dimension == "P-001") || ((Dimension[2] == > > "Q-001")))'); > > > > > > qbr.value(range); > > qr = new queryrun(q); > > SalesTable_ds.query(q); > > SalesTable_ds.queryRun(qr); > > > > Any Suggestion would be helpfull, > > > > Thx > > > > Davids > > > > > [Non-text portions of this message have been removed]
[development-axapta] Query Addrange For Array Fields...!
Hi All, i wanna create querybuild datasource using OR for array fields for ex : show salestable with dimension[1] = 'P-001' or dimension[2] = 'Q-001' i've try with this code, but it didn't work. Query q; QueryBuildDataSourceqbds; QueryRunqr; QueryBuildRange qbr; Range range; ; super(); q = new query(); qbds = q.addDataSource(Tablenum(SalesTable)); qbr = qbds.addrange(fieldId2ext(fieldnum(SalesTable,Dimension),2)); range = strfmt('(((Dimension == "P-001") || ((Dimension[2] == "Q-001")))'); qbr.value(range); qr = new queryrun(q); SalesTable_ds.query(q); SalesTable_ds.queryRun(qr); Any Suggestion would be helpfull, Thx Davids
[development-axapta] display customer in customize company account
hi all i'm using Ax 3.0 Sp4 KR 2 i've got problem when display customize customer in all company account. for ex : all company account = pst, jkt, bdg when i'm in pst i wanna display all customer in company pst, jkt, bdg But when i'm in jkt or bdg just display jkt or bdg only thx in advance [Non-text portions of this message have been removed]
[development-axapta] Select Sum n Rounding in Axapta ???
Hi All,... i'm beginner on axapta 3.0 sp3 I'm gonna design report with rounding value. Does Anybody Know the syntax Sqlserver using on Axapta, Now i'm using select syntax like this : while select SumTaxMST from CustInvoiceJour_1 where CustInvoiceJour_1.TaxGroup == 'PPNK-2' && CustInvoiceJour_1.ClosePeriod == 6 { SumTaxB += round(CustInvoiceJour_1.SumTaxMST,1); } i know it's better, if the syntax like this : select sum(SumTaxMST) from CustInvoiceJour_1 where CustInvoiceJour_1.TaxGroup == 'PPNK-2' && CustInvoiceJour_1.ClosePeriod == 6; But the value of sum is not rounding,... Plz tell me the right syntax thx in advance, David Santoso [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.
[development-axapta] Select Sum n Rounding in Axapta ???
Hi All,... i'm beginner on axapta 3.0 sp3 I'm gonna design report with rounding value. Does Anybody Know the syntax Sqlserver using on Axapta, Now i'm using select syntax like this : while select SumTaxMST from CustInvoiceJour_1 where CustInvoiceJour_1.TaxGroup == 'PPNK-2' && CustInvoiceJour_1.ClosePeriod == 6 { SumTaxB += round(CustInvoiceJour_1.SumTaxMST,1); } i know it's better, if the syntax like this : select sum(SumTaxMST) from CustInvoiceJour_1 where CustInvoiceJour_1.TaxGroup == 'PPNK-2' && CustInvoiceJour_1.ClosePeriod == 6; But the value of sum is not rounding,... Plz tell me bout the syntax thx in advance, David Santoso [Non-text portions of this message have been removed] SPONSORED LINKS Computer part Programming languages Microsoft axapta Support exchange YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.
[development-axapta] Display method
Hi guys,... my name is davids, newbie on axapta i need u'r advise... Here is bout the case. I 've made form from 2 datasource ( CustpackingslipJour, CustpackingslipTrans) & want to make display method that is customer name on grid (datasource Custinvoicejour) i've made this display method on datadictionary | custpackingslipjour like this display CustName orderName() { return CustTable::find(this.OrderAccount).Name; } And on grid Control i made string edit which is datasource custpackinglsipjour n methodname ordername it has display the customer name, but the problem is we can't find by customer name < my point is right click & find customer name> has anybody experience on this ? thx in advance. YAHOO! GROUPS LINKS Visit your group "development-axapta" 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.