Dynamics AX Payment Journal Report - How to show invoice id?

Dear All,

I've been working on a requirement that my client asked me recently which is; they want to have "Invoice #" on "Payment Journal" report. At first, I searched how the DP (Data Provider) class filling the temp table "LedgerJournalTMP". I found that in temp table there is a field for invoice but that doesn't populate when report runs. So, I've to figure out how the system keeps track of the invoice that I associate via "Functions - Settlement".

After some research, it came to know my knowledge that there is a field "VendTransId" in "LedgerJournalTrans" that gets the "RecId" of "VendTrans" table when the journal is posted. Atleast I got something but how to show the "Invoice #" on report if the journal is not posted yet? And then I remember one of my colleague told me about "OffsetRecId". I searched the table "SpecTrans" and Voila!

I'll write in detail about "SpecTrans" in future post.

MS Dynamics AX 2012 - Reports deployment issue on windows 7 (UAC)

Hello, today I'm going to have to tell you that running MS Dynamics AX with SQL Reporting Services on windows 7 platform may put you in trouble when deploying reports to Report Server from Dynamics AX AOT or Visual Studio. If you come across the same issue this is how to figure it out.

Refer to the snapshot below, the error shows up from both environment Visual Studio and AOT;

The problem is windows 7 does not start "Remote Registry" services automatically. All you've to do is to start the "Remote Registry" services and you're done.

Try to deploy the reports and I hope that won't make any noise.

That's it for now. If you find any difficulty, feel free to contact Microsoft because I don't own this product :D.

Narrated Abu Huraira: Allah's Apostle said, "The deeds of anyone of you will not save you (from the (Hell) Fire)." They said, "Even you (will not be saved by your deeds), O Allah's Apostle?" He said, "No, even I (will not be saved) unless and until Allah bestows His Mercy on me. Therefore, do good deeds properly, sincerely and moderately, and worship Allah in the forenoon and in the afternoon and during a part of the night, and always adopt a middle, moderate, regular course whereby you will reach your target (Paradise)."

Microsoft Dynamics AX 2012/r2: Database Restoration

Today, I'm writing this blog just incase I need to know how to restore "Dynamics AX 2012" database from a different machine later. :D

Steps that need to be done prior restoring "MicrosoftDynamicsAX" database are:

• From table "SysServerConfig", take the values of "ServerID", "ServerGUID" and note it down somewhere

• From table "UserInfo", take the values of "Company", "SID", "NetworkDomain", "NetworkAlias"

After restoring the database "MicrosoftDynamicsAX" from different machine, you'll receive an error that says, "Enable to logon on Microsoft Dynamics AX 2012: Event ID:110"

Recommended Solution:

We need to configure Server / Client side settings on SQL Server – DynamicsAX tables. I’ll show you how to do that in simple steps

• In table "SysServerConfig" insert/update the values of [ServerID, ServerGUID] from the values we noted down earlier

• In table ‘UserInfo’ insert/update the values of [Company, SID, NetworkDomain, NetworkAlias ] from the values we noted down earlier

That's it for now. I'll be glad if it helps someone.

The Prophet Muhammad (peace be upon him) said: "Do you know who is most generous? ... God is the Most Generous, then I am most generous to humankind, and the most generous people after me will be those who will acquire knowledge and then disseminate it. (They) will come on the Day of Resurrection singly, like a ruler." Al-Tirmidhi, Hadith 93