Wrong account getting DR and Credit when doing MR22

[Former Member]

Hello experts

When we did MR22 for inventory value adjustment ,credit and debit went to the same account.

The actual result should have been credit to the account which is debited right now i.e 7*****

and credit to a balance sheet account 1*****

Can anyone guide on how to check and solve this?

Thanks

[Former Member · Accepted solution]

Hello Friends

I have found out the reason for wrong entries getting posted from MR22

Well , the entries are actually correct because the material for which price change was done has 0 quantity at present therefore , system could not see any stock to adjust and it skipped the BSX entry and instead posted PRD entry.

Thanks for all who guided me.

[Former Member]

Hello Friends

We still have no resolution , as to why our entries are going like

PRD Debit

UMB Credit

Any inputs from anyone ?

[Former Member]

Thanks for all your reply

But i checked in Valuation class PRD and the accounts for debit and credit are same.

And now when i checked UMB , only one account is maintained.

Now we want the a stock balance sheet account to be credit and cost inv value adj to debit

But in this case in MR22 , "Cost inv value adj" account is getting dr and Cr

[ankurch]

Hi Ankita,

So you added one more account to transaction key "UMB"

That is what you want to say!!!

[Former Member]

I just checked and found that Dr entry is coming from PRD and Cr entry is coming from UMB.

Any idea , why so ?

[ankurch]

While Posting Debit/Credit Material the accounting entries will be generate from transaction/event Key - UMB & PRD

The entries will be updated if you minimize the cost of the material -

The account from UMB will be Debited

The Account from PRD will be credited.

Please check whether you assigned the same GL in UMB & PRD for your issue.

Thanks & regards,

Ankur Chauhan

[Former Member]

UMB is getting credited and PRD is getting debited.

Same account is assigned in UMB and PRD.

[ankurch]

Ankita,

Lets take an example suppose -

As per your scenario you need to increase the value of your material A.

In that case the accounting posting will be if you maintained price control "V" (Moving Average Price)

The entries will be Stock A/C Debited & Price Difference A/C Credited.

Please consider the FI consultant which account needs to assigned or you can check at your end by "FS00"

Thanks & regards,

AC

[Former Member]

Thanks Ankur

I understand , what you are saying

But I am not able to understand that why UMB is getting credited and PRD is getting debited

Trying to figure out that

[ankurch]

For your case as per your provided input I can say that your material has price control "S"(Standard price) where any additional different will be posted to price difference account & here you are doing debit/credit Material in that case material valuation UMB will be updated.

It is standard behavior.

If you maintained price control "V"(Moving Average Price) than your entries will be -

89      Raw material              BSX     S(Debit)

93      Material Valuation       UMB     H (Credit)

[Former Member]

Really appreciate your inputs

But for the concerned material , Price control is maintained  as V.

[ankurch]

Hi Ankita,

Please check first your valuation class in material master, than subsequently check OBYC configuration for the same valuation class -

For e.g. -

Inventory A/C + Which is configured through BSX

B.S. GL -  Which maintained in transaction key "UMB" with valuation modifier for your AAC.

Thanks & regards,

Ankur Chauhan

[Former Member]

Hi Ankur

Thanks for reply

But , i checked BSX and UMB.

BSX is having a inventory account maintained and UMB has BS GL account.

But still the system is taking same account in debit and credit i.e BS GL account

when doing MR22.

Any idea why ?

[Former Member]

Hi Ankitha,

You might have assigned same GL account for both credit as well debit...please check in obyc configuration for the UMB transaction key and Valuation class...

Regards,

Skanda.

[former_member206852]

Dear Ankita

Whether it is MR21 or MR22, in both the cases, system picks the material GL (Balance Sheet Asset GL ) from material master (BSX) and the subsequent Debit/Credit from OBYC-->UMB (Which will be P/L Expense GL).

It seems there is some issue with your configuration, as system will issue error message if UMB settings are missing.

Let me know if you still have any queries?

Best Regards

Syed Zia Abbas

[Former Member]

Thanks for all your reply

But i checked in Valuation class PRD and the accounts for debit and credit are same.

And now when i checked UMB , only one account is maintained.

Now we want the a stock balance sheet account to be credit and cost inv value adj to debit

But in this case in MR22 , "Cost inv value adj" account is getting dr and Cr