- December 1, 2022
- Posted by: Priyanka Yadav
- Category: Blog
This Blogs will provide information about the Cash position inquiry and cash control feature.
The Cash Position inquiry allows you to determine the corresponding cash positions for financial dimension sets that contain self-balancing dimensions. The inquiry shows the beginning cash balance, and the effect of the addition of cash receipts, the subtraction of cash disbursements and the subtraction of interfund transfers to arrive at an ending balance. Then from the ending balance, general budget reservations, encumbrances or pre-encumbrances are subtracted to arrive at an unencumbered balance.
Pre-requisite : To enable this feature go to Workspace < Feature Management <All and search Cash Position inquiry. And then enable now.
Set up the Cash position inquiry
1. Go to General ledger > Ledger setup > Cash position parameters.
2. On the Cash position parameters page, in the Column one group, follow these steps:
In the Column name field, enter a label for the heading of the first column in the inquiry (for example, Beginning balance).
In the Opening balance main accounts field, select the accounts that you want to reference for inquiries about the opening balance.
2. In the Column two group, follow these steps:
Enter a label for the heading of the second column (for example, Cash receipts).
To use only the sum of all debit and credit transaction amounts for the data that is included in the inquiry, select the main accounts in the Debit and credit main accounts list.
The inquiry will add the net amount of the debit and credit accounts, plus the debit and credit amounts from the main accounts that are specified in the other fields in the group.
1. In the Column three and Column four groups, follow these steps:
Enter a label for the heading of the third column (for example, Cash disbursements) and the fourth column (for example, Interfund transfers).
For both columns, specify the main accounts to distribute debit and credit entries. Also specify the debit-only main accounts and credit-only main accounts.
2. In the Column five group, enter a label for the heading of the fifth column (for example, Ending balance).
A result is automatically calculated from the accounts that you specified in the first four columns. For this example, the calculation is Beginning balance + Cash receipts – Cash disbursements – Interfund transfers.
3. In the Column six and Column seven groups, follow these steps:
Enter a label for the heading of the sixth column (for example, General budget reservations or Encumbrances) and the seventh column (for example, Pre-encumbrances).
For both columns, specify account numbers for the debit and credit main accounts, and for the debit-only main accounts and credit-only main accounts.
4. In the Column eight group, enter a label for the heading of the eighth column (for example, Unencumbered balance).
A result is automatically calculated from the accounts that you specified in the fifth through seventh columns. For this example, the calculation is Ending balance – Encumbrances – Pre-encumbrances.
5. Select Save.
Run the Cash position inquiry
1. Go to General ledger > Inquiries and reports > Cash position.
2. In the Parameters section, follow these steps:
In the Date interval field, select the code for the date interval. Alternatively, in the From date and To date fields, define the date interval.
In the Financial dimension set field, select the financial dimension set.
Optional: Set the Suppress accounts with all zeroes option to Yes to exclude accounts from the inquiry if they have all 0 (zero) balances.
Optional: Set the Display segments in separate columns option to Yes to show the account names for each dimension as separate columns in the grid.
Optional: To filter the values for a specific dimension, in the fields below the Financial dimension set field, select the dimensions to include. The options that are available vary, depending on the financial dimension set that you selected.
3. Select Calculate balances to run the inquiry.
2. Cash Control Feature
This feature enables the ability to define a limit to prevent expenditures if no cash balance is available at the fund, sub fund, grant or project level.
The cash control limit is compared to the cash control balance (cash account balance minus all posted, unpaid Accounts payable invoices). When the cash control balance is less than the cash control limit, the limit is exceeded.
Set up cash control
Follow these steps to set up cash control and cash control accounts.
1. Go to General ledger > Ledger setup > General ledger parameters.
2. Go to General ledger > Ledger setup > Cash control configuration.
3. Set the Display account names option to Yes to show the account names for cash accounts and Accounts payable accounts that you enter in the grid.
4. Enter each cash account.
We recommend that you add all financial dimension strings for all valid cash accounts. You can then specify which cash accounts are subject to the cash control limit.
7. In the Cash account field, enter the cash account financial dimension string. You must enter complete account numbers.
8. Select the Participate check box to indicate that the cash account financial dimension string is subject to cash control. These cash accounts and the corresponding Accounts payable accounts are validated against the cash control configuration rules.
9. Optional: In the Accounts payable account field, enter the Accounts payable account financial dimension string that is used with vendor invoices. You must enter a complete account number.
10. In the Threshold field, enter the amount that must remain in the cash account to pass validation. You can enter a negative number if the cash account can be overdrawn (that is, the transaction amounts can exceed the account balance).
View accounts in cash control
You can review the current balance of the accounts that you defined on the Cash control configuration page.
Go to General ledger > Inquiries > Cash control inquiry.
The inquiry includes the following information:
• The current cash account balance
• The balance of all posted, unpaid Accounts payable invoices that are applied to the cash account’s corresponding Accounts payable account
• The cash control balance, or the current cash account balance minus all posted, unpaid Accounts payable invoices
• The cash control limit, so that you can compare it to the cash control balance and determine whether payment of the Accounts payable
invoices will cause the cash account balance to fall below the cash control limit
Resetting the workflow status for Journal:
This feature allows you to reset workflow for a journal. Once the workflow is reset on the journal, you will need to resubmit it.
Look out for future blogs on the additional features
Have other Microsoft Dynamics AX/NAV/GP/F&O/BC/HR/SCM inquiries or needs?
Visit our Contact Support page to see how our experts can help!
For more information, please contact
Brightpoint Infotech at firstname.lastname@example.org or
by calling our corporate office at
+1 (954) 536-2923