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.
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.
@RManathungage94 , I accomplished this by using the Audi to track / count the number of times the Shipment confirmation was printed. 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,
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.