Dynamics Community Forum Thread Details

Creating invoice proposal with selected lines from sales order in x++

Greetings,

I have problem in creation of invoice proposal with certain line.

the requirement is to create invoice proposal for a certain line in sales order.

but, i faced the following problem the invoice proposal created contains all the lines from any sales order connected to the project.

here is my code:

ProjInvoiceProjId       _ProjectContractId = "ProjectContract";    //Project Contract Id for which we want to create Invoice Proposal
        ProjProposalJour        projProposalJour;           //Table which will store journal records after creating Invoice Proposal
        ProjInvoiceChoose       m_oProjInvoiceChooseNormal; //Class for creating Invoice Proposal
        ProjFormLetter          projFormLetter;             //Class for Posting Invoice Proposal
        ProjTable               projTable;

        changecompany("Company")
        {
            ttsBegin;


            projTable = projTable::find("ProjectID");
            //Creation of Invoice Proposal
            m_oProjInvoiceChooseNormal = ProjInvoiceChoose::PSANew_InvoiceChoose(_ProjectContractId,projTable.ProjId,dateNull(),maxDate(),true, SalesUpdate::All);
            m_oProjInvoiceChooseNormal.parmQuerySalesLine(true);
            m_oProjInvoiceChooseNormal.parmQueryOnAccTrans(false);
            m_oProjInvoiceChooseNormal.parmQueryRetentionTrans(false);
            m_oProjInvoiceChooseNormal.parmQueryRevenueTrans(false);
            m_oProjInvoiceChooseNormal.parmQuerySubscriptionTrans(false);
            m_oProjInvoiceChooseNormal.parmQueryAdvanceTrans(false);
            m_oProjInvoiceChooseNormal.parmQueryCostTrans(false);
            m_oProjInvoiceChooseNormal.parmQueryEmplTrans(false);
            m_oProjInvoiceChooseNormal.run();

            while select forUpdate projProposalJour where projProposalJour.ProjInvoiceProjId == projTable.ProjInvoiceProjId
            {
                //For approving Invoice proposals
                projProposalJour.LineProperty = ProjLinePropertyCode::Approved;
                projProposalJour.update();
                //For Posting Invoice Proposals
                projFormLetter = ProjFormLetter::construct(DocumentStatus::ProjectInvoice);
                projFormLetter.createParmLine(projProposalJour);
                projFormLetter.run();
                //To get latest record
                projProposalJour = projProposalJour::find(projProposalJour.ProposalId);

                info(strFmt("Invoice ProposalId: %1 \t InvoiceId: %2",projProposalJour.ProposalId,projProposalJour.ProjInvoiceId));

            }

            ttsCommit;
        }

Really appreciate any assistance greatly.

thanks.

Quick Links

Leaderboard