Results 1 to 4 of 4

Thread: Creating custom subtotal in Transform designer

  1. #1
    New Member
    Join Date
    Dec 2018
    Location
    Philadelphia, PA
    Posts
    11

    Creating custom subtotal in Transform designer

    Good morning,
    We are very new to Transform development and can't figure out one issue. Our R42565 (invoice) can contain different line types (S, F, L for example). When PDF with these comes to Transform server, I want to generate my own subtotals based on line type and display it at the bottom. In Create form, we just created user global variables and have a simple IF statement executed for each detail section, checking details line type and adding extended amount to the appropriate global variable. Then each of these was displayed on the last page of each invoice (sales order sub total, freight sub total, discount sub total). How we can create similar logic in Transform 7.0 designer? Built in subtotals won't work. Thanks

  2. #2
    New Member
    Join Date
    Sep 2006
    Location
    Seattle, WA USA
    Posts
    44

    Creating custom subtotal in Transform designer

    Hi Anita,
    We do a very similar summation thing in Transform.
    Just read through the bag containing the R42565 PDF. We use the OSA/PDF RT Paser object to load the PDF into a bag.
    Then use Scan and Data Walker objects to read through the bag.
    For us, we use Number Parser object to convert the string containing the amount to sum in the bag.
    In the bag, the number is a Unicode string object as it may be blank.
    Once converted, just use Add object to accumulate into a Number object variable.
    E1 9.1 tools 9.2.2.5 IBMi v7r2
    Websphere 9.0.0.2

  3. #3
    New Member
    Join Date
    Dec 2018
    Location
    Philadelphia, PA
    Posts
    11
    Larry, thank you. I will try to make it happen. Thanks again.

  4. #4
    Senior Member Adrian_Chimirel's Avatar
    Join Date
    Nov 2000
    Location
    Toronto, Canada
    Posts
    2,163
    Hi Anita,
    First thing first welcome to the JDEList's Transform (former FormScape forum).
    I used to work with both Create!Form and FormScape some (long) time ago, and I am using Transform 7.1 now, an improved FormScape, not a newer Create!Form.
    I suggest you get some professional training, as I did a year or so ago, 'cause it really helped!
    Warm regards,
    Adrian,
    E1 9.1 TR 9.2.2.4 03-26-2018_03 MSQL 2016 x64, WebLogic 12c, all on WIntel 2016 x64
    3rd Party Software: All Out Security 3.2, TransForm 7.1, SAP Business Objects Enterprise XI 12
    In the Microsoft Azure Cloud!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.