Report to calculate unit cost

cavalcanti_space

Hi guys,

Does anyone have any ideas how I can build a report to calculate the unit cost of item per day.
I need to group the item per day and display the unit cost.
The "average cost calc type" is set to: item and the average cost period is set to: day

Any help would be much appreciated.

Cheers

Edson

kapil4dynamics

There is no need to create some report for this, i think Sales analysis can be used for this.

cavalcanti_space

But it does not let me display the unit cost per day.
like this

date

---

item--unit cost
01/01/08---a1

---

120

---

a2

---

130

---

a3

---

115
02/01/08---a1

---

130

---

a2

---

131

---

a3

---

115
03/01/08---a1

---

130

---

a2

---

132

---

a3

---

115

sorry for the dashes, but the browser messes up the post if i leave blank instead