Good day,
I have created a new custom field named transport on the opportunities, sales quote, sales order and invoices and memo’s screen.
I would like the value entered in the custom field to carry over to the sales quote, sales order and invoices and memo screen when a new one is created.
Currently the value already carries over to sales quotes, since it uses the same DAC as opportunities.
Any help on how to be able to achieve this would be great.
Solved
Retreive value from one DAC and use it in another
Best answer by Naveen Boga
Hi
public PXAction<CROpportunity> createSalesOrder;
[PXUIField(DisplayName = Messages.CreateSalesOrder, MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Select)]
[PXButton]
public virtual IEnumerable CreateSalesOrder(PXAdapter adapter)
{
PXGraph.InstanceCreated.AddHandler<SOOrderEntry>((graph) =>
{
graph.RowInserted.AddHandler<SOLine>((cache, args) =>
{
var soOrderLine = (SOLine)args.Row;
KNSOLineExt soOrderLineExt = soOrderLine.GetExtension<KNSOLineExt>();
foreach (CROpportunityProducts line in Base.Products.Select().FirstTableItems.ToList().Where(x=>x.InventoryID == soOrderLine.InventoryID))
{
CROpportunityProductsExt lineExt = line.GetExtension<CROpportunityProductsExt>();
soOrderLineExt.UsrTransport = lineExt.UsrTransport;
graph.Transactions.Cache.Update(soOrderLine);
}
});
});
return Base.createSalesOrder.Press(adapter);
}
Hi
For Instance on the Sales order Screen:
- Create a BQL view with the JOIN on the SalesOrder and Sales Quote/Opportunity to get the Custom value.
- Assign the Value to the Customer(usr field)
+20Hi
Below is the sample code for your reference to get the value from Opportunities to Sales Quote and the same way you can use it for other screens.
Hope this helps!
// The below code will get the value from Opportunity to Sales Quote
public sealed class SalesQuoteExt : PXCacheExtension<SalesQuote>
{
#region UsrCustomField
[PXDBDecimal()]
[PXDefault(typeof(Search<OpportunityExt.CustomField,
Where<Opportunity.Condition1, Equal<Current<SalesQuote.Condition1>>,
And<Opportunity.Condition2, Equal<Current<SalesQuote.Condition2>>,
And<Opportunity.Condition3, Equal<Current<SalesQuote.Condition3>>>>>>),
PersistingCheck = PXPersistingCheck.Nothing)]
[PXUIField(DisplayName = "Transaction")]
public virtual decimal? UsrCustomField { get; set; }
public abstract class usrCustomField : PX.Data.BQL.BqlDecimal.Field<usrCustomField> { }
Currently I am working with the following code, but I am getting the following error when trying to create the sales order
Unable to cast object of type 'PX.Data.PXResult`2[PX.Objects.CR.CROpportunity,PX.Objects.CR.BAccount]' to type 'PX.Objects.CR.CROpportunityProductsExt'.
public PXAction<CROpportunity> createSalesOrder;
[PXUIField(DisplayName = Messages.CreateSalesOrder, MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Select)]
[PXButton(ImageKey = PX.Web.UI.Sprite.Main.DataEntry)]
public virtual IEnumerable CreateSalesOrder(PXAdapter adapter)
{
PXGraph.InstanceCreated.AddHandler<SOOrderEntry>((graph) =>
{
graph.RowInserted.AddHandler<SOLine>((cache, args) =>
{
var soOrderLine = (SOLine)args.Row;
var soOrderLineExt = PXCache<SOLine>.GetExtension<SOLineExt>(soOrderLine);
foreach (CROpportunityProductsExt line in adapter.Get())
{
soOrderLineExt.UsrTransport = line.UsrTransport;
}
});
});
return Base.createSalesOrder.Press(adapter);
}
+20Hi
public PXAction<CROpportunity> createSalesOrder;
[PXUIField(DisplayName = Messages.CreateSalesOrder, MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Select)]
[PXButton(ImageKey = PX.Web.UI.Sprite.Main.DataEntry)]
public virtual IEnumerable CreateSalesOrder(PXAdapter adapter)
{
PXGraph.InstanceCreated.AddHandler<SOOrderEntry>((graph) =>
{
graph.RowInserted.AddHandler<SOLine>((cache, args) =>
{
var soOrderLine = (SOLine)args.Row;
var soOrderLineExt = PXCache<SOLine>.GetExtension<SOLineExt>(soOrderLine);
foreach (CROpportunityProducts line in adapter.Get())
{
CROpportunityProductsExt lineExt = line.GetExtension<CROpportunityProductsExt>();
soOrderLineExt.UsrTransport = lineExt.UsrTransport;
}
});
});
return Base.createSalesOrder.Press(adapter);
}
Below code changes I have done for CROpportunityProductsExt. Please verify
Hi
Unable to cast object of type 'PX.Data.PXResult`2[PX.Objects.CR.CROpportunity,PX.Objects.CR.BAccount]' to type 'PX.Objects.CR.CROpportunityProducts'.
+20+20Hi
public PXAction<CROpportunity> createSalesOrder;
[PXUIField(DisplayName = Messages.CreateSalesOrder, MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Select)]
[PXButton]
public virtual IEnumerable CreateSalesOrder(PXAdapter adapter)
{
PXGraph.InstanceCreated.AddHandler<SOOrderEntry>((graph) =>
{
graph.RowInserted.AddHandler<SOLine>((cache, args) =>
{
var soOrderLine = (SOLine)args.Row;
KNSOLineExt soOrderLineExt = soOrderLine.GetExtension<KNSOLineExt>();
foreach (CROpportunityProducts line in Base.Products.Select().FirstTableItems.ToList().Where(x=>x.InventoryID == soOrderLine.InventoryID))
{
CROpportunityProductsExt lineExt = line.GetExtension<CROpportunityProductsExt>();
soOrderLineExt.UsrTransport = lineExt.UsrTransport;
graph.Transactions.Cache.Update(soOrderLine);
}
});
});
return Base.createSalesOrder.Press(adapter);
}
Hi
Thank you for this, It definitely solved my issue regarding my error, but for some reason the transport value does not carry over.
Do you also experience this?
+20Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.