Report to calculate unit cost

cavalcanti_space
cavalcanti_space Member Posts: 49
edited 2009-06-15 in NAV/Navision Classic Client
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

Comments

  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    There is no need to create some report for this, i think Sales analysis can be used for this.
    Kapil Khanna
  • cavalcanti_space
    cavalcanti_space Member Posts: 49
    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

Categories