Tuesday, 29 March 2016

To get Customers total amount Transaction using X++ Code


static void CustOpenTrans(Args _args)
{
     CustTrans custtrans;
    CustTable custtbl;
    while select custtbl
    {
    select sum(AmountMST) from custtrans where custtrans.AccountNum == custtbl.AccountNum;
        info(strFmt("Customer - %1  Amount - %2",custtbl.AccountNum,custtrans.AmountMST));
    } }
Posted by at
Labels: ,

6 comments:

  1. Unknown8 May 2016 at 10:19

    Hi Rajendra, I want to find find the name of customers with the total transaction amount less then a specific amount for instance amount less the 10000 how should I modify this query to suit my requirement. Can you please help ?

    ReplyDelete
    Replies
    1. Rajendra Chilukuri8 May 2016 at 23:27

      Thanks for viewing my blog !!!!

      just add
      select sum(AmountMST) from custtrans where CustTrans.AmountMST < 10000 && custtrans.AccountNum == custtbl.AccountNum
      This may helpful for you

      Delete
    2. Unknown9 May 2016 at 02:44

      Hey thanks for replying I tried this earlier as well but it gives negative values as well. Can we do it only using CustTrans and also remove negative values without using if clause ?

      Delete
    3. Rajendra Chilukuri9 May 2016 at 07:08

      Hii Pranay
      try this once
      select sum(AmountMST) from custtrans where CustTrans.AmountMST > 0
      && CustTrans.AmountMST <10000 && custtrans.AccountNum == custtbl.AccountNum ;

      Delete
  2. Rajendra Chilukuri9 May 2016 at 05:49

    This comment has been removed by the author.

    ReplyDelete
  3. Unknown20 July 2018 at 16:52

    who to print the sum of amount for each accountnum from CustTrans

    ReplyDelete

Subscribe to: Post Comments (Atom)