In doing some testing with 2021.100.26 it looks like the social security numbers are now encrypted through BAQ. So no more accessing from PrEmpMas through baq or baq report. The suggested fix is to create a UD column. Just a heads up for anyone interested. I will need this for some reports, addin…

I got it all working after learning some things. It does use the UpdateExt for the UBAQ, but i dont believe I had any other choice. Should just update the results table on the BAQ. Inside the BPM its using GetList. foreach (var ttDecrypt in (from row in result.Results select row)) { // Decry…

When I post the Encrypted SSN to a message box I get a small portion of it. Same as the BAQ column. 24 characters I believe. It’s trying to decrypt only part of it so I get Nothing for a result after that. (Actually might be the entire thing i dunno) Here is my process (which is a little goofy …

[image] kylepbsps: Epicor.Security.Cryptography.Encryptor.DecryptToString(MaskedSSN); It works in Form Customization, same code. Must be missing a reference, or something with how im doing the bpm.

So if i do a message box through the code block it works yay. Now I confirmed I can decrypt it. Next step is to add it back to the baq column or replace a column in the baq result.

Ughh… im going to give up and pay Epicor to rewrite our 401k Submission report (Which requires SSN). I wrote the original BAQ Report in E10, which was very simple, just query PrEmpMas table with sub-query on deductions. I can get the decrypted value to show up in a message box when the baq return…

Loop through the results in the dataset, and assign the decrypted value to a Calculated field in the BAQ.

I got the following error when I try to do it on Form Customization… ‘Epicor.Security.Cryptography.Encryptor.DecryptToString(string)’ is obsolete: ‘Use an overload that takes a key parameter or use ServerEncryptor on the server or ClientEncryptor on the client instead. Note that they use a differen…

This no longer works in 2022.2.27 (11.2.200.27) :frowning: foreach (var ttDecrypt in (from row in result.Results select row)) { // Decrypt “PREmpMas_SocSecNum” field for each row string encryptedData = ttDecrypt.PREmpMas_SocSecNum; string decryptedData = Epicor.Security.Cryptography.Encryptor…

Post the text of that error message instead of a screen shot.

Server Side Exception BPM runtime caught an unexpected exception of ‘CryptographicException’ type. See more info in the Inner Exception section of Exception Details. Exception caught in: Epicor.ServiceModel Error Detail Correlation ID: 909e6f8f-00d2-459d-87a7-71ed103828c6 Description: BPM run…

Does that method have an overload to set the padding?

BAQ for PrEmpMas Social Security Number (Encrypted)

Kinetic ERP

josecgomez (Jose C Gomez) January 22, 2024, 1:05am 20

The fix for 2022+ is

Epicor.Security.Cryptography.ServerEncryptor.DecryptToString(encryptedData);

Topic		Replies	Views
Accursed Vacation Report SSN's Kinetic ERP	3	564	August 18, 2023
Explanation on BAQ Security in relation to Active Home Page Kinetic ERP baq , active-home-page , menu-security	35	6408	July 29, 2026
BAQ and Reports - How dangerous is it Epicor ERP 10 dashboard , e10-baq	15	4424	February 11, 2020
Possible solution for silent BAQ parameter passing (working now) Kinetic ERP baq , kinetic , baq-parameter , application-studio	30	9189	November 7, 2023
SQL to BAQ? Kinetic ERP sql , baq	48	5021	March 25, 2025

BAQ for PrEmpMas Social Security Number (Encrypted)

Related topics