on 12-26-2014 6:40 AM
Dear all,
I want to calculate total gross value of all sales order of particular Customer.
Suppose i have created one sales order and i have selected one customer XYZ and the gross value of this SO is 20000rs, again i have created a new sales order and this time i have selected same Customer XYZ and the Gross Value of this Sales Order is 30000rs.
now i want to calculate total gross value of both sales order of XYZ customer .
Means I want to calculate total gross value of sales order based on Particular Customer .
Please Help me.
Thanks & Regards,
Manoj Kannaujiya.
Hello Manoj,
When shall this calcualtion start? Triggering on Save of the SO?
Where shall the value be persisted? Own Custom BO, extension field of SAP BO Customer, ...
Bye,
Horst
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Horst,
The above query is solved.
I have another query in Cloud for Customer.
In C4C there is a customer work center - go to account there is a YTD Revenue field.
I want to apply some validation on YTD Revenue.
But i am not finding the YTD revenue field at the time of coding.
Please Help me.
Thanks,
Manoj
Hi Horst,
Thanks for your help.
I fixed that issue.
Please find the following code.
import ABSL;
import AP.CRM.Global;
import AP.Common.GDT;
var NetAmount = 0;
var NetCurrency ="";
if(this.IsSet())
{
var salesOrderQry = CustomerQuote.QueryByElements;
var salesOrderParams = salesOrderQry.CreateSelectionParams();
salesOrderParams.Add(salesOrderQry.PartyBuyerPartyKey.PartyID.content,"I","EQ",this.InternalID);
var salesOrderRes = salesOrderQry.Execute(salesOrderParams);
if(salesOrderRes.Count() > 0 )
{
foreach(var eachSalesOrder in salesOrderRes)
{
var totalValue = eachSalesOrder.TotalValues;
NetAmount = NetAmount + (totalValue.NetAmount.content);
NetCurrency = totalValue.NetAmount.currencyCode;
}
}
this.CurrentCommon.SalesVolume = NetAmount.ToString().TrimRight("0")+" "+ NetCurrency;
}
Thanks & Regards,
SRINIVAS BORRA
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.