Question

How Decrypt a value in GI from Payroll Settings screen?

  • 22 December 2023
  • 6 replies
  • 55 views

Userlevel 3
Badge

Hello Everyone, 

Can you please help me in decrypt a value from the Employee Payroll settings → Tax Settings → Social Security Number? Below is the screenshot for reference.

 

 


6 replies

Userlevel 4
Badge

Hi,

The issue is that the value in the database is encrypted. As a result, if the data field is used as part of an expression, it will pull the encrypted value.

As a workaround, add the data field to the results grid without using it as part of an expression/formula.

Hope this helps!

Userlevel 3
Badge

@MinushaWeerasuriya76  Thanks a lot for the prompt response.

Can you please help me with an example?

Badge +11

The issue is that the value in the database is encrypted. As a result, if the data field is used as part of an expression, it will pull the encrypted value.

@MinushaWeerasuriya76 - This makes sense in the context of a GI, but his screenshot is from Employee Payroll Settings. It should not be scrambled there.

Userlevel 3
Badge

@darylbowman  Thanks for the response. But I don’t understand how this works for the OLD data records to display the value in the GI?

Badge +11

I’m not sure what you mean by old data records. Minusha’s comment was that it is an encrypted database field, and apparently there are some limitations with getting the decrypted value from the database when using it in a GI formula. This makes enough sense to me. However, your screenshot is from the out-of-the-box screen where the field should have no issues showing the decrypted value. This is what I was saying.

Userlevel 7
Badge

Hi @nsmith51 were you able to find a solution? Thank you!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved