Prev
Next
Forums User Experience Lawson Design Studio

MA43.1 Design Studio Form to update APDistrib

 3 Replies
 0 Subscribed to this topic
 12 Subscribed to this forum
Sort:
Author
Messages
Kate Liamero
Veteran Member
Posts: 70
Veteran Member
12/2/2008 4:03 PM
    I am trying to update the apdistrib table from MA43.1 form. These are the fields I am trying to update.
    1. apd.description(30)  =  vendor# and however many characters from ven-vendor-name that will fit.
    2. apd.dst-reference(10)  = first 10 characters of the invoice field.

    I don't even see apdistrib referenced in the form.  The reason we need to update apdistrib is so that when the transaction goes over to GLTRANS the fields glt-reference will contain the first 10 characters of the invoice rather than the voucher#  and so glt-description will contain the vend# and part of the vendor name rather than the item#. Voucher # and Item# have no value for us.

    Is this possible to do in design studio?


    Thanks

    Kate

    aladjimi
    Advanced Member
    Posts: 18
    Advanced Member
    12/2/2008 5:13 PM
      I ran into the same issue with a differnt form, I ended up having to build a dummy form referencing the fields which I wanted to update.
      John Henley
      Posts: 3353
      12/2/2008 6:39 PM
        The code that stamps that is buried in a library that gets compiled into MA43. AP20 has the APD description stored in a hidden field, so you can use Design Studio to change it. However, that's not the case with MA43. What you can do is create a user exit for MA43 that fires every time an invoice is updated and have it stamp the desired APD fields.
        Thanks for using the LawsonGuru.com forums!
        John
        Kate Liamero
        Veteran Member
        Posts: 70
        Veteran Member
        12/2/2008 7:12 PM
          Thanks John. That's what I thought looking at the MA43.1 in Design Studio. I figured if anyone knew a workaround it would be you.

          Thanks

          Kate