AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Parameters for a re...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Parameters for a report to print from Kit Assembly

Acumatica Report Designer
Last Post by JohnFothergill 7 months ago
1 Posts
1 Users
1 Likes
260 Views
RSS
JohnFothergill
Posts: 10
 JohnFothergill
Topic starter
July 25, 2022 2:09 pm
(@johnfothergill)
Member
Joined: 2 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
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 6 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×