GL Journal related to documents

Description

There is a potential improvement if we add link on GL Journal to any document.

This can be achieved adding the columns GL_Journal.AD_Table_ID and GL_Journal.Record_ID

To use this feature we can:

  • Add a button on the toolbar similar to how the requests button behaves but related to GL Journal

    • allows to create a GL Journal related to the record on screen

    • show pressed if there are related GL Journals

    • show the number of journals and navigate to them

  • On the accounting viewer we can add a flag to show the related notes when showing posting for a document

WDYT?

Environment

None

Activity

Show:

Andres Lopez Andrade August 22, 2020 at 8:05 PM

Triaged by arlopeza

I think it’s a great idea, the case exposed by Carlos usually is exposed on some clients and is difficult to trace it if the Accountant re-classify accounts and forgot to enter the original doc.

Thomas Bayen September 3, 2014 at 11:29 PM

Yes, I think this idea is great. It gives an easy way to extend the accounting rules "manually" for special and seldom used cases without having to create an new "Doc_*" implementation in Java. To add these postings to the viewer is a very good idea.

I think when you implemented that it would be easy to use it also to connect an GL Journal also to non-Document records. That was what my comment proposed. Please keep that (as an later option if not directly implemented) in mind when implementing it.

Carlos Ruiz September 3, 2014 at 10:17 PM

Use case is like this:

My accountant sometimes re-classify some postings from an invoice.

This can be done in a permanent basis using GL-Distribution, for example changing one account by another, or distributing percentages.

But, when the change is related just to one specific invoice, my accountant just create a GL Journal moving the old account to the new account. The problem is that I don't have traceability about those journals-related-to-a-document. The accountant add the invoice number on the description but that's not enough, with the proposed button I would like to make it clear that the posting of a document was modified using a GL Journal - and even better if the accounting viewer shows the posting of the document and additionally (optionally) could show the posting of the related journals.

WDYT?

Thomas Bayen August 16, 2014 at 7:57 AM

I am not sure about the usecase in your mind. The usecases I have in my mind belong to the fact that one can not easy create accounting facts with self-made tables. So you could add accounting to your own database objects.

My proposal is to think about not restricting this to documents but to any database object. I am not sure if this is possible as easy. But we may think about it.

Details

Assignee

Reporter

Priority

Created August 14, 2014 at 2:46 PM
Updated August 22, 2020 at 8:05 PM