Share
ReportHi,
Is there a way we can control only authorised personnel to print sales invoice, when the sales invoice times printed is more than 1?
Thank you.
*This post is locked for comments
You’re offline. This is a read only version of the page.
Hi,
Is there a way we can control only authorised personnel to print sales invoice, when the sales invoice times printed is more than 1?
Thank you.
*This post is locked for comments
I have uploaded the package (Reprint.Package) at www.box.net/.../r1oltu1y0j
This VBA code will
1. Get the number times invoice already printed
2. Prompt user for the password, if invoice was already printed
a. If correct password is entered, invoice is printed successfully
b. If incorrect password is entered, invoice printing is canceled and a message is displayed
3. In case of batch printing from Print Sales Documents window and Sales Batch Entry window, user is prompted for password when he tries to check on “Reprint Previously Printed/Sent”
a. If correct password is entered, user is allowed to check on the checkbox
b. If incorrect password is entered, checkbox is disabled
The password is hard coded in the vba code
Rubal,
Hi, this reprint previously printed check box is not applicable when user printing the invoice from sales order transaction entry window > Sales Document Print Option.
we need to control and disallow user from printing the invoice from sales document print option as well.
thank you.
Field level security can be applied to the Reprint Previously Printed check box requiring a password to mark this field.
Hi, i am not possible to show the input box during report generation. could you please explain or provide some sample?
thank you.
Pui,
You can write vba code on BeforeUserChanged of the Print button. You can execute the SQL query to get the number of times print. To cancel the print command use
CancelLogic = True
You can refer to following post to get code related to using the ActiveX in VBA
blogs.msdn.com/.../using-ado-with-vba-with-report-writer.aspx
Rubal,
Hi Rubal,
may i know what is the command to be used to end/cancel the print operation in report writter when the user is not entering the correct password?
thank you.
Pui,
I don’t think this functionality is available out of box. However, you can easily do it using small customization.
You can use the following query to get the number time invoice is already printed
Select TIMESPRT from SOP10100 where SOPNUMBE='XXXXXX'
You can build a customization to check if invoice is already printed. You can cancel the print operation or prompt for a password, if it was already printed.
Rubal,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (