How to get all CusttransOpen Transactions .

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

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

Hi Kranthi,

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

Thanks
Haribabu

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

Thanks Kranthi…