Informatica Cloud - Incremental Load (Data Ingestion)

Today we will learn how to create incremental data load (ingestion) in Informatica cloud data integration

1. Create two SQL server connections in Informatica cloud administration
1. Connection for source database
2. Connection for target database
2. Create a mapping from Informatica data integration
1. Add source
1. Select source connection (point to the newly created source connection in the Informatica administration)
2. Select source type as query
3. In the query window, enter the query to get the maximum timestamp from your target table
4. The timestamp should come from the target database table here. This max timestamp will act as a filter to fetch latest records from the source
   

NAV - Vendor List Report with Column Grouping

Today we will learn to Create a NAV Report named Vendor List which will show amount of vendors for all G/L Accounts.

The G/L Accounts will come in one Row.

Declare Your Data Item (NAV Table from which we want to fetch data)

SQL - Procedure to calculate Computed column values according to formulae stored inside table

Suppose if we have formulae's stored in our table row. e.g : for the above table for second row the formulae is 1+2 that means first row's value + second row's. we have to supply the ID field to determine the value and formulae.

AX 2012 - Make SSRS Report Using SQL Stored Procedure

Today we will learn how to create AX SSRS reports using SQL queries/Stored Procedure

Open SQL management studio and navigate to your dynamics AX database. Create a new stored procedure.

Write the query in store procedure according to your need.

Unable to post GRN. Number sequence error

GRN Journal button is not available after PO Posting.
Number sequence could not be generated because a number sequence reference is missing. Ensure that all  necessary number sequences are set up.

Number Sequence Code generates numbers that are longer than the maximum length allowed.

When applying a number sequence to EDT. If you get following error.

Go to the EDT > properties > string size > increase the string size according to the number sequence format length.

AX 2012 SSRS - Cheque report Customization

Today we will learn how to customize standard cheque report and add a new cheque design.

1) Make a new Output type MenuItem for your cheque report.

2) Make changes in the standard enum for cheque report and add your cheque name.

AX 2012 - SSRS : Print duplicate copies of same report

1)Make a string type parameter in your SSRS contract class in which you will save your Report type like Duplicate copy 1,Duplicate copy 2, Extra copy and so on....

2)Then go to your controller class and assign that parameter to your contract.

3)Now in your report dataset you will able to see the parameter, add to your design.

4)Call your report through menu item and pass the parameter in args.parm() method. you can loop through if you want to pass multiple parameters.
Note : to get multiple copies you have to call report multiple times passing different parameter in args.parm() like copy1,copy2,copy3,etc..

and it will get printed now.

Enjoy...!