Hi,
I need to modify ARTranForDirectInvoice Project DAC.
Existing Query In DAC
[PXProjection(typeof(Select2<ARTran,
LeftJoin<INTran,
On<INTran.FK.ARTran>>,
Where<ARTran.released, Equal<boolTrue>,
And<
Where2<
Where<INTran.released, Equal<True>,
And<INTran.qty, Greater<decimal0>,
And<INTran.tranType, In3<INTranType.issue, INTranType.debitMemo, INTranType.invoice>>>>,
Or<
Where<INTran.released, IsNull,
And<ARTran.lineType, In3<SOLineType.miscCharge, SOLineType.nonInventory>,
And<
Where2<
Where<ARTran.qty, Greater<decimal0>,
And<ARTran.tranType, In3<ARDocType.debitMemo, ARDocType.cashSale, ARDocType.invoice>>>,
Or<
Where<ARTran.qty, Less<decimal0>,
And<ARTran.tranType, In3<ARDocType.creditMemo, ARDocType.cashReturn>>>>>>>>>>>>,
OrderBy<Desc<ARTran.refNbr>>>),
Persistent = false)]
[PXCacheName(AR.Messages.ARTran)]
[Serializable]
I need to remove And<INTran.qty, Greater<decimal0> condition from above query.
How I do that.