Skip to main content

Total Amount of Purchase Order in X++

Method 1: 

public AmountCur totalAmount()

       // PurchLine       purchLine;

        AmountCur       amountCur = 0;


        while select crosscompany purchLine

            index hint PurchLineIdx

            where purchLine.PurchId         == purchtables.PurchId

              && !purchLine.IsDeleted

        {

           // amountCur += purchLine.calcLineAmountExclTax(purchLine.PurchQty );

                

           amountCur += purchLine.calcLineAmount(purchLine.PurchQty + purchLine.ConfirmedTaxAmount );

                

        }

        return amountCur;

Comments

Popular posts from this blog

Change Company

change company helps to chnage the value of our field on the mark of the entity value  suppose you are overding a value in 3005 when you change to 1005 and click button the value changes in 1005 too   class LegalEntityRestriction_FYCDeleteExistingEntries     {         /// <summary>         ///         /// </summary>         /// <returns></returns>         public boolean modified()         {             boolean ret;                      //ret = super();             LedgerParameters ledgerparameter;                  ret = super();             if(LegalEntityRestriction_FYCDeleteExistingEntries.valueStr( ) == enum2Str(NoYes::Yes))   ...

Split Method in X++

Split method is used to split value of a Name or Number using a decimal or comma so that we can separate them and use in fields in report or in form   public static void main (Args args)     {         str _Value,beforeDec,afterDec;         int x;         str str1='Jake,Grey';         Names names;          List strlist=new List(Types::String);         ListIterator iterator;           strlist=strSplit(str1,',');         iterator = new ListIterator(strlist);         while(iterator.more())         {             x= x+1;             if(x==1)             {                 beforeDec =iterator.value();           ...