Skip to main content
Question

No able to refesh a custom view data fields on APInvoice navigation or selecting different Bill


aaghaei
Captain II
Forum|alt.badge.img+10

Our business needs to show the summary of Commitments (PO and Subcontracts) on top of the invoice to facilitate the approval controls. I have created a view and related DAC called “UDCTPOOrderSummary”. I have added the required fields from the view I have ctreated to the header section of the “AP Bills and Adjustments” as shown in the below snippet. 

 

 

I have added the beloe data view to the APInvoiceEntry Extension.

        public PXSelectJoin<UDCTPOOrderSummary,
            InnerJoin<APTran, On<UDCTPOOrderSummary.orderType, Equal<APTran.pOOrderType>,
                And<UDCTPOOrderSummary.orderNbr, Equal<APTran.pONbr>>>,
            InnerJoin<APInvoice, On<APTran.tranType, Equal<APInvoice.docType>,
                And<APTran.refNbr, Equal<APInvoice.refNbr>>>>>,
            Where<APInvoice.docType, Equal<Current<APInvoice.docType>>,
                And<APInvoice.refNbr, Equal<Current<APInvoice.refNbr>>>>> POOrderSummaryView;

 

I have added the below code to my page as well. I tried AutoCallBack on a few of the fields to see does t make any difference but didn’t.

      <px:PXLayoutRule runat="server" ID="POOrderSummaryViewRule" StartColumn="True" ControlSize="XM" LabelsWidth="SM" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryTotalCost" DataField="POOrderSummaryView.CuryTotalCost" Enabled="False" AutoCallBack="True" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryTotalTax" Enabled="False" DataField="POOrderSummaryView.CuryTotalTax" AutoCallBack="True" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryTotalAmt" Enabled="False" DataField="POOrderSummaryView.CuryTotalAmt" AutoCallBack="True" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryBilledCost" Enabled="False" DataField="POOrderSummaryView.CuryBilledCost" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryBilledTax" Enabled="False" DataField="POOrderSummaryView.CuryBilledTax" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryBilledAmt" Enabled="False" DataField="POOrderSummaryView.CuryBilledAmt" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryUnbilledCost" Enabled="False" DataField="POOrderSummaryView.CuryUnbilledCost" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryUnbilledTax" Enabled="False" DataField="POOrderSummaryView.CuryUnbilledTax" />
      <px:PXNumberEdit runat="server" ID="edPOOrderSummaryViewCuryUnbilledAmt" Enabled="False" DataField="POOrderSummaryView.CuryUnbilledAmt" />

When user opens the Bills and Adjustment screen for the first time, system shows the data correctly on top of the form as expected but when user selects another bill from the list or uses navigation keys, the PO data I have added is not refereshed and always shows the values when form initiated. I tried to force the system to refresh “POOrderSummaryView.View.RequestRefresh()” on APInvoice_RowSelected Event but didn’t work either. I will appreciate help me how should I refresh the data on navigation.

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings