Unique reference number in General Ledger Transactions report

Hi @lubos

here I am again to request to have a new column with a unique code in the “general ledger transactions report” that identifies all the transactions related to the same entry. In Italy is required by law and I cannot find a way to do this with the current instruments.


Can you provide an example of what you mean? In Manager, each transaction is a unique, standalone record, even when they follow earlier transactions like a receipt follows an invoice.

Transactions are not chains.

Yes, and each transaction has a unique code that identifies all the items within that record.

Essentially, an audit trail numbering, or a General Ledger by Transaction report instead of a General Ledger by Account report.

For example… if I register an invoice I have two or more ledger transaction (a cost in the profit & loss Vs a debt in the balance sheet). If I look at them in the general ledger report they are listed by date inside the two ledgers with many others of them. If I identify these transactions with a unique key (the db Key) i can match them searching this key in the report.

Having the possibility to link them easily in the report is a requirement of the Italian law.

So essentially, @Davide, you are suggesting a code that would identify and link the debit(s) and credit(s) associated with an entry. This would be the equivalent of looking up a single line in the journal book of a hand-written, double-entry accounting system, before the transaction’s debit(s) and credit(s) have been transcribed to individual account ledgers. I understand what you are suggesting now.

Yes. But also for payments, journal entries and so on. Every group of transactions (ie inserted under the same form) should have its ID. By doing so it would be very easy to reconstruct a journal book by sorting by date firstly and by ID secondly

I was thinking the same thing when I posted earlier this day about having account codes on the General ledger transactions report.

At the moment the sorting of the transactions by account makes things complicated if you try to find which transactions happened at what time.

1 Like

@Tut @lubos do you think it can become an “idea”?

1 Like