How to resolve "Error: 'OrderDate' cannot be empty" in my custom screen

Hi @oshadarodrigo64  Can you please share the source code (DAC and Graph files), so that we can review and help you if we can found something strange?

Hi ,

I have defined the view like this now.

public PXSelectReadonly2<POLine,
          InnerJoin<POOrder,On<POLine.orderNbr,Equal<POOrder.orderNbr>,
          And<POLine.orderType, Equal<POOrder.orderType>>>>, Where<POLine.vendorID, Equal<Current<APProforma.customerID>>>>
          POrdersView;

After defining the view like above, I’m not able to select one by one, but when I click add-close button all the values are added and can be saved without getting the ‘OrderDate cannot be empty error’. 

I think this is happening because of using the PXselectReadonly attribute as it creates a read-only view . I have taken the selected feild from POLine dac to allow user to select the value. So how Can I enable editable only to the one feild (selected) to allow check it.? below I mentioned a method that I have attempted but it didn’t work as it is.

protected virtual void POLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler)
        {
            PXUIFieldAttribute.SetReadOnly<POLine.selected>(cache, e.Row, false);
            PXUIFieldAttribute.SetEnabled<POLine.selected>(cache, e.Row, true);

        }

Hi @epetruncio89 ,

for the smart panel I need to load data from both POLine and POOrder. for that I have defined the view using PXSelectReadonly2 attribute to avoid ‘OrderDate cannot be empty error’. now the error is gone when saving the added data in the grid to the database. but my issue is I cannot select and add one by one from smart panel because i’m not allowed to select the check box there. Instead of that, when I select add button in the smart panel, all the available values are added to the grid. To allow user to select one value, I have added the field ‘selected’ of POLine. so I thought that I’m getting this issue because I have a read-only view, so I thought of trying to change only the specific field ‘selected’ to set editable, but I don’t know whether it is correct or wrong, However I have put the whole code of the graph for your reference. 

namespace GRIProformaInvoice.Extension
{
    // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active
    public class APProformaEntry_Extension : PXGraphExtension<APProformaEntry>
    {

        public PXSelectReadonly2<POLine,
           InnerJoin<POOrder,On<POLine.orderNbr,Equal<POOrder.orderNbr>,
           And<POLine.orderType, Equal<POOrder.orderType>>>>, Where<POLine.vendorID, Equal<Current<APProforma.customerID>>>>
           POrdersView;

        public PXAction<APProforma> MyAction;
        [PXUIField(DisplayName = "Add Purchase", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)]
        [PXButton(CommitChanges = true)]
        public virtual IEnumerable myAction(PXAdapter adapter)
        {
            try
            {
                if (POrdersView.AskExt() == WebDialogResult.OK)
                {
                    return InsertSelectedLines(adapter);
                }
            }

            catch (PXDialogRequiredException ex)
            {
                PXTrace.WriteError(ex);

                throw;
            }
          return adapter.Get();
        }

        public virtual IEnumerable InsertSelectedLines(PXAdapter adapter)
        {
              if (POrdersView != null)
            {
                int lineNbr = Base.APProformaItems.Select().Count + 1;
                foreach (PXResult< POLine, POOrder> result in POrdersView.Select())
                {
                    POOrder order = result;
                    POLine line = result;

                    if (line.Selected == false) continue;

                    {
                        APProformaItemList toBeInserted = new APProformaItemList();
                        toBeInserted.Ponbr = order.OrderNbr;
                        toBeInserted.LineNbr = lineNbr++;
                        toBeInserted.POLineNbr = line.LineNbr;
                        toBeInserted.POrderQty = 30;
                        toBeInserted.Itemid = 25;
                        toBeInserted.Description = line?.TranDesc;
                        toBeInserted.Amount =  line.ExtCost;
                        toBeInserted = Base.APProformaItems.Insert(toBeInserted);
                        Base.APProformaItems.Update(toBeInserted);

                    }
                }

            }
            return adapter.Get();

        }


        protected virtual void POLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler)
        {
            PXUIFieldAttribute.SetReadOnly<POLine.selected>(cache, e.Row, false);
            PXUIFieldAttribute.SetEnabled<POLine.selected>(cache, e.Row, true);

        }

If you could find something strange in this code , it will be helpful if you can let me know,

thank you.

You should remove the PXReadOnly and replace it with your original code you had in place. I did not realize you were using that smart panel to select lines to add like that. You won’t be able to do it with the view defined using PXReadOnly. I strongly advise you revert to your original code. I am looking into the code you provided now.

Hi @epetruncio89,

please check the PM.

Can you provide a trace log with the stack trace?

Thank you for sharing your solution with the community @oshadarodrigo64 !