I am using MS dynamics AX R3, I need to set limit in Bank balance.
For e.g. I have a bank account that have balance 5000 and need to set the limit 1000 on it. So user can only withdraw (through payment) 4000 and 1000 should remain in this account and if user want to withdraw the amount greater than 4000 like 4100 then system should give error or warning and not allow to do payment. Any one have any idea ?
There is a bank credit limit functionality available.
Please have a look at the following site, which describes details: docs.microsoft.com/.../usa-create-a-payment-journal-and-validate-the-credit-limit-for-a-bank
Would be great if you could go through this document and let us know if this fits your requirement and answers your question.
I performed a scenario on test machine details are below:
I have a bank account HBL and I have set Credit limit = -2,000.00
And this bank has balance 10,000.00
Now if I make payment against this bank account of amount 11000.00 and validate the payment system give OK message snap is below:
Now if make payment of amount 13000.00 then system give warning of credit limit.
This means I can make payment of 12000 (Bank balance = 10000.00 + Credit limit = 2000.00 = 12000) If try to make payment above of 12000 then system will give warning.
But I want a reverse scenario that if bank has balance 10000.00 and set the limit 2000.00 then system should allow to make payment of amount 8000.00 (Bank balance = 10000.00 – limit = 2000.00 = 8000) and if make payment above of amount 8000.00 then system should give warning.
Hope above detail give more understanding on my problem.
Good Morning Rahat Ali,
What you describe does not sound like a credit limit but a minimum balance that you want to keep on the account, right?
Have you tried adding a positive limit of +2000?
Not sure if this is going to work because I never had a similar requirement. Therefore, please test it.
If it does not work out of the box then you might have to consider making a system modification.
Business Applications communities