Create 2 GL lines

abhi1901

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.

Kishorm

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

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 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

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.