Skip to main content
Solved

How to get the number of Printouts of a Report

  • December 30, 2022
  • 4 replies
  • 194 views

Forum|alt.badge.img

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.

View original
Did this topic help you find an answer to your question?

4 replies

DavidEichner
Captain II
Forum|alt.badge.img+13
  • Captain II
  • 372 replies
  • Answer
  • December 30, 2022

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.


Forum|alt.badge.img

Hi @DavidEichner,

Thank you for the guidance. I will try that way.

thanks again,

regards.


brendan91
Semi-Pro III
Forum|alt.badge.img+1
  • Semi-Pro III
  • 92 replies
  • January 3, 2023

@RManathungage94

This 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)


wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 98 replies
  • January 3, 2023

@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,  


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