Question

Create formula to show number of labels out of qty

  • 9 May 2023
  • 1 reply
  • 59 views
F
Rank
Badge

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
Rank
Userlevel 4
Badge +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/

Jennifer Douglas, MBA, MIS

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved