In CJI3 after consumption of Material INVENTORY IS NOT DEBITTING

[Former Member]

User is Making good Issue through MB1A Movement - 221 Q

After that Actual is coming as Consumption of Material in CJI3

But The Inventory account is not getting debited in CJI3. (Cost is reflecting at both the places in Inventory as well as Consumption in CJI3 )

Double actual cost is getting posted.

But when I check the Value of Stock after Consumption in MB52 there the value of stock is reducing as soon I make the Good issue. (Through MB1A 221 Q)

It is happening only in One material Code.

GL & Cost Element are all there in that company code. Linked with that material.

[former_member203108]

When you do the Goods issue, Inventory will get credited and consumption will be debited.

But you are saying "inventory is not getting debited", Also i referred your earlier and as per that I can see following entries are shown in CJI3

CJI3 SHOWING 10 QTY AMOUNT 100   - Invetory Debit during GR

NOW WHEN WE DO MB1A 221 Q ON THAT SAME WBS Z500.D

COMSUMPTION GOT BOOK.

MB52 SHOW 0 VALUE AS NO STOCK IS THERE AFTER CONSUMPTION.

BUT NOW IN CJI3

INVENTERY COST REFLECT AS 100 QTY -10 - Invetory Credit during GI - You mean to say value is not in negative but quantity is in negative?

CONSUMPTION COST AS 100 QTY 10 - Consumption Debit during GI

Screenshot will help here.

[Former Member]

Dear Sir,

While GRN Inventory got Credited but after consumption Inventory is not getting debited in CJI3 (Debit entries are missing in CJI3)

I have analysed One More Thing While making GRN the Inventory Came in Gl (208040) in valuation class.

after GRN someone changed the GL in OBYC in this valuation class and Used new GL (208050)

Now the Inventory Exist in GL 208040.

But after MB1A 221 Q., when I see the accounting Document ( the new GL 208050 got debited )

and Credit account is the Consumption account.

But in CJI3 I am Not getting the any debit entry Not even New GL and Not even the old GL.

I know there is a mistake that no one should change GL in OBYC after good receipt.

If some one has changed the GL after good receipt then while consumption posting, the previous GL will not get Debit.

But as in accounting document we can see that after Consumption new GL got debited but why this debit entry is not reflecting in CJI3.

[Former Member]

Dear Rahul,

Have you tested Gerry hodgins solution hope this will fix your problem.

please try this option

regards

Deepak

[Former Member]

I Think If I was getting error for all material then I need to try that If i am Getting error for one material only then i Think those all settings are.

[Former Member]

There * is used instead of 115

[former_member203108]

Check if Cost elements are created for New GL.

[Former Member]

That New GL was Inventory Balance Sheet GL.

[former_member203108]

You can still create it. Check with your FICO consultant. How do you expect to flow cost to WBS without a cost element.

[Former Member]

All the Inventory GL are not linked with any cost element and cost is flowing to WBS. We have around 20 Inventory GL every where cost flow o WBS withou any cost element even in this case also the Old GL Inventory came and Budget was checked without any cost element even in New GL the consumption account got credit and budget was consumed only in absence of Debit entry Budget got consumed twice.

[gerry_hodgins]

Hello Rahul Jha

I believe this question might be better answered in the MM forms , CJI3 just reads from the

tables it does no manipulation of data

Also  take note that the 221 Q is NOT a transfer posting, but
a goods issue for project stock.

If you check the technical name for the field in MIGO item overview, the
WBS Element field is GOITEM-PS_PSP_PNR.

While in item detail, tab "Where", the WBS Element field technical name
is "GOITEM-MAT_PSPNR". They are different fields.

For the two fields "GOITEM-PS_PSP_PNR" and "GOITEM-MAT_PSPNR":

1. "GOITEM-PS_PSP_PNR" is an account assignment field and is filled when
   you perfrom a consumption posting with a WBS-element as the account
   assigment i.e: a 221 posting with normal stock.

