Automatic settlement in GL
I have implemented the automatic settlement feature for our customer IFRC (International Federation of Red Cross). We have setup recurrences with the Process automation feature in General Ledger, to settle "suspense accounts" that are debited and credited, hopefully with the same amount, by di...
Allocation rules should work on revaluation currency process
Foreign currency gain/loss accounting entries are posted to adjust the accounting and reporting currency amounts. These entries should be subject to allocation rules, despite their "currency value" field is 0.00 so that we have a more accurate distribution of the al...
Financial Tags - Escape Delimiter Character
When using custom lists or tag values that are not customer-controlled (invoices, vendor names, etc) it is not possible to escape the financial tag delimiter. This results in either the tag value not matching the source data, i.e. removal of delimiter manually, or the tag is split in the resul...
Automatic settlement on transaction where amount is split on multiple lines
Currently the Process automations for automatic ledger settlement only allows for transactions that match credit debit on lines 1: 1. If, for some reason, the total amount is split into multiple rows, that does not work.
It needs to work for matching on multiple lines if the t...
The ‘Lines’ column doesn’t automatically populate on journals posted via integrations
In General Ledger > Journal entries > General journals the column ‘Lines’ which is supposed to populate with the number of lines on the journal is blank for journals posted through integrations, you currently have to go into the journal and then back out for the Lines column to populate.
Add a Journal Creation Date and Time stamp
When reviewing ‘Not posted’ journals in General Ledger > Journal entries > General journals, it would be helpful to be able to add a column to show the Date and Time the journal was created.
I’ve experienced several scenarios where knowing the date and time a journal was creat...
Make the presentation of DR and CR values consistent across all Amount columns.
For example, when you run a Trial Balance and select a MainAccount closing balance to view the supporting transactions, there are inconsistencies in the presentation of DR and CR values.
‘Amount in transaction currency’ and ‘Amount in reporting currency’ present values right a...
Incorrect legal entity company name (DAT) issue in Ledger Calander database log
We have enabled the Database Log in UAT to monitor change tracking details of Ledger Calander change as per the customer's requirements. During our testing, we observed that while the Database Log is capturing the change details accurately, it is not reflecting the correct Legal Entity (DAT ca...
Export balance sheet in XBRL format
The possibility to extract financial statements, specifically a italian balance sheet in XBRL format, including reclassified IV EEC Directive.
This type of balance sheet could be setup and created in General ledger>Inquiries and reports>Financial reports , but now you ca...
How to set financial dimension values limited by the main account type?
According to our internal business, we want one of the FD show less FD value for a specific main account type, but whole FD values for other main account type, in the same legal entity, at the same time.
For example, we have 1 account structures, including 2 FD. The 2nd FD sho...