Monday, March 26, 2018

Free Text Invoices in Microsoft Dynamics AX 2012

Parameter Setup:
  • Navigate to Accounts Receivables > Setup > AR Parameters.
  • Click Project link/tab.
image
  • Check mark the “Display project-related fields on free text invoices” check box.
  • Check mark the “Allow ledger account number to be edited” check box if you want to be able to change the revenue ledger account, which gets defaulted when you choose the project and category in the free text invoice.
    Having done that required parameter setup, let us now go and post a free text invoice.
Create and Post a Free Text Invoice:
  • Navigate to Accounts Receivables > Common > Free Text Invoices > All free text invoices and create a new FTI.
image
  • Enter Customer account = 1102. Rest all customer related data will get loaded automatically.
  • Click Line details fast tab and click the Project tab.
  • Enter the required project and category.
image
  • Notice that, as soon as you enter the project and category, the main account field gets populated with the main account which is setup in the project posting profile.
  • If you want to change the account, you can do so, as we have marked the check box in AR parameters forms.
  • Now, fill in the invoice description, Quantity and the unit price and finally post the FTI.
  • You can then verify the project revenue and see that this gets recorded in the project.

Monday, February 12, 2018

Parameter screen in ssrs reports













Today i discuss the ssrs report paramter it is easy to deploy


Common Uses for Parameters

Here are some of the most common ways to use parameters.
Control Paginated and Mobile Report Data
  • Filter paginated report data at the data source by writing dataset queries that contain variables.
  • Filter data from a shared dataset. When you add a shared dataset to a paginated report, you cannot change the query. In the report, you can add a dataset filter that includes a reference to a report parameter that you create.
  • Filter data from a shared dataset in a SQL Server mobile report. See Create mobile reports with SQL Server Mobile Report Publisher for more information.
  • Enable users to specify values to customize the data in a paginated report. For example, provide two parameters for the start date and end date for sales data.
    Connect Related Reports
  • Use parameters to relate main reports to drillthrough reports, to subreports, and to linked reports. When you design a set of reports, you can design each report to answer certain questions. Each report can provide a different view or a different level of detail for related information. To provide a set of interrelated reports, create parameters for the related data on target reports.
  • Customize sets of parameters for multiple users. Create two linked reports based on a sales report on the report server. One linked report uses predefined parameter values for sales persons and the second linked report uses predefined parameter values for sales managers. Both reports use the same report definition.
    Vary Report Presentation
  • Send commands to a report server through a URL request, to customize the rendering of a report. For more information, see URL Access (SSRS) and Pass a Report Parameter Within a URL.
  • Enable users to specify values to help customize the appearance of a report. For example, provide a Boolean parameter to indicate whether to expand or collapse all nested row groups in a table.
  • Enable users to customize report data and appearance by including parameters in an expression.