Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Sales price model: Sales prices not depicted correctly

(0) ShareShare
ReportReport
Posted on by

Hello to everyone,

one of our customers has discovered issues with the sales price model of the project management and accounting model.

If I go to the Invoice journal of the accounts payable model and select account type "vendor" and offset account type "project" I can post the cost price and sales price. For example: In the Contoso environment I have set up the sales price (expense) with a charge percentage of -25.00%.

pastedimage1673016994317v1.png

After that, I typed in in the invoice journal an invoice amount (=cost amount) of 300.00€. With the Formula [ (Cost price* (100+pricing) / 100) = sales price ] I got a sales price of 225.00€. This is right according to this side About sales price models | Microsoft Learn

pastedimage1673022564455v2.png

But if I try the same approach in the environment of our customer, this approach won't work.

For example: I have a sales price (expense) with a charge percentage of -25.00% again.
pastedimage1673023767647v4.png

I post an invoice journal against the corresponding project ID. But the sales price depicted is not right. It states 126.05€ instead of the 150€. It should be 150€ according to the formula in the link above [ (200* (100 - 25.00) / 100) = sales price ]. For some reason it takes in the formula the "Net" cost price of 168.0672€. So 200€/1.19=168.0672€ -> [(168.0672€* (100-25) / 100]= 126.05€ 
Why is it taking the Net cost price in the formula and not the gross cost price? In the contoso environment it always takes the gross cost price in the formula.

pastedimage1673023959159v5.png

Another problem: After posting the invoice journal and trying to make an invoice proposal against the corresponding project ID, I get then the sales amount  94.12€, which is also strange because it deviates from the 126.05€ mentioned above.

pastedimage1673024119394v6.png


Can someone help me with these two issues pleae?

Best regards
DNC

  • DNC Profile Picture
    DNC on at
    RE: Sales price model: Sales prices not depicted correctly

     Andre Arnaud de Calavon : Hello André,

    - 1.19 represents the factor for the sales tax. So we use the factor of 1.19 if we have a sales tax of 19%

    - the gross cost price includes the sales tax. That means: Net cost price / 1.19 = Gross cost price -> 200€/1.19=168.07€

    - if the sales tax is not included in the cost price, I am talking about net gross price -> 168.07€ only

    Yes, sales tax should be included. As you can see in screenshot 3: The cost price is 200€. According to the formula mentioned above last week, the sales price should be 150€ if we have a cost price of 200€. Instead, it shows a sales price of 126.05€. This is because we use in the formula the net cost price of 168.07€, instead of the 200€. But why? In screenshot 3 only the cost price of 200€ has been mentioned.

    This also contradicts to what we have in our own Contoso environment (screenshot 2) where it takes the gross cost price for the formula in order to compute the sales price.

    Any idea here?

    ---

    Ok,
    I have to correct a little bit the posting from before. I have checked the vouchers of the invoice journals in the Contoso environment and in the environment of the customer:

    Contoso environment:
    pastedimage1673258190509v1.png

    Customer environment:
    pastedimage1673258515807v3.png

    So in screenshot 1 it does not take the sales tax. In screenshot 2 it takes the sales tax. How can I set up the system that for the formula it takes the gross cost price of 200€, instead of the net cost price of 168.07€? Or is that not possible?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,979 Super User 2025 Season 1 on at
    RE: Sales price model: Sales prices not depicted correctly

    Hi DNC,

    What exactly do you mean with a difference between a net and gross cost price? Where do you have a factor of 1.19? What is this number about? Maybe it is related to Sales Tax? If so, is the vendor/invoice setup to have the prices including sales tax?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,979 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,848 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans