Complete inventory document

[#1]

Hi experts,

I tried to find the answer via search here, but I couldn't. We have problems with active inventory documents. I found many threads about active documents already, but none, which really gives an answer what the standard SAP way is to set it to complete. If we count and post all differences, the inventory document status is still active in MI22. Status in IKPF is X (ZSTAT) and A (DSTAT). There are no open differences to post anymore, all have been posted. ZC is set for all materials in case qty is zero. Since we don't want to delete every inventory document (again) next year for the inventory count, how become these inventory documents complete?

Many thanks,

Martin

[former_member183424 · Accepted solution]

Use MI20, you can find the material which is not posted. Just pick the document from MI22 (which status shows active), then go to MI20. see this.

[Former Member · Accepted solution]

Hello Dev,

I don't get a list in MI20, because every item with a difference has been posted. There is no outstanding posting and every material has been counted properly, but the status in MI22 is still "active", which I don't understand.

Thanks,

Martin

[JL23 · Accepted solution]

Can you check with SE16 at table IKPF, What value is in fields ZSTAT and DSTAT for your document in question?

Then do the same on table ISEG: do all record for this document have a X in fields

XZAEL

XDIFF

[Former Member · Accepted solution]

Jürgen,

See IKPF status above in my initial post. ISEG-XZAEL has got "X" in every item. XDIFF only some "X". This causes IKPF-DSTAT = "A" I suppose and this means document = active I guess. BUT, this doesn't make sense in my opinion, because I can't get a "X" for XDIFF for the other items, since there is no counted difference for these. All other items with differences have already been posted, otherwise I would get a list in MI20, right?

Thanks,

Martin

[JL23 · Accepted solution]

Please read OSS note 67072 - Control and correction of physical inventory indicators

and compare your settings and test the correction report

[Former Member · Accepted solution]

Jürgen,

Thanks, I read this note already. I'm not sure, if it's the solution actually... It says:

However, the error is not corrected if you delete these physical inventory documents; the physical inventory indicators remain incorrect.

But if I delete the PIDs, the documents are not active anymore, so I can correct it through this. Whereas this is not a long term solution and not meant to be by SAP. I just don't know, why they are active in the first place after counting and posting the differences...

Anyway, maybe I should ask basis to implement this note. It's at least worth a try.

[JL23 · Accepted solution]

I thought to mention this note because the report can be executed in test mode, this could at least show an evidence about an inconsistency.

However I think you did not post difference for all items. my posted ISEG records have all a X in field

XDIFF, regardless of having a real difference or no difference.

[Former Member · Accepted solution]

I should get a list of "differences to be posted" in MI20, if there are some left, shouldn't I? If I go to MI20 I enter the plant, inventory document number and tick the boxes "Not yet counted" - "Partially Counted" - "All counted" for Phys. Inventory Documents and "Not yet couned" and "Only cntd." for Phys. Inventory Items and don't get a single hit (List contains no data). So this doesn't make sense to me really...?

[JL23 · Accepted solution]

What do you get if you select all boxes in status selection for item, exept the box for difference posted

[Former Member · Accepted solution]

It's the same, when I tick all boxes apart from "posted" I don't get anything. "List contains no data". It just puts an "X" in XDIFF where a real difference was and has been posted. The rest of the items is blank for XDIFF and has status "counted". The other ones "counted, adjusted".

[JL23 · Accepted solution]

is it a new document where you can still go in with MI04 or execute MI07?

Do you get error messages if you try MI07 again?

[Former Member · Accepted solution]

Ha! It seems I got it now! We post all our differences via MI20. But there it will only "touch" and post the items with differences and not the one without! You can't tick the boxes in the subsequent screen of those. If I go to MI07 now and save there again (boxes are ticked of the ones without a difference automatically), it says "PID saved without differences" and now the status for IKPF-DSTAT = "X"! Not ideal in my opinion really... Do you post your differences always in MI07 rather then MI20?

Many thanks for your help!

[JL23 · Accepted solution]

Yes we post differences only in MI07, and use MI20 only to print a difference list.