Re: Determining net profit for month.

Posted by Sue Sloan on August 25, 2004 at 10:48:55:

In Reply to: Determining net profit for month. posted by Brian Cummings on August 24, 2004 at 17:09:15:

: How can I instruct ODP to add up total product sales for the month and subtract the total product cost (using the cost figures I've entered into the product worksheet)?
: Ideally, I would like to edit the "Sales Summery by Month" report to include number of products sold, total product sales (gross less tax and shipping), and total cost of product.

In ODP V2, that report is based on the order database (ordhead), and the numbers you want are in the order items (ordetail) database. Here are some calculated fields you could add to the report:

Auto_Sum_of_OrderSubTotal is the total without shipping/tax.
Auto_Sum_of_UnitsOrdered is the total quantity of the items.

To get the total cost you would need to first add a calculated field to get the cost for each order item, then a summary of that field:

LineItemCost = ordetail.UnitsOrdered * products.COST
Sum_LineItemCost = SSum(LIneItemCost)

Add the fields to the report in question's summary panel(s).

Note that ODP Version 3 contains reports that give you profit by product. It does not give you a monthly total other than you can get "this month", "Last month", "this year" and "last year" reports. And you can set the date to be assumed for "today" and that adjusts the other reports such that you can get any month or year you want.

Sue Sloan

Follow Ups:

• Re: Determining net profit for month. Brian Cummings 8/25/4 (2)
  • Re: Determining net profit for month. Sue Sloan 8/25/4 (1)
    • Re: Determining net profit for month. Brian Cummings 8/25/4 (0)

Post a Followup

Name    : 
E-Mail  : 
Subject : 

Comments:
: : How can I instruct ODP to add up total product sales for the month and subtract the total product cost (using the cost figures I've entered into the product worksheet)? 
: : Ideally, I would like to edit the "Sales Summery by Month" report to include number of products sold, total product sales (gross less tax and shipping), and total cost of product.

: In ODP V2, that report is based on the order database (ordhead), and the numbers you want are in the order items (ordetail) database. Here are some calculated fields you could add to the report:

: Auto_Sum_of_OrderSubTotal is the total without shipping/tax.
: Auto_Sum_of_UnitsOrdered is the total quantity of the items.

: To get the total cost you would need to first add a calculated field to get the cost for each order item, then a summary of that field:

: LineItemCost = ordetail.UnitsOrdered * products.COST
: Sum_LineItemCost = SSum(LIneItemCost)

: Add the fields to the report in question's summary panel(s).

: Note that ODP Version 3 contains reports that give you profit by product. It does not give you a monthly total other than you can get "this month", "Last month", "this year" and "last year" reports. And you can set the date to be assumed for "today" and that adjusts the other reports such that you can get any month or year you want.

: Sue Sloan


Optional Link URL:  
Link Title:         
Optional Image URL: