Skip to main content
Question

Printing record numbers on the basis of splitting condition in a report


Forum|alt.badge.img

Hello Community,
i have been trying to get the results on the basis of the following scenario:
I have an SO with Item 1A, Item 2A, Item 3A,  Item 4A (all of these of 200 in qty each) under Item Class A and Item 1B, Item 2B, Item 3B, Item 4B (all of these of 40 qty each) under Item Class B.
I have the requirement to print 1 label per every 200 qty for the items of class A & print 1 label for every 20 qty of items of class B.
So the label shall display as: 1 of 4, 2 of 4,...4 of 4 for Items under Class A and 1 of 8, 2 of 8,...8 of 8 for items of class B.
I have been able to display by putting the below conditions in the report designer:
 

 And have put up the grouping condition for Item Class.

But not able to display the requirement as highlighted in the below screenshot:
 


 


How can I put up the condition to display the above requirement

4 replies

Forum|alt.badge.img
  • Author
  • Varsity I
  • 24 replies
  • December 6, 2023

Hello Community,
Any suggestions? Even if we can satisfy any one condition that would help me out to display the required results.
Thanks in advance.


Forum|alt.badge.img
  • Author
  • Varsity I
  • 24 replies
  • December 6, 2023

Tried to apply the following condition:
 

Where variable is set as:
 

 


Forum|alt.badge.img
  • Author
  • Varsity I
  • 24 replies
  • December 7, 2023

And this is what the label displays when applying the above mentioned logic: 

 

1 of 8 for all the 8 labels


 

4 of 4 for the remaining 4 labels

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2810 replies
  • January 9, 2024

Hi @harshita53 were you able to find a solution? Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings