Results 1 to 3 of 3

Thread: Sum Totals & Concatenate like #'s

  1. #1

    Sum Totals & Concatenate like #'s

    Hi,
    I'm wondering if anyone has had the opportunity to do the following:

    We have a section that stores lot # and quantity for shipped goods.

    The lot # could differ for each line, or could be the same. As the user scans the product a record is created in a JDE table. Each record is unique, even if the lot # is the same.

    I'm looking for (2) things:

    Where lot # is the same within line #, display only 1 time. Additionally, sum a quantity from multiple sections and display as single section.


    I've attached a scenario.

    Thanks in advance
    Teri
    Attached Files Attached Files

  2. #2
    Member
    Join Date
    Feb 2005
    Location
    California, USA
    Posts
    281
    You should be able to do what you want using UserVariables or Tables functions. I'm thinking you might need to sort the detail lines by Lot# so all lines with the same lot# are together.

    It would probably be easiest using a Table because you could use the Sum function to get the total Qty for each Lot#


    Karen.

  3. #3

    Sum Totals & Concatenate like #'s

    Hi Karen,

    I did try User Variables multiple ways but was not successful.
    I am not familiar with using a Table, but will see if I can dig up some how to's and go from there.

    Thanks for pointing in a direction!

    Teri



    Quote Originally Posted by KSwaeby View Post
    You should be able to do what you want using UserVariables or Tables functions. I'm thinking you might need to sort the detail lines by Lot# so all lines with the same lot# are together.

    It would probably be easiest using a Table because you could use the Sum function to get the total Qty for each Lot#


    Karen.

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.