cancel
Showing results for 
Search instead for 
Did you mean: 

Sales order price vs Invoice price - Difference mitigation

vish_24
Explorer
0 Kudos

Dear Gurus,

I am dealing with a situation on my project. Please refer to below screen shots.

1. Sales order was created in Jan 2021. Sales order Price is calculated cost (EK02) standard price from material master (Accounting 1) + Mark up = 5033.05

2. Part is manufactured in the month of Aug 2021

3. Before delivery in the meantime, part material standard price is changed in Aug 2021 = USD 3875.33

4. Delivery is created after material master standard price is changed. So delivery accounting document is picking up latest new standard material master price.

5. Invoice is created. So it is also picking up new price. That is USD 3875.33 + Mark up = USD 6781.83

Since business already committed Sales order price to customer, we need to stick to the same price (Jan 2021 month price) and not new changed price in material master.

Gurus how we can achieve this in a standard way. I am also showing here the current VTLA screen shot below

Could we achieve this by changing routine with other standard one (which one?) OR do we need to develop a new routine.

Kindly help with your inputs/suggestions.

Regards

Vishwas

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

Not sure how your pricing procedure is set up currently. In standard, EK02 would be placed at the bottom step after PR00 and is set to statistical. This being the case, how are you determining your price? In fact, EK02 is only a Cost and Not a Price. Also, technically speaking, condition types like EK01 / EK02 / VPRS would store all the overhead costs and obviously, the buyer should have some minimum profit margin to this overhead cost. Having said that, is your client selling to internal customer (STO) or external ?

vish_24
Explorer

Thank you Lakshmipathi.

Below are my answers to your points-

1. EK02 cost we are taking as price in the Sales order and adding 75% mark up on it for profit.

2. Selling to an external customer.

To add in this, i have resolved this issues in below way and tested in Sandbox -

In copy control Sales order to Delivery (VTLA), under Item section > Data transfer tab, I have changed Business data '2' to '101. And tested the scenario.

Sales order created (back dated) with standard material cost EK02 (x)> changed standard price (Y) in material master > created delivery in current date (in delivery accounting document EK02 is showing correctly X price. it is not taking changed material master price Y) > created invoice which shows X value in invoice

So by changing business data in copy control system is behaving correctly. Actually i am a bit surprised with this but what client required is fulfilled.

Regards

Vishwas

Answers (1)

Answers (1)

sreemohan
Active Participant
0 Kudos

Hi Vishwas,

Please check in transaction VTFL, against pricing type if it’s maintained as ‚G‘ as in standard settings. This would copy the sales order price to the invoice.

Regards

Sreemohan

vish_24
Explorer
0 Kudos

Thanks Sreemohan.

VTFL has G on it for price type. But we had issue change of EK02 price in material master, which was reflecting in delivery accounting document. So VTLA worked for me by changing business data in copy control.

Regards

Vishwas

vish_24
Explorer
0 Kudos

Hi Sreemohan,

If i keep pricing type 'D' instead of 'G', will it not copy pricing from Sales order. Sorry for my earlier wrong msg. In VTFL we have pricing type 'D'. The issue is yet not resolved.

D - Copy pricing elements unchanged

G- Copy pricing elements unchanged and redetermine taxes

Regards

Vishwas