• 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!

Sum Totals & Concatenate like #'s

pulsatk

Member
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
 

Attachments

KSwaeby

Reputable Poster
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.
 

pulsatk

Member
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



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