AP 1-time Vendor numbering - 999000001 series

 3 Replies
 0 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
RajR
Posts: 5
    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
    Posts: 476
    Veteran Member
      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
      Posts: 3
      New Member
        There is any way we can find how many one time vendor numbers are used or un-used count ?
        Ragu Raghavan
        Veteran Member
        Posts: 476
        Veteran Member
          a SQL query like this ?

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