Skip to Content
0
Former Member
Jun 08, 2011 at 03:49 AM

Customer Returns - Inventory Valuation

761 Views

Hi Folks,

I have a business requirement where the inbound delivery should be received at the original material price instead of the current MAP. As of now the system is receiving the item back at the current MAP price. For example:

Goods Issue:

Price = $10, Qty = 5

CR Inventory 50 DR COGS 50

Billing:

CR Customer 50 DR Revenue 50

The MAP changes from $10 to $15 and then the customer returns the goods. The system is currently doing the following:

Credit Memo (Cancel Billing)

DR Customer 50 CR Revenue 50

Goods Return (receive back in inventory)

DR Inventory 75 (New MAP) CR COGS 75

Is there any way to match the return document to the original PGI? This doesnt look like an unusual requirement but our SD consultant says there is no way to do this. is there any way around this?

Thanks