Generate Document No In Gen Journal Lines 81

Answers

• Options

  ErictP Member Posts: 164

  2018-03-13

  In my case the Invoicenumber is transfered to the field "External Document No."
  In the next lines this field is checked.
  

    IF GenJnlBatch."No. Series" <> '' THEN BEGIN
      GenJnlLine.RESET;
      GenJnlLine.SETRANGE("Journal Template Name","Journal Template Name");
      GenJnlLine.SETRANGE("Journal Batch Name","Journal Batch Name");
      GenJnlLine.SETRANGE("External Document No.", "Invoice No.");
      IF NOT GenJnlLine.FINDFIRST THEN
        DocumentNo := NoSeriesMgt.GetNextNo(GenJnlBatch."No. Series", "Posting Date",FALSE);
      ELSE
        DocumentNo := GenJnlLine."Document No.";
  

  1
• Options

  jsshivalik Member Posts: 67

  2018-03-13 edited 2018-03-13

  Hi
  
  This code should be written under which Trigger. In the above code Document No will be Generated before Post. Can Vendor have same External Document No for more han 1 record.
  
  I am Uploading Data for Gen Journal Lines table 81.
  
  What is GenJnlBatch."No. Series"
  
  Thanks

  0
• Options

  ErictP Member Posts: 164

  2018-03-13

  Trigger is OnAfterImportRecord.
  If PurchSetup."Ext. Doc. No. Mandatory" = FALSE then the vendor can have multiple times the same "External Document No."
  
  In your case the GenJnlBatch."No. Series" is the same as "Posting No. Series":='JV';

  1
• Options

  jsshivalik Member Posts: 67

  2018-03-13 edited 2018-03-13

  Hi
  
  I have written like this . Is it ok It is generation Document no for each line
  
  "Journal Template Name":='GENERAL';
  "Journal Batch Name":='test';
  "Posting No. Series":='JV';
  "Line No.":=GetLineNumber;
  "Document No.":= NoSeriesMgt.GetNextNo("Posting No. Series", "Posting Date",FALSE);
  
  How does this works
  NoSeriesMgt.GetNextNo("Posting No. Series", "Posting Date",FALSE);
  
  Can u pls help according to my data . What changes i need to do in above code
  08.06.2017 Invoice 1 Vendor V000001
  08.06.2017 Invoice 2 Vendor V000001
  08.06.2017 Invoice 2 Vendor V000001
  08.06.2017 Invoice 3 Vendor V000002
  08.06.2017 Invoice 3 Vendor V000002
  08.06.2017 Invoice 4 Vendor V000003
  
  2,3 should have same Document No . In Dataport this field is Document No
  
  Thanks

  0