Skip to main content
Question

Create formula to show number of labels out of qty

  • May 9, 2023
  • 1 reply
  • 88 views

Forum|alt.badge.img

I have a report for labels on receipt. The client will receive an amount of products and then print labels for the items. Lets say the client receives 7 items. On the label they want to print 7 labels (which works as it is dependent on the qty received). I am using this formula now =[POReceiptLine.ReceiptQty]+' '+[POReceiptLine.UOM].

 

On the label it is displayed as 7 pallets in this instance and there are 7 labels

 

this formula creates 7 labels to be printed, but the client wants the labels to display as 1/7.00 pallets 2/7.00 pallets, 3/7.00 pallets etc for each of the 7 labels.

 

Does anyone have any idea what would the right formula be to be able to do that?

 

Thank you in advance

1 reply

Jennifer Douglas
Varsity I
Forum|alt.badge.img+1

There is a wonderful ‘Tips and Tricks’ article on linkedin that covers something similar to this written by Laura Jaffee a couple of years ago.  

 

https://www.linkedin.com/pulse/acumatica-tips-tricks-how-print-multiple-product-labels-laura-jaffe/


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