Sales/Purchase Document Postings To G/L

Jonathan2708
Jonathan2708 Member Posts: 552
edited 2012-02-03 in NAV/Navision Classic Client
Hi,

Out of the box NAV posts sales/purchase documents to the G/L by consolidating any G/L lines on the document that have the same G/L code and dimensions. This means that you lose the line detail in the G/L entries and are left with just one entry per G/L account and dimension, with a description of the invoice number. This makes analysing the account tiresome as you have to navigate to the sales/purchase document each time in order to see the details.

In all versions of NAV prior to 2009SP1 I have implemented mods to the following objects to change this behaviour so that the G/L postings represent the detail lines entered on the documents :
Table 49 : Invoice Post. Buffer
Codeunit 80 : Sales-Post
Codeunit 90 : Purch.-Post

However in 2009SP1 the G/L posting code in codeunits 80 and 90 has changed quite a lot and I now can't see where to make the changes to split the G/L postings. Has anybody else achieved this?

Any help appreciated,

Jonathan

Comments

  • AngelaMills
    AngelaMills Member Posts: 29
    I was wondering if you ever got an answer to your question. This is something we would like to do as well. Thank you.
  • jglathe
    jglathe Member Posts: 639
    Hi,

    yes, done this. It is in the same objects (you need to add CU5986..5988 for service on the list), different distribution of the changes. More of a problem is that the standard primary key is already pretty long... but there is also a solution for this.

    with best regards

    Jens
  • AngelaMills
    AngelaMills Member Posts: 29
    thank you Jens. I am a little confused.. your response doesn't seem to address the question of how to post Purchase Documents to the GL with the Purchase Invoice line descriptions. We do not use the service modules.. Do you have an example of the code that will update the GL description with the Purchase Invoice line description and not the header invoice number? Thanks again.
  • jglathe
    jglathe Member Posts: 639
    Hi,
    AngelaMills wrote:
    Do you have an example of the code that will update the GL description with the Purchase Invoice line description and not the header invoice number?

    I won't give source code, sorry. A solution for multiple fields (free choice) is part of an AddOn we're selling.

    It's a common requirement and easy to solve, I'm sure it has been discussed on mibuso/dynamicsuser.net before.

    with best regards

    Jens
  • AngelaMills
    AngelaMills Member Posts: 29
    Do you have a link to the addon?
  • jglathe
    jglathe Member Posts: 639
    Hi Angela,

    I've sent you a PM.

    with best regards

    Jens

Categories