02 March 2017

how to add date range in query value in AX 2012

queryBuildRange = queryBuildDataSource.addRange(fieldNum(CustPackingSlipJour,DeliveryDate));
        queryBuildRange.value(queryRange(fromDate,toDate));
        //queryBuildRange.value(SysQuery::range(fromDate,toDate));

Refreshing SSRS report meta data in Dynamimcs AX 2012 || Refreshing code changes in reports objects in SSRS

When changing parameter or Parameter labels or added new parameter in the Contract class, do the following:
1. In VS, remember to change the prompting string for the parameter.
2. Refresh the Datasets.
3. Build the VS project.
4. Add the Report to the AOT.
5. Delete the Report from the Report Server.
6. Deploy the report in VS.
7. Most importantly, Compile the SSRSReport in the AOT.
8. Go to SSRS report and restore and check the properties: Changed Time is affected or not.
Query changes not affected means:


static void deleteSRSReportQuery(Args _args)
{
SRSReportQuery srsReportQuery;
ttsBegin;
while select forUpdate srsReportQuery
{
srsReportQuery.doDelete();
}
ttsCommit;
}

Ledger Voucher creation Framework and x++ code to create ledger voucher

 Please click her for MS reference file Below is the out of the box example reference and code. SalesInvoiceJournalPostSubBill_Extension->...