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 :
Finance | Project Operations, Human Resources, ...
Unanswered

Project Cost and Sales price when invoice amount is overtyped

(0) ShareShare
ReportReport
Posted on by

Hi,

We have config in our system so sales prices for items = cost price on the project transaction.

We are seeing an issue where the invoice amount has to be overtyped due to the 2 decimal places on quantity not being enough to calculate the correct invoice amount from the PO. 

Say as an example we create a PO with quantity of 1 and price of £1000

The invoice then comes in under this amount for £798.69 which is 0.79869 of the unit quantity. As AX does not allow us to enter this many decimal places we can only enter 0.79 or 0.8 and then overtype the value. 

For this example we will pick 0.79 as the unit quantity. When we do this the system records the cost price as the overtyped value Â£798.69 but the sales price as 0.79 Â£790 (1000 * 0.79)

This means when we bill this item on to a customer we make a loss of £8.69 we should be passing on at 100% of the cost price. 

Does anyone know of any config to stop this or is is a bug I should report to MS? We are currently on 10.0.20

Thanks

Dave

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    299,361 Super User 2025 Season 2 on at
    RE: Project Cost and Sales price when invoice amount is overtyped

    Hi Dave,

    If this is a service item (non-stocked), have you considered switching the quantity and the price on the order lines? You can have 1000.00 quantity for £1. Then you can post 798.69 quantity and don't get the loss due to rounding.

  • Dave C Eng Profile Picture
    on at
    RE: Project Cost and Sales price when invoice amount is overtyped

    Hi André,

    Thanks for the suggestion it is for services. Unfortunately we have suggested this previously but it just isn’t how peoples minds work they want to see the value for the service as quoted.

    We do encourage them to use hours as the unit and an hourly value if it can be broken down this way.

    9/10 the invoice comes in for PO value which was what was quoted for the service but it’s just the odd one that comes in for another value.

    It does seem like a bug that the system is using one value for cost price and another for sales price! Especially when the config says sales price = cost price.

    Might take it up with MS see what they say.

    Thanks again

    Dave

  • André Arnaud de Calavon Profile Picture
    299,361 Super User 2025 Season 2 on at
    RE: Project Cost and Sales price when invoice amount is overtyped

    Hi Dave,

    I do understand switching the numbers would require some additional thinking from the users. In the past, I made a customization where the quantity and price fields were replaced with edit methods. Based on a setting, it stored the quantity in either the quantity field or the unit price and the same for the price. Then for thenuser it was looking thensame, but it was switched on table level.

    Let us know when Microsoft provided you with an update.

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,047

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 885 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 592 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans