Using data from attachments to use in X++ in D365

(0) Share

Report

Posted on by Ali Sajjad

195

Hi All,

I've a Sales Order with two sale lines in it. For both of these lines, I've attached a note using top right attachment tool and for the header of sales order, I did the same.
The requirement is to use these attachment notes in X++ code so I can use them to populate fields on report.
Is there any way to get reference from like first sales line to the respective attachment and same for all?

Any code or suggestions?

Regards,
Ali

1526.pastedimage1574981204617v5.png

3527.pastedimage1574981061286v2.png

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Satish Panwar 14,673 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Ali,

Notes are stored in DocuRef table and has relationship with salesline on reftableid and refrecid. You need to get data from DocuRef table and then print on report. Check relationship in Visual Studio.

Was this reply helpful? Yes No
Blue Wang Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Ali,

As mentioned, files are saved to docuvalue and docuref tables.

Here's a similar thread,more details,please refer : dynamicsuser.net/.../attach-files-programmatically-using-x

Was this reply helpful? Yes No
Ali Sajjad 195 on at

Like (0)

Report
Copy link

Link copied!

Thank you all.

I tried the relationship pointed by Satish and they worked.

Regards,

Ali

Was this reply helpful? Yes No