How to create line No ?

Answers

• Options

  Sai_123 Member Posts: 18

  2018-10-04

  If anyone Knows Kindly let me know!It would be Helpful

  0
• Options

  navuser1 Member Posts: 1,329

  2018-10-04

  Use Autosplitkey propertities in Page level

  Now or Never

  0
• Options

  Sai_123 Member Posts: 18

  2018-10-04

  Didn't work ! i used that properties..!

  0
• Options

  aceX Member Posts: 166

  2018-10-04

  In NAV, you can use Autosplitkey property for this purpose. But when you use that property the values are incremented for 1. This is practice mostly for ledger tables where Entry No. is the key. In your case if this is the Line table where Line No is one of the keys, you should use function or insert the code OnInsert trigger on your table:
  
  global var Record YourTable
  global var Integer LineNo
  
  
  function GetLineNo
  -return value Integer
  
  OnInsert
  GetLineNo(Rec);
  
  
  LOCAL GetLineNo:Return Integer
  IF YourTable.FINDLAST THEN
  LineNo := YourTable."Line No." + 10000
  ELSE
  LineNo := 10000;
  
  EXIT("Line No.");
  
  
  I hope this can help you. But before continue to develop in NAV, please read some books. Here it is one example:
  http://www.mergetool.com/Data/MGT/CalProgGuide.pdf

  0
• Options

  Slawek_Guzek Member Posts: 1,690

  2018-10-04

  @acex I think you've mistaken AutoIncrement with AutoSplitKey
  
  @sai_123 AutoSplitKey is the property to be used, but it only works when the integer field you want to be auto-numbered is a part of a primary key on a table, and only when the integer field is the last one in the PK definition. If this is not the case you need to add some code to handle this.
  

  Slawek Guzek
  Dynamics NAV, MS SQL Server, Wherescape RED;
  PRINCE2 Practitioner - License GR657010572SG
  GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

  1
• Options

  kriki Member, Moderator Posts: 9,096

  2018-10-05

  [Topic moved from 'Navision DOS' forum to 'NAV Three Tier' forum]
  
  

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  
  

  0