• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

AP 1-time Vendor numbering - 999000001 series

 3 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
RajR
Send Private Message
Posts: 5
6/29/2011 7:47 PM
Hello All,

Can anyone tell me whether is it possible to change the one-time Vendor number format from 999000001 to 990000001? I understand that Lawson stores the Last-One-Time Vendor# in APVENGROUP table?

Is the prefix 999 hardcoded somewhere in the code or database? I also understand that it looks at the Vendor Class to make a determination whether the vendor should be a one time vendor.

I understand that if we find a way to change the one time vendor number starting from 999000001 to 990000001, then we need to make sure that the Regular Vendor numbering sequence should not clash/overlap with the 1-time vendor#.

If anybody can shed some lights, that would be great. We are on 9.0.

Thanks,
Raj.
Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
7/4/2011 6:11 PM
Looks like it is hardcode in one of the libraries: /apsrc/appdliv/APVO80PD

IF (APVOWS-PERMANENT-VENDOR)
000180 COMPUTE APVOWS-VENDOR-NUM = VGP-LAST-VENDOR + 1
000190 PERFORM 1020-REPLACE-ZEROS-IN-VENDOR
000240 IF (APVOWS-VENDOR-ALPHA > APVOWS-LAST-REG-VENDOR)
000410 MOVE APVOWS-INIT-VENDOR TO APVOWS-VENDOR-ALPHA
END-IF
ELSE
000160 IF (VGP-LAST-ONE-VEN NOT = 999999999)
000170 MOVE VGP-LAST-ONE-VEN TO APVOWS-VENDOR-NUM
000180 ELSE
000190 MOVE 999000000 TO APVOWS-VENDOR-NUM
END-IF
000180 ADD 1 TO APVOWS-VENDOR-NUM
000190 PERFORM 1020-REPLACE-ZEROS-IN-VENDOR.
subba
New Member Send Private Message
Posts: 3
New Member
9/19/2011 5:54 PM
There is any way we can find how many one time vendor numbers are used or un-used count ?
Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
9/19/2011 11:10 PM
a SQL query like this ?

select count(*) from apvenmast where vendor like '999______'