How to get all CusttransOpen Transactions .

Dynamics 365 for Finance and Operations/AX Developer Forum
#1

Hi,

I am trying to pull out all open customer invoices for particular legal entity,but I have checked there is no other straight relation between custtrans and custtransopen except accountnum field.

Kindly suggest any Idea to pull out all custtransopen transactions by joining with custtrans.

Thanks

Hari

#2

There is a relation - CustTransOpen.RefRecId == CustTrans.RecId.
Please always tag your AX version.

#3

Hi Kranthi,

I am trying to get all open transactions from Ax 2009.

Thanks
Haribabu

#4

It is same even in AX 2009. CustTransOpen.RefRecId == CustTrans.RecId.

#5

Thanks Kranthi…