Skip to main content
Solved

"Mark for PO" checkbox in SOLine does not update "Mark For PO" in LineDetails


Forum|alt.badge.img+1

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

 

 

Best answer by Yuriy Zaletskyy

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:

 

[PXFilterable]
        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.

 

View original
Did this topic help you find an answer to your question?

3 replies

mariankharechko60
Freshman II

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

 


Forum|alt.badge.img+1

@mariankharechko60 Yes it is same.


Yuriy Zaletskyy
Jr Varsity I
Forum|alt.badge.img+2

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:

 

[PXFilterable]
        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


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