Hello Community;
I’m creating a form to retrieve Invoices and Memos infos and calculate some taxes,
I’m doing a Left join between ARInvoice table and MasterInvoice where master invoice is a table inherting from ARInvoice, like this :
public class MasterInvoice : PX.Objects.AR.ARInvoice
{
}
SelectFrom<ARInvoice>
.LeftJoin<Customer>.On<ARInvoice.customerID.IsEqual<Customer.bAccountID»
.LeftJoin<MasterInvoice>.On<ARInvoice.masterRefNbr.IsEqual<MasterInvoice.refNbr»
The project is published successfully and the MasterInvoice fields are there, but those fields showing no data.
Any ideas?
Best answer by Dmitrii Naumov
View original