Re: [development-axapta] Re: Creating Local XML File
AIF has a Channels table with the path that is used for the xml files. In your code you would need to modify that path to dump the file on a local folder (selected by the user I presume) then reset it to the former value if needed. But, I think what you did with the XML Document class was the right thing to do since AIF is really intended to be a server process. On Thu, Apr 29, 2010 at 4:33 PM, www_programmer www_program...@yahoo.comwrote: Thanks for the reply Sumit! I am pretty sure that I had everything in the AIF setup complete... however I can't be sure since I didn't get this to work. I might have also had an issue with my code. I wasn't able to find a step-by-example of creating a new query, using the Axd Document wizard, then creating xml file locally. That would have been helpful. But, I also came to the conclusion that my approach was more complicated than needed. I wrote a class to execute on the server to loop over my query results and use the XmlDocument class to create the XML document and save the file locally. This worked out just fine and is the solution I will use for now. Would still like to figure out what my issues with the AIF to XML via file adapter was... but will have to look into that later. If anyone has an example to post, that would be great! Cheers! --- In development-axapta@yahoogroups.comdevelopment-axapta%40yahoogroups.com, Sumit Loya loya.su...@... wrote: Hi, You will have to setup all the AIF settings from Basic -- Setup -- Application Integration Framework. Have you done that? Regards, Sumit On Mon, Apr 26, 2010 at 10:56 AM, www_programmer www_program...@...wrote: I am trying to understand the best way to create XML files on the local system in AX. I have created a new query that displays data from InventTable and SalesTable. (InventTable.ItemId, InventTable.ItemName, SalesTable.Price). I would like to add a button to a form to, send electronically like functionality in other forms and have an XML file generated on the local file system. I created my query and then ran the AIF document service wizard and selected only the read option. I have looked over the examples for similar existing functionality that utilizes the AxdSend class to create the xml file. I'm getting an error that I don't have an endpoint setup... but it looks to me like I do. I'm a bit lost on this one as I have not done this before. Can anyone point me to a more clear or step-by-step example of creating a new query and going through the process to creating the XML document? Thanks for all the help Cheers! [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[development-axapta] consuming web service data set in X++
Has anyone accessed a data set from a web service and been able to work with it in X++ code that is consuming that service? If so, what tneeds to be done. I was able to get the dataset and call its methods. One method returned a string, but I get an error in X++ when I try to print or assign the string to a variable. Mary Ann [Non-text portions of this message have been removed]
Re: [development-axapta] Re: AX 2009 - Reporting Service- Error
I found instructions on msdn library on how to add the Master Company Reporting Currency. (Walkthrough: Creating a Cube). However, I am surprised that in my case I need to do this even for standard AX cubes! Actually, initially I did not need to do this. All the KPIs displayed fine with demo data loaded. Then I wanted to experiment with a virtual company to share the LedgerTable. I was experimenting for learning - trying to do what is suggested in the document Extending Microsoft Dynamics 2009 Default Cubes for Analytics across Virtual Company Accounts. As soon as I had modified AX to do share the Ledger Table, I could no longer process the cubes, even when I had created the LedgerTableView and fixed the LedgerTable select statement. I get the error mentioned below in this email stream. I do not understand why the standard cube would start to require the master company reporting currency if it was not needed before! I am using SQL 2008 and Visual Studio 2008 on Windows 2008 R2 with AX 2009 SP1, I am unable to create the Reporting Currency Named Query. When I click Finish, the error shows the SQL for the query which needs to be fixed, but there seems to be no way to edit the query. If I quit, I do not have a Query to edit! So, I have three questions for anyone who has succeeded in working with virtual companies and this problenm with the Master Company Reporting Currency: 1) Is there any way with default cubes to avoid getting this error. 2) If not, is it required to map the Master Company Exchange Rate to the Time dimension for every one of the time dimensions (because there are multiple times (dates) listed among the dimensions of each cube)? Or is it sufficient to do this only for the dimension that is labeled Time without extra clarification. 3) How can the Reporting Currency Named Query be created correctly without needing to use the wizard and then (if you can) open and edit the query (which may not exist!) -- Forwarded message -- From: Rahul ra...@rahulsharma.in Date: Wed, Dec 16, 2009 at 1:45 PM Subject: [development-axapta] Re: AX 2009 - Reporting Service- Error To: development-axapta@yahoogroups.com Hi, It looks like cube is missing Master COmpany reporting Currency dimension. This dimension provides reporting of financial measures in all the currencies used by the companies implemented in Dynamics AX and this dimension is not automatically created when you generate a BI project for a cube. You must manually create this dimension. This dimension is neccessery to display the KPIs for a cube in a Business Overview Web part in Enterprise Portal. Regards, Rahul Sharma http://settings.messenger.live.com/Conversation/IMMe.aspx?invitee=e7579\ 4c17db3...@apps.messenger.live.commkt=en-inhttp://settings.messenger.live.com/Conversation/imme.aspx?invitee=e75794c17db3...@apps.messenger.live.commkt=en-in www.RahulSharma.in http://www.rahulsharma.in/ http://www.rahulsharma.in/ blog.RahulSharma.in http://blog.rahulsharma.in/ http://blog.rahulsharma.in/ --- In development-axapta@yahoogroups.comdevelopment-axapta%40yahoogroups.com, TOM SEBASTIAN tomvaya...@... wrote:  Dear Reyaz,  Thanks for your quick reply,  I process all the dimensions and cube and restarted the Reporting Service and AOS but i have still the same error. I have a shared datasourse in reporting server the connection string is as following :  SharedLibrary.DynamicsAXOLAP Provider=MSOLAP;Data source=localhost;Initial Catalog=Dynamics AX;Integrated Security=SSPI  In my Role center all the KPI's are alos not working it gives the following error  QuQuery (1, 196) The dimension '[Master Company Reporting Currency]' was not found in the cube when the string, [Master Company Reporting Currency].[Currency].[Local], was parsed.ery (1, 196) The dimension '[Master Company Reporting Currency]' was not found in the cube when the string, [Master Company Reporting Currency].[Currency].[Local], was parsed.  please reply  Thanks Tom  --- On Mon, 16/11/09, reyaz ahamad reyaz_mc...@... wrote: From: reyaz ahamad reyaz_mc...@... Subject: Re: [development-axapta] AX 2009 - Reporting Service- Error To: development-axapta@yahoogroups.comdevelopment-axapta%40yahoogroups.com Date: Monday, 16 November, 2009, 14:52  hi dear ur problem is from the analysis server .have u installed analysis serevr if u installed analysis server then u go to the sql server and connect to analysis server and process all the dimenssion and cube .This process will resolved ur problem. Best Regards Reyaz Ahamad       CorporateServe Consulting Outsourcing| 51, Moulsari Avenue, DLF Phase-3| Gurgaon 122 002  Member of Microsoftâs Presidents Club 2009 Web:www.corporatese rve.com | email: reyaz.ahamad@ corporateserve. com --- On Sun, 15/11/09, TOM SEBASTIAN tomvaya...@yahoo. co.uk wrote: From: TOM SEBASTIAN tomvaya...@yahoo. co.uk Subject: [development- axapta] AX 2009 - Reporting Service-
Re: [development-axapta] Send email from Ax
I cannot guarantee it will work, but try using \r\n for Carriage Return + Line feed. It may not work if these characters are stripped out by AX. In that case, I cannot offer help. On 4/20/09, anton_tjiptadi anton_tjipt...@yahoo.com wrote: Dear all, I developed some notification program in Ax 3. This program should send email regarding some changes in Axapta. Problem is I set the message body so it would look nice when my user receive it. Turns out all the format missing so it would only display one long lines without any format. Example of my lines is Purchase order no 1234 is created \n. Please approve or reject \n\n Regards \n Admin I'm using dialog to display this message before Axapta send it. It already looks nice on screen. Message body in my dialog already looks like this : Purchase order no 1234 is created Please approve or reject. Regards Admin After I clicked ok on my dialog, it send the email but with all character in one line. -- Purchase order no 1234 is created.Please approve or rejectRegardsAdmin Any suggestion? Thanks in advance. Regards, Anton [Non-text portions of this message have been removed]
Re: [development-axapta] Button that opens a dialog from a class that can be changed in the same form
I am not sure if I am completely understanding your goal. However, I will make a suggestion. You may want to look into using the MenuFunction object to launch your class. Search the AOT (using find) for menuFunctionActionStr as text in method and you will see some examples for launching an action menu item in the code. The class name is a parameter. Your class needs to have a main method that creates an instance of itself and calls the prompt method to display the dialog (But you probably did that already if you created a Menu Item to call the class). Do not use a Menu Item Button on your form. Rather just use a Button and override the clicked method to compose your MenuFunction call. On 4/17/09, benoit.billington benoit.billing...@yahoo.com wrote: I have a form with a ClassName field which can be filled by classes that implements a certain interface. On that same form I have a button that will open the dialog from the selected class Since this is dynamic I dunno how I could launch the specific Dialog. Maybe by overridding a method from the menuItemButton... [Non-text portions of this message have been removed]
Re: [development-axapta] Re: Data is exist but not display in axapta report
There are many wonderful examples of custom fetch methods. Highlight the
Reports node of the AOT and right click to choose Find. Find methods named
fetch. You will see many examples.
On 3/30/09, seli ana seli_ana_cute_...@yahoo.co.id wrote:
hi, thanks for your answer.
I think i already make some mistakes in my codes.
But, i already set the correct data source and i move my code in fetch
method.
the data still not display. can you give me some code example in fetch
method?
Thanks for your help..
--- On Tue, 3/24/09, Kristanto Surjadi
kristantosurj...@yahoo.comkristantosurjadi%40yahoo.com
wrote:
From: Kristanto Surjadi
kristantosurj...@yahoo.comkristantosurjadi%40yahoo.com
Subject: [development-axapta] Re: Data is exist but not display in axapta
report
To: development-axapta@yahoogroups.comdevelopment-axapta%40yahoogroups.com
Date: Tuesday, March 24, 2009, 10:08 AM
Hi Seli,
Regarding question number 1:
First of all your code placement is very unusual. Why do you put it in
formLetterRemarks display method? it is better to put it in the fetch method
on the report...unless you have your reason
Your programable section, that you execute (using element.execute( 1)).
What data you print on that section? Have you set correct data source on
the field you want to print?
Regarding question number 2:
you can try either this.methodname or element.methodname, depends on where
you create the methods.
Regards,
Kris
--- In development- axa...@yahoogrou ps.com, seli_ana_cute_ bgt
seli_ana_cute_ b...@... wrote:
Hi all,
I have created report in axapta with many data sources.
1. When i open the report, the data not display in report although data
is exist in database. The code are :
display FormLetterTxt formLetterRemarks ()
{
;
while select formLetterRemarks where formLetterRemarks. FormLetter= =61
{
element.execute( 1);
}
return formLetterRemarks. Txt;
}
Is there any mistakes in my code? cause only this code not display any
data.
2. how to use method that i already create
for example : i already create method 'A', and i want to use method 'A'
in method 'B'. how to call the method 'A' in method 'B' code?
Please help me cause i'm newbie in axapta.
Thanks very much..
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Re: [development-axapta] PLEASE HELP: CRYSTAL REPORTS 2008 AND AX2009
Check out Recrystallize Addin from Promentum. On Tue, Mar 17, 2009 at 1:13 PM, tavocol2002 tavocol2...@yahoo.com.mx wrote: Hello to everybody. Currently we are implementing a Customer that allready have Crystal Reports 2008. They have 1540 reports and they want to use the same formats and only change the DataSets, the customer developers has been working with the AX reporter but the conclusion was that AX Reporter doesn't offer the same speed and versatility that Crystal. I know that Crystal have .NET assemblies but i don't know how to use all of these assemblies in AX. And most important if the answers is yes (Execute Crystal through .NET), how can i execute reports automatically and pass parameters without interaction just like AX Reports Autojoin property Thank you very much. Any help would be really good, even NO answers will be received, because there's no info about this in any place. Gustavo Camargo :D
Re: [development-axapta] Re: DLL called by class running on Client works but on Server doesn't
I think the trustworthy computing recommendation is to run on client. Did you put the CLR dll in the GAC on the server to allow it to run on the server? Try that. Otherwise, you can use group policy to deploy the dll to all clients and run on client only. On Fri, Mar 6, 2009 at 8:18 AM, pkpeterson652 ppeter...@agilitybiz.net wrote: Forgot to put in error message being received: CLRInteropt is throwing the following error: Exception has been thrown by target of an invocation. I only get the above error when the class is being run on the server. Paul --- In development-axapta@yahoogroups.com, pkpeterson652 ppeter...@... wrote: I have a DLL supplied by a third party to handle WSDL communications with their website. This DLL functions with no problems when connecting to their test website which is unsecured reguardless if it is running on client or marked as run on server. However, when connecting to their production site which requires having some certificates installed we run into a problem that I'm not sure on how to debug. We have installed the required certificates on the terminal server and on the AOS machine. If the class that calls the DLL functions via CLRInterop is set to run on client we successfully connect. If it is set to run on server it fails. It doesn't matter that my client session is already on the AOS itself or on a terminal server it still fails when the class is set to run on server. Any suggestions on how to debug would be helpful. Thanks, Paul
Re: [development-axapta] Project export
I do not know of a way to do what you desire. But if you run the cross-reference update on all of your project components, you can view the using references to be sure you know about all dependencies. Then you can add those EDTs manually to your project even though they were created for the other project. I actually do all of my development from the project itself. I create a group template will the same structure as the AOT. I export the template, then rename it in the AOT. I create all objects only from within the project. Even when I edit an object, I do not touch it until I have dragged it into my project first. If I notice dependencies that might not be in the target environment, I just add them to my project even if I did not change them. I always create a job in the project that is just comments to remind myself and others what is in the project and why - that is a place to indicate that some objects are included as dependencies but are not modified. By this process, I can export with few if any dependencies overlooked. I hope that this is helpful. On Tue, Feb 24, 2009 at 8:09 AM, benoit.billington benoit.billing...@yahoo.com wrote: Is it possible to export a project with all it's dependant object even if they aren't included in the project itself? eg. I have a table in my project which uses 2 EDT's that were created for another project. When I export my project I want the export file to contain those 2 specific EDT's because if I import that project in a new environnement I need those 2 EDT's
Re: [development-axapta] error while using Intercompany Journal
Your attachments are being removed by the group so it is difficult to provide help with the benefit of a visual. Did you already check in the Dimensions table and you can see that the dimension VALUES selected in the one company do physically exist in the same table for other company as well? I presume that they do not exist and that is the source of the error. The intercompany journal transaction will not create dimensions in the target that do not already exist - they do need to pre-exist in both companies. Perhaps you may want to consider using a virtual company and table collection to share the dimensions across the two companies. If the dimensions do already exist in both companies and you get the error, then I cannot offer any other suggestion. Perhaps you should check with the person who installed the extra dimensions to be sure that the process used has attached the extra dimensions for the use of both companies. On Mon, Feb 23, 2009 at 10:22 PM, abhishek mehta abhi_love...@yahoo.com wrote: Hi All, If anybody has got any idea pls let me know Regards Abhishek Mehta, From: abhishek mehta abhi_love...@yahoo.com To: development-axapta@yahoogroups.com Sent: Tuesday, February 10, 2009 11:19:42 AM Subject: [development-axapta] error while using Intercompany Journal Hi All, We are facing a strange error while posting intercomapny journal in Ax 2009. We have two company say company 1 company 2 We created a Intercompany Journal in GJ where we will be selecting Dimensions for both companies Here We got five dimension in our enviornment. If I am in company 1 and selecting dimension for company 1 only then there is no error.but if I am selecting a dimension in for company 2 that to the last two dimension(which we have purchased) than the system is throwing error that dimension is not found in relating tables in other company I am attachinh the screen shot of the error I have debug the same but for default three dimension it is not throwing the error and for rest two in intercompany it is throwing Any help would be highly apprecited. Regards Abhishek Mehta, [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [development-axapta] MSDAX5.0 Enterprise Portal
When Page Definitions contain web pages in the AOT of Microsoft Dynamics AX which you can deploy to the Enterprise portal mearly by right-click choosing Deploy Page When anything is created in the AOT, it physically only resides in a layer.aod file. You will not find the web pages on the harddisk even though the properties of the object in the AOT references what appears to be a file with extension aspx. Consult EPAdmin.chm, AXDeveloperDocs.chm, and Developer.chm for readily available help files when AX and EP are installed. I personally do not know of a tutorial for creating EP user controls (which are now built in Visual Studio). Hopefully someone else will provide more assistance for you. On Sun, Feb 22, 2009 at 11:17 PM, Abhishek aks...@yahoo.com wrote: Hi guys Can somebody explain the use of Page Definitions node under Web node--- Web Files---Page Definitions. And where in the server these files exist. And also give me some link to a good tutorial for creating enterprise portal web user controls.
Re: [development-axapta] I need urgent help
It is not completely clear what you are asking in your request. 1) is the number of allowed rental cars still account number specific or is it now location or address specific? I will assume that the limit is still customer account specific - addresses do not matter. 2) are there two addresses - pick up location and drop off location? I can guess that you have a limit per customer but you want lines only to show the location information for each rental. If this is the case, you can model your form after the purchase order and sales order forms where the form has a split display - customer information at the header, rental location information on the lines. Your check for allowed number of rentals, as you mention, is a kind of credit check - just as is done for customers based on total sale, etc. If there are two addresses, you need to create/select two addresses. Consider using the Alt.Address capability with new address types for origin and destination. If there is only one address to track, then the task is easier and you do not need to add new types. So it seems you already have the right idea to proceed - I do not have any alternative advice. I am just confirming what you yourself suggested as the approach to take. Good luck on this project. On Fri, Feb 6, 2009 at 11:49 AM, Dinkar Lalit dinkarla...@yahoo.com wrote: Hello all: I posted this message to MS Ax programming discusssion group but did not get any help. I am new in AX and started working ona real project. I post the question below: I am newbie in MS Dynamics. I have a question which follows: 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. Thank for your suggestions in advance. Dinkar [Non-text portions of this message have been removed]
Re: [development-axapta] How to show field hidden by user in X++
For versions Dynamics AX 4.0 and Axapta 3.0 there is a configuration key under Administration keys that can disallow all user modifications to the UI. This is essentially #2 but impacts more than just hide/show. The user will not be able to re-arrange columns or move fields from one tab to another. This keeps the user interface experience the same for all users. If you want to disable user modifications, go to Administration Setup System Configuration. Open the Administation folder and uncheck the option labeled Advanced Form Customizations. This configuration key appears to have been removed in AX 2009, so I am not sure how you can do this same thing in the latest release. On Mon, Feb 2, 2009 at 6:15 AM, christian.myrvold christian.a.myrv...@gmail.com wrote: Hey everyone, I've searched both the group postings and google for this, and haven't found anything yet. I need to either: 1. Show a field in a form immediately after a user hides it (so it looks like the hide functionality doesn't work), or 2. Disable the hide functionality when a user right clicks on the field. I would say the the first is preferrable, if it's at all possible. Sincerely, Chris
Re: [development-axapta] Hi All
Failed to create file old\axapd.aoi may or may not be the problem. This error will prevent a developer from using compare on old code in AOD files that are in the old folder. That is likely a permissions problem for that folder. The AOS service does not have write permissions on the old folder. Is the client actually shutting down the AOS server every night? Or maybe are they doing something else, like shutting down the database to do a cold backup. If they actually shutdown the machine that has the AOS, then it should start automatically. It almost sounds like it is the database which is becoming unavailable in the middle of the night (I saw this before). Then the AOS is forced to stop when the database is not available. In that case, the AOS does not start automatically. Your setting to start automatically upon startup would not apply. I am not sure if all of this is helpful - but I am just sharing my thoughts about the problem. On 12/10/08, abhishek mehta [EMAIL PROTECTED] wrote: Thnx for the reply Here in event viewer it is throwing this error Failed to create file old\axapd.aoi. Error code was 3 while the services status i kept automatic still is not starting automaticaly and i need to start manualy What can be possible reason for this error Regards Abhishek Mehta, --- On Mon, 12/8/08, MaryAnn Hand [EMAIL PROTECTED]maryann.hand%40gmail.com wrote: From: MaryAnn Hand [EMAIL PROTECTED] maryann.hand%40gmail.com Subject: Re: [development-axapta] Hi All To: development-axapta@yahoogroups.comdevelopment-axapta%40yahoogroups.com Date: Monday, December 8, 2008, 9:14 PM check the eventvwr if startup totally fails - sometimes it will stay in the starting state and you need to refresh services to see when it is actually started. On Fri, Dec 5, 2008 at 1:12 AM, abhi abhi_loveall@ yahoo.com wrote: I am facing an issue @ my client's place, They are shutting down server after their working hours everyday... I had made the setting for Dynamics Services Automatic so when the server starts services starts auotmaticaly But here after doing so still the services are not startting up What can be the issue or how I can resolve the same Thanks in Advance Regards Abhishek Mehta [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [development-axapta] FORCE USER AUTO LOGOFF
The administrator can kill sessions from the Online Users form. But that person needs to know who really is inactive. The session does tell when the session started, so maybe someone needs to check periodically and be ruthless to those who stayed on more than the allotted time. On Thu, Dec 4, 2008 at 8:59 AM, tavocol2002 [EMAIL PROTECTED] wrote: Hello to everybody. Currently our customer are using Microsoft Dynamics AX 4.0 with a limited number of licences (15). The problem is that the number of users are increasing but the general manager doesn't want to buy new licenses. So, based on the CEO decisions, we are managing the automatic logoff from user options form. And every user has a max time of 10 minutes. At the beggining that was good, but now, a large amount of users found a way to prevent that AX shutdown their sessions. The current method to doing that is when you create a new record and a field is set as mandatory. When the auto logoff try to shutdown the session, the validateWrite throws the warning that the field has to be filled. This kind of methods are stoping the productivity, because you can see users in the middle of the morning taking a break of 20 minutes and their sessions still active. And other users that has tons of work with problems because the users aren't free. Exist any kind of code or mod to force AX to shutdown the AX session??? Than you very much :D Gustavo Adolfo Camargo Téllez Microsoft Dynamics AX Developer MDO Consultores Asociados S.A. Bogotá D.C. - Colombia (South America)
Re: [development-axapta] Hi All
check the eventvwr if startup totally fails - sometimes it will stay in the starting state and you need to refresh services to see when it is actually started. On Fri, Dec 5, 2008 at 1:12 AM, abhi [EMAIL PROTECTED] wrote: I am facing an issue @ my client's place, They are shutting down server after their working hours everyday... I had made the setting for Dynamics Services Automatic so when the server starts services starts auotmaticaly But here after doing so still the services are not startting up What can be the issue or how I can resolve the same Thanks in Advance Regards Abhishek Mehta
Re: [development-axapta] datediff equivalent in X++
You have a couple choices. 1) You can execute your complex SQLstatement from AX - but if you do, be sure to use trustworthy computing options available in AX 4.0 and AX 2009. (See Dev IV training manual, chapter 2, or find the white paper on Writing Secure Code. You would use CodeAccessPermission subclass for direct SQL first (I do not remember the name off-hand) then use the Connection and statement objects to execute your SQL. 2) You can get # days between two dates by using the function date2num which returns days since 1/1/1900. You do that to both dates and then get the difference. But you cannot execute a function from within AX SQL, so you need to do a less efficient loop - select the rows based on other conditions and then write if check on the date difference. That is not so bad if you do not extract a huge number of rows that you require date differences for. On 12/3/08, vamsi praneeth [EMAIL PROTECTED] wrote: Not sure about difference in days, but if you want the difference in years there's a method in Global class Global::yeardiff() which takes dates as parameters. Try your luck with it. How can I figure out the difference in # of days between two dates? Can it be done using a select statement as well? The following t-sql is what I am trying to accomplish but if you can answer one or both of the above questions would help me get there as well.. T-SQL select avg(datediff( day, transdate, closed)) from custtrans ct (nolock) where accountnum=' aa122'and closed '1/1/1900' and dataareaid=' demo' and amountmst0 and transdate = getdate()-90 select custTrans where localCustTrans. AccountNum= ='ba368' localCustTrans. Closed != datenull() localCustTrans. AmountMST 0 localCustTrans. TransDate = systemdateget( )-90; [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
Re: [development-axapta] How to Add sum of Debit and Credit
If I understand - it is so simple - I could be missing something. Create a display method on the table that has debit and credit and return the sum. In the report use the data method property instead of the data field property.. On Mon, Dec 1, 2008 at 6:46 AM, M. Nuaman Sharif [EMAIL PROTECTED] wrote: Hi all I added field credit and debit in LedgerJournal report, I want to add sum or credit and debit for each voucher Please help Thanks
[development-axapta] Re: [Axapta-Knowledge-Village] Query on Dimension group.
Renaming dimensions are global not group linked. The only way to do what you describe is to modify the code to change label on specific forms or reports for the requirements of the client. On Thu, Nov 27, 2008 at 9:24 PM, Trinadh Sura [EMAIL PROTECTED] wrote: Dear All, I renamed the Item dimensions color and size in the Dimension group as per the requirements of the client and attached the group to group of Items (an Item group). But I do want to rename these dimensions again for some specific purpose and attach to some other group of Items(Item group). How can I address this requirement in Ax 4.0 Regards, Trinadh THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed.
[development-axapta] Re: [Axapta-Knowledge-Village] Date and time
It is certainly possible in AX 2009, but not in earlier versions. On Thu, Oct 30, 2008 at 2:57 AM, Trinadh Sura [EMAIL PROTECTED] wrote: Dear all I want to enter date and time in one field. Is it possible? If yes. Tell me . Regards, Trinadh THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed.
Re: [development-axapta] NumberSequencing Framework Problem
Sayed, To use a new number sequence, you need to be sure that the number sequence engine has the proper reference to your new number sequence. There is quite a lot to do besides creating the number sequence. The Developer IV training manual has a whole chapter with the step by step instructions for using new number sequences. Do you have access to that manual or can you get a copy? If not, I can try to reply again with a quick summary of what all you must do. For now, you should investigate what number sequences ends in _210 (BasicSetupNumber sequences - menu item named Number sequences). Then find out what extended data type is linked to that number sequence (using the other menu item References). That may give you a clue as to why your book ID is picking up that number sequence. Mary Ann On Mon, May 5, 2008 at 1:10 PM, syed baber [EMAIL PROTECTED] wrote: Hi, I have implement number sequence framework in my module name Book and I want to autogenerate the field BookID . In the number sequene wizard I have given the format B_## but when i open the form the BookID Column contains number like 05_210 ,08_210 etc. Can anybody let me know what is the problem. Why the BookID is not generated as I have mentioned in the format. I really want urgent reply. Thanks in Advance. bye [Non-text portions of this message have been removed]
Re: [development-axapta] Add New field in SalesInvoice Report
Syed, You need to provide more detail for anyone to provide help. But in hopes to help a little, you should know that the SalesInvoice is built from data in the CustInvoiceJour and CustInvoiceTrans - the report is NOT based only on SalesTable and SalesLine. So, if you added the field to the SalesTable or SalesLine tables you need to carry the field through to the CustInvoiceJour or CustInvoiceTrans. You can write a display method, or you can use the initFrom methods. I hope that this at least gets you started. Mary Ann On Mon, May 5, 2008 at 6:31 AM, adeelshafqat2004 [EMAIL PROTECTED] wrote: Hi dears! I need ur help in adding new field in SalesInvoice Report i have applied my all methods but its not working...Please Do explain with little demonstration.. Best Regards... Syed Adeel Shafqat
Re: [development-axapta] Companies
Pooja, Code is not company specific, so it should work fine in any company. However, if there is a data dependency for the code, you may need to setup that data on the other company as well. If you provide more detail about how it works in DAT company and what is happening in the other Company,we may be able to provide additional help Mary Ann On Mon, May 5, 2008 at 2:56 AM, Pooja . [EMAIL PROTECTED] wrote: Hi all I coded complite project on DAT company ..But is is not working on other company created by Functional Consultant ...What would be reason pooja - Original Message From: jquinteroz [EMAIL PROTECTED] To: development-axapta@yahoogroups.com Sent: Saturday, 3 May, 2008 10:36:05 PM Subject: [development-axapta] Importing CSV file to SalesLine Hi!: We need to import a cvs file with order details. Using Import option from Axapta, the sales line imported does not have price. What I need to do in order that the order line, like manual registration, get in automatic way the related unit price?. The record has the following: -Sales Id -Item Id -Qty Ordered -Reservation (manual) -Currency code -Sales Unit (EA) -Invent Dim Id Share files, take polls, and make new friends - all under one roof. Go to http://in.promos.yahoo.com/groups/ [Non-text portions of this message have been removed]
Re: [development-axapta] notExists in executeQuery
Bob,
Rather than using a select statement, you should modify the query of
your form. Type this. and select query(), then add
.dataSourceTable(tableNumBOM_tempTable. Then the method
joinMode(JoinMode::JoinMode::NoExistsJoin) can be used.
You can use the find tool starting at the Form node to look for
methods containing text NoExistsJoin and you will see examples of
where the standard code modifies queries in forms.
I hope this helps,
Mary Ann
On Thu, May 1, 2008 at 7:07 AM, Bob [EMAIL PROTECTED] wrote:
Hello Im quite new to ax and I need to do this:
I have a form with 2 data sources
1: BOM_tempTable (will change name later)
2: productConfigTable
In my form I have to show all the data in table 1 (bom_temptable)
so I made a design like this:
...
Grid:Grid
StringEdit:PalleId - BOM_tempTable.PALLETID (keeps changing to CAPS)
StringEdit:ReolId - BOM_tempTable.RackId
StringEdit:Hyldeid - BOM_tempTable.ShelfId
StringEdit:Cover - BOM_tempTable.Cover
There is also a dropdown box on the design that refers to a baseenum
with 4 items (Normal,PalleId,ReolId,HyldeId).
When you select a thing in the dropdown it will
run BOM_tempTable_ds.executeQuery();
The idea is then when you pick one of the items in the dropdown the
query should change to show the BOM_tempTable where (pickedItem)
dosnt excist on table 2 I done this to try and get it to work.
public void executeQuery()
{
MW_RM_ProductConfigTable _MW_RM_ProductConfigTable;
;
switch (sortSelect.selection())
{
case BOM_tempFormSortSelect::HyldeId :
select _BOM_tempTable
index hint idx
order by ShelfId
notExists join _MW_RM_ProductConfigTable
index hint bomIdx
where _MW_RM_ProductConfigTable.ShelfId == _BOM_tempTable.ShelfId;
break;
...(2 more case(s) with PALLETID and RackId)...
case BOM_tempFormSortSelect::Normal :
select _BOM_tempTable
index hint idx
order by recid;
break;
}
super();
}
But when I do this there arnt any change I still just get the same
date as when I open the form any help would be apriciated
(the drop down box works fine when I select somthing It starts to
scearch but the resault isnt correct cause I can find the items in
the grid that are on the productconfigtable and I only want the ones
that arnt there but are on bom_temptable)
on the table BOM_tempTable I made 3 relations
relation1
BOM_tempTable.PALLETID == MW_RM_ProductConfigTable
relation2
***.Rackid == ***.Rackid
relation3
***.ShelfId == ***.ShelfId
I tried using no relations and having all relations in one
I cant figure out what is wrong :E
Re: [development-axapta] how to implement the lookup feature resemble Google china in EP
The attachment does not show for these posts. Try using the lookup fieldGroup for the table you are looking up. Just drag into that fieldGroup the fields you would like to see for your dropdown of the lookup. An easy alternative is attaching a custom lookup form to an extended data type. See EmplID data type for an example. The Development III course explains how to create custom lookups as well - if you have access to that training manual. Mary Ann 2008/4/29 Jeff [EMAIL PROTECTED]: Hi all I want to implement the lookup feature resembles the attachment showed. any solution would be of great help - 雅虎邮箱，您的终生邮箱！ [Non-text portions of this message have been removed]
[development-axapta] How do I get headings to display all the time.
I created a report with a line from InventTable and a table from InventTableModule. The first time that the table for InventTableModule appears, the headings are there. For all subsequent appearances of InventTableModule data, the headings are not displayed. I noticed, on the Sorting tab, that there is an option labeled Which parts of the field should subheadings be printed for -- but I cannot change Auto to something else. I have tried modifying many of the report properties as well. I just cannot determine what will control the display of those headings. I hope someone can help me with this concern. Mary Ann Hand
[development-axapta] Intensive Development Training
Developers new to Dynamics AX, This message is to let everyone know about intensive training on Ax4 development. There is a bootcamp in May that has space available. I tried a couple days ago to inform group members about this course, but I think the link I provided may have prevented it from being delivered to the group membership. So, if you are interested, please reply to me directly and I will provide more information outside of this group. M Hand
[development-axapta] Intensive Development Training is now available
The first developer bootcamp in the USA will happen in May 2007 in the Washington DC area -- It involves three weeks of very comprehensive development in Dynamics AX. Consider joining me there - enroll while space is available. Visit this link for more information. http://university.msregistration.com/content/courseabstract.asp?CcpSubsiteID=59vdid=0ProductID=2861EventID=17517hdnPrivateEventID=PreRegistrationID= This course is subsidized. The all-inclusive price is quite low for three weeks of training. Note that you will need partnersource login to get to the link. Be among the first to earn the new AX Developer Master certification!
[development-axapta] Sorting by columns - causing performance hit
I need to set the InventTable form to prevent users from clicking on column heading to sort by a field. There were too many items and the sort ran for hours causing everyone else on that AOS to experience huge delays. Is there any way to prevent the column sort Mary Ann Hand
[development-axapta] Can we prevent column sort on a specific form with lots of data?
I am dealing with a customer that has a huge item master. One user just clicked on a column heading to sort by a column that is not indexed. AX went off for hours to do that sort. It created a performance problem for all other users as well. The only way to kill that sort was to stop the AOS server because CNTRL-Break would not respond in this case. Is there a way to prevent column sort, either for all columns of the InventTable Form? Or better yet, is it possible to disable specific columns, such as those not indexed. Thanks, Mary Ann
[development-axapta] How can I suppress an annoying message?
When a report needs to be rescaled, the info log pops up with a message... reportname - Report is scaled x percent to fit the page. I have two customers who do not want to see these messages. The report looks fine. I cannot find this message among the labels, so I cannot find the place in the code to comment it out. If I cannot supress this message, can I do something to scale the report in the code so that Axapta will not need to rescale it? Thanks for any help you all can post. Mary Ann
Re: [development-axapta] Resorting a table buffer
one way is to create a new index on the table (in Axapta) with the field you
want to sort by and then use the order by in the select or the index hint.
Without an index, particularly on a name field, would make the select far
too slow.
On 1/25/06, Christoph Malherbe [EMAIL PROTECTED] wrote:
Hi all,
Please consider the following:
static void ProcessCustomers(CustTable ct)
{
while (ct)
{
print ct.AccountNum;
next ct;
}
pause;
}
This is a hypothetical scenario where the method receives a table buffer
as
parameter. The table buffer is sorted by AccountNum desc. Before
processing the table buffer with the while statement, I'd like to change
the sort order to Name asc. Is this something that can be done without
having to re-execute the select that populated the table buffer in the
first
place?
Regards,
Christoph Malherbe
[Non-text portions of this message have been removed]
SPONSORED LINKS
Computer parthttp://groups.yahoo.com/gads?t=msk=Computer+partw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yLpvcLTIDJ5FTkRJGsO11w Programming
languageshttp://groups.yahoo.com/gads?t=msk=Programming+languagesw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=cuhEClK4dU4wapXFmKisbQ Microsoft
axaptahttp://groups.yahoo.com/gads?t=msk=Microsoft+axaptaw1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=yfeG_U6QaLfPOZZIud02Fg Support
exchangehttp://groups.yahoo.com/gads?t=msk=Support+exchangew1=Computer+partw2=Programming+languagesw3=Microsoft+axaptaw4=Support+exchangec=4s=90.sig=hy8yRGMzrmxdphyITTUeqA
--
YAHOO! GROUPS LINKS
- Visit your group development-axaptahttp://groups.yahoo.com/group/development-axapta
on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED][EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service http://docs.yahoo.com/info/terms/.
--
[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.
Re: [development-axapta] Axapta Installation configuration certification
If you attend a Microsoft bootcamp, you will get materials and the exam will seem very easy. I do not know any way to get materials without taking a class. On 1/25/06, g [EMAIL PROTECTED] wrote: Hi, I have a plan to write Axapta Installation Configuration certification exam. If any of you already attended that, please suggest me which site i should refer and where i have to get materials for this. I need ur valuable help. Regards, Gopi - Do you Yahoo!? With a free 1 GB, there's more in store with Yahoo! Mail. [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. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 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.
