apdistrib diff's between 7.x and 9.x

Sort:
You are not authorized to post a reply.
Author
Messages
Dave
Basic Member
Posts: 13
Basic Member
    I have a request from our Finance department to make a change to APDISTRIB in LSF9 on a couple of fields.  Current values are creating problems in some of their AP reports and their GL190.   Wondering if anyone has received a similar request and how you handled it.

    They would like to create an external process to replace values reported in LSF9 to the values that used to be there in version 7.x.   The change was made in 8.x.

    1.  Description field.  replace the item-number which currently is written to that field with the Vendor/Vname.

    2.  Dst-Reference.  Replace the Voucher number currently written to this field with the Invoice Number.  Even though reference field is 10 and invoice can be 22 characters.

    They want the changes made in AP175 so this information will also transfer over to the GL to correct their GL290's, GL90's, etc.

    I've offered up a few alternatives but they are adamant on the change to the tables.  Any advice would be greatly appreciated.

    Thank you,

    Dave Robertson
    davroberts@edisonlearning.com
    ERP Manager
    EdisonLearning


    John Henley
    Senior Member
    Posts: 3348
    Senior Member
      Actually, the best place to do it is in Design Studio in AP20; AP175 just picks up what is in APINVOICE/APDISTRIB and passes it forward. The other advantage is that--by using Design Studio--you're not customizing a key Lawson-delivered program. What I have done for clients is this:
      function FORM_OnBeforeTransaction(fc)
      {
      if (fc == "C" || fc == "A" )
      {
      for (var nRow=0; nRow < 5; nRow++)
      {
      //stamp vendor name into distribution description
      lawForm.setDataValue("APD-DESCRIPTION",lawForm.getDataValue("VEN-VENDOR-VNAME"),nRow)
      }
      }
      return true;
      }
      Thanks for using the LawsonGuru.com forums!
      John
      Dave
      Basic Member
      Posts: 13
      Basic Member
        Thank you, that's a great idea!  One question?  Do you see any problems with replacing the delivered values? I don't want to replace the values and find out later I might have broken something in AP or GL.

        Thanks again,
        Dave
        John Henley
        Senior Member
        Posts: 3348
        Senior Member
          I'm assuming you have posting option = 'D' set up for the AP company on AP00.4 ?

          I have not heard of any issues with doing this; you can override either of these fields on AP20; what you're seeing is just the defaults that are entered programmatically if you don't enter anything.

          One other option to consider is that vendor number and invoice are passed over to GL via attributes if you have them set up on GL05 for source code AD.
          Thanks for using the LawsonGuru.com forums!
          John
          You are not authorized to post a reply.