I am having an issue with being able to report the full taxpayer ID on Vendor 1099 activity report? Is there a way to unmask this field as it is currently only showing the last 4 of the taxpayer id.
I am having an issue with being able to report the full taxpayer ID on Vendor 1099 activity report? Is there a way to unmask this field as it is currently only showing the last 4 of the taxpayer id.
Hi bbates,
It seems that you are using another Sage product rather than Sage CRM. Please confirm if you are using Sage 500 ERP, and if so, we can move your post to the correct Support Group.
Thanks,
Derek
Yes sorry i should have added that. We are using Sage 500 ERP
No problem. Thanks for confirming. I will move your post over to the Sage 500 ERP Support Group now.
Thanks,
Derek
Thanks
This was done by design, I believe starting in version 2018 as part of data privacy protection. To make it user configurable would require an enhancement (would require UI change, security event processing, and a stored procedure change).
If you absolutely have to have the full taxpayer ID printed and have a partner or a qualified SQL person on staff, a customization to one stored procedure can accomplish this as long as you are willing to accept all risks. SAGE DOES NOT ENDORSE THESE CHANGES, USE AT YOUR OWN RISK.
BE SURE TO TEST THIS IN A TEST DATABASE BEFORE MOVING IT TO PRODUCTION AND TO BACKUP PRODUCTION DATABASE PRIOR TO MOVING THE CHANGES.
The stored procedure spapV1099ActiveRpt has two lines that would need to be modified. Each line gets the same change.
------------------------------------------------------
------------------------------------------------------
For an enhancement request, please contact Sage Support and/or create an entry on the Ideas site on your business desktop middle pane (which links to https://www5.v1ideas.com/TheSageGroupplc/Sage500ERP)
*Community Hub is the new name for Sage City