Adding standard value for requested Date in sales order

​@Bravo94 What are you trying to set the Date to be ?

Hello,

i’m a colleague of bravo94. We want to set it to 09.09.9999. Reason is, that the customer wants it to be mandatory for the user to set an rquest date, and some kind of blockade if the user forgots, before he creates an delivery note. An request date in the future does exactly that, when you try to create an outgoing delivery note, it throws an error.

 

Hi ​@Bravo94,
 

1. Open the Customization Editor.

2. Navigate to the DAC where the RequestDate field is declared.

3. Locate the [PXDefault] attribute on the RequestDate field and replace:

   [PXDefault(typeof(AccessInfo.businessDate))]

   with:

   [PXDefault(typeof(RequestDateDefault))]

4. Declare the default value constant class in your DAC file:

   public class RequestDateDefault : PX.Data.BQL.BqlDateTime.Constant<RequestDateDefault> { public RequestDateDefault() : base(new DateTime(9999, 09, 09)) { } }

5. Ensure the merge method is set to replace the existing attributes:

   [PXMergeAttributes(Method = MergeMethod.Replace)] 
    

6. Publish the Customization project.

Below is the whole code snippet.

     [PXNonInstantiatedExtension]
  public class SO_SOOrder_ExistingColumn : PXCacheExtension<PX.Objects.SO.SOOrder>
  {
      #region RequestDate  
        [PXMergeAttributes(Method = MergeMethod.Replace)]
[PXDBDate()]
    [PXDefault(typeof(RequestDateDefault))]
    [PXUIField(DisplayName = "Requested On", Visibility = PXUIVisibility.SelectorVisible)]
      public DateTime? RequestDate { get; set; }
      #endregion

      public class RequestDateDefault : PX.Data.BQL.BqlDateTime.Constant<RequestDateDefault>
{
    public RequestDateDefault() : base(new DateTime(9999, 09, 09)) { }
}
  }

Hope it helps!

Hi ​@Bravo94, You can also try through Customization Attribute Option:

Just replace 

[PXDefault(typeof(AccessInfo.businessDate))]

with

[PXDefault("09/09/9999")]

and Publish Project.
 

I hope it Helps!

Hi ​@Bravo94, You can also try through Customization Attribute Option:

Just replace 

[PXDefault(typeof(AccessInfo.businessDate))]

with

[PXDefault("09/09/9999")]

and Publish Project.
 

I hope it Helps!

Thank your very much! Worked out just fine.

Hi ​@Bravo94, You can also try through Customization Attribute Option:

Just replace 

[PXDefault(typeof(AccessInfo.businessDate))]

with

[PXDefault("09/09/9999")]

and Publish Project.
 

I hope it Helps!

I have a customer who wants the "Requested On" field to only have this value if the Order Type is "SO".

I tried this here, but it did not work :


 

namespace PX.Objects.SO
{
    public class SOOrderExtensions : PXCacheExtension<SOOrder>
    {
        #region RequestDate  
        [PXDBDate()]
        [PXUIField(DisplayName = "Request Date", Visibility = PXUIVisibility.SelectorVisible)]
        public DateTime? RequestDate { get; set; }
        #endregion

        // Field Defaulting Event-Handler for RequestDate
        protected void _(Events.FieldDefaulting<SOOrder.requestDate> e)
        {
            var row = (SOOrder)e.Row;
            if (row == null) return;

            // Check if OrderType is "SO" (Sales Order)
            if (row.OrderType == "SO")
            {
                e.NewValue = new DateTime(9999, 9, 9); // Set default value
            }
        }
    }
}

Hello, ​@Bravo94 I tried with RowInserted and It worked for me.
You can use following in SOOrderEntry Graph:
 

        [PXDBDate()]
        [PXUIField(DisplayName = "Request Date", Visibility = PXUIVisibility.SelectorVisible)]
        public DateTime? RequestDate { get; set; }
        #endregion

        protected virtual void SOOrder_RowInserted(PXCache sender, PXRowInsertedEventArgs e)
        {
            SOOrder row = e.Row as SOOrder;
            if (row == null) return;

            if (row.OrderType == "SO")
            {
                row.RequestDate = new DateTime(9999, 9, 9);
            }
        }

I hope it helps!
 

​@Abhishek Niikam 

right now i used this in SOOrder Extensions :

namespace PX.Objects.SO
{
      [PXNonInstantiatedExtension]
  public class SO_SOOrder_ExistingColumn : PXCacheExtension<PX.Objects.SO.SOOrder>
  {
      #region RequestDate  
      [PXDBDate()]
    [PXUIField(DisplayName = "Requested On", Visibility = PXUIVisibility.SelectorVisible)]
      public DateTime? RequestDate { get; set; }
      #endregion
  }
}

and this in SOOrderEntry :

namespace PX.Objects.SO
{
    public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry>
    {
        #region Event Handlers

        // RowInserted Event for SOOrder
        protected virtual void SOOrder_RowInserted(PXCache sender, PXRowInsertedEventArgs e)
        {
            SOOrder row = e.Row as SOOrder;
            if (row == null) return;

            // Check if OrderType is "SO"
            if (row.OrderType == "SO")
            {
                row.RequestDate = new DateTime(9999, 9, 9); // Set default value for RequestDate
            }
        }

        #endregion
    }
}



And it works, thanks to you so far.
The only issue is that when I switch the Order type, the field “Requested on” is empty. Previously, it used to automatically display the current date."

Hello, ​@Bravo94 You can try ​@Nilkanth Dipak snippet or if you still have that previous customization in editor for Request On field i.e.

 [PXDefault("09/09/9999")

Just remove that from customization editor and publish project again.

Thank you very much