Friday, October 21, 2011

Get last form values in Dynamics Ax 2009


Last Form values by user in Dynamics AX 2009

Problem : I got one task that i need to store last form values by user specified. In my task need to store a selection in enum values. 

Solution   : I searched for resources to solve this issue. Ax has inbuilt feature to store user-wise and  version wise form information. I described  this feature.
             
                   consider one form it has enum field with 6 possible selection. what i am going to do is storing the last selection of enum field according to user. here follow the steps.
          
              




                  * You need to update the class declaration method in form by below code
                                

                 ABC category;
                 #define.CurrentVersion(1)
                 #localmacro.CurrentList 
                 category,
                 #endmacro
 


                    show status  - declaration of variable. ABC enum field i used, and the variable used to store the selection of user

                    #define.currentVersion(1) -Version stored in the cache by list (how many values added here 1) what if you are going to add one more field on that list. then you need to increase the version by 1 (at your choice but the version must differ numerically like #define.currentVersion(2)) because cache knows version 1 has 1 variables and version 2 has 2 variables. i hope you understand.

                    #localmacro.currentList ...........#endmacro - it describes what are all the variables we are going to store.

                  *  Methods need to be created, written in form methods
                         
                           Public void initParmDefault()
           {
               ;
               category = ABC::None;
           }
                       above method describes the default parameter. what if no versions saved in cache. its for first use.when user first open the form the default value (declared above) display.

                          public container pack()
                {
                    return [#CurrentVersion,#CurrentList];
                }


             public boolean unpack(container packedClass)
                {
                    int version;
                    ;
                    version = RunBase::getVersion(packedClass)
                    if(version)
                       {
                           [version,#CurrentList] = packedClass;
                           return true;
                       }
                       return false;
                }

                      Above two methods used to format (Pack) and extract (unpack) data. The two methods going to called by xSysLastValue class. In our case pack method will give value of a enum field and version to xSysLastValue class then this class save those values by version in cache. unpack method called by xSysLastValue class to extract those values by user and version. below i will explain the xSysLastValue class.
         
                        
        public identifiername lastValueDesignName()
        {
            return element.args().menuItemName();
            // you can use element.args().designName();
            // this method returns the name of caller
        }
        public identifiername lastValueElementName()
        {
            return this.name();
        }
        public UtilElementType lastValueType()
        {
            return UtilElementType::Form;
        }
        public userId lastValueUserId()
        {
            return curuserid();
        }
        public dataAreaId lastValueDataAreaId()
        {
            return curext();
        }
 
                    Above methods combine to ensure the values that needed by xSysLastValue.savelast method.This values are needed to maintain different user store values different objects in different companies.

                      Override close() method by below coding

                      public void close()
             {
               ;
               Category = ComboBox.selection();
               xSysLastValue::saveLast(this);
               super();
             }

                  when the form closes this system method triggered. here the xSysLastValue class send the user selected values to cache.

               Override a run() method by below coding
                      
           public void run()
             {
                ;
                //called before opeing the form 
                super();
                //get the last value stored in cache 
                //here unpack method used
                xSysLastValue::getLast(this);   
                //set the last user selection on the field
                combobox.selection(showStatus);
             }
 
        above method used to set last values in form.
 
 
            Implement the above flow. if you had any doubt comment. 



                                                                                     




  
                         





             







Tuesday, October 18, 2011

Error 1740: The endpoint is a duplicate


18-10-2011

Error 1740: The endpoint is a duplicate

Problem: Error 1740: The endpoint is a duplicate. When i installed second AOS in server and tried to start the service. But it gives the above error.

Solved: It occurs when two AOS using the same port. I changed the port for one AOS then everything was fine.

Object Server 03: RPC error: The Dynamics Server could not be started because TCP Port 2752 is already in use.

You can use Netstat command to find out what are all the ports using. If you want to use the same port for two AOS’s then stop the other AOS then use the Active AOS. You only need to restart the AOS.

Monday, October 3, 2011

EDT Array Elements in Dynamics AX



 
03-10-2011

Array Elements (EDT) in Axapta


Usage: Array elements used to duplicate the table field 


Learned: I was assigned by a task to do some necessary changes in ProjTable that’s where i found out about array elements. Array elements used to duplicate table field to array of same field.
Look at the projtable – sortingid field in that field look the EDT below

                                               
                                                         
When you expand the field column in table you can only see one field but when you open the table you can see three fields in there. They are all come from the declared EDT.

Tuesday, September 27, 2011

Access multicompany data in dynamics AX

27-09-2011
How to get cross company data in Axapta
Usage: You can get multiple company data
Learned: I was assigned by a task to get data of another company to the current company. So i searched developer guide to get this done and i found out an inbuilt solution for this. One keyword (crosscompany) mentioned in msdn. How to use this keyword. Checkout the example.
·         Select crosscompany:<company name>  from <Table name>
<Company name> - data type - container, so you can give multiple company names
Any queries please comment or mail me

Monday, September 26, 2011

Custom Build notifications and popup in Axapta

Custom Build Notifications:
Usage: This method used to create custom build notifications and Popup in Dynamics AX
Learned: Today I was assigned by this task. The task was to give notification to every company and user (the company and user has been already selected in parameter form in AR) when I post payment journal in Accounts receivable module. So here I have two situations
1.       Purely hard code everything to create notification when I post journal in payment journal
2.       Otherwise cross code the default AX functionality in notifications (Alert rule).
I choose the second options it’s a far simpler than first one. Ok how did I do it? (If it has some mistakes and bugs. please comment on that) here follow the steps
·         Notifications are retrieved from the Event Inbox table.
·         We need to insert one perfect record in Event inbox then problem solved. System automatically retrieves and gives the notification from Event Inbox table.
·         Ok how to insert the perfect record
1.       I just created new table method in Event Inbox “InitfromPaymentJournal”. Here I had written the following code.

static void initFromPaymentJournal(DataAreaId Companyid,LedgerJournalId JournalId)
{
    EventInbox  EventInbox,inbox;
    SysUserInfo SysUserInfo;
    ;

    ttsBegin;
    while select SysUserInfo order by SysUserInfo.Id where SysUserInfo.Id!=""
    //while select maxof(inboxId) from inbox where
    {
        select maxof(inboxId) from inbox;
        EventInbox.InboxId                                        =   EventInbox::nextEventId();
        EventInbox.CompanyId                                =   Companyid;
        EventInbox.AlertTableId                              =   212;//2271;
        EventInbox.AlertCreatedDateTime         =   DateTimeUtil::utcNow();
        EventInbox.ParentTableId                           =   212;//2271;
        EventInbox.IsRead                                          =   NOYES::No;
        EventInbox.Subject                                        =   "Payment Journal Posting Created";
        EventInbox.AlertedFor                                 =   "Post created";
        EventInbox.UserId                                          =   SysUserInfo.Id;
        EventInbox.ShowPopup                               =   NOYES::Yes;
        EventInbox.Visible                                          =   NOYES::Yes;
        EventInbox.Message                                     =   strfmt("Paymentjournal Post created for %1",JournalId);
        EventInbox.insert();
    }

    ttsCommit;
}

2.       InboxId is the mail field in event inbox table. I used the default method in Event inbox table. You can check it out, I sent the company Id (the notification show in which company) and Journal id (Payment journal id) as arguments. Other things you can understand by go through it.
3.       That’s it now you can enjoy the custom notifications created through X++ code. If you can’t get the automatic notification popup you can just go through my previous post.
4.       But In notification form you can’t find the record by clicking Go to Origin button. If anybody know this please guide me. Thanks.

Friday, September 23, 2011

Create alert rules using Alerts and Batch processing in Axapta

Alert Rules:
Usage: Alert rules used to capture and notify record level changes. It can work with Batch server also
Learned:
·         Alert rule cant notify automatically there are some steps you need to done before you can enjoy this feature
·         Steps:
1.       Number sequence must setup  Basic->References->System Id (Number Sequence)
2.       Administrations -> Setup -> Batch groups set both the groups by name and assign the batch server. You must assign the batch server because the batch server is going to run your alerts automatically


3.       Basic -> Periodic -> Alerts -> set both the alerts into batch group that you already created
There are two alerts change based (change of fields) and due based (date intervals).