cancel
Showing results for 
Search instead for 
Did you mean: 

COGS vale different in sale order and billing document

former_member595952
Participant
0 Kudos

HI!

  I am facing a problem that, i create a sale order and delivery order but when i create the billing documents and check the COGS value there is different in both one. In sale order level COGS vale is 100 but in the billing document level the value of COGS is 102.  I like to know how it is possible i means reason of this change and now how i can solve it.

Regards

Khan

Accepted Solutions (1)

Accepted Solutions (1)

jignesh_mehta3
Active Contributor
0 Kudos

Hello,

If the Material Price is calculated on Weighted Average basis, then this is possible.

Because when you created Sales Order, the moving average price was 100 but after that your Procurement department may have purchase some more quentity if same material at higher price, thus the moving average Price moves up.

So if a inward good moment is done in between creating Sales Order & Invoice then it is possible that moving average prices has changed.

Thanks,

Jignesh Mehta

Answers (3)

Answers (3)

Lakshmipathi
Active Contributor
0 Kudos

Go to the condition tab of the billing document, select the VPRS condition type and click on blue lens at the bottom left. 

If the condition control field is set to

·         'H',  the cost was taken from the goods issue

·         'A',  it was redetermined from the valuation segment of the material master

·         in case of 'D' or 'E'  it was copied from the preceding document

G. Lakshmipathi

Former Member
0 Kudos

Hi Muhammad,

If Sales order creation date and  Billing  creation date is different then it may be effect with Cost of Material. If material is created with moving average price then price varies on average basis.

hope it may helpful

Former Member
0 Kudos

Are you talking about the Cost (VPRS) ?

former_member595952
Participant
0 Kudos

Yes it is VPRS