Skip to content
+1-888-319-3663

COMMUNITY FORUM

next payment number

John asked 8 years ago
We are creating a payables trx map and are including credit card payments.  Where can we find the GP rolling column for next payment number that is used for the credit card payment?Thanks
Answers
Best Answer
Hanson answered 8 years ago
John,

There isn't an available GP procedure for us to create a rolling column off of. So you either have to use a custom rolling column in place of that to make your own number, or set up a sql script that grabs the next number from the table for you within the map and increments it for each record.

H
Jaliyaj replied 7 years ago

GP does have a next payment number stored procedure. For example,

DECLARE @RC int
DECLARE @I_vInc_Dec tinyint
DECLARE @O_iPMNPYNBR varchar(21)
DECLARE @O_iErrorState int
 
— TODO: Set parameter values here.
 
set @I_vInc_Dec =1
 
EXECUTE @RC = [taGetPMNextPaymentNumber] 
   @I_vInc_Dec
  ,@O_iPMNPYNBR OUTPUT
  ,@O_iErrorState OUTPUT
 
select @O_iPMNPYNBR as PMNextPaymentNumber

I had to script this out myself but I would much prefer SC do it for me

Can we add it as a feature request for the next release

Chris answered 7 years ago
Yes we can add it in as another option for the future, most likely will not be in the next release though as that will be coming out shortly. I believe in the next release they are adding field service, project, and bank rec rolling column/next number options – so they are actively adding in new ones.

H
Moreen replied 6 years ago

Did this ever get added to any of the versions?


If you would like to submit an answer or comment, please sign in to the eOne portal.