Method Community

Help!  

I have successfully customized our company's Estimate template with Report Designer.  However, I need to have the “item” field view/print only the "child" name/number and not the full "parent" name/number details.  Does anyone know how I could accomplish this in Report Designer?  Do I need to create a customized "field" in Report Designer, if so, how?  Is there something that I need to adjust in QB or Method so that it only views/prints the child information?

Example:

Item Field Prints - Two Parent Levels: Aerosol Products:Flow Measurement & Control:1104

Need it to Print -  Child Level Only: 1104

I appreciate any assistance provided.

Thanks,

Gloria

Hey Gloria,

You can't accomplish that using Calculated Fields; you would need to use Scripting.

Take a look at our Report Designer Help Center articles, specifically: Solution No. 416

Scroll down to: 'Calculated script for getting parent'

You would need to modify the code to get it working with LineItems/Retrieving Child.

-- Mortaza

Awesome!  Thanks for the guidance.  I will give it a shot.