Skip to Content
0
May 11, 2020 at 04:24 AM

How to use CDS view to generate Sales Allowance Report based on difference in New Sale price and Old Sale price and quantity sold to each customer in particular period?

317 Views

Because of fluctuations in commodity rates, business often offers some Sales allowance to customers. But due to fluctuations in commodity market, brass rate goes down, then total cost of manufacting of that articular FG also goes down.

In such cases, business give Sales allowance to customers periodically.

Now expectation from system is as below:

System should generate Sales Allowance report based on difference in New Sale price and Old Sale price and quantity sold to each customer in particular period.

So that Business comes to know about allowance they are supposed to pay to customers.

How can customer achieve that through CDS view?