cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory reconciliation issue (Material Type,Goods Issue, Unit of Measure)

Former Member
0 Kudos

Hello SAP Experts,

Please currently I have a client with the following issues and I am looking for the best way to resolve them:

1). They created several Stock Materials with the wrong Material Types UNBW and NLAG () and this has been affecting the way such materials are treated in Inventory and Finance. What is the Best Practice to resolve this issue so that the impact in Accounts and Inventory become reconciled with the true values considering that the materials have been consumed.

2) Several of their materials also was created with the wrong Unit of Measure. Is there a way to correct the impact it has made on inventory and finance for the materials that are already consumed? I want to also ensure that other POs are raised with the right unit of measure.

3). From my investigation, Several Sock Materials and Non-Valuated materials in the store though where received via SAP in Inventory Goods Receipt, they were issued out manually without issuing them in SAP Goods Issue. This means that there are false stock value and quantity. What is the best way to resolve these issue so that Stock Value and Stock Quantities are balanced with the reality of their current stock?

Please to answer these above questions, put in mind that there are different Posting Periods and these issues have been on for about 2 years now.

I shall be so grateful to get your responses and recommendations. I shall also give marks to those who give it a good shot.

Best regards,

PAT

Accepted Solutions (1)

Accepted Solutions (1)

former_member197616
Active Contributor
0 Kudos

Hi, Point 1  : Material Type change . However this is possible in SAP . You can change the material type of the material in SAP making the material afresh like with no open documents / No open stock and other open items . then you can change the material type.Normally stock materials also can be brought in for consumption against an accouny assignment through PO like the Non valuated materials. In your case if your non stock materials are brought in as stock materials and are available in stores , then try cnsume againt the account assignment intended for the non stock materials and then change the material type . Point 2: Try provide the alterbative UOM in the MMR with the conversion factors . This will make less impact .Please check the uom they have used and the base unit of measure and the conversion factors . Point 3. If you have the preceeding documents in the system , you can try as many materials consuming for them . But of course as you said period are the issue and postings will happen in the current period only and will effect this year boon of records . Please make a text note in the document before posting . Have you not ever made a Physical Inventory in the system ? However many of the things need to go on case to case to basis . Regards,

Answers (4)

Answers (4)

BijayKumarBarik
Active Contributor
0 Kudos

Hi,

These are generic issues are  in any effective project!

Material master are already created with material types and not possible to change now with properties on quantity and value update(OMS2)

Now any inventory movements for material can be tracked with t.code S_P00_07000139

Accosting with G/L  details can be tracked with t.code MR51

Based on difference in present physical stock and book stock for material - you can go for adjustment with physical inventory( T.codes MI01, MI04 and MI07)

OR

Any price change for material with respect to earlier price and present demanded price can be maintained   with new a price t.code MR21

Regards,

Biju K

Former Member
0 Kudos

Thank you Sai, Jurgen and Ankur for your contributions. kindly give more insight about "Post Adjust entries through FI document in previous period" do you mean back dating of periods can be achieved in FI so that transactions made 1 year ago can properly be reconciled in FI?

Regards.

ankurch
Active Contributor
0 Kudos

Yes Patrick,

You can adjust the accounting entries which made by your client a year ago by using the transaction code "F-02".

Please see the below example -

Lets say your client created a Purchase order of a single items a year ago for which inventory managed, than the accounting entries at the time of

MIGO -

Stock A/C(BSX) +

GR/IR A/C -

MIRO -

GR/IR A/C +

Vendor A/C -

Consumption -

Stock A/C -

Coonsumption A/C +

Now While doing "F-02"

You just need to do the entries -

Consumption A/C -

Stock A/C +

after making these entries your entries for the particular materials are being nullified.

Please take the little help from your FI Consultant also to post the entries in Previous period.

Thanks & regards,

Ankur Chauhan

ankurch
Active Contributor
0 Kudos

AS Best SAP Practice you cannot post the material documents in closed posting period, so the best practice is as per @Jürgan already advised put the deletion indicator for existing material, post adjust entries through FI document in previous period via transaction code "F-02" for existing stock of material count the physical inventory first in your stock and post the adjustment in current period.

Thanks

Ankur Chauhan

JL23
Active Contributor
0 Kudos

1) best practice is to set a deletion indicator and to create a new correct material. Also cancel all open documents e.g. purchase orders and create them again with the new material after it was created.

You certainly cannot correct it in a way that values that were posted 2 years ago into consumption would now appear as inventory value with a new material material only.

if the materials are valuated then any postings will certainly affect financial books.

2) see 1 and 1001 existing disussions

3) do a physical count and give the users a training so that such physical goods issues without postings in SAP will not happen again in future.