Hello Community,
i’m working on a customization project and i want a grid to show some results of joining 2 tables, I wanted to ask how to join ARinvoice to MasterInvoice, because when i do it the form shows “ARInvoice duplicated many times in FROM clause”
Joining ARInvoice to MasterInvoice
Hi
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
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
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?
i’m displaying Tax information; Installments, TaxTotal, amounts, terms and i’m doing calculated fields to calculate installments taxes based on Terms
Hi
Here is the statment i’m using :
SelectFrom<ARInvoice>
.LeftJoin<Customer>.On<ARInvoice.customerID.IsEqual<Customer.bAccountID>>
.Where<ARInvoice.status.IsEqual<ARDocStatus.closed>……..etc
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.