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

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.

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).