I facing the issue with the unitcost field where datatype is decimal(25,6) and in the DAC, i have used
[PXDBDecimal(typeof(Search<CommonSetup.decPlPrcCst>))]. In Company Screen i have set Price/Cost = 4 still its defaulting 6 decimal place. please guide if missed any thing to default from the company set up.
Best answer by harikanthm60
protected virtual void DefaultUnitCost(PXCache sender, TSProdMTran row)
{
object UnitCost;
sender.RaiseFieldDefaulting<TSProdMTran.unitCost>(row, out UnitCost);
if (UnitCost != null && (decimal)UnitCost != 0m)
{
decimal? unitcost = INUnitAttribute.ConvertToBase<TSProdMTran.inventoryID>(sender, row, row.UOM, (decimal)UnitCost, INPrecision.UNITCOST);
sender.SetValueExt<TSProdMTran.unitCost>(row, unitcost);
decimal? extcost = row.IssueQty * row.UnitCost;
sender.SetValueExt<TSProdMTran.extCost>(row, extcost);
}
Below code is changing the decimal precision as set in the company screen using Price?cost decimal field.
decimal? unitcost = INUnitAttribute.ConvertToBase<TSProdMTran.inventoryID>(sender, row, row.UOM, (decimal)UnitCost, INPrecision.UNITCOST);
#region UnitCost
public abstract class unitCost : PX.Data.BQL.BqlDecimal.Field<unitCost>
{
}
protected decimal? _UnitCost;
//[PXDBPriceCost(MinValue = 0)]
[PXDBDecimal(typeof(Search<CommonSetup.decPlPrcCst>))]
[PXDefault(TypeCode.Decimal, "0.0", typeof(Coalesce<Search<INItemSite.tranUnitCost, Where<INItemSite.inventoryID,
Equal<Current<TSProdFormula.inventoryID>>, And<INItemSite.siteID, Equal<Current<TSProdFormula.siteID>>>>>,
Search<INItemCost.tranUnitCost, Where<INItemCost.inventoryID, Equal<Current<TSProdFormula.inventoryID>>>>>))]
[PXUIField(DisplayName = "Unit Cost",Enabled =false,IsReadOnly = true)]
public virtual decimal? UnitCost
{
get
{
return this._UnitCost;
}
set
{
this._UnitCost = value;
}
}
#endregion
+19
I have not tested but can you try with the below one?
[PXPriceCost]
+19Have you tried this already?
protected virtual void DefaultUnitCost(PXCache sender, TSProdMTran row)
{
object UnitCost;
sender.RaiseFieldDefaulting<TSProdMTran.unitCost>(row, out UnitCost);
if (UnitCost != null && (decimal)UnitCost != 0m)
{
decimal? unitcost = INUnitAttribute.ConvertToBase<TSProdMTran.inventoryID>(sender, row, row.UOM, (decimal)UnitCost, INPrecision.UNITCOST);
sender.SetValueExt<TSProdMTran.unitCost>(row, unitcost);
decimal? extcost = row.IssueQty * row.UnitCost;
sender.SetValueExt<TSProdMTran.extCost>(row, extcost);
}
Below code is changing the decimal precision as set in the company screen using Price?cost decimal field.
decimal? unitcost = INUnitAttribute.ConvertToBase<TSProdMTran.inventoryID>(sender, row, row.UOM, (decimal)UnitCost, INPrecision.UNITCOST);
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
