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!!!