cancel
Showing results for 
Search instead for 
Did you mean: 

Invoice reversal issu

Former Member
0 Kudos

Dear Gurus, We created a purchase order for 1 EA @ USD 2000

Then we did invoice for 1 EA @ USD 2000 (GR Based IV unchecked)

subsequently we did another invoice for 1 EA @ USD 3000 and cancelled it immediately(-USD 3000)

Then GR was done for 1 EA, for which SAP has valuated @ USD 2500

It was suppose to be USD 2000 but why SAP took USD 2500 is my question.

Please answer.

Accepted Solutions (1)

Accepted Solutions (1)

former_member183424
Active Contributor
0 Kudos

System will take the price during GR as per only posted invoice, system will take the cancelled invoice at the time of reverse GR.

You have posted two invoices for quantity 2 and amount 2000+3000 = 5000 USD.

So system is taking the amount 5000/2 = 2500 USD at the time GR.

If you will go for the reverse the GR, then system will take the value as 2000 USD because at this time system will take the sum amount of all invoices (posted and cancelled) / Quantity (2000+3000-3000 = 2000 USD).

This is the posting logic for goods receipt without GR based Invoice.

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Dibyendu i now reversed the gr and now it is valuated in usd 2000 as expected. I again rebooked gr and even now usd 2000 taken.

But i wanted to know why system is not considering the invoice canceelled in first is my doubt.please elaborate

Former Member
0 Kudos

Hi Dibyendu,

Thanks i will test it.

All,

This is a service material.

Former Member
0 Kudos

HI Srinath ,

in case of moving average price MAP, every movement , entry of invoices ( for external procured materials ) and order settlkement ( for internal produced materials )changes the material price. the MAP is calculate automatically by the system : inentory value \ inventory quantity.

the system attemps to absord the price variance - if this case exist - into inventopry value. It compares the invoice quantity with current stock quantity  and :

1. if stock quantity ie equal or greater than invoice quantity, the invontory account is then posted with th price variance amount.

2. if the stock quantity is lower than invoice quantity  then the inventory account is posted with an amount calculated on the following formula.

Price variance * ( stock quan / invoice quent ) ---> The deference between total invoice value and the formula calculated value is posted to a price calculation amount .

0 Kudos

Hi Srinath,

This is very basic and simple concept of Material valuation. Please check price indicator it could be MAP hence so. Nothing wrong from system perspective. But your expectation was related to Standard price control in material master record settings.

former_member183424
Active Contributor
0 Kudos

No. System will behave same if you will use standard price.

Former Member
0 Kudos

Hi Srinath,

The material must be having moving average price, hence, as Dibyendu has explained, the valuation of the material has changed after processing GR.

Regards,

Anindita

JL23
Active Contributor
0 Kudos

the moving average has nothing to do with the GR valuation, contrary it is built from it.

Former Member
0 Kudos

Gurus any idea on why ths SAP valuate goods reciept like this