BeyondERP.Subscribe

Inquiry page · General ledger

Cash position

A public sector inquiry that determines cash positions for financial dimension sets that contain self-balancing dimensions.

Used by
Accountant, Accounting manager, Accounting supervisor and 12 more roles
Business process
—
Menu item
PSNCashPositionInquiry
Main table
PSNTmpCashPositionSummary
Data entity
—
Setup steps
—
Show what matters for

Everyone

1What it is and why

What it isA public sector inquiry that determines cash positions for financial dimension sets that contain self-balancing dimensions.
What you do hereUsed to show the beginning cash balance, receipts, disbursements, and interfund transfers that lead to an ending balance, and then subtract budget reservations, encumbrances, or pre-encumbrances to get an unencumbered balance.
ExampleRun the inquiry for a date interval and a financial dimension set, and suppress accounts that have all zero balances.
Cash position page in Dynamics 365
The page in a working Dynamics 365 system. page title tab to open what to set or check

Functional consultant · Solution architect

2Where it fits

Business process—
Menu pathGeneral ledger › Inquiries and reports › Cash position
Set up firstCash position parameters Microsoft Learn ↗
Used next by—
Related pages—

End user · Functional consultant

3How to do it

Microsoft's steps

  1. Go to General ledger > Inquiries and reports > Cash position.
  2. In the Date interval field, select a code, or enter a From date and To date.
  3. In the Financial dimension set field, select the dimension set.
  4. Optionally, set Suppress accounts with all zeroes to Yes.
  5. Optionally, set Display segments in separate columns to Yes.
  6. Select Calculate balances.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Financial dimension setThe dimension set the cash positions are calculated for.Microsoft Learn ↗——
Suppress accounts with all zeroesLeaves out accounts whose balances are all zero.Microsoft Learn ↗——
Display segments in separate columnsShows each dimension in its own column.Microsoft Learn ↗——

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
— No setup is made on this page.

Solution architect

5Design impact

Shared or per company—
Can it be undone—
Feature or country—
If you change it later—

Technical architect

6Technical

Menu itemPSNCashPositionInquiry Checked in Dynamics 365
FormPSNCashPositionInquiry Checked in Dynamics 365
TablePSNTmpCashPositionSummaryShown as “The summary balance temporary table” in Record infoChecked in Dynamics 365
Data entities—
Who can open itPrivilegesCash Position Inquiry PSNCashPositionGenerateDutiesInquire into journals and transaction status LedgerJournalsTransactionStatusInquire
15 security rolesAuditor AuditPolicyManagerBudget manager BudgetBudgetManagerChief executive officer CompanyChiefExecutiveOfficerChief financial officer CompanyChiefFinancialOfficerAccounts receivable clerk CustInvoiceAccountsReceivableClerkAccounts receivable manager CustInvoiceAccountsReceivableManagerTax accountant FBTaxAccountant_BRInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccountant LedgerAccountantAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisorFinancial controller LedgerFinancialControllerAccounts payable clerk VendInvoiceAccountsPayableClerkAccounts payable manager VendInvoiceAccountsPayableManager
Checked in Dynamics 365
Actions on the page—

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=PSNCashPositionInquiry
Integrate with—
Table definition—

Everyone

8Sources and checks