Check Value in External Document inside General Journal if its existing in GL Entry (posted) or Not

Answers

• Options

  SanderDk Member Posts: 497

  2019-07-06 edited 2019-07-06

  What have you tryed so far? If you add your code + NAV/BC version, you can expend a lot better answer.

  For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  

  0
• Options

  Suhail Member Posts: 23

  2019-07-07

  i didn't try yet, im new in NAV and afraid to crash the system, all i know to put the condition code inside CodeUnit 12 in OnBeforePostGenJnlLine event

  0
• Options

  SanderDk Member Posts: 497

  2019-07-07 edited 2019-07-07 Answer ✓

  Hi @Suhail
  If can use OnBeforePostGenJnlLine then I can guess that you run a NAV 2016 or newer ?
  It is very important to specify your version, if you want a good answer. I cannot guess if it is C/AL or AL you are using.
  
  
  Do not be afraid to crash the system, your properly will do this more than one time, but you will learn from this
  
  Create a event subscriper from codeunit 12 OnBeforePostGenJnlLine .
  Declare a local record of G/L Entry.

  GLEntry.reset;
  GLEntry.SetRange("External Document No.",GenJournalLine."External Document No.");
  if not GLEntry.IsEmpty then
         Error('Your very own error message');
  

  For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.
  

  5
• Options

  Suhail Member Posts: 23

  2019-07-08

  Hi @SanderDk ,
  
  Thanks for reply
  im using NAV 2018 and appreciate your code i will check it and get back to you,
  
  Thanks to you

  0
• Options

  Suhail Member Posts: 23

  2019-07-08

  by the way i find event similar to the requirement "CheckPurchExtDocNo" in Codeunit 12 and simlar to your code.
  
  all i need to prevent the users to post an journal line with existing "External Document No." value in "G/L Entry".

  0
• Options

  Suhail Member Posts: 23

  2019-07-08

  @SanderDk
  
  Thanks your guidance was very helpful to me, i really appreciated

  0