Ive created a PXProjection DAC and Im just trying to multiple a field by a constant (for now).
The PXFormula field of DfltCompQtyCalc keeps returning null no matter what I try? It works when I remove the Multiply<> operator. Also if I just define the PXFormula<index1>.. I get a list of 2’s so the constant is fine also? Why cant I multiply the two!!
using System;
using PX.Data;
using PX.Data.BQL;
using PX.Data.BQL.Fluent;
using PX.Data.ReferentialIntegrity.Attributes;
using PX.Data.WorkflowAPI;
using PX.Objects.CM;
using PX.Objects.Common.Attributes;
using PX.Objects.CS;
using PX.Objects.GL;
using PX.Objects.IN;
using PX.Objects.PO;
using PX.Objects.SO;
namespace AutoKitAssembly
{
[Serializable]
[PXCacheName("KitAssy_Sub2")]
[PXProjection(typeof(Select2<INKitSpecStkDet,
InnerJoin<KitAssy_Sub1,On<INKitSpecStkDet.kitInventoryID,Equal<KitAssy_Sub1.kitInventoryID>,And<INKitSpecStkDet.revisionID,Equal<KitAssy_Sub1.revisionID>>>>
>))]
public partial class KitAssy_Sub2: PXBqlTable, IBqlTable
{
#region KitInventoryID
public abstract class kitInventoryID : PX.Data.BQL.BqlInt.Field<kitInventoryID> { }
[StockItem(IsKey = true, BqlField = typeof(INKitSpecStkDet.kitInventoryID), Enabled = true)]
public virtual Int32? KitInventoryID { get; set; }
#endregion
#region RevisionID
public abstract class revisionID : PX.Data.BQL.BqlString.Field<revisionID> { }
[PXDBString(100, IsUnicode = true, IsKey = true, InputMask = "", BqlField = typeof(INKitSpecStkDet.revisionID))]
public virtual String RevisionID { get; set; }
#endregion
#region KitInventoryID
public abstract class compInventoryID : PX.Data.BQL.BqlInt.Field<compInventoryID> { }
[StockItem(IsKey = true, BqlField = typeof(INKitSpecStkDet.compInventoryID), Enabled = true)]
public virtual Int32? CompInventoryID { get; set; }
#endregion
#region DfltCompQty
public abstract class dfltCompQty : PX.Data.BQL.BqlDecimal.Field<dfltCompQty> { }
[PXDBDecimal(IsKey = true, BqlField = typeof(INKitSpecStkDet.dfltCompQty))]
public virtual Decimal? DfltCompQty { get; set; }
#endregion
private class index1 : Constant<decimal>
{
public index1() : base(2m) { }
}
#region DfltCompQtyCalc
public abstract class dfltCompQtyCalc: PX.Data.BQL.BqlDecimal.Field<dfltCompQtyCalc> { }
[PXDecimal()]
[PXFormula( typeof(Mult<INKitSpecStkDet.dfltCompQty,index1>), null)]
public virtual Decimal? DfltCompQtyCalc { get; set; }
#endregion
#region DfltCompQtyCalc2
public abstract class dfltCompQtyCalc2: PX.Data.BQL.BqlDecimal.Field<dfltCompQtyCalc2> { }
[PXDecimal()]
[PXFormula( typeof(INKitSpecStkDet.dfltCompQty), null)]
public virtual Decimal? DfltCompQtyCalc2 { get; set; }
#endregion
}
}