Auto Increment a Number in PeopleSoft

Ask Question

Help Others

Mon, 12/10/2007 - 1:43am — Lepa

Use the GetNextNumber function to increment the value in a record for the field you specify by one.

Syntax:
GetNextNumber ({record.field | record_name, field_name}, max_number)

Best place to add such code is in SavePostChange event.

Example:
My_Field = GetNextNumber(My_Record.My_Field, 99999999);

Bookmark/Search this post with

Lepa's blog

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!

Comments

Have a question? Please ask it on the forum instead.

Wed, 03/12/2008 - 9:34am

hari (not verified)

Hi Nice

Hi
Nice

Mon, 06/30/2008 - 5:41am

Nitin (not verified)

Re: Auto Increment a Number in PeopleSoft

There ia another function GetNextNumberWithCommits.
This created a new connection .. fetch the number,.. updated with new and commits.

One of them is having an Issue on OS390.

Mon, 06/30/2008 - 8:39am

Lepa

Offline

Joined: 06/23/2008

Posts: 565

Re: Auto Increment a Number in PeopleSoft

Nitin, your talking about GetNextNumberWithGapsCommit, right? I think you just forgot the word "Gaps". But yes I agree with you, GetNextNumberWithGapsCommit has more flexibility and provides better performance. Thanks for your tip!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Tue, 01/27/2009 - 3:24am

Mayank (not verified)

Re: Auto Increment a Number in PeopleSoft

Nitin / Lepa i do agree with both of you..and want to update 1 more thing which is --
The GetNextNumberWithGaps function is very restrictive in its usage. The GetNextNumberWithGapsCommit function can be used in any event.

Tue, 05/17/2011 - 9:16am

david wong (not verified)

Re: Auto Increment a Number in PeopleSoft

do you place the code on the record or on the page?

Wed, 05/18/2011 - 10:57pm

Lepa

Offline

Joined: 06/23/2008

Posts: 565

Re: Auto Increment a Number in PeopleSoft

I would put that code on the component level if you code under savepostchange event.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Allowed HTML tags: <div> <pre> <br> <code> <a> <em> <blockquote> <strong> <ul> <ol> <li> <dl> <dt> <b> <p> <h1> <h2> <u> <img>
Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.
You can enable syntax highlighting of source code with the following tags: <code>. The supported tag styles are: <foo>, [foo].

BBcode

You can use BBCode tags in the text.
Lines and paragraphs break automatically.
Web page addresses and e-mail addresses turn into links automatically.

More information about formatting options

Notify me when new comments are posted

CAPTCHA

The question below is to prevent automated spam submissions.

What code is in the image?: *

Enter the characters shown in the image.

Unanswered Forum Posts

Title	Under	Posted on
MD5 - SHA checksum of a file.	PeopleSoft Technical	02/07/2012 - 5:29am
nVision Tabular Report through PIA with prompts	PeopleSoft Technical	02/02/2012 - 10:07pm
Can we create an AE to mass update Position - Jobcode data?	PeopleSoft Technical	01/18/2012 - 3:11am
Pay Components on job data can be defaulted and setup based on the rules?	PeopleSoft Functional	01/05/2012 - 4:58am

Main Menu

User login

Quick links

Sponsored links

Recent blog posts

Who's new