Create 2 GL lines

abhi1901
abhi1901 Member Posts: 102
edited 2013-09-02 in NAV/Navision Classic Client
Hi All,

If I have same item and everything same on Sales order then in that case I have one line GL entry.
Now I want to have two GL lines in that case too. and also if VAT is there then 2 lines for VAT also should be created in GL entry.

Can anyone help me regarding this.

Comments

  • Kishorm
    Kishorm Member Posts: 921
    edited 2013-09-02
    Add "Line No." To the "Invoice Posting Group" table and also add the field to the primary key. Then you need to set this value to the sales line "line no." either in codeunit 80 (older versions of NAV - I think it's in FillInvPostingBuffer) or in the PrepareSalesLine function in the "Invoice Posting Group" table (newer versions of NAV).

    EDIT: table is "Invoice Post. Buffer" (table 49)
  • abhi1901
    abhi1901 Member Posts: 102
    Kishorm wrote:
    Add "Line No." To the "Invoice Posting Group" table and also add the field to the primary key. Then you need to set this value to the sales line "line no." either in codeunit 80 (older versions of NAV - I think it's in FillInvPostingBuffer) or in the PrepareSalesLine function in the "Invoice Posting Group" table (newer versions of NAV).


    Thank you Kishrom but is there an other way without changing the primary key to the table.
  • abhi1901
    abhi1901 Member Posts: 102
    abhi1901 wrote:
    Kishorm wrote:
    Add "Line No." To the "Invoice Posting Group" table and also add the field to the primary key. Then you need to set this value to the sales line "line no." either in codeunit 80 (older versions of NAV - I think it's in FillInvPostingBuffer) or in the PrepareSalesLine function in the "Invoice Posting Group" table (newer versions of NAV).


    Thank you Kishrom but is there an other way without changing the primary key to the table.



    And one more thing I dont have "Invoice Posting Group" table in Db. So how can I do it now?
  • Kishorm
    Kishorm Member Posts: 921
    Sorry, table is "Invoice Post. Buffer" (table 49) - I didn't have NAV in front of me when I originally posted.

    Can't think of a way without changing the primary key. I have made a similar change in the past and it doesn't cause a problem.

Categories