web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Cost Amount (Actual) with VAT - Average costing method

(0) ShareShare
ReportReport
Posted on by 55

Hi All!

I have a question regarding how the Cost Amount (Actual) is calculated.

The problem is that apparently Nav is calculating the Cost Amount (Actual) with VAT.

Is this correct? Shouldn't the value be without VAT?

For example:

Product: A

Only receive a Purchase Order:

Qty. - 10

Unit. Cost (without VAT) - 1

Total without VAT - 10    Total with VAT 12.3

=>Cost Amount (Expected) = 10

=> Cost Amount (Actual) = 0

 ---

When I post the purchase order the values are:

=>Cost Amount (Expected) = 0

=> Cost Amount (Actual) = 12.3

And the average cost is calculated with VAT.

Is this a configuration? I just want the costs without VAT.

Is this situation familiar to anyone?

Thanks a lot!

 

 

*This post is locked for comments

I have the same question (0)
  • mmv Profile Picture
    11,471 on at
    RE: Cost Amount (Actual) with VAT - Average costing method

    Hi,

    I don't think there is any setup for this.  What you could do is:-

    1. Create a Purchase Order.

    2. Select the Item and enter the other details like, Quantity, "Direct Unit Cost" etc.

    3. Check the "Unit Cost" on the line.  It has to be excluding VAT. 

    If the "Unit Cost" shows a value which is Incl. VAT, it means that the issue is at the Purchase Order itself.

    Is there any customization?

    Best Regards,

    MMV

  • Suggested answer
    serendipity Profile Picture
    1,010 on at
    RE: Cost Amount (Actual) with VAT - Average costing method

    Hi,

    You might want to check if you modified these fields as standard NAV would always have the Cost Amount (Actual) field expressed net of VAT.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Saurav.Dhyani Profile Picture

Saurav.Dhyani 2 Super User 2025 Season 2

#2
RK-25090803-0 Profile Picture

RK-25090803-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans