How can i show sales order NO in the customer transactions form.

Finance and Operations/AX Developer Forum
1

Dear ,

How can i show sales order NO in the customer transactions form.

2

First of all create a relation between your transaction table and SalesTable and write your query according to your requirement

3

And moreover how is your transaction form being called ?Is that form is opened from linking SalesTable form or its called as the first form ?

4

Hi Ahmed,

In ‘custtrans’ table you have ‘InvoiceId’ field

& In cust invoice jour table you also have the same field so

you can fetch the salesorderId from CustInvoiceJour table via the Invoice Id

5

Hi Ahmed,

you can check the relation in CustTrans Table where there are 3 relations are applied:InvoiceId,InvoiceAccount,InvoiceDate

Using These 3 fields you can retrieve the SalesId from CustInvoiceJour.

Thanks & Regards,

Britto John Baskar.A

6

In the first Thank you for your reply

i did what you say but

When you open customer transaction will find sales id for payment although no sales order for payment and sales orders for the invoices not correct