Movement Type 101 - 102

[#1]

Hi All,

In inventory 2LIS_03_BF extractor brings movement types how sgould they be handled in the transformation/update rules? Example movement type 101 is GR into valuated stock and 101 is GR reversal. When calculating valuated stock there are inbound and outbound, and the inbound is total receipts and outbound is Issues, so it calculates the valuated stock. But there are two movement types for receipts itself (inbound, outbound). Should inbound be added and outbound be subtracted for receipts?

Something like.

if movement t ype = 101

receiptqty = receiptqty + qty (comes with 101 type)

endif.

and if movement type = 102

receiptqty = receiptqty - qty (comes with 102 type)

endif.

Is it the way it should be handled?

Thanks,

Alex.

[Former Member]

Well...Alex....Standard 0IC_C03 infocube consider this situation its obviously if not the total stock could not be calculated...first you must know that 0IC_C03 have non cummulative key figures...check the key figure definition for Total Stock and you must notice that this key figure is not like typical KF, this one consider that the calculated value for total stock is the result of the Inbound Movement - Outbound Movements (like your logic) this is standard..........this is the reason because theres no need to any routine in transfer or update rules...... check all the definitions of KF of the 0IC_C03 infocube....

Regards

[Former Member]

Alex,

What you did is correct. 102 is an reverse of GR (from a PO). It cannot be treated as outbound. It is a reverse of inbound. Thus you are correct.

This question is a MM question instead of BW question. If you post it to MM Forum, you would easily get an answer.

Thanks,

Bingjie

[Former Member]

Bingjie,

Thank you for your reply. The reason I put this in BI is because someone must have had the simillar situation rather than just installing business content, and at my client they are more interested in knowing the total stock, receipts, issues and adjustments. I still have a question about adjustments and I will post in MM area.

Thank you again.

Alex.

[Former Member]

This logic is implemented in Standard update rules and transfer rules...

Check that...

[Former Member]

Diaz,

Thank you for your reply.

In the standard content they use movement type to control, but each implementation can have their defind numbers for movement types. In my installation 101 and 102 are all receipts, but 101 is GR and 102 is GR reversal for PO. In this case since it is GR reversal it will reverse the entries made to the quantity and hence it should be subtracting inventory quantity by what ever qty number comes in the record, and my requirements does not care for categorical stocks they are interested in total issues, receipts and adjustments against each material.

I hope I explained it enough to understand the question.

Thanks,

Alex.