Steps to calculate Average Cost in Navision

1) At item card, click on Item –> Entries –> Value Entries to open the value entries screen.

2) Copy all records in the value entries screen to Excel.

3) In the Excel sheet, sort the records by Valuation Date.

4) Add a column called Cost Amount to the Excel sheet. Cost Amount = Cost Amount (Expected) + Cost Amount (Actual). Use Excel formula to populate the Cost Amount column for all records.

5) Add a column called Cost Amount (Accumulated). As indicated by the column name, it is the accumulated value of Cost Amount from first record to the last record. Again use Excel formula to populate this column.

6) Add a column called Quantity (Accumulated). Quantity (Accumulated) is the accumulated quantity from first record to the last record. Use Excel formula to populate this column.

7) Add a column called Avg. Cost. Avg. Cost = Cost Amount (Accumulated) / Quantity (Accumulated).

8) Now, look for the last inbound entry record for each Valuation Date. The Avg. Cost for the last inbound record for each valuation date is the average cost for the day.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s