Dynamics AX 2012

RegisterOverrideMethod was called twice for the same object for method Dynamics Ax 2012

October 28, 2016 by alirazazaidi

I was developing the report by adding UI Class and building the drop down list to select multiple customer.

When I try to bind, DataSet of SSRS report to data provider class, it shows following error.

RegisterOverrideMethod was called twice for the same object for method ‘textChange’. You can only override a method once per instance.

On Exploring I found that I used the Same dialog field in two lookup methods.

SysLookupMultiSelectCtrl::constructWithQuery(this.dialog().dialogForm().formRun(), dlgCustAccount.control(), query, false, selectedFields);

Time field on SSRS shows time format Report Dynamics Ax 2012

October 28, 2016 by alirazazaidi

Today is another small tip,

I was developing a custom report. Queried table stored the date and time in separate fields ie. Transdate and transtime. On mapping the transtime to report, its showed time format. Instead of time value.

For it solution, I added the string field on report temp table and then convert the time with time2str function and map to the field.

Complete statement is below.

TableTmp.StransTime = time2Str(_Trans.transTime, TimeSeparator::Colon, TimeFormat::AMPM);

As result, report will display the trans time instead of its format.

TSQL Query for tables where each General ledger entry has effect Dynamics Ax 2012

September 27, 2016 by alirazazaidi

For Future reference, I used following Queries to check the General Ledger Entry in Dynamics ax 2012. Small tip,

You can used them to delete posted ledger entry

select * from LEDGERJOURNALTABLE where JOURNALNUM =’XYZ-015528′

select * from LEDGERJOURNALTRANS where JOURNALNUM =’XyZ-015528′

select * from LedgerEntryJournal where JOURNALNUMBER =’XyZ-015528′

select recid,* from GeneralJournalEntry where LedgerEntryJournal= LedgerEntryJournal.RecID

select * from GeneralJournalAccountEntry where GeneralJournalEntry = GeneralJournalEntry.RecID

select * from custtrans where custtrans.VOUCHER in

–ACCOUNTNUM =’Cust-02032′ and

(

select LedgerJournalTrans.VOUCHER from LedgerJournalTrans

join LEDGERJOURNALTABLE

on LedgerJournalTrans.JOURNALNUM = LEDGERJOURNALTABLE.JOURNALNUM

where LEDGERJOURNALTABLE.POSTED =1 and ( LedgerJournalTrans.ACCOUNTTYPE =1 or LedgerJournalTrans.OFFSETACCOUNTTYPE =1) and LEDGERJOURNALTABLE.JOURNALNUM =’XyZ-015528′

Financial dimension for work position Dynamics Ax 2012.

August 15, 2016 by alirazazaidi

I used following code snippet to get financial dimension attached with hcmposition

static void GetFinancialDimensionValue1(Args _args)

{

HcmPosition  position;

HcmPositionDefaultDimension  positionDefaultDimention;

DimensionAttributeValueSetStorage dimStorage;

Counter i;

select * from position

join * from positionDefaultDimention

 

where position.PositionId=="000001"

&& position.RecId == positionDefaultDimention.Position;

 

 

 

dimStorage = DimensionAttributeValueSetStorage::find(positionDefaultDimention.DefaultDimension);

 

for (i=1 ; i<= dimStorage.elements() ; i++)

{

 

info(strFmt("%1 = %2", DimensionAttribute::find(dimStorage.getAttributeByIndex(i)).Name,

dimStorage.getDisplayValueByIndex(i)));

 

}

}

Reference: https://jkmsdax2012.wordpress.com/2015/11/16/how-to-get-financial-dimensions-for-a-particular-customer-using-x-code-in-ax-2012/

Cannot edit a record .. An Update Conflict occurred due to … Dynamics Ax 2012 R3.

August 11, 2016 by alirazazaidi

today I got this error while running a custom report.

Cannot edit a record in Table

An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.

I found that this error occurs due to concurrent access to table is allowed. And we did not need concurrent access.

I change the ccEnabled to no

If this error occur on table that can be used on concurrent mode, then write tableBuffer.reread() before adding or modify data.

Reference: https://community.dynamics.com/ax/f/33/t/95177

water mark in SSRS report Dynamics Ax 2012.

August 4, 2016 by alirazazaidi

Hi, all very small tip today, Recently I have to add water mark in one of custom report.

In SSRS for Dynamics Ax 2012, we can achieve water mark by adding background image in report body.

Water mark image should be small in size and used as background Image. If you use high in size image, Report will threw errors on deployed at server.

This water mark can hide and show with ssrs expression.

So complete real word requirement will be Print report with water mark if certain criteria meets, other wise print report normal report.

At SSRS side right right click on report Body and click on Body Properties.

From property window, select fill, select file the image source “embedded” and import file.

After import file will be shown as report explorer

Now add following expression to show report display water mark or not.

=IIf(Fields! DuplicateCopy.Value=1,”Duplicate3″,””)

How to run RDP based report from X++ and passing parameter using Data contract.

July 19, 2016 by alirazazaidi

Interesting, I was modifying some RDP based report, I found that parameter was passed to report through custom table, As report will run form button, and based on current selected record. So former developer did that on pressing button, selected value inserted some custom table. When report run, query on table and fetch required value form custom table and whole report logic run on that value. That approach works fine, single user environment. Problem I found to send parameter to report through x++ code. I found SrsReportRunController works wonder here.

Suppose we are running some report for customer, And Report Name is customer Report and we have to pass current customer account on form as parameter. If you report is based on Report data provider than following code snippet works for you.

SrsReportRunController controller = new SrsReportRunController();

CustomerReprtDC rdpContract = new CustomerReprtDC ();

SRSPrintDestinationSettings settings;

super();

controller.parmReportName(ssrsReportStr(CustomerReport,CustomerCopy));

controller.parmShowDialog(false);

rdpContract.parmCustAccount(CustTable.AccountNum);

controller.parmReportContract().parmRdpContract(rdpContract);

controller.startOperation();

No such host is known and AOS not reached SSRS Dynamics AX R3.

July 14, 2016 by alirazazaidi

Yesterday I deployed the new SSRS customization to staging, so QA / Functional guy can test.

Client configured the AOS to Database server and Application server was moved for backup services.

Due to change in AOS server I have to face two issues.

“No Such Host is known.”

Whenever we run the report on staging server during report processing Error pop up appear with message “ Host not found “.

Modification in Windows Register, did not solve this problem. I have to reinstall the Reporting services extension form Dynamics Ax 2012 R3.

Second issue I faced that During installation of Reporting Extensions. Setup did complete and shows message about it did not locate the Required AOS. Interesting setup pointing to old server.

I solve this error by removing the credential save for Business connecter form Administration module for Dynamics AX. After rerun the reporting extension form AX Setup, Installation will complete successfully. Later deploy all reports and reports runs successfully.

Display methods in Report SSRS Dynamics Ax 2012 .

June 13, 2016 by alirazazaidi

Hi, All, today I have to modify the report. Interestingly this report was built on AOT Query, instead of Data provider class. Current Scenario I was working on Worker Report. The requirement was to show’s primary position and department. HCMWorker table has two display method returns these values.

We can add these display methods into reports by following way.

For example I am modify the out of the box HCMWorkersHiredInPeriod Report.

Now Problem appears, we need different values then provided by out of the box display methods. For example we need Position Title instead of Primary Position Id. for this Add new display method that will return the Position Title instead of Position Id, compile table synchronize table, restore the AOT Query and refresh the report data Set. If there is no error in your working environment you will find required methods in report Data set.

Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists. Dynamics Ax 2012

May 19, 2016 by alirazazaidi

Hi, All today I got error while creating Leger entry

Cannot create a record in General journal entry (GeneralJournalEntry). Date: .The record already exists.

I found some issue with free sequence number in NumberSequenceList . I manually delete the free sequence number with following statement.

static void Job14(Args _args)
{
NumberSequenceList list;

while select forUpdate * from list where
list.NumberSequenceId ==5637145445 && list.Status ==NumStatus::Free
{
ttsBegin;
list.delete();
ttsCommit;
}

}

I got again got help from Andre answer on dynamics Ax community

Reference: https://community.dynamics.com/ax/f/33/t/138926

« Previous Page