AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Parameters for a re...
 
Notifications
Clear all

Questions Parameters for a report to print from Kit Assembly

 
Acumatica Report Designer
Last Post by JohnFothergill 3 years ago
1 Posts
1 Users
1 Reactions
1,173 Views
RSS
JohnFothergill
Posts: 10
 JohnFothergill
Topic starter
July 25, 2022 2:09 pm
(@johnfothergill)
Eminent Member
Joined: 5 years ago

I have a client that manufactures products and packages these in Cartons.  As they roll off the production line they are stacked onto a pallet.  When the pallet is full they generate a new lot from the kit assembly and then print a label to go onto the pallet.  They want to print each label as the pallet is wrapped rather than in bulk at the beginning or end of the production run so that they have the time that the label was printed.  There are three pallet wrapping stations so there could potentially be three orders being processed at the same time.

image

I have written the report to print the pallet labels using the Production Order number and Lot / Serial number as input parameters and it runs fine.  What I want now is to add logic to the parameters.

I already have the list of values populating correctly for the kit assembly using the following view name - =Report.GetFieldSchema('INKitRegister.RefNbr').  I would like to restrict this list to only Kit Assemblies that have a Balanced status as there will be several in the system for future orders that will be on hold and plenty that are Completed.  I  would also like the Default Value for the parameter to be the largest value that has a status of  Balanced - this I have not been able to achieve.  I have tried using the Max( ) function in the Default Value field but this gives me a runtime error.

The second parameter can either be the line number or the lot/serial number.  I can't get the list of values to default here at all - for the view name I have tried =Report.GetFieldSchema('INKitTranSplit.LotSerialNbr.RefNbr') , =Report.GetFieldSchema('INKitTranSplit.LotSerialNbr.RefNbr') , =Report.GetFieldSchema('INKitTranSplit.LineNbr.RefNbr').  I would like the list of values to be restricted to the RefNbr selected in the previous parameter and also default to the largest number in the selection.

 

Can anyone help me with the syntax for this?  Is it even possible?

Thanks in advance...   John


Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 52 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×