Need to Modify Query of a Projected DAC

Hi @jeewanishalika20  I have removed the below condition and please find the query below.

And<INTran.qty, Greater<decimal0> 

	[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.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)]

Hi @jeewanishalika20  Sorry, I’m not clear with the above question. Can you please elaborate?

No, we cannot change the ARTranForDirectInvoice.cs file, either you need to inherit or extend the DAC and check once.

@jeewanishalika20

sorry for typos. Writing on cellphone.

The projection DACs in Acumatica are equivalent of SQL views. I don’t think there is a way to alter built in Projections behavior. I am not sure about the extent of this projection DAC and its purpose of usage in your case but here are alternate options you have. Depending on your use case one or all my work. I ordered as easiest to most difficult below. please note the below option1 can work if inside the graph the view is not casted as the Projection DAC otherwise the platform will fail to explicitly convert one to another.

1. copy the existing DAC and change the Projection query then in your graph extension override the view selecting from the original DAC to the Custom DAC
2. wWrite a view delegate instructing the platform to read from custom DAC instead of original. If the view has already a delegate you will override the existing 
3. A little bit of hacking by overriding the view in graph initialization and directing the existing view to read from a new one. The below is an example for a different scenario but logic is the same. See Yuriy’s response also can be found in his blog.