Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

AX 4.0 SALESPRINTSETUP Table

(0) ShareShare
ReportReport
Posted on by 5

Hi,

We have Microsoft AX 4.0 running on SQL Server 2005. I am trying to get the email address which is used for sending out Invoices from the PRINTJOBSETTINGS column in SALESPRINTSETUP table. The PRINTJOBSETTINGS column is of Image data type. But it is not really an image. Can someone please help me how to  extract information from PRINTJOBSETTINGS? I have attached an image of the SALESPRINTSETUP column after I ran the following query.

SELECT CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), PRINTJOBSETTINGS)) FROM SALESPRINTSETUP

35056_2D00_imagedata.jpg

Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 456 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 310

#3
Saalim Ansari Profile Picture

Saalim Ansari 261

Overall leaderboard

Product updates

Dynamics 365 release plans