[development-axapta] AOD modified date
Our auditor requires to know when are the AOD files updated by AX. Is it only when a change is made in the corresponding layer in an AOT object or are there other situations? If an object exists in both VAR and USR, if it is modified in USR can the VAR aod file in anyway be affected? If aoi is rebuilt can this affect? If cross reference is updated can this affect? The reason is the VAR aod file has strange dates that cannot be explained (since we did not do any changes in the VAR layer since a certain date) and so the auditor wants to know the situations of how AX can modify it Is there any way we can filter or see if there is any object in the VAR layer that has a created or modified date after a certain date? Thanks James [Non-text portions of this message have been removed]
[development-axapta] How to open new outlook meeting request from ax on button click
HI All , I want to open Outlook meeting request on button click of AX form. This form is activity form in CRM module. Can anyone please help me with this, how can i do this. Your help is much apprciated.Please attached screenshot of meeting request i want to open. Thanks,Asit [Non-text portions of this message have been removed]
[development-axapta] Consolidation In 2009
Dear All, Has anybody worked on Consolidation of different companies in different countries in Ax 2009. The COA of all the companies in different countries is similar. The localisations will be different offcourse but we want consolidation of the same to be done.Regards Abhay -- THIS E-MAIL IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed. [Non-text portions of this message have been removed]
[development-axapta] Posting a Credit Note
Hi, I have a requirement for changing the way Ax posts a sales order credit as compared to its initial invoice. When we post an Invoice, Ax uses the following accounts A/R (Posting Profile Summary account) Dr Sales (Item group SO revenue account) Cr COGS (Item group SO consumption account) Dr Inventory (Item group SO issue account) Cr -- If I post its credit note, it will usPosting Credit Notee the same accounts, in standard Ax However, I need to be able to make it post like this ReturnsDr A/R (Posting Profile Summary account) Cr Obsolete InventoryDr COGS (Item group SO consumption account) Cr Need to change the Sales and inventory accounts here Does anyone know how to achieve this? Or anybody done a customization for this? Thanks Akshay [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/development-axapta/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/development-axapta/join (Yahoo! ID required) * To change settings via email: development-axapta-dig...@yahoogroups.com development-axapta-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: development-axapta-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [development-axapta] How to Enter group of field data in One Text field.
Khalil UR Rehman, Try to put a code in the modified method of the said field and concatenate all. Example: public void modifiedField(fieldId _fieldId) { super(_fieldId); switch (fieldExt2Id(_fieldId)) { case fieldnum(InventTable, ItemId): this.ItemName = this.ItemName ? this.ItemName : this.ItemId; this.setNameAlias(); // added code this.NewField = Item Number + Item Name + Dimension Group + Hieght + Width + Depth; // break; } } From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Khalil Rehman Sent: Sunday, December 13, 2009 5:38 AM To: Knowlege Village; Adeel AX Technical Consultant; AX Consultant Sumit Loya; Development Axapta; Development Group Subject: [development-axapta] How to Enter group of field data in One Text field. Dear All, in Inventory Master form, i have a requirement that if i enter Data in Item Number, Item Name, Dimension Group, Hieght, Width, Depth fields. it should be combined in a new field place on form automatically. thanks regards. KHALIL UR REHMAN __ Windows Live Hotmail: Your friends can get your Facebook updates, right from HotmailR. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/soc ial-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_4:092009 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[development-axapta] Re: AX 2009 - Reporting Service- Error
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-in www.RahulSharma.in http://www.rahulsharma.in/ blog.RahulSharma.in http://blog.rahulsharma.in/ --- In development-axapta@yahoogroups.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.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- Error To: AxaptaGroup development- axa...@yahoogrou ps.com Date: Sunday, 15 November, 2009, 12:29 PM  Dear All,  I sucessfully installed AX 2009, Reporting Services and Reporting Extension sucessfully. I can i aceess http://localhost: 81/Reports and http://localhost: 81/Report Server.  I have deployed the AX reports but while the SRS reports through AX am getting this error  Error during processing of âAX_CompanyNameâ report parameter. (rsReportParameterP rocessingError)  Please reply  Thanks TS [Non-text portions of this message have been removed] The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo. com/ [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[development-axapta] LedgerTrans summarization record purge
I'm wondering if anyone has worked on reducing size of LedgerTrans file. Our current table is 30GB, we want to clean out data older than 4 years. I've got a preliminary class that summarizes transactions deletes the originals and it seems to work. I've recalculated period balances and so far they tie out to the penny. I'm wondering if I'm missing anything. AXv3sp3
RE: [development-axapta] LedgerTrans summarization record purge
Should be fine so long as you can live without the detail and just keep a good safe backup of all the original J From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of mep53565 Sent: 15 December 2009 07:32 To: development-axapta@yahoogroups.com Subject: [development-axapta] LedgerTrans summarization record purge I'm wondering if anyone has worked on reducing size of LedgerTrans file. Our current table is 30GB, we want to clean out data older than 4 years. I've got a preliminary class that summarizes transactions deletes the originals and it seems to work. I've recalculated period balances and so far they tie out to the penny. I'm wondering if I'm missing anything. AXv3sp3 [Non-text portions of this message have been removed]
[development-axapta] Re: How to Enter group of field data in One Text field.
I will suggest you add a new field of type container and show it on form with display method. This way you can display your data in any format you want and you can access each field value in the container. //Rahul blog.RahulSharma.in www.RahulSharma.in --- In development-axapta@yahoogroups.com, Ruel Ormita r...@... wrote: Khalil UR Rehman, Try to put a code in the modified method of the said field and concatenate all. Example: public void modifiedField(fieldId _fieldId) { super(_fieldId); switch (fieldExt2Id(_fieldId)) { case fieldnum(InventTable, ItemId): this.ItemName = this.ItemName ? this.ItemName : this.ItemId; this.setNameAlias(); // added code this.NewField = Item Number + Item Name + Dimension Group + Hieght + Width + Depth; // break; } } From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of Khalil Rehman Sent: Sunday, December 13, 2009 5:38 AM To: Knowlege Village; Adeel AX Technical Consultant; AX Consultant Sumit Loya; Development Axapta; Development Group Subject: [development-axapta] How to Enter group of field data in One Text field. Dear All, in Inventory Master form, i have a requirement that if i enter Data in Item Number, Item Name, Dimension Group, Hieght, Width, Depth fields. it should be combined in a new field place on form automatically. thanks regards. KHALIL UR REHMAN __ Windows Live Hotmail: Your friends can get your Facebook updates, right from HotmailR. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/soc ial-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_4:092009 [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[development-axapta] Re: AOD modified date
Hi James, First of all to get a list of objects modified in a leyer, open UtilElements table (System Documentation) and filter on fields utilLayer modifiedDateTime. Yes, AOD is modified when you make changes in application and ofcourse there are other factors like if you restart AOS, if you rebuild AOI etc. If object exists on both VAR n USR, if u modify it on USR , VAR will not be affected. I hope this helps. //Rahul blog.RahulSharma.in http://blog.rahulsharma.in/ www.RahulSharma.in http://www.rahulsharma.in/ --- In development-axapta@yahoogroups.com, James Flavell djf1...@... wrote: Our auditor requires to know when are the AOD files updated by AX. Is it only when a change is made in the corresponding layer in an AOT object or are there other situations? If an object exists in both VAR and USR, if it is modified in USR can the VAR aod file in anyway be affected? If aoi is rebuilt can this affect? If cross reference is updated can this affect? The reason is the VAR aod file has strange dates that cannot be explained (since we did not do any changes in the VAR layer since a certain date) and so the auditor wants to know the situations of how AX can modify it Is there any way we can filter or see if there is any object in the VAR layer that has a created or modified date after a certain date? Thanks James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]