G/L - Item Ledger Relation already exists. G/L Entry No.=0, Value Entry No.=1027

yeewoon

Hi. I am referring to NAV 2016. My customer facing a problem whereby when click Preview Posting button in Sales Invoice, error prompt: G/L - Item Ledger Relation already exists. G/L Entry No.=0, Value Entry No.=1027." I have checked the G/L - Item Ledger Relation table & Value Entry, the Entry No. does not exist. However, when I click Post button, no error prompt, the Invoice posted successfully.

I have no idea how is this error prompt, and where else should I check. Kindly advise. Thank you.

vnhack

In Codeunit 12 Gen. Jnl.-Post Line

//IF NOT GenJnlPostPreview.IsStarted THEN BEGIN
GLReg."To VAT Entry No." := NextVATEntryNo - 1;
IF GLReg."To Entry No." = 0 THEN BEGIN
GLReg."To Entry No." := GlobalGLEntry."Entry No.";
GLReg.INSERT;
END ELSE BEGIN
GLReg."To Entry No." := GlobalGLEntry."Entry No.";
GLReg.MODIFY;
END;
//END;

vnhack

In Codeunit 12 Gen. Jnl.-Post Line

//IF NOT GenJnlPostPreview.IsStarted THEN BEGIN
GLReg."To VAT Entry No." := NextVATEntryNo - 1;
IF GLReg."To Entry No." = 0 THEN BEGIN
GLReg."To Entry No." := GlobalGLEntry."Entry No.";
GLReg.INSERT;
END ELSE BEGIN
GLReg."To Entry No." := GlobalGLEntry."Entry No.";
GLReg.MODIFY;
END;
//END;

yeewoon

Hi vnhack,

Seems like it involves coding part to solve the issue. Is it considered as a standard bug?

serendipity

Hi, where do I need to put the codes as I do not see where to place the suggested codes in CU12

serendipity

could anyone please help as the client has this issue - I need to know where exactly in CU12 do I put the suggested code?

rajatech135

Hi Yee Woon, Escalate to technical.