Dynamics Community Forum Thread Details

Custom Invoice Packing List will only print for Poweruser

I recently updated my client from GP Dynamics 18.2 to 18.5. They have used a customized Packing Slip for several years. Since the update only POWERUSER can print it, everyone else gets a 'not privileged' error. I have tried everything I can think of. I have followed the steps in the 'Reprint Check Remittance not privileged to run this report in 2018' to no avail. If I use the first call to Dynamics 10000 it comes back with a code 20050 and I get no data at all, on any of the scripts. If I use the next call to Dynamics 10000 it's 115. This does reference Sy Custom Reports but these users are already assigned the Roles it lists. It also references TRx Year end, which I went in and marked them for access, but this didn't fix it either.

I have tried marking every security Role and every task other than POWERUSER, that doesn't work. If I give them POWERUSER the report will run.

I also tried 'How to change security permissions' but again, it returns no information.

This makes no sense to me. What can I do to figure this out? I cannot give them POWERUSER status.

Below is the pertinent information from the scripts.

{ CALL DYNAMICS.dbo.zDP_SY10000SS_1 ( 'MARY', 1, 0, 20050, 23 ) }

* Date: 02/20/2023 Time: 20:56:41

stmt(144537560):*/

Then the last line is:

BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY05000SI 2, 'Microsoft Dynamics GP', 'Company, Inc.', 'MARY', 6, '2023.02.20', '20:56:41', 'Access to print the Packing Slip was denied.', @num OUT SELECT @num END

I can include more of the DEXSQL but it seems this is the one that is supposed to indicate the issue.

Any help is greatly appreciated.

Thank You

Categories:

Microsoft Dynamics GP

Quick Links