Adding a Total field using JavaScript

Sort:
You are not authorized to post a reply.
Author
Messages
jojo.serquina
Veteran Member
Posts: 63
Veteran Member

    I don't have much experience with Design Studio and in need of help. I'm trying to add a field to display the grand total of a purchase order. On the available data src, there is no field for grand total, so I will have to add one using calculation of existing field values. I want the total to display, of course, after a successful inquiry.

    I would like to use the "Inquire" button to trigger the calculation - how do I go about doing it?

     

    jojo.serquina
    Veteran Member
    Posts: 63
    Veteran Member
      i could create a DME query based on the PO number entered by the user, but I don't know how to use it with Design Studio, either :-/
      Terry P
      Veteran Member
      Posts: 234
      Veteran Member
        What form are you wanting to do this on? PO20.1 or something else. The totals are on PO20.5 (when you click Total from PO20.1 it takes you there). You can look on that screen to see the table name, and then add it on PO20.5 if you want.
        jojo.serquina
        Veteran Member
        Posts: 63
        Veteran Member
          It's actually MA43, Terry.
          Terry P
          Veteran Member
          Posts: 234
          Veteran Member
            send me an email at pickering@4j.lane.edu - I have some code in ma43 that would do it for you I think.
            jojo.serquina
            Veteran Member
            Posts: 63
            Veteran Member
              email sent. we're on LSF 9, btw.
              You are not authorized to post a reply.