AX 4.0 SALESPRINTSETUP Table

(0) Share

Report

Posted on by RobinAX

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