Although you have to provide the detail requirement,but it seems like your Client wants some Sales Forecasting system which will help them to plan and monitor the future sales along with a analysis of past and present sales data.
for example, we produce TV,and we make a sales plan to sale 1000 TVs in the begin of a month, and the selling expenses is 500$. At the end of the month, we will check the plan's completion and how the selling expenses is spent.
At the end of the month, we will check the plan's completion and how the selling expenses is spent.
If that is the case ,You can create One Z- report by SQVI with according to your requirement .In that report will show you the Month End activities of Expensive's Like If you create 10 Sales Order ,for 10 sales Orders ,If you create 10 Billing Documents then these 10 Billing doc costs are your selling expensive's of particular month .In that report will show,each billing doc having how much Net Value and Tax Value like all details .If add all Billing doc amounts then obviously you will get a big amount ,this big amount is your Selling expensive per month.
If you are running COPA you could use it. What do you define as sales expenses? A SD condition or amounts in FI accounting?
In COPA you can transfer value fields from SD, MM and FI to COPA (real amounts) and you can plan amounts (plan amounts) according characteristics in different versions. After you can report the differences designing your own reports with customizing tools (report painter).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.