Skip to main content
Solved

SOMTRLV - Positive/Negative variance of Direct Material Cost


Harsha Siriwardhana
Hero (Former Employee)
Forum|alt.badge.img+8

Does anyone have an idea about transaction SOMTRLV (Positive/Negative variance of Direct Material Cost)?

What triggers this transaction?

What is its actual impact on Inventory Value and the GL?

Can we prevent this transaction from being triggered?

Best answer by Tharindu Illangasinghe

Hi ​@Harsha Siriwardhana,

 

The SOMTRLV transactions are recorded in Shop Orders when there is a variance in the Material Cost.

 

Basically, when the Standard Cost of the Material in the Shop Order differs to the Actual Cost of the Materials used in the Shop Order. This is to balance the over/under cost of the materials used in the Shop Order.

 

In the below Shop Order, you can see that the Standard Cost of the Material is “10”. The Qtys of manterial needed is “1”.

 

However, I have over issued material to this Shop Order (Issued “5” qtys). So, the Actual Cost of Material is “50”.

 

Now, when I Receive and Close the Shop Order there is an excess of 40 (i.e., “50” - “10”). So, to balance the books a “SOMTRLV- - Negative variance of Direct Material Cost” transaction has been created.

 

This does not affect the Inventory Value of the manufacturing part, since you are using Inventory Valuation Method as “Standard Cost”.  

 

However, the GL will get updated once the Inventory Transaction SOMTRLV- bookings are passed to a Voucher and the same is posted to the GL.

 

Harsha Siriwardhana wrote:

 

Can we prevent this transaction from being triggered?

I’m not sure why you want to prevent this, since this is required from the accounting point of view. Also, it is not incorrect such transaction getting created.

 

(Note that, when using Valuation Method as “Weighted Average” such transactions will not get created. But…. that is not a remebdy though a differnt mechanism for cost calculation)

View original
Did this topic help you find an answer to your question?

3 replies

Tharindu Illangasinghe
Superhero (Partner)
Forum|alt.badge.img+15

Hi ​@Harsha Siriwardhana,

 

The SOMTRLV transactions are recorded in Shop Orders when there is a variance in the Material Cost.

 

Basically, when the Standard Cost of the Material in the Shop Order differs to the Actual Cost of the Materials used in the Shop Order. This is to balance the over/under cost of the materials used in the Shop Order.

 

In the below Shop Order, you can see that the Standard Cost of the Material is “10”. The Qtys of manterial needed is “1”.

 

However, I have over issued material to this Shop Order (Issued “5” qtys). So, the Actual Cost of Material is “50”.

 

Now, when I Receive and Close the Shop Order there is an excess of 40 (i.e., “50” - “10”). So, to balance the books a “SOMTRLV- - Negative variance of Direct Material Cost” transaction has been created.

 

This does not affect the Inventory Value of the manufacturing part, since you are using Inventory Valuation Method as “Standard Cost”.  

 

However, the GL will get updated once the Inventory Transaction SOMTRLV- bookings are passed to a Voucher and the same is posted to the GL.

 

Harsha Siriwardhana wrote:

 

Can we prevent this transaction from being triggered?

I’m not sure why you want to prevent this, since this is required from the accounting point of view. Also, it is not incorrect such transaction getting created.

 

(Note that, when using Valuation Method as “Weighted Average” such transactions will not get created. But…. that is not a remebdy though a differnt mechanism for cost calculation)


Harsha Siriwardhana
Hero (Former Employee)
Forum|alt.badge.img+8

Hi ​@Tharindu Illangasinghe 

 

Thank you for your detailed explanation, which guided us in investigating the costing method of the specific inventory parts. As you mentioned, we mistakenly configured one of the inventory parts with ‘Standard Cost.’

I truly appreciate your help.

 

Best regards,
Harsha


Tharindu Illangasinghe
Superhero (Partner)
Forum|alt.badge.img+15

You are welcome ​@Harsha Siriwardhana 😊


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings