Jump to content

Find line items, qty and totals summary


This topic is 2493 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a found set of invoice records using a search for line items matching "paper widgets". Each record has multiple line items but only one line with "paper widgets". "Paper widgets" may have varying quantities on each record. I want to get a summary count of "paper widgets" or the sum total $ across the found set. What script steps could do this? Thanks.

Link to comment
Share on other sites

9 hours ago, cos said:

What script steps could do this?

You posted this in calculations, yet you ask about script steps. To script this, you could start by doing:

Go to Related Record [ From table: “LineItems”; Show only related records; Match found set; New window ] 

Next, constrain the found set in LineItems to "paper widgets" only and get the summary value from a summary field defined in the LineItems table.

Finally, close the current window to return to your original found set in Invoices.

 

This could probably be simpler if the initial search were performed in the Lineitems table to begin with.

 

 

Edited by comment
  • Like 1
Link to comment
Share on other sites

This topic is 2493 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.