Account assignment in MIRO for moving average price..

[Former Member]

Hi,

We are using moving average price scenario in MM, there is a purchasing order, and good receipt is done.. The price of the incoming invoice is different than the price of PO, normally while entering this invoice over trx MIRO, this different should trigger the stock account, but no stock account appears after using the simulate button, because of this system gives error of PRD key ..

I checked all setting in OBYC for BSX and WRX keys... G/R is already done.. everything is ok..

Any ideas on that problem ?

[Former Member]

.

[raghavendra_praveen]

Hi

Please check OBYC setting for KBS transaction - the posting keys mentioned. They should be 81 and 91. I hope this could be the reason for account type M in MIRO for GL posting.

Thanks

[raghavendra_praveen]

Hi

You have to enter the value equal to that of GR value in item details and difference value (in invoice) directly debiting the material (material tab in IV) then it will go to stock account.

If stock have been consumed then it will go to PRD account.

Thanks

[Former Member]

Thx for your quick answers, problem resolved..

Anıl,

[Former Member]

Hi again,

I did the account assignment for PRD key, the material is not available in stock.. In MIRO trx, when i apply price difference, in simulation, there is no vendor account and VAT account, also doubles the stock account..

I'm sending you the simulation screen, any ideas ?

Pstn Acc Type Post Key Line item ID G/L account Amount

1 K 31 empty empty 69,62-

2 S 86 W 8000800001 58,96

3 M 89 M 1570800001 0,04

4 M 99 M 1570800001 0,04-

[raghavendra_praveen]

Hi

How you are entering the value in MIRO. From the data you posted it indicates that your GR value is 58.96 and crediting vendor 68.92. How you created price difference for the material. If you want to debit/ credit material then post the value in Material tab in MIRO screen (In MIRO - you can see 3 tabs - PO reference, GL reference, material reference). IF material has been consumed it will go to PRD account otherwise hit stock account.

Thanks

[Former Member]

Hi Praveen,

Original PO and GR value is 58,96. But invoice is 59.. so i apply price difference of 0,04 in MIRO item. I made the customization in OBYC for PRD key as you said.. And there is no stock for the material..

As i sent you the simulation screen, the price difference goes to an account of 1570800001 (bsx key), but i connected PRD key to 1570800014.. there is no stock.. PRD key should work but bsx key is working..

what am i doing wrong ?

There is no material or G/L account tab in my MIRO screen, it may be because of patch levels or version or something i dont know...

[raghavendra_praveen]

Hi

Activate direct posting to stock/ material by checking the tabs under MM -> LIV-> incoming invoice -> activate direct postings to GL & material.

Then if there is any diference in invoice value and GR value, enter the difference value under material or GL account (depending on requrement). If stock exists it will go to stock account otherwise will go to PRD account.

Thanks

[Former Member]

Praveen,

I realized something.. I'm trying to post the invoice to December.. I mean invoice date and posting date is 20.12.2008. When i use this date simulation screen is as i told you before..

But when i try to post it to October, system acts normal, and price difference hits the PRD key..

I think there is a problem in material master data.. I checked it for december and october but everything seems normal for accounting 1&2..

What might be the problem ?

thx..

[Former Member]

Hi,

Any idea on that ?

[raghavendra_praveen]

Hi

Please check whether stock exists in the period in which you are posting invioce (check date wise).

If stock exists on invoice posting date it wil go to stock account (difference) otherwise it will go to PRD account.

And also check the currency in which you are posting invoice- if is different from local area currency then exchange rate will be applied (which will go to stock account in local area curency).

And also check your OBYC settings are perfect or not. And let us know how you are applying price difference in invoice? are you changing line item value (is it same as GR/IR credit value) or invoice amount value in IV?

Thanks

[Former Member]

Hi,

12 2008 and 01 2009 MM periods are open.. there is one item in PO, and GR is done to 30.12.2008 by 8 st. After that , all stock for that material is consumed to 03.01.2009 and 08.01.2009 four by four ( i mean first consumption was done at 03.01.2008 by 4 st, and second consumption was done at 08.01.2009 by 4 st)

When i check the material master data for accounting 1 view, for 12 2008 stock is 8 st..for 01 2008 stock is zero..

Currency is the same for all documents and master data..OBYC setting are fine ..

I'm changing the line itme value.. It's not the same as GR/IR credit value..

[raghavendra_praveen]

Hi

By changing the item value in invoice, and entering the posting date before GR date - if you simulate invoice it will go to price difference account as there is no stock to be valuated. If stock exists on posting date of invoice - it will go to stock account/ stock will be valuated (invoice is similar to subsequent debit in that case)

Thanks

[Former Member]

Hi,

I expect the system behave as you told but it doesnt... I'm posting the invoice to the same date as GR done.. There is no stock for period 01 2009, but It seems to be 8 st available stock for 12 2008 period..

When i apply price difference, system debits stock account and credits the stock account again and debits GR/IR account .. there is no vendor account and VAT account in simulation screen.

But when i post invoice any date for 01 2009 period ( which is after the GR date ) everything is normal.. difference goes to PRD account..

[Former Member]

Hi Andem,

If there is no sufficient stock coverage, then it will hit PRD account.

before posting the invoice check the stock.

Regards

Anand