amount in goods issue for delivery

[former_member598326]

Hello everyone,

I'm trying to solve a problem for some time now and I'm out of ideas so I hope you guys can help me.

The scenario is as follows:

We receive goods in the warehouse on daily basis.
Goods are received in Euros but stored in local currency, so, because of exchange rate, average moving price changes daily.
Goods are sold and issued once a week, on Friday or Saturday but the issue date should be from the Monday of the current week.
We start with sales order, outbound delivery is created, in the background material and FI document are posted and then, based on the delivery, invoice is issued.

In sales order we enter the price manually and that price is copied to invoice.

The problem is the amount used in the FI document posted behind outbound delivery. We need it to be average moving price of material on the issue date (Monday) and the system is using average moving price of material on day of creation of the document (Friday).

How to achieve this?

If I understand it correctly amount from Sales order cannot be copied to delivery.

Is it possible to enter it manually somehow?

Thank you in advance.

Best regards.

B.

[Lakshmipathi]

You can have a look at the logic how moving average price is being calculated from OSS note 1506200. Based on that explanation, you can build the required logic.

[former_member183424]

SAP stores historical data (including MBEW table) month wise not day wise in table MBEWH. So day to day basis moving price is not captured anywhere.

There are no option to enter COGS amount (which is basically calculated from moving price) during posting delivery PGI.

[former_member598326]

Thank you for you answer.

I saw MBEW table and understand that price history is kept on monthly basis, so there's no way to tell the system to take average moving price on specific date for COGS amount.

There's no option to enter amount manually?

[Lakshmipathi]

Not sure what you are talking about. If your requirement is to fetch the inventory cost as on Monday of that week, you can change the service rendered date in sale order or Actual Goods Issue date in delivery

[former_member598326]

Thanks.

I tried do be descriptive but made it more complicated than it is.

"Fetch the inventory cost as on Monday of that week" is a good description.

I tried changing dates in both Sales order and Delivery but it doesn't help, the system is still taking "Friday's" date.

Any other idea?