Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Wednesday, February 14, 2018

Relation between PSAProjProposalProj with PSAContractLineItems in AX 2012


static void Job80(Args _args)
{
     psaProjProposalProj psaProjProposalProj;
     projOnAccTrans projOnAccTrans;
     projProposalOnAcc projProposalOnAcc;
     psaContractLineItems psaContractLineItems;
     while select psaProjProposalProj where psaProjProposalProj.ProjProposalId == "UDI-000127"//_projProposalJour.ProposalId
            join projOnAccTrans where projOnAccTrans.ProjID == PSAProjProposalProj.ProjId
                                    && projOnAccTrans.TransactionOrigin == ProjOrigin::Prepayment
            join projProposalOnAcc where projProposalOnAcc.TransId == projOnAccTrans.TransId
                                    && projProposalOnAcc.ProposalId == PSAProjProposalProj.ProjProposalId
            join psaContractLineItems
                        where psaContractLineItems.FeeProjId == psaProjProposalProj.ProjId
        {
            info(strFmt("%1",psaContractLineItems.LineValue));
        }
}

No comments:

Post a Comment

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...