Hi,
i have created a Methord that Pulls Soline items, i want to throw Error for certain conditions in that methord, How can we Achive that?
Solved
Is it possible to throw Error in a Method?
Best answer by Atiq
Hi Vignesh,
i have written the logic to bring the soline values from artran, and using Saleorderval(tran1,line1); method, iam populating the error
public virtual IEnumerable invFilter(PXAdapter adapter)
{
var x = AlternateInvId.Select().Count;
var q = Invview.Select().Count;
var s = Lineqty.Select().Count;
var k = Invview.AskExt();
if (this.Invview.AskExt() == WebDialogResult.OK)
{
foreach (ARInvoice invoice in Invview.Select())
{
if (invoice.Selected == true)
{
try
{
foreach (SOLine sO in Lineqty.Select())
{
var kb = sO.InvoiceNbr;
var aa = sO.OrderNbr;
}
foreach (ARTran tran1 in PXSelect<
ARTran,
Where<ARTran.tranType, Equal<Current<ARInvoice.docType>>,
And<ARTran.refNbr, Equal<Current<ARInvoice.refNbr>>>>>
.Select(Base, invoice.RefNbr, invoice.DocType))
{
SOLine line1 = PXSelect<
SOLine,
Where<SOLine.orderType, Equal<Required<SOLine.orderType>>,
And<SOLine.orderNbr, Equal<Required<SOLine.orderNbr>>,
And<SOLine.lineNbr, Equal<Required<SOLine.lineNbr>>>>>>
.Select(Base, tran1.SOOrderType, tran1.SOOrderNbr, tran1.SOOrderLineNbr);
if (line1 != null)
{
SOLine line = new SOLine();
line.InventoryID = line1.InventoryID;
ItemAvailabilityExt.Check(line);
//line.UOM = tran1.UOM;
line.BranchID = line1.BranchID;
line.OrderQty = line1.OrderQty;
Saleorderval(tran1,line1);
line.UOM = line1.UOM;
line.InvoiceNbr = invoice.RefNbr;
PXDBQuantityAttribute.CalcTranQty<SOLine.orderQty>(Base.Transactions.Cache, line1);
Base.Transactions.Insert(line);
}
}
}
catch (PXException ex)
{
// throw ex.Message;
}
public void Saleorderval(ARTran tran, SOLine line2)
{
foreach (SOLine line
in PXSelect<SOLine, Where<SOLine.invoiceNbr, Equal<Required<SOLine.invoiceNbr>>, And<SOLine.inventoryID, Equal<Required<SOLine.inventoryID>>>>>.Select(Base, tran.RefNbr, tran.InventoryID))
{
if (line.OrderType == "RC")
{
if (line.CustomerID == tran.CustomerID)
{
if (line.InvoiceNbr == tran.RefNbr)
{
if (tran.Qty != (LineQtyCount))
{
LineQtyCount = LineQtyCount + line.OrderQty;
if (line.OrderQty != LineQtyCount)
{
// throw new PXException(Messages.SOLine, PXErrorLevel.RowError);
PXUIFieldAttribute.SetError<SOLine.orderQty>(Base.Transactions.Cache, line1, "No");
}
}
}
}
}
1 person likes this
+5Hi
You can override the method use the following to set the error on certain field,
PXUIFieldAttribute.SetError<SOLine.orderQty>(sender, e.Row, warning);Hope that helps.! If you need further information, feel free share more details on the requirements and current implementation.
#VP
Hi
public void saleorderval( ARTran tran, SOLine line2)
{
foreach (SOLine line
in PXSelect<SOLine, Where<SOLine.invoiceNbr, Equal<Required<SOLine.invoiceNbr>>, And<SOLine.inventoryID, Equal<Required<SOLine.inventoryID>>>>>.Select(Base, tran.RefNbr, tran.InventoryID))
{
if (line.OrderType == "RC")
{
if (line.CustomerID == tran.CustomerID)
{
if (line.InvoiceNbr == tran.RefNbr)
{
LineQtyCount = LineQtyCount + line.OrderQty;
if (line.OrderQty != (LineQtyCount))
{
try
{
PXUIFieldAttribute.SetError<SOLine.orderQty>(sender, e, "Yes");
}
catch(Exception ex)
{
}
}
}
}
}
i have created a methord and the method has no cache attached to it, in this case what parameters should be passed to SetError Method?
+4
+5Hi
You can use the cache of the transaction and pass the current detail line of the loop, below is an example of action in SOOrderEntry that does set the error when the quantity is greater that 0.
public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>
{
#region Event Handlers
public PXAction<SOOrder> setError;
[PXUIField(DisplayName = "Set Error")]
[PXButton]
protected IEnumerable SetError(PXAdapter adapter)
{
foreach (SOLine line in Base.Transactions.Select())
{
if (line.OrderQty > 0)
{
PXUIFieldAttribute.SetError<SOLine.orderQty>(Base.Transactions.Cache, line, "Yes");
}
}
return adapter.Get();
}
#endregion
}Feel free to post if you have any questions, along graph extension as it might give us a better context of what you are trying to accomplish. Good Luck.!
#VP
Hi
Thank you for the Response, i have tried the above approch But it didnt work. Actually, in my requirement, For RC Sales Order i have added a button in SOline, which populates all the invoices for the current customer in a popup. and when i select any invoice then it brings all the iventory items to soline which i have Achived. but there is another conditon which needs to be implemented i.e it should compare the items qty of the selected invoice items and sum of Qty of existing RC orders, if it does not match the condition it should display an error. For this Reason i have created a method that pulls soline and tran values and i call it from Action, But iam not able to implement the Error .
“The return quantity exceeds the quantity available for return for the related invoice line AR010261, FOODCHIP36. Decrease the quantity in the current line, or in the corresponding line of another return document or documents AR010308, AR010316 that exist for the invoice line.”
1 person likes this
+5Hi
Can you please share a simplified customization project using which we could reproduce the issue?
Hi Vignesh,
i have written the logic to bring the soline values from artran, and using Saleorderval(tran1,line1); method, iam populating the error
public virtual IEnumerable invFilter(PXAdapter adapter)
{
var x = AlternateInvId.Select().Count;
var q = Invview.Select().Count;
var s = Lineqty.Select().Count;
var k = Invview.AskExt();
if (this.Invview.AskExt() == WebDialogResult.OK)
{
foreach (ARInvoice invoice in Invview.Select())
{
if (invoice.Selected == true)
{
try
{
foreach (SOLine sO in Lineqty.Select())
{
var kb = sO.InvoiceNbr;
var aa = sO.OrderNbr;
}
foreach (ARTran tran1 in PXSelect<
ARTran,
Where<ARTran.tranType, Equal<Current<ARInvoice.docType>>,
And<ARTran.refNbr, Equal<Current<ARInvoice.refNbr>>>>>
.Select(Base, invoice.RefNbr, invoice.DocType))
{
SOLine line1 = PXSelect<
SOLine,
Where<SOLine.orderType, Equal<Required<SOLine.orderType>>,
And<SOLine.orderNbr, Equal<Required<SOLine.orderNbr>>,
And<SOLine.lineNbr, Equal<Required<SOLine.lineNbr>>>>>>
.Select(Base, tran1.SOOrderType, tran1.SOOrderNbr, tran1.SOOrderLineNbr);
if (line1 != null)
{
SOLine line = new SOLine();
line.InventoryID = line1.InventoryID;
ItemAvailabilityExt.Check(line);
//line.UOM = tran1.UOM;
line.BranchID = line1.BranchID;
line.OrderQty = line1.OrderQty;
Saleorderval(tran1,line1);
line.UOM = line1.UOM;
line.InvoiceNbr = invoice.RefNbr;
PXDBQuantityAttribute.CalcTranQty<SOLine.orderQty>(Base.Transactions.Cache, line1);
Base.Transactions.Insert(line);
}
}
}
catch (PXException ex)
{
// throw ex.Message;
}
public void Saleorderval(ARTran tran, SOLine line2)
{
foreach (SOLine line
in PXSelect<SOLine, Where<SOLine.invoiceNbr, Equal<Required<SOLine.invoiceNbr>>, And<SOLine.inventoryID, Equal<Required<SOLine.inventoryID>>>>>.Select(Base, tran.RefNbr, tran.InventoryID))
{
if (line.OrderType == "RC")
{
if (line.CustomerID == tran.CustomerID)
{
if (line.InvoiceNbr == tran.RefNbr)
{
if (tran.Qty != (LineQtyCount))
{
LineQtyCount = LineQtyCount + line.OrderQty;
if (line.OrderQty != LineQtyCount)
{
// throw new PXException(Messages.SOLine, PXErrorLevel.RowError);
PXUIFieldAttribute.SetError<SOLine.orderQty>(Base.Transactions.Cache, line1, "No");
}
}
}
}
}
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.