Amounts posted in GR is different from what is expected

[former_member609157]

Hi!

The net price for 1 piece is 1 USD
when GR is posted, it is expected that gr quantity = gr amount

however, it is displaying more than what is expected.

example:

GR quantity = 6.333,320

GR amount = 405.485,400

acct assignment cat = P so there is no material master saved in SAP.

why is it displaying a different amount?

Really appreciate this if anyone can answer

Thank you!

[lingaiahvanam · Accepted solution]

Hi Crissa,

Please refer to the follwoing SAP note to fix this issue.

https://launchpad.support.sap.com/#/notes/1915844

In the great majority of the cases, the valuation of WRX is correct. You can prove it easily executing the report MBEXPLAINWRX from the note 2139101.
The report explains the valuation logic in the standard system:
For the valuation of the receipts we compare the quantity received so far against the quantity invoiced so far.

• If the quantity we are receiving has not been invoiced yet, then the valuation will be made according to the Purchase Order Net Value.

PO Net Value = Ordered Quantity x PO Net Price
GR Value = GR Quantity x (PO Net Value / Ordered Quantity)

Note: If non-deductible tax exists for the relevant PO Item (there is a value in EKPO-NAVNW) the same should be added to the PO Net Value.
GR Value = GR Quantity x [(PO Net Value + EKPO-NAVNW) / Ordered Quantity]

• If the quantity we are receiving has been invoiced already, then the valuation will be made according to the Clearing value of the invoices:

GRV = Quantity in the posting x (Clearing Value - Goods Receipt Value) / (invoiced quantity - goods receipt quantity)

Note: the Clearing Value of the invoices is not the Invoiced Value but the value posted to the GR/IR clearing account in the corresponding accounting document: Field AREWR in table EKBE.

In case that foreign currencies are involved please check the EKBE-AREWB field.

• If the quantity that we are receiving has only been partially invoiced, the valuation is carried out according to the two formulas above: The quantity which has been already invoiced, will clear the remaining value in the GR/IR clearing account, and the part that has not been invoiced yet, will be valuated according to the PO Net Value.

Besides, it is necessary to take into account if the PO item has the indicator GR-Based IV set or not. Check the KBA 1827732 for further information about this.

When dealing with Scheduling Agreements, refer to KBA 1836227. For doubts about the valuation of reversals and cancellations check KBA 1827734. When different units of measure are involved, check also KBA 1836255.

The valuation of the Delivery Costs follows the same logic explained above. In this case, the values are taken from EKBZ and not from EKBE and the indicator GR-Based IV is not taken into account so the PO history of the Delivery Costs should be considered in chronological order.

Best Regards,

Lingaiah

[former_member609157]

Thanks Lingaiah Vanam

it happens when GR is posted after IR posting and AccM posting for a bigger amount than the difference (example: My PO quantity is 100, I GRed 10 and only invoiced 5 then AccM an amount of 10). The Gr based is not ticked and unfortunately, I cannot see the full article of the note..(it requires me to log-in but doesn't accept my credentials).