cancel
Showing results for 
Search instead for 
Did you mean: 

Incorrect COGS for vendor consignment stock

Former Member
0 Kudos

Dear Gurus:

I found this problem during User Acceptance testing, two and a half weeks away from Go-live date.

Requesting immediate support.

Conditions:

Sales Order currency = USD

Selling price = 200 USD

Material Internal Price (COGS) - condition type VPRS = 100000 IDR

Material on stock is a vendor consigned material.

Problem:

When executing Post Goods Issue for the delivery of a vendor consigned material with the above conditions, system defines the COGS by taking the nominal value but assigns currency USD, instead of IDR. In other words, system shows COGS as 100000 USD, instead of 100000 IDR.

Therefore, the COGS becomes incorrect and resulting in very large value.This problem does not happen when the material consumed by the PGI is from unrestricted stock (not vendor consigned material).

Steps to reconstruct the problem:

Create Material with Moving Average Price in IDR.

Create Customer with currency USD.

Create Purchasing Info Record for Consignment of the Material with price in IDR.

Create stock for the material as vendor consignment.

Create sales order with currency USD using customer and material above.

Create delivery, perform picking and PGI.

Display the accounting document resulting from the PGI.

Check the resulting COGS.

The amount shows the nominal amount from the material internal price but with incorrect currency.

As comparison, do the same as above for material taken from unrestricted stock, instead of from vendor consignment stock. Check the resulting COGS. The amount should be correct.

I would really appreciate any help and suggestions.

Best regards

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos
COGS becomes incorrect and resulting in very large value.  This 
   problem does not happen when the material consumed by
     the PGI is from unrestricted stock (not vendor consigned material).

Check the vendor master what currency is maintained.

thanks

G. Lakshmipathi

Answers (0)