[development-axapta] Re:Using other compare tools for code merge?
I've used a nice tool called Compare and Merge (http://www.compareandmerge.com). I use it to do side-by-side comparisons of XPO files. Jim Chwaszczewski | Senior Consultant | Wipfli LLP | Office: 920.662.2917 469 Security Blvd, Green Bay, WI 54313 www.wipfli.com http://www.wipfli.com A division of Wipfli LLP -- The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP CPAs and Consultants -- [Non-text portions of this message have been removed]
[development-axapta] Re: New table in AX
You can also run update the XRef from Tools, Development tools, Cross-reference, Periodic, Update. Uncheck all the boxes except Update Data Model and Update Type Hierarchy. It takes about a minute to run. Jim Chwaszczewski Wipfli, LLP Email: jchwaszczew...@wipfli.com mailto:jchwaszczew...@wipfli.com -- The content of this e-mail and any attached files is confidential, and may be subject to certain privilege. This e-mail is intended for the designated recipient(s) only. If you have received this e-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this e-mail (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP CPAs and Consultants -- [Non-text portions of this message have been removed]
[development-axapta] Re:query - date criteria
Karen: It would be nice if AX allowed you to put something like d+2 in the query criteria, but the date shortcuts only work in date fields. Try this link: http://www.dynamics-ax-addons.com/en/add_ons/smart_query.html Jim Chwaszczewski Wipfli, LLP Email: jchwaszczew...@wipfli.com -- The content of this e-mail and any attached files is confidential, and may be subject to certain privilege. This e-mail is intended for the designated recipient(s) only. If you have received this e-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this e-mail (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP CPAs and Consultants -- [Non-text portions of this message have been removed]
[development-axapta] Re:I need urgent help
--- excerpt I am working on a project and have created a form calculates the number of allowed rental cars per months. It tracks the allowed, rented and remaining slots. This is saved in a table and the form is called from the CustTable form. My questions is this table is a user(account number) specific and I want to create another or similar form that is going to be address specific since same customer (or account number) can rent again but return it to different locations (address specific). Same logic will be used, however the logic checks the rental entry with the allowed number and if it car rental requested more than allowed and it is placed on a credit hold with a reason. I plan to use the Address form for the address. What do you suggest for this? I am thinking to create another table for the lines (address specific) and do the logic on a form base or add a class to do the logic. --- I believe your first requirement is Limit how many cars can be rented by a CustId. MaryAnn's suggestion about adding the check to the credit-limit processing is good. Your second requirement sounds hazy. Why are pick-up and return addresses customer-specific? I would think addresses would be tied to a rental location or possibly tracked as part of each rental transaction. In other words, are there other elements of your project that track a rental where you could track the pick-up and return locations? Jim Chwaszczewski Wipfli, LLP -- The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP CPAs and Consultants -- [Non-text portions of this message have been removed]
[development-axapta] Field Encryption
Has anyone done coding for field encryption? I want selected data encrypted in the database (for example, custom passwords, Social Security numbers, etc.). I'm guessing I can call something with WinAPI in 3.0. I presume that I can use something in .NET classes in 4.0. Jim Chwaszczewski Wipfli, LLP The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed]
[development-axapta] RE: How to find out how far on the page a report has printed
Martin, there are element properties/methods on the report called (something like) element.mmLeft, element.PageHeight100mm. You shouldn't have to keep a running total of the headers and lines printed. Jim Chwaszczewski JChwaszczewski (@) wipfli . com Message 3 From: mdegroot1950 [EMAIL PROTECTED] Date: Wed May 17, 2006 1:49am(PDT) Subject: How to find out how far on the page a report has printed Hello colleague Axapta developers, I have a report with a table field which can be 1000 characters long, but it can also contain zero or a few characters. With setting the property dynamic height to true, printing of this field works OK. But since there can be a variable number of lines used for printing this field, I want to know either the height of the field (all the lines together) plus the height of every other line which I print, or alternatively I want to know what the current height is where the next line will be printed. Getting the current print position (e.g. in mm from the top of the page) will be the easier way, but if I can ask the height (in mm) of every line which will be printed (depending on the largest font size used in the line) then I can just add up those heights and I will then also know how far on the page the printing has progressed. There are very many classes and methods available in Axapta, but the System Documentation Help is very short. It mostly gives only the name of the method, the return value and the type of the input parameters. I would very much appreciate your help on this subject. Martin de Groot The Netherlands The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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.
RE: [development-axapta] Digest Number 1740
You're right, the synchronize should take care of this for you. You could also look at the actual table structure in the database and compare it to what Axapta thinks it should be. Could there be a problem with the owner of the table (dbo vs. bmssa)? If you see more than one owner, you may need to run a script to force all Axapta tables to have the same owner (preferably dbo). Jim Chwaszczewski [EMAIL PROTECTED] -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] Sent: Thursday, May 11, 2006 10:59 AM To: development-axapta@yahoogroups.com Subject: [development-axapta] Digest Number 1740 Message 2 From: csmanohar2000 [EMAIL PROTECTED] Date: Thu May 11, 2006 4:18am(PDT) Subject: Synchronize Problem While Upgrading from 2.5 to 3.0 sp5 KR1 I am upgrading an installation from 2.5 to 3.0 SP5 KR1. I opened up the old 2.5 database with my upgraded application which started the upgrade checklist. While going thru the upgrade checklist, I have completed all steps thru pre-synchronize data upgrade, the next step being synchronize. One of he error messages I have received at the end of synchronization is as follows. Error Synchronize Cannot execute a data definition language command on (). The SQL database has issued an error. Info Synchronize SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Column name 'INVENTDIMID' does not exist in the target table. Info Synchronize SQL statement: CREATE INDEX I_019NUMIDX ON BOMCALCTABLE (DATAAREAID,ITEMID,INVENTDIMID,BOMID,ROUTEID,PRICECALCID) Many tables from version 2.5 (eg 'BOMCALCTABLE' shown above) with the field ConfigId have been modified in 3.0 as follows. 1. Rename the field ConfigId to DEL_ConfigId 2. Add field InventDimId. >From what I know, synchronization step should take care of this by updating undelying database table automatically to match table definition in AOT. Instead of doing that, it complains it can't find the field inventDimId while trying to create an index that includes InventDimId. Can you please help me understand what is happening here. Thanks The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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.
RE: [development-axapta] Digest Number 1728
If the field is a string field, should the syntax include an asterisk? select Table1 where Table1.Field1 like '15,10*'; On a related note, I found the inRange function in the Global class useful to evaluate ranges in code - similar to what queries can do. static void testInRange(Args _args) { info(strfmt('%1',inRange('1..3',5))); info(strfmt('%1',inRange('1/1/06..1/31/06',today(; } Jim Chwaszczewski [EMAIL PROTECTED] -- Message: 3 Date: Mon, 10 Apr 2006 09:33:04 +0530 From: [EMAIL PROTECTED] Subject: like - not working Hi, why the following qry is not working: select Table1 where Table1.Field1 like '15,10'; regs, Hema. S The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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.
RE: [development-axapta] Digest Number 1715
My experience is with 3.0 Sp4. I believe you have to setup the virtual company before you put records into the table. This insures that the dataareaid (company) on the record isVC1. Setting up the virtual company after records are entered doesn't update the dataareaid of existing records (it would be nice if it did). I've had some luck simply updating the dataareaid in Query Analyzer, but make sure everyone is out of Axapta. If you are using the AOS, you'll want to restart it. Jim Chwaszczewski [EMAIL PROTECTED] Message: 8 Date: Wed, 22 Mar 2006 12:01:29 - From: axpdev [EMAIL PROTECTED] Subject: Problem in Virtual Company Hi, I created a New Virtual Company Account say VC1 and added table collection which containes only LedgerTable. I included 2 Company account DAT and DMO both has records in Ledger table. When I open the Chart of Accounts No records has been listed. can any body explain me how to setup virtual Company. Thanks in Advance. The content of this e-mail and any attached files is confidential, and may be subject to certain privilege. This e-mail is intended for the designated recipient(s) only. If you have received this e-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this e-mail (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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] Axapta Upgrade
Hi James. Interesting is definitely the word for Axapta upgrades. The service pack brings in new SYP, GLP, DIP layers. I do the code upgrade to the current release and service pack. I then open the old 2.5 database with the new application which starts the whole data upgrade. There are separate ReleaseUpdateDB... classes for moving the data from 2.5 to 3.0 and then from 3.0 to the current SP. So far, I haven't had any major problems. According to Microsoft, Axapta service packs are cumulative so if a service pack becomes a required stopping point on the way to another release, then it shouldn't be a service pack, it should be a new release like 3.5. I definitely put up a fuss when Microsoft creates more problems for upgrades. Upgrades take enough time as is and it hard to bill clients for extra work caused by Axapta's developers (we end up eating the time). With all that said, I have a great time working with Axapta. I'm looking forward to seeing 4.0. Jim Chwaszczewski [EMAIL PROTECTED] Message: 1 Date: Wed, 22 Mar 2006 08:57:36 +0900 From: James Flavell [EMAIL PROTECTED] Subject: RE: Digest Number 1713 Supposedly the install doc says need to upgrade 2.5 to 3.0 BUT then do not start Axapta...rather just apply SP5. So basically each version is a milestone I would say Interesting as it sounds like you say you have not taken this approach but gone directly to the service pack...I am just wondering does that not mean your SYS layer is actually a 2.5 version? In theory the SP should only bring in a SYP layer Interesting Thanks James 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.
RE: [development-axapta] Digest Number 1713
I've not seen anything from Microsoft saying that you must migrate to 3.0 before migrating to SP4. You'll have to check with them since I could be wrong. However, I've done 3 upgrades from 2.5 to SP3 in the past 6 months and I'm working on a 4th to SP4. There are some hotfixes that were issued for SP3 that had jobs to run in addition to the upgrade. The developers made a royal mess of inventory. In general, Microsoft says you cannot skip major releases, so you can't go from 2.1 to 3.0 (skipping 2.5), or 2.5 to 4.0 (skipping 3.0), but unless there is something mentioned in the service pack documentation you should be able to migrate to the newest service pack of the next higher release. As a customer or VAR, I would be sorely angry if Microsoft came out with a service pack that made such major changes that I had to do a double upgrade within a major release. Due to the difference of the responses, I recommend you check with Microsoft. Jim Chwaszczewski - Message: 6 Date: Mon, 20 Mar 2006 09:14:58 +0100 From: Askeryd Thomas [EMAIL PROTECTED] Subject: SV: Digest Number 1706 You can not go to SP4 directly. MS should have a spec. somewhere which packs are milestones or what to call them. Thomas. Från: development-axapta@yahoogroups.com genom James Flavell Skickat: fr 2006-03-17 01:53 Till: development-axapta@yahoogroups.com Ämne: RE: [development-axapta] Digest Number 1706 Hi Jim, Can you confirm you can go from 2.5 to 3.0SP4 directly (i.e. just run the Sp4 installation etc). I was always under the impression we had to upgrade to 3.0SP0 first. Just want to check as I am doing such an upgrade in the near future Thanks James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Chwaszczewski, Jim Sent: 16 March 2006 02:11 To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Digest Number 1706 You can upgrade directly to 3.0 SP4 from 2.5. Number sequence references in 3.0 must be unique. A number sequence can only be used once. You need to clean up number sequence references in 2.5 before the upgrade. It's one of those architectural changes they don't tell you about. Jim Chwaszczewski [EMAIL PROTECTED] The content of this e-mail and any attached files is confidential, and may be subject to certain privilege. This e-mail is intended for the designated recipient(s) only. If you have received this e-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this e-mail (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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] AxaptaCOMConnector using incorrect Company/DataAreaID
In User Options, have you tried changing the default company of the user you connect as? The changecompany statement only changes the company for the block of code that follows it. info(curExt()); // whatever company I'm currently in ChangeCompany('SYN') { info(curExt()); // this executes in SYN } info(curExt()); // back to the current company Jim Chwaszczewski [EMAIL PROTECTED] The content of this e-mail and any attached files is confidential, and may be subject to certain privilege. This e-mail is intended for the designated recipient(s) only. If you have received this e-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this e-mail (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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.
RE: [development-axapta] Digest Number 1706
You can upgrade directly to 3.0 SP4 from 2.5. Number sequence references in 3.0 must be unique. A number sequence can only be used once. You need to clean up number sequence references in 2.5 before the upgrade. It's one of those architectural changes they don't tell you about. Jim Chwaszczewski [EMAIL PROTECTED] Message: 1 Date: Fri, 10 Mar 2006 14:48:34 +0100 From: Dahlsgaard Jan [EMAIL PROTECTED] Subject: SV: Error whil upgrad Ax 2.5 DB to Ax 3.0 SP4 I don't think you can go directly from 2.5 to 3.0SP4. You have to upgrade your db to 3.0 og 3.0SP1 first. Fra: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] På vegne af pbercher Sendt: 10. marts 2006 13:29 Til: development-axapta@yahoogroups.com Emne: [development-axapta] Error whil upgrad Ax 2.5 DB to Ax 3.0 SP4 Hi, during the upgrade process i get the folowoning message: *** Info Message (13:26:31) Run job 'updateCustSalesLinkTable' ordered by 'Admin' in database 'pa1'. Error Message (13:26:31)\Table CustPickingListSalesLink Reference for call of number sequences is not specified. *** any good hints where to look? Thx Pirmin The content of this e-mail and any attached files is confidential, and may be subject to certain privilege. This e-mail is intended for the designated recipient(s) only. If you have received this e-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this e-mail (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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] Axapta Code Protection
The Axapta's current architecture makes scrambling code problematic. Imaging modifying classes and tables that contain scrambled code. How would you know where to insert your modifications if the logic is not readable? Can they scramble only part of a method? Is the scrambling consistent between releases? Imagine upgrades if the next release of the scrambled software doesn't use the same scrambled names. Imagine reporting against scrambled field and table names. I would find the scrambling approach annoying and begging for the development of a descrambler. Scrambling code puts all the support burden on the vendor. Can they handle it? The Axapta community is known to fix Microsoft's and other vendor bugs. I don't mind black-box add-ons, but Axapta's architecture doesn't support it (yet) other than the kernel. I would like to see more process hooks in Axapta rather than overriding methods to add functionality. I can envision optional classes that are called (if they exist) during a process. Jim Chwaszczewski [EMAIL PROTECTED] Message: 4 Date: Fri, 3 Feb 2006 08:55:55 +0100 From: Andrae, Tobias [EMAIL PROTECTED] Subject: AW: Axapta Code Protection - Source Scrambling Hi Henrik, this sounds nice indeed. BUT: Would you like to be responsible for an Axapta project at a customers site where important parts of the application are scrambled because you, as the project leader, had to buy some scrambled 3rd party modules? What about customizing those things after the installation, let's say, two years after Kick-Off? I don't know ... In my eyes one of the biggest strengths of Axapta is it's open source idea. And after all - all of you (me included) have learned programming in Axapta by reading some of the code provided... Best regards, Tobias The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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.
RE: [development-axapta] Digest Number 1684
The Axapta's current architecture makes scrambling code problematic. Imaging modifying classes and tables that contain scrambled code. How would you know where to insert your modifications if the logic is not readable? Can they scramble only part of a method? Is the scrambling consistent between releases? Imagine upgrades if the next release of the scrambled software doesn't use the same scrambled names. Imagine reporting against scrambled field and table names. I would find the scrambling approach annoying and begging for the development of a descrambler. Scrambling code puts all the support burden on the vendor. Can they handle it? The Axapta community is known to fix Microsoft's and other vendor bugs. I don't mind black-box add-ons, but Axapta's architecture doesn't support it (yet) other than the kernel. I would like to see more process hooks in Axapta rather than overriding methods to add functionality. I can envision optional classes that are called (if they exist) during a process. Jim Chwaszczewski [EMAIL PROTECTED] Message: 4 Date: Fri, 3 Feb 2006 08:55:55 +0100 From: Andrae, Tobias [EMAIL PROTECTED] Subject: AW: Axapta Code Protection - Source Scrambling Hi Henrik, this sounds nice indeed. BUT: Would you like to be responsible for an Axapta project at a customers site where important parts of the application are scrambled because you, as the project leader, had to buy some scrambled 3rd party modules? What about customizing those things after the installation, let's say, two years after Kick-Off? I don't know ... In my eyes one of the biggest strengths of Axapta is it's open source idea. And after all - all of you (me included) have learned programming in Axapta by reading some of the code provided... Best regards, Tobias The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. 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] Re: Editing and Upgrading Help
I'll look into those tables. I believe they are not actual tables in the database but pseudo-tables on the various three types of help files in the application directory. There are some classes used to access the help (xUtilApplCodeDoc, xUtilApplHelp, xUtilCodeDoc). I may modify the help system to display both user help (from a custom table) and standard help (from the documentation nodes). Thanks. Jim Chwaszczewski Wipfli, LLP Message: 6 Date: Fri, 26 Aug 2005 02:24:15 -0700 (PDT) From: Sonny Wibawa Adi [EMAIL PROTECTED] Subject: Re: Editing and Upgrading Help Hi Jim Chwaszczewski, How about compare the help data through the database? It's just an opinion, the more technical solution is up to you (create a program or just use select query). Axapta help text is stored in database. - the application object database (UtilElements table), All elements list - the application help texts (UtilApplHelp table), Newly created elements' help text except tables and classes - the application delveloper help texts (UtilApplCodeDoc table), and in Tables' and Classes' help text - the system help texts (UtilCodeDoc table). System elements' help text (like: Global class' functions) Best regards, Sonny Wibawa Adi, MBSCP, MCSD.NET, MCAD.NET The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] 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] Editing and Upgrading Help
We have a client who wants to extensively modify Axapta's help. Since the help system does not use layer technology any editing is permanent. This will cause problems when upgrading. Does anyone have any ideas on how to minimize this problem when upgrading? I suppose we could modify the help system to save and display changed help text from a new table. The help should be part of the database anyway. Jim Chwaszczewski Wipfli, LLP Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. [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]
Hemant: Unfortunately any AOT import will be applied in the layer you're signed on to (or the highest modified layer of the object). If you sign on to the VAR layer and import the hotfix, unmodified objects will be modified in the VAR layer. If the object is already modified in the USR layer, then the changes go to the USR layer. (Rant) I consider this a substandard method for applying hotfixes and have made product suggestions to fix this. I believe the hotfixes should be imported into the proper patch layers. I'm sure MBS can provide an xpo that is protected by some hash key and uses a one-time key to import hotfixes into protected layers. The current hotfix process can potentially override customer changes in affected methods. Removing hotfixes during a code upgrade is yet another burden. Jim Chwaszczewski Wipfli, LLP Message: 2 Date: Fri, 5 Aug 2005 12:49:41 -0700 (PDT) From: Hemant Kumthekar [EMAIL PROTECTED] Subject: Hot Fix objects Hi Guys, I had noticed that after the Hot Fix (HF) is applied, Axpata objects which are modified start appearing in USR layer instead of the designated layer like SYP / GLP. This can create some problems if the cuatomer has not purchased CUS layer lic keys. Is there anyway other than logging to USP layer before import HFs XPO and directing the objects to correct layer. Thanks in Advance. Hemant The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This E-mail is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. Pursuant to Treasury Circular 230, the IRS requires us to advise you that if this email (or any attachment) contains advice concerning any federal tax issue, it was not written or intended to be used, and may not be used, for the purpose of avoiding federal tax penalties. WIPFLI LLP Business experts. Right from the start. [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] Changing Form Layout
I have a client that wants to change form layout in 3.0 based on the user group the user is assigned to. Any thoughts about how to approach this? Thanks for your thoughts. Jim Chwaszczewski JChwaszczewski @ wipfli . com The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This E-mail is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. 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] Multi-Level ComboBox
Can Axapta do a dropdown combobox like this? Category1 Value1 Value2 Value3 Category2 Value4 Value5 I'm thinking I can manually load a FormComboBoxControl and only allow the user to select entries that start with a blank. They can select values but categories. Jim Chwaszczewski Wipfli, LLP Email: JChwaszczewski @ wipfli.com mailto:[EMAIL PROTECTED] The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
RE: [development-axapta] Digest Number 1383
I just installed this hotfix (HF30SP3_041) and had problems. The only method that should be replaced is the Global.weekOfYear method. The Global_am.xpo file I downloaded contained other methods in the Global class that actually replaced some SYP layer fixes. I have a case with MBS and hopefully the xpo file will be fixed soon. Jim Chwaszczewski JChwaszczewski @ wipfli.com Message: 4 Date: Fri, 04 Feb 2005 10:11:54 +0100 From: Michael Niemeyer [EMAIL PROTECTED] Subject: RE: wkofyear Hi, it's only in 2005 ? see: HF30SP3_041 - Week numbers, Hot Fix Corrections made for: Weeknumbers wasn't displayed correctly in tools/systemdate/calendar. From: Alfonso Collados Arroyo [EMAIL PROTECTED] Reply-To: development-axapta@yahoogroups.com To: 'Development-Axapta (development-axapta@yahoogroups.com) development-axapta@yahoogroups.com Subject: [development-axapta] wkofyear Date: Fri, 4 Feb 2005 09:51:36 +0100 Hi all: I 'm using the wkofyear function and I see that this function returns always one week less . Why? Thanks Alfonso The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. 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.
[development-axapta] Having / like relational operators
If you are using straight SQL, just build the statement as you've specified. If you are using Axapta's embedded SQL, try using the MATCH function in your where clause. If you are using a query, the query range value can use wildcards, ranges, etc. Both the Match function and query values can use Axapta's version of regular expressions. Jim Chwaszczewski Wipfli, LLP Date: Thu, 28 Oct 2004 09:07:46 - From: pepejeans2k [EMAIL PROTECTED] Subject: Having / like relational operators Really have problem to construct SQL to compare things where not equal to. I have things like using addrange.value(Strfmt (_expression_)), but the result is just undesire. Can anyone tell me how to construct sql queries like (Example) using Axapta? 1. Select * from CustTable where name not like '*a*' 2. Select * from CustTable having name in ['Stephen', 'David'] 3. Select * from CustTable where substr(name, 1,2) = 'c'; thks in advance. The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
[development-axapta] DSN
So the DSN is no longer needed at V3.0 (I'm glad). Thank you. Next question: On V2.5, do I have to set up different DSN's if I have multiple V2.5's installed on the same machine? For example, BMSDSN-Client1, BMSDSN-Client2. I would think so since each DSN points to a database. Jim Chwaszczewski Wipfli LLP The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
[development-axapta] DSN
Does Axapta still use a system DSN? If not, at what version did it become unnecessary? Jim Chwaszczewski Wipfli LLP The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
[development-axapta] Install Questions
Has anyone tried installing multiple versions of the Axapta Application, Client, and Server on the same PC? For example, having both V3.0 Sp2 and V3.0 sp3 installed. This is for testing and supporting multiple clients on different versions. I have the following questions... 1) The Client install wants to know about the database. Why should the install care about this? Isn't that what the configuration utility is for? I'm assuming it's to initialize the original configuration. 2) The server install wants to know about the application. Isn't that what the AOS Manager service is for? (Same questions as above). 3) What other non-applications files and registry entries do the installs create? If I have multiple versions installed, could these potentially cause problems (i.e. a V2.5 client accessing V3.0 dlls or settings)? Jim Chwaszczewski Wipfli LLP The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
[development-axapta] RE: SysDataImportExcelClient Error
I haven't used this class and don't do much importing, but from what I'm reading in SysDataImportExcelClient, it appears that the spreadsheet has to be in a certain format for Axapta. Maybe someone else can shed some light here, but I believe the class is used to import a spreadsheet that was created/exported by Axapta. The class seems to expect that the first 5 rows of the spreadsheet (see the clip below from macro Excel in the AOT) contain certain Axapta information. The class returns a container of values that correspond to one row of the spreadsheet. As the class examines each column, it looks for certain information in the corresponding column in the first five rows. If the EnumRow (4) is zero (not a Enum TypeID), then it checks the TypeRow (3) for an extendedTypeID, otherwise it attempts to convert the cell value to an extendedTypeID. Because the class expects an internal extendedTypeID number in the spreadsheet leads me to suspect that Axapta is expecting a spreadsheet it created. I hope this helps. /* * Excel cell values */ #define.LabelRow(1) #define.SheetInfoRow(2) #define.TypeRow(3) #define.EnumRow(4) #define.NameRow(5) Jim Chwaszczewski Wipfli LLP --- Date: Thu, 17 Jun 2004 15:15:41 -0600 From: Ing. Gonzalo Bastos S. [EMAIL PROTECTED] Subject: Error Hi Jim Chwaszczewski Thanks for your advice, It' s really help me, but when I try to importthe Template this error is presented:I'll appreciate If you can help me...Error al ejecutar código: SysDictType objeto no inicializado. Seguimiento de pila: \Classes\SysDictType\baseType \Classes\SysDataImportExcelClient\read - line 47 \Classes\SysDataImportExcelServer\sheet2Table - line 53 \Classes\SysDataImportExcelServer\importSheets - line 53 \Classes\SysDataImportExcelServer\run - line 7 \Classes\SysDataImport\main - line 10 \Classes\FormFunctionButtonControl\Clicked Best Regards.Ing. Gonzalo Bastos Stephens Dpto. de Ingeniería Columbus IT Partner The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
[development-axapta] Re: Data Export/ Import - Excel Spreadsheets Error
Check out discussion 6200 on http://technet.navision.com. Here's my contribution. I also had a problem with SysExcelTemplateWizard generating an infolog in the same place. I'm on 3.0 SP2. It happens because new DictEnum returned null. The following one line change in FormatCell fixed it for me... // DictEnum returns null if field does not use an ExtendedDataType // label = new DictEnum(_tmpExcelField.methodEnumId).label(); -- comment out this line and add following line. label = _tmpExcelField.methodEnumId ? new DictEnum(_tmpExcelField.methodEnumId).label() : 'Unknown'; Jim Chwaszczewski Wipfli LLP - Message: 10 Date: Wed, 16 Jun 2004 00:04:37 - From: gonzalo_edo [EMAIL PROTECTED] Subject: Data Export/ Import - Excel Spreadsheets Error When I try to create a template at Administration -Periodic -Data Export/ Import - Excel Spreadsheets -Template Wizards for a table created by myself, after I click on Finish button this error is displayed Error executing code: DictEnum object not initialized. Stack trace: \Classes\DictEnum\label \Classes\SysExcelTemplateWizard\formatCell - line 22 \Classes\SysExcelTemplateWizard\formatType - line 21 \Classes\SysExcelTemplateWizard\formatColumns - line 37 \Classes\SysExcelTemplateWizard\createTemplate - line 17 \Classes\SysExcelTemplateWizard\run - line 21 \Classes\SysExcelTemplateWizard\main - line 11 But, if I create a template for an Axapta Table, by example CustTable, the process completes succesfully, the fact is, what I'm missing on table definition or what can I do to solve this problem?? Best Regards. Gonzalo. The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
[development-axapta] RE: SalesTable Form Caption
I looked at the setCaptionText on the SalesTable form (thank you). I've created a form that is called from the SalesTable form that displays a SalesLine and has SalesLine and SalesTable as datasources. When I change my form's caption I still get the SalesTable and SalesLines keys appended to what I specify in the caption. I use methods clearLinks and clearDynalinks in the form's Init method on both datasources. Neither datasource uses the TitleDataSource property. How do I prevent Axapta from appending the record keys to the caption? Jim Chwaszczewski - Wipfli LLP The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
[development-axapta] SalesTable Form Caption
Does anyone know how the SalesTable form Caption displays (SO ID, Customer Name, Item Name)? Jim Chwaszczewski Wipfli LLP The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ADVERTISEMENT 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.
[development-axapta] setFocus
Title: Message Hello. When an Update button is clicked on my form and there are errors, I display an error message. I also want to set the focus to the appropriate field. I can't find any documentation on "setFocus". Is there another or better way? Thanks. Jim Chwaszczewski (an Axapta newbie). The content of this E-mail and any attached files is confidential, and may be subject to certain privilege. This email is intended for the designated recipient(s) only. If you have received this E-mail in error, please immediately contact the sender. WIPFLI LLP Business experts. Right from the start. 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.