Issue in Query

(0) Share

Report

Posted on by Sajjad_00

477

I am having a SQL Query and need the same in AX but not able to do its not identifying a table.

SELECT        DISTINCT CUSTPACKINGSLIPTRANS.PACKINGSLIPID
FROM            CUSTINVOICETRANS INNER JOIN
                         CUSTINVOICEPACKINGSLIPQUANTITYMATCH ON CUSTINVOICETRANS.SOURCEDOCUMENTLINE = CUSTINVOICEPACKINGSLIPQUANTITYMATCH.INVOICESOURCEDOCUMENTLINE AND
                         CUSTINVOICETRANS.DATAAREAID = CUSTINVOICEPACKINGSLIPQUANTITYMATCH.DATAAREAID INNER JOIN
                         CUSTPACKINGSLIPTRANS ON CUSTINVOICEPACKINGSLIPQUANTITYMATCH.PACKINGSLIPSOURCEDOCUMENTLINE = CUSTPACKINGSLIPTRANS.SOURCEDOCUMENTLINE AND
                         CUSTINVOICEPACKINGSLIPQUANTITYMATCH.DATAAREAID = CUSTPACKINGSLIPTRANS.DATAAREAID
WHERE        (CUSTINVOICETRANS.DATAAREAID = 'MEMF') AND (CUSTINVOICETRANS.INVOICEID = '03-CINV-17-00051')

how can I convert this to X++

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

SAADULLAH M Z 175 on at

Like (0)

Report
Copy link

Link copied!

Why don't you try View, Create a new View from AOT by adding all your table by joining together.

It will make your selection statement simple.

Was this reply helpful? Yes No
Suggested answer

Pravasti AK 2,985 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Do you struggle only with DISTINCT CUSTPACKINGSLIPTRANS.PACKINGSLIPID, or do you have any additional problems?

Try to declare a table with a buffer .

Thanks,

Kavitha

Was this reply helpful? Yes No
Verified answer

Sajjad_00 477 on at

Like (0)

Report
Copy link

Link copied!

OK Done. Thanks to all

Was this reply helpful? Yes No