BeyondERP.Subscribe

Setup page · General ledger

Cash position parameters

The setup page for the public sector Cash position inquiry.

Used by
Accounting manager, Accounting supervisor
Business process
Analyze cash position in Dynamics 365 Finance
Menu item
PSNCashPositionColumnSetup
Main table
PSNCashPositionColumnSetup
Data entity
PSNCashPositionColumnSetupEntity
Setup steps
1 on this page
Show what matters for

Everyone

1What it is and why

What it isThe setup page for the public sector Cash position inquiry.
What you do hereUsed to customize the column names and the main accounts used to derive the amounts in each column of the inquiry.
ExampleLabel column eight Unencumbered balance, which is calculated as the ending balance minus encumbrances and pre-encumbrances.
Cash position parameters 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 processManage cash › Track cash position › Analyze cash position in Dynamics 365 Finance
Menu pathGeneral ledger › Ledger setup › Cash position parameters
Set up first—
Used next byCash position Microsoft Learn ↗
Related pages—

End user · Functional consultant

3How to do it

Step by step, with screenshots

Set up Cash position parameters1 screen

Used to customize the column names and the main accounts used to derive the amounts in each column of the inquiry.

  1. Screen 1

    Set the cash position opening balance account

    Go to General ledger > Ledger setup > Cash position parameters

    1. Under COLUMN ONE, check the column name
    2. Choose the opening balance main account
    3. Select Save
    1Opening balance main accounts110100
    Column nameBeginning balance
    Set the cash position opening balance account (zoomed on the outlined fields)
    Show the full screenSet the cash position opening balance account
    page title tab to open what to set or check

Microsoft's steps

  1. Go to General ledger > Ledger setup > Cash position parameters.
  2. In the Column one section, enter a column name, such as Beginning balance, and select the opening balance main accounts.
  3. In the Column two section, enter a name, such as Cash receipts, and select the debit and credit, debit-only and credit-only main accounts.
  4. Do the same for columns three and four, such as Cash disbursements and Interfund transfers.
  5. In the Column five section, enter a name for the calculated ending balance.
  6. In the Column six and Column seven sections, enter names and main accounts, such as for encumbrances and pre-encumbrances.
  7. In the Column eight section, enter a name for the calculated unencumbered balance.
  8. Select Save.

Source: Microsoft Learn ↗

Field guide

FieldWhat it meansWorked exampleTable column
Column nameThe heading shown for that column in the Cash position inquiry.Microsoft Learn ↗Beginning balanceColumnEightLabel
Opening balance main accountsThe accounts whose opening balance fills the first column.Microsoft Learn ↗110100ColumnOneRange
Debit and credit main accountsAccounts whose net debit and credit amounts are used for the column.Microsoft Learn ↗—ColumnSevenRange
Debit-only main accountsAccounts whose debit amounts only are used for the column.Microsoft Learn ↗—ColumnSevenDebitRange
Credit-only main accountsAccounts whose credit amounts only are used for the column.Microsoft Learn ↗—ColumnSevenCreditRange

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision · common mistake · test
Set up Cash position parameters——

Solution architect

5Design impact

Shared or per companyPer company: each legal entity has its own records. Microsoft data model ↗
Can it be undone—
Feature or country—
If you change it later—

Technical architect

6Technical

Menu itemPSNCashPositionColumnSetup Checked in Dynamics 365
FormPSNCashPositionSetup Checked in Dynamics 365
TablePSNCashPositionColumnSetupShown as “Cash position parameters” in Record infoKey field: KeyChecked in Dynamics 365
Data entitiesPSNCashPositionColumnSetupEntityCash position parameters Microsoft data model ↗
Who can open itPrivilegesMaintain accounts for cash position report PSNCashPositionSetupDutiesEnable general ledger process LedgerGeneralLedgerProcessEnable
2 security rolesAccounting manager LedgerAccountingManagerAccounting supervisor LedgerAccountingSupervisor
Checked in Dynamics 365
Actions on the pageOptions: Personalize, Page options, Edit, ShareChecked in Dynamics 365

Developer

7Developer

Open it directlyhttps://<your-environment>/?mi=PSNCashPositionColumnSetup
Integrate withPSNCashPositionColumnSetupEntity data entity Microsoft data model ↗
Table definitionPSNCashPositionColumnSetup columns and relations Microsoft data model ↗

Everyone

8Sources and checks