[development-axapta] Shop Floor Control > Setup
Hi We are using Dynamics AX 2009. We have a weird situation in Shop Floor Control > Setup > Employee module Whenever we hit the Employee table link, sometimes the Employee screen is loaded with BLANK values in "Standard Profile" column, but NOT ALWAYS... Its not consistent, We can able to reproduce it frequently. Could someone please assist me what could be the reason. I appreciate you. Thanks Jaffar [Non-text portions of this message have been removed]
[development-axapta] Programmable Section in AOT Report
Hi As per one of the requirements I have to design a report which looks like SalesPackingSlip with different information on it. Lets say its SalesPackingSlip1. In my new report SalesPackingSlip1, I need to have a section which should give a summary of my lines i.,e I would like to display my new section that should group by my lines based on some product group Example Item No. Product Group Qty Net Weight Gross Weight Amount Item1 group1 10 10 5 10.00 Item2 group1 10 10 5 40.00 Item3 group2 20 10 20 30.00 Item4 group2 30 10 40 40.00 At the end I need to have a summary section which lists the following records Product Group Qty Net Weight Gross Weight Amount group1 20 20 10 50.00 group2 50 20 60 70.00 I think I have to use Programmable section with Report's fetch() method to achieve this. I was trying something like that but couldn't get it... Could someone please help me in this regard? Pls let me know if you need further information. Thanks Jeff [Non-text portions of this message have been removed]
Re: [development-axapta] Re: How to Company as parameter to SSRS report?
Guys Any thoughts on the below question? Also i have another question. Is it possible to call Axapta display/data methods from SSRS reports? ->Jafar From: Jafar To: development-axapta@yahoogroups.com Sent: Wednesday, March 11, 2009 1:05:43 PM Subject: Re: [development-axapta] Re: How to Company as parameter to SSRS report? Hi Prass Thanks for your reply. Could you Please explain in detail How do i pass curExt() value as my MenuItem Parameter I have @strCompanyId as parameter in my menuitem which i already created in my SSRS report too. I would appreciate if you guide me further on this. Pls find the attached screeen capture for more details Thanks Jaffar From: Prasetyo Budi Utomo To: development-axapta@yahoogroups.com Sent: Tuesday, March 10, 2009 9:10:00 PM Subject: [development-axapta] Re: How to Company as parameter to SSRS report? Hi Jaffar, In SSRS I usually create Store Procedure and define a parameter to filter dataareaid (company) then include "curext()" statement/command in AX to call that parameter. Prass --- In development-axapta@yahoogroups.com, Jafar wrote: > > Hi > > I have created a SSRS report and called from Dynamics AX MenuItem. > > To create SSRS report i used SQL Server Business Intelligence Dev Studio > tool. I have Company ID as one of the (Hidden) parameters in the report and > used in query too (as @compayid) > > When I call from Dynamics AX menu, How do I pass the current Company > (CompanyId) where i'm in? > > I would appreciate if someone help me on this. > > Pls let me know if you need more information. > > > Jaffar > > > > > [Non-text portions of this message have been removed] > Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed]
[development-axapta] List page - Filter Pane - Advance Query Filter Change
Hi I have couple of queries about how to customize Filter Pane in Sales Order List Page? 1. As shown in the attachement (FilterPane-NewField.jpg), there are search fields already available, if i want to add one more search column ie., SalesTable.ShippingDateConfirmed as a search field and in the Grid display. How do i do that? 2. If i want to change the Advance Filter Query (as shown in fig AdvanceFilter-Change.jpg), how do i do that? Lets say if i want a column aXTendCredit. aXTendCredStatus = Hold instead of Customers.Stopped = Invoice..All, How do i change that? I would appreciate if somoen assist me on this Thanks Jaffar [Non-text portions of this message have been removed]
Re: [development-axapta] Re: How to Company as parameter to SSRS report?
Hi Prass Thanks for your reply. Could you Please explain in detail How do i pass curExt() value as my MenuItem Parameter I have @strCompanyId as parameter in my menuitem which i already created in my SSRS report too. I would appreciate if you guide me further on this. Pls find the attached screeen capture for more details Thanks Jaffar From: Prasetyo Budi Utomo To: development-axapta@yahoogroups.com Sent: Tuesday, March 10, 2009 9:10:00 PM Subject: [development-axapta] Re: How to Company as parameter to SSRS report? Hi Jaffar, In SSRS I usually create Store Procedure and define a parameter to filter dataareaid (company) then include "curext()" statement/command in AX to call that parameter. Prass --- In development-axapta@yahoogroups.com, Jafar wrote: > > Hi > > I have created a SSRS report and called from Dynamics AX MenuItem. > > To create SSRS report i used SQL Server Business Intelligence Dev Studio > tool. I have Company ID as one of the (Hidden) parameters in the report and > used in query too (as @compayid) > > When I call from Dynamics AX menu, How do I pass the current Company > (CompanyId) where i'm in? > > I would appreciate if someone help me on this. > > Pls let me know if you need more information. > > > Jaffar > > > > > [Non-text portions of this message have been removed] > Yahoo! Groups Links [Non-text portions of this message have been removed]
[development-axapta] How to Company as parameter to SSRS report?
Hi I have created a SSRS report and called from Dynamics AX MenuItem. To create SSRS report i used SQL Server Business Intelligence Dev Studio tool. I have Company ID as one of the (Hidden) parameters in the report and used in query too (as @compayid) When I call from Dynamics AX menu, How do I pass the current Company (CompanyId) where i'm in? I would appreciate if someone help me on this. Pls let me know if you need more information. Jaffar [Non-text portions of this message have been removed]