Ledger settlements enable user to create an overview of due amount on ledger accounts. This functionality is mainly used by accountants to prepare balance sheet specifications. However when accountants are trying to prepair annual reports, they can't request this information historically. AX will only provide an overview of which amount aren't settled. By adding the 'last settlement date' column, accountants are able to account for the balance position at eg. 31-12-2016.
The 'settlement date' value should be populated with the highest transdate value of the ledger transactions selected in the ledger settlement (last date of the ledger transactions with the same settlementId).
This column can be added to the LedgerTrans table and or LedgerTransSettlement table. I guess this depends on the way this functionality gets embedded elsewhere. Visualizing this column might be useful as, one or more older transactions slip in the ledger settlement. It makes it easier to spot errors and also clarifies the progression of the account.
It's a minor adjustment but provides great insight.
Comments
Hi Sil. We added a settlement date on the new advanced ledger settlement form in 8.1.1. Please take a look at that feature and see if it helps with this idea. You can enable it with the new Ledger settlement tab in the G/L parameters
Category: General Ledger
I had to implement this feature for a customer on AX 2009. Additionally to adding the field in table LedgerTransSettlement, I had to enhence the report LedgerDimensionTransStatement, so that the user may select the cutoff date until which settled transactions must not be shown. This was quite a challenge, but it is neccessary to make this functionality really useful. Such a functionality was needed by me in France, when I printed the ledger account statements for external Accountants. In that report, I also had to show the settlement number (which is present in the LedgerTransSettlement table.
Category: General Ledger
Administrator on 2/23/2022 5:42:38 PM
The Settlement date was added with the Advanced ledger settlement functionality, which is now standard (automatically enabled) as of build 10.0.21. In addition, the Unsettled transaction report will now use the Settlement date to determine whether the transactions were settled as of the To date of the report. The trial balance will also be updated to utilize the Settlement date when drilling down to the transaction details and choosing to view only the Unsettled transactions.