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%.
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
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.
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.
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.
Can someone help me with these two issues pleae?
Best regards
DNC
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:
Customer environment:
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?
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?
André Arnaud de Cal...
291,979
Super User 2025 Season 1
Martin Dráb
230,848
Most Valuable Professional
nmaenpaa
101,156