Friday, September 05, 2014

How To Get Contact Information on Dynamic AX 2012 R3 - Dwipa Rachmawan

Here is the sample how to get or retrieve multiple contact information on customer
like the following pictures :
When we are clicked the button More options - Advanced :

As you can see in this form the datasources is LogisticsElectronicAddress
but the information about Purpose is not in here.

So this is the jobs for retrieve contact information and display the value Purpose
static void DPR_ContactInformation(Args _args){    DirPartyContactInfoView                 contactInfoView;    LogisticsElectronicAddress              logisticsElectronicAddress;    LogisticsElectronicAddressRole          logisticsElectronicAddressRole;    LogisticsLocationRole                   logisticsLocationRole;    CustTable                               custTable;    DirPartyPostalAddressView               DirPartyPostalAddressView,postalAddressView;    select * from CustTable        where custTable.AccountNum == '3003';    while select contactInfoView        where contactInfoView.Party == custtable.Party    join DirPartyPostalAddressView        where DirPartyPostalAddressView.Party == contactInfoView.Party    join logisticsElectronicAddressRole        where logisticsElectronicAddressRole.ElectronicAddress == contactInfoView.RecId    {        info(strFmt('Name=%1 Type=%2 Locator=%3 Purpose=%4',contactInfoView.LocationName, contactInfoView.Type, contactInfoView.Locator, LogisticsLocationRole::findRec(logisticsElectronicAddressRole.LocationRole).Name));    }}
And here is the result

Good Luck
Wasalam
READ MORE - How To Get Contact Information on Dynamic AX 2012 R3 - Dwipa Rachmawan

Wednesday, August 27, 2014

Error when refresh PurchPurchaseOrder datasource on Dynamic AX 2012 - Dwipa Rachmawan Cool :P

When i do custom report Purchase Order in AOT the report name is PurchPurchaseOrder
and do refreshing on dataset PurchPurchaseOrderLine. The error raise

Element
':PurchPurchaseOrder.Parameters.IsPurchConfirmationRequestJournal' has already been defined.To correct this, rename one or more of the model elements so that they have a unique name.

Do following step in order to fixed the problem
1. just rename it the parameter IsPurchConfirmationRequestJournal become IsPurchConfirmationRequestJournalX (you can do as you want)
2. set property this IsPurchConfirmationRequestJournal

  1. allow blank
  2. nullable
become true
3. after you rename it, right click the report PurchPurchaseOrder and klik restore. (just klik ok if there is popup windows)

4. do refreshing again on dataset PurchPurchaseOrderLine
when doing system will create for you another parameter which is IsPurchConfirmationRequestJournal
and change this parameter property  like above

  1. allow blank
  2. nullable

5. Klik the report rebuild and deploy

Thats it and Good luck

Wasalam
READ MORE - Error when refresh PurchPurchaseOrder datasource on Dynamic AX 2012 - Dwipa Rachmawan Cool :P

Monday, August 18, 2014

Windows Server 2012 Release Candidate domain controllers have a default for the security setting named "Allow cryptography algorithms compatible with Windows NT 4.0" that prevents weaker cryptography algorithms when establishing security channel sessions.

Problem when create domain on windows server 2012

Problem Syntax : 

Windows Server 2012 Release Candidate domain controllers have a default for the
security setting named "Allow cryptography algorithms compatible with Windows NT 4.0"
that prevents weaker cryptography algorithms when establishing security channel
sessions.

Solution is :

1. Just log-off off your windows account.
2. Then Log-in with an  Administrator account
3. Try again the proses
4. does it (this solution work with my situation),

what about yours ...!, please comment.
READ MORE - Windows Server 2012 Release Candidate domain controllers have a default for the security setting named "Allow cryptography algorithms compatible with Windows NT 4.0" that prevents weaker cryptography algorithms when establishing security channel sessions.

Monday, March 10, 2014

Concenate the expresion in SSRS reports in Dynamics AX 2012

Sometime when we create report in SSRS, often we must concenate string with variabel or the the expression.

by the example : ssrs expression in the textbox

first way..
create texbox and enter this expression
="Mars Odyssey was launched in "& First(Fields!AsOfDate.Value) &" to hunt for past or present water on the red planet."
second way..
create texbox and enter this expression only
=First(Fields!AsOfDate.Value,"TCN_RencanaFillingDP")

after that insert the text before the expression
Mars Odyssey was launched in

and then insert the other text after the expression
to hunt for past or present water on the red planet.

like this pictures below



i am prefer the second way.
:Dpr

READ MORE - Concenate the expresion in SSRS reports in Dynamics AX 2012