Thursday, 23 April 2015

How to restrict main accounts for manual entry in Dynamics AX?

In this post, I am going to describe how to restrict accounts for manual entry in Dynamics AX.
Accounts can be restricted for manual entries but you cannot control account for automatic entries in Dynamics AX if those accounts are used.
I will show you how accounts can be used manually as well as automatically.
This functionality is useful for banking solutions where it is not preferable to use main accounts manually.

Manual entry scenario: 
I am using COM demo data set here.
Go to General ledger > Common > Main accounts
Select 11010 main account
















Click Edit or double click the selected record
Check mark Do not allow manual entry checkbox















Now, i am going to post General journal from General ledger module using the same account 11010 on which i checked mark the do not allow manual entry checkbox


















You can see on the above screenshot that 11010 main account is not allowed for manual entry. However, 11010 can be used for automatic entries where the checkbox do not allow manual entry is checked or not, it doesn't effect automatic entries.

Automatic entry scenario:
I am using main account 11010 as cash bank account "Treas Bank".
"Treas Bank" is a bank account that contains account 11010.















Now, i am going to post General journal using the offset account type "Bank" and offset account "Treas Bank" that contains account 11010.

















You can see on the above screenshot that General journal is posted successfully and the voucher is created as a result of posted General journal.
Voucher is showing below entries 
999-45999-120-101             -100 (Credit amount) [Originating entry]
999-11010                           100 (Debit amount)  [Offset account entry of Bank account                                                                                  "Treas Bank"]

As you can see that 11010 account is checked mark on Do not allow manual entry checkbox but there is entry generated against this account as shown above because it is generated automatically by the system. I didn't enter the manual entry account here.

For any issues or concerns, you can contact me on my below email addresses uzi_sag@hotmail.com, uzairshah50@yahoo.com

Happy Daxing!

2 comments:

  1. thanks for the nice info.. also visit http://skillquotient.net for info

    ReplyDelete
  2. Your blog is excellent and detailed. Thanks for sharing this information. You can keep in touch with them via an Accounts Payable toll-free number +44 20 3627 1872. To have more support,you can visit our site:- Accounts Payable 

    ReplyDelete