6

GL Line Item Age across Fiscal Year

The current Awareness between ledger settlement and year-end close enhancement does not provide a method to review the age of open (i.e. unsettled) GL postings once a roll-forward has taken place (with the exception of the Ledger Settlement screen). 


The new feature includes the ability to activate Keep detail during year-end close to provide line item level granularity for opening balances which "greatly improve[s] the ability to settle the unsettled ledger transactions in the next fiscal year".


However only the Ledger Settlement screen includes the "Original transaction date" field which indicates when the open item were originally posted and this form only allows selection of a single Main Account at once. The Trial Balance report allows user to check "Show unsettled transactions only" option in Transaction view, so it is possible to view open items only, but it is not possible to check the original posting date for opening balance transactions.


Fields for settlement

In addition to this the Awareness feature will only copy the following values from the original transactions: Ledger account (the main account and all financial dimensions), Amounts in the transaction, accounting, and reporting currencies, Description, Posting layer, Posting type. 


While the feature does "greatly improve the ability to settle the unsettled ledger transactions in the next fiscal year" the lack of all other values from the original transactions makes the process of performing ledger settlement more challenging. E.g. settlement via matching Document field.


Category: General Ledger
STATUS DETAILS
Needs Votes