• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Creating custom subtotal in Transform designer

anita_jag

Member
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
 
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.
 
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,
 
Top