Hi,
I want to add a “Duplicate” tag to all the printouts of a report except the first one.
If this is the first printout.
all the other printouts of the same report should be like,
does anyone know how to do this in report designer?
Thank you,
Regards.
Best answer by DavidEichner
Depending on the report, you need to look and see if there is a Printed field or some kind of status field that would indicate it has already been printed once before. In looking at the Shipment record, there is no such field so you would need to customize the DAC with a field labeled something like Printed in a boolean datatype. Additionally, you would need to add code that changes the value of Printed custom field to True after printing occurs. Once that is in place, you would be able to use Report Designer to show the Duplicate image when that Printed field value is True.
+13Depending on the report, you need to look and see if there is a Printed field or some kind of status field that would indicate it has already been printed once before. In looking at the Shipment record, there is no such field so you would need to customize the DAC with a field labeled something like Printed in a boolean datatype. Additionally, you would need to add code that changes the value of Printed custom field to True after printing occurs. Once that is in place, you would be able to use Report Designer to show the Duplicate image when that Printed field value is True.
+1This article was created the same day as your inquiry. It may be additionally helpful
How to print a text or an image indicating an invoice is being reprinted | Community (acumatica.com)
+3
There is a field on the SOShipment called ConfirmationPrinted that we setup to be audited.
Then I used the information from this article to count the prints.
https://asiablog.acumatica.com/2019/02/how-to-count-number-of-prints-in-acumatica.html
I had to adjust the length in the joins to use the correct field length.
Then in the report designer, I did this as the field
=iif(Count ( [PrintRecords.BatchID]) >1 , ' REPRINT' , 'PRINT')
The field ConfirmationPrinted couldn’t be used as it is getting set just prior to the printing of the form.
This initially only works when printed from the Shipments or Process Shipments & not from the Printed forms, SO642000. The printed forms does not set the flag,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
