How to : auto update otomatic value field ?

Decorate the Formal attribute on the Available shipment field something like below 

[PXFormula(typeof(Sub<Soline.Qty, Soline.kuotaPengiriman>))]

Happy Coding!

Hi @yanuaralfianus37  I agree with Vinay and here are more details. Please find the details below.

•  PXFormula attribute will work both bound and unbound fields but the PXFormula will NOT will not populate value for the existing records/documents. Until we go and modify the Qty or kuotapengiriman fields “Available for Shipment” will not be updated.

If Available for Shipment field is only display purpose and if it is unbound field I recommend you go with PXDBCalced attribute, this will work for existing records as well as new records.

Here is sample example for your reference. 

 public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>
    {      
        #region UsrAvailableForShipment
        [PXDecimal]
        [PXDBCalced(typeof(Sub<SOLine.orderQty, SOLineExt.kuotapengiriman>), typeof(decimal))]
        [PXUIField(DisplayName = "Available for Shipment")]
        public virtual decimal? UsrAvailableForShipment { get; set; }
        public abstract class usrAvailableForShipment : PX.Data.BQL.BqlDecimal.Field<usrAvailableForShipment> { }
        #endregion 
    }

[PXFormula(typeof(Sub<Soline.Qty, Soline.kuotaPengiriman>))]

hi @Vinay K thanks for the code 

 public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>
    {      
        #region UsrAvailableForShipment
        [PXDecimal]
        [PXDBCalced(typeof(Sub<SOLine.orderQty, SOLineExt.kuotapengiriman>), typeof(decimal))]
        [PXUIField(DisplayName = "Available for Shipment")]
        public virtual decimal? UsrAvailableForShipment { get; set; }
        public abstract class usrAvailableForShipment : PX.Data.BQL.BqlDecimal.Field<usrAvailableForShipment> { }
        #endregion 
    }

hi @Naveen B thanks for the information, i want to ask, how to convert type data if one of field in PXDBCalced is Int ?.

Hi @yanuaralfianus37  PXDBCalced attribute will calculate and returns the decimal value.

Can you please share your Available For Shipment DAC field here.

Hi @Naveen B, this all SS

i got this error after open SO

        [PXDecimal]
        [PXDBCalced(typeof(Sub<SOLine.orderQty, SOLineExt.kuotapengiriman>), typeof(decimal))]
        [PXUIField(DisplayName = "Available for Shipment")]

Hi @Naveen B Thanks for help, This is topic is solved  .

@yanuaralfianus37 Great :) Thanks for sharing the update.