SSRS Report: Arabic Numbers and Hijri Date

Hi,
Please find some SSRS Reports properties where showing how to set a number field to Arabic numbers.

Select a number field and the Localization properties.
See the above image to set it.
To Show a Gregorian date in Hijri Date, please set the Localization property as below.

Thanking you 
Have a Nice Day!!!
Regards,
Mr. 221

SQL Server: Check online users of a database and kill the current sessions.

Scenario: Sometime restore/detach database you will get a message that the database cannot use exclusively because currently there are some users who using the database.

Find all the current users of your SQL Server.

SELECT login_name, COUNT(session_id) AS [session_count] 
FROM  sys.dm_exec_sessions
GROUP BY login_name
ORDER BY login_name


Then kill the current sessions.


USE master;
GO
ALTER DATABASE <your db Name>
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
ALTER DATABASE <your db Name>
SET MULTI_USER;

GO

Then try to continue your work as usual.



Have a nice day!!!

Mr. 221

AX 2012 R3 Error Message: Cannot create a record in Balance (CustVendTempOpenTrans). Amount 0,00. The Record already exists.

Problem:
Please see the message as given below:

This issue comes when you try to settle a customer/vendor.Reason:

One record (may be payment/Invoice) already marked for settlement.
how to find it.

Solution: 


Try to override this error and find the record which is marked for settlement.

Step. 1:

AOT > Classes > CustVendOpenTransBalancesManager

Method Name: add

Make all comment and add new lines. see as following:

then find the marked transaction. It is happening because of error in updation of transaction.

Step.2:

Now go to

AOT > Tables > SpecTrans

Find the the record there.

Delete it and you can continue.

This issue will not come later.



Wish you all the best.

Have a nice day!!!

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

The above subject is an error message from AX 2012 R3, commonly happening here, even you once solve it again this message will welcome you.
See the message as blow.
Problem:

 Solution:
 Go to xxx/Organization administration/Common/Number sequences/Number sequences (here XXX is your legal Entity name).

find your Number sequence for General journal transfer. 
See below in my case:

 Open this number sequence and edit. Locate Continuous check mark.

 

And  untick this continuous option and then try to post your Journal.
After once posted, you can com here and tick this option same like before which will not affect you for further postings.

Thank you

Have a nice day!!!

Mr. 221 

Dynamics Ax 2012 Reports

Deploy the default reports [AX 2012]

  1. Ensure the link http://<Server Name>/Reports  working fine.

2. Open the link and verify the folder existence

3. Open Dynamics AX 2012 > System administration > Setup > Business Intelligence > Reporting Services.

4. 

 5. After saving this configuration Press "Ctrl + D"

6. locate any report from AOT>SSRS Reports> Reports
Select any Report
Right Click the Deploy the report.
if you get the messafe is okay then try the following.
 
To deploy all reports, enter the following command:

1. Run as Administrator "Microsoft Dynamics AX 2012 Management Shell"

2. Publish-AXReport –ReportName *