2. "GOITEM-MAT_PSPNR" is a stock indicator and would be filled.

   i.e: 221 Q posting with special stock Q in your case.

When you issue material from project stock, the general assumption must
be, that this consumption goes to the very same  project.

Reason is that many users use non-valuated project stock.

This means that the stock was already accounted to the project (MAT_PSPNR) when the
Q-stock was created. If you now consume it with a different WBS-element,
you would consume it for free and the costs stay with the MAT_PSPNR.

I hope this information helps ..

Ger

[Former Member]

Hello Mr. Hodgins

I do understand the this explained by you above.

It is happening with all the material in our system.

Except in one material

I purchsed 1 material in WBS Z500.D

COST OF THAT MATERIAL IS 100 Rs. Qty 10

CJI3 SHOWING 10 QTY AMOUNT 100

NOW WHEN WE DO MB1A 221 Q ON THAT SAME WBS Z500.D

COMSUMPTION GOT BOOK.

MB52 SHOW 0 VALUE AS NO STOCK IS THERE AFTER CONSUMPTION.

BUT NOW IN CJI3

INVENTERY COST REFLECT AS 100 QTY -10

CONSUMPTION COST AS 100 QTY 10

THE THING IS THAT IN CJIE

TOTAL COST OF 200 IS REFLECTING BECUASE

CJI3 IS NOT GETTING THE DEBIT ENTRY OF INVENTRY

BUT WHEN I CHECK IN MM REPORT THERE THE STOCK HAS GOT DEBITTED.

WHAT YOU EXPLAINED ABOVE IS A REGULAR CASE

BUT I M GETTING AN ERROR

[gerry_hodgins]

Hi Rahul Jha

In the Standard the the settlement receiver posting can unintendedly update the WBS element with statistical actual values

This is becasue of the configuration of the system

In trasnaction SPRO

-> Financial Accounting (New)
   -> Asset Accounting
      -> Integration with the General Ledger
         -> Additional Account Assignment Objects
            -> Specify Account Assignment Types for Account Assignment Objects

and click the 'Execute' icon to the left of the last item.

Select "generic" company code '*' and double click on 'Depreciation area'.

Select area 1 and double click on 'Account assignment objects'.

Have a look at the row with  AcctAsgnOb = PS_PSP_PNR   TTy = 115 ,

Account Assignment Type = 01 for which the AcctAssgnt indicator is  f l a g g e d .

This means: Postings with transaction type 115 are also
   statistically posting to the WBS elements referencd
   in the assets 'Origin' tab (see step (1))!

This  is why the settlement receiver postings to FXA
       (unintendedly) also statistically post the WBS elements again  causing unintended high actual/assigned values!

See note 684659 for details,

I hope this is more helpful

Ger 

[Former Member]

This message was moderated.

[kenmelching]

On the material master for the one problem material look at the Accounting Views and see if the material is set to Standard Cost or Moving Average.

Also, what type of stock are you specifying on the Project Definition?  Valuated or Non-Valuated Project Stock.

[Former Member]

We r Using Valuated Stock in Project Definition. and its on Moving Average Stock.

Dear Sir,

I have analysed One More Thing While making GRN the Inventory Came in Gl (208040) in valuation class.

after GRN someone changed the GL in OBYC in this valuation class and Used new GL (208050)

Now the Inventory Exist in GL 208040.

But after MB1A 221 Q., when I see the accounting Document ( the new GL 208050 got debited )

and Credit account is the Consumption account.

But in CJI3 I am Not getting the any debit entry Not even New GL and Not even the old GL.

I know there is a mistake that no one should change GL in OBYC after good receipt.

If some one has changed the GL after good receipt then while consumption posting, the previous GL will not get Debit.

But as in accounting document we can see that after Consumption new GL got debited but why this debit entry is not reflecting in CJI3.