Column definition ledger entry type calculations
Important
Important:
To eliminate the need to support multiple financial analysis solutions, Sparkrock plans to retire the Reporting and Analytics extension in 2025. Sparkrock will communicate more details regarding timing as soon as that information becomes available. Sparkrock recommends that you start using the Financial Analysis extension before 2025. For more information, see Financial Analysis.
On the Column Definition page, in Ledger Entry Type, you can specify the following values:
Commitments
Encumbrances
Encumbrance Entries
Note
Note:
Encumbrance entries are the encumbrances that are created on release of a purchase order and are reduced with the purchase order that is being invoiced.
The Amount Type for the Commitments, Encumbrances, and Encumbrance Entries ledger entry types is always Net Amount. The calculations that appear on financial reports and reporting and analytics reports are updated as described in the sections below based on the Ledger Entry Type that is specified.
Commitments ledger entry type calculation details
The following list includes details about the commitments calculation that appears on Financial Report and Reporting and Analytics Report pages when the Ledger Entry Type of Commitments is set up on the respective column definition:
Purchase request lines must have a Status of Pending Approval, Approved, or In Progress and have all the following conditions:
- The posting date must be within the Date Filter.
- The purchase Status must be blank.
- The document is not a template.
The amount that is used is the Line Amt. Incl. Tax Exp. (LCY).
When the line Type is Item, the Encumbrance G/L Account on the respective Item Card page is used.
Encumbrances ledger entry type calculation details
The following list includes details about the encumbrances calculation that appears on Financial Report and Reporting and Analytics Report pages when the Ledger Entry Type of Encumbrances is set up on the respective column definition:
The calculation uses the total of remaining amount, including the tax expense, from the purchase line where the Type is equal to Order, Invoice, or Credit Memo, for the combination of the general ledger account and dimensions when the value of the Commitment Date is within the Date Filter.
When the line Type is Item, the Encumbrance G/L Account on the respective Item Card page is used.
All column types are supported except for Balance at Date, Beginning Balance, and Subsidiary.
Encumbrance entries ledger entry type calculation details
The encumbrance entries calculation that can appear on the Financial Report and Reporting and Analytics Report pages when the Ledger Entry Type of Encumbrance Entries is set up on the respective column definition, uses the total of the line amount, including the tax expense, from the encumbrance entries for the combination of the general ledger account and dimensions on the encumbrance date.
All column types are supported except for Balance at Date, Beginning Balance, and Subsidiary.
See also
Prepare financial reporting with financial data and account categories
Reporting and analytics
Feedback
To send feedback about this page, select the following link: