Skip to main content

Hi All,

 

I have created a new grid screen which uses the same SOLine DAC and used views are as follows.

public PXSave<SOLine> Save;
public PXCancel<SOLine> Cancel;

>PXFilterable]
public PXSelectJoinOrderBy<SOLine,
        InnerJoin<SOOrder, On<SOLine.orderType, Equal<SOOrder.orderType>,
            And<SOLine.orderNbr, Equal<SOOrder.orderNbr>>>,
        LeftJoin<InventoryItem, On<SOLine.inventoryID, Equal<InventoryItem.inventoryID>>,
        LeftJoin<AMProdItem, On<PX.Objects.AM.CacheExtensions.SOLineExt.aMProdOrdID, 
        Equal<AMProdItem.prodOrdID>>,
        LeftJoin<AMBomItem, On<AMProdItem.bOMID, Equal<AMBomItem.bOMID>,
            And<AMProdItem.bOMRevisionID, Equal<AMBomItem.revisionID>>>,
        LeftJoin<AMBomOper, On<AMBomItem.bOMID, Equal<AMBomOper.bOMID>,
            And<AMBomItem.revisionID, Equal<AMBomOper.revisionID>>>>>>>>,
        OrderBy<Asc<SOLine.orderNbr>>> SOLineView;

 

But when I update “Mark For PO” checkbox from the new grid screen it does not update the corresponding “Mark For PO” checkboxes in LineDetails of that SOLine. 

Additionally it does not update the POSource field in SOLine and LineDetails as well.

 

How Can I fix this issue?

 

Any help would be much appreciated!

 

Thanks

 

 

After save button and refresh the screen, situation the same?

 

@mariankharechko60 Yes it is same.

Answer

 

  1. You should check your bql and condition there. Be sure that it select correct rows from SOLine table.
  2. Check data in Details tab and your copy tab, compare keys (OrderType, OrderNbr, LineNbr).

 

It is a sample that I used in my test:

 

pPXFilterable]
        public PXSelectJoin<SOLine,
    InnerJoin<SOOrder, On<SOLine.orderType, Equal<SOOrder.orderType>,
        And<SOLine.orderNbr, Equal<SOOrder.orderNbr>>>>,
    Where<SOLine.orderType, Equal<Current<SOOrder.orderType>>,
        And<SOLine.orderNbr, Equal<Current<SOOrder.orderNbr>>>>,
    OrderBy<Asc<SOLine.orderNbr>>> SOLineView2;

And the result:

Worked as expected.

 

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved