Actuals Sales

(0) Share

Report

Posted on by Community Member

Good day all

I use Microsoft Navision and I use Tableau to do visualizations of NAV

In NAV I am analyzing the Value Entry table that contains columns for sales amount(Actual) , cost amount(Actual), sales amount(Expected), cost amount (Expected) and Expected Cost

Tableau connects directly to my relational tables so the data is raw within NAV. How would I calculated

Actual Sales Amount , Actual Cost Amount, Actuals Net Revenue, Actual Gross Revenue and Actual GP with the about mentioned value columns in the Value Entry Table of NAV

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Alexander Ermakov 28,096 on at

Like (0)

Report

The answer depends on what do you mean by Actual Sales Amount, Actual Net Revenue and Actual Gross Revenue (please provide a numeric sample, as in different countries these concepts vary).

Sales Amount (Actual) would give you the revenue amount, however there is one issue here to remember. Value Entry will give you the sales figures only for those sales that are made when you use items. If you use G/L accounts, Value Entry will not have any records on that.

Imagine a situation when you posted a Sales Order with few items in lines and they are in both G/L Entry and Value Entry. When items arrive to customer, he claimed he is not happy as items arrived late. Your company decided to give him 5% discount after his claim. You will have a correct sales amount in Value Entry only if you reverse fully the initial sales order and then post a new sales order with 5% smaller sales price. Unfortunately, in reality managers are not doing this. They just post a 5% credit memo to reduce customer receivables against sales revenue account, without indicating any items in lines of that credit memo. That results in a funny situation that by Value Entry info you had 5% more sales revenue than actually it is. Keep in mind such possibility.

Thus, I do not like to operate with Value Entry for calculation of revenue by BI tools. I prefer to deal with posted sales invoices and posted credit memos for that purpose as it is more reliable source of revenue info.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I joined the Sales Invoice Header , Value Entry and Customer tables together , as this tables will give me the data to work with in analyzing data for customers per product in my OLAP Cube , in the cube there is lots of calculations done to get to net revenue , gross revenue , cost amount etc.. see a screenshot of my report based on one customer per brand class product. this data is from my OLAP Cube (Warehouse) which gets transformed from NAV into the warehouse. however I am connecting directly to the NAV relations tables to do visualization from the live / raw data to do similar what is done in the OLAP cube and to get to the same values in the OLAP cube ,so the NAV values must correspond to the Cube values. so how would I calculated the Net Revenue, Gross Revenue , Sales Costs as per my OLAP cube

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Problem resolved

Was this reply helpful? Yes No