Joining ARInvoice to MasterInvoice

Hi @hmzamr,

Can you please more details like steps to reproduce, a simple customization package, current behavior and expected behavior? 

Hi Vignesh,
i’m making a new form to show a grid showing ARInvoices, i want to join the ARInvoice to it’s MasterInvoice where ARInvoice.masterRefNbr is equal to MasterInvoice.refNbr

SelectFrom<ARInvoice>
                .LeftJoin<MasterInvoice>.On<ARInvoice.masterRefNbr.IsEqual<MasterInvoice.refNbr»

the project was validated and published successfully, but when it comes to show the form or add fields to it, it says ‘Duplicated use of ARInvoice_ARInvoice in one FROM clause ’
because basically MasterInvoice is AR.ARInvoice

Hi @hmzamr,

I don’t see the MasterInvoice table or DAC. Is it a custom DAC? Can you possibly share a customization package using which we can reproduce the behavior?

Hi @hmzamr ,

                           The Master Table for ARInvoice is ARRegister,  and the Relation you are looking for is ARInvoice.RefNbr=ARRegister.refnbr

Is this what you are looking for ?

in a simple word, i want to join ARInvoice to itself where the masterRefNbr is equal to refNbr.
Is there a way where i can do that?

Hi @hmzamr ,

                         Can you please elobarate, what information are you displaying on the grid?

i’m displaying Tax information; Installments, TaxTotal, amounts, terms and i’m doing calculated fields to calculate installments taxes based on Terms

Based on What you are pulling the data, i mean how are you bringing the data?

Hi @Atiq 
Here is the statment i’m using :
SelectFrom<ARInvoice>
                .LeftJoin<Customer>.On<ARInvoice.customerID.IsEqual<Customer.bAccountID>>
                .Where<ARInvoice.status.IsEqual<ARDocStatus.closed>……..etc