How to view changes to Customer Orders regarding Batch used?

[Former Member]

Hi all, currently my company uses a 3PL that doesn't manage our batch numbers accurately. Because of this reason, when it comes to Customer Orders and Batches are allocated to that order (picked by 3PL) sometimes those batch numbers do not exist in our SAP to be invoiced. Team is having to use MB1B to alter batches allocated. Because of this batches between 3PL and our SAP is inaccurate, and monthly a full stocktake using a automatically generated reported from our 3PL is needed to be done to match as much as possible.

I'm trying to avoid doing it this way as it is extremely time consuming. What i'm thinking is if there was a way to collate Customer Orders at the end of the day that have been altered and then manually readjust rather than doing it once a month, I do a bit at a time daily.

How do I view history of a Customer Order so I can see what batch was assigned to the order instead of the original picked batch?

[former_member42743]

Tough answer for a forum like this. But the root cause of the problem needs to be addressed, not finding a fix to accommodate an obviously error laden process. Having no clue how your system is integrated with the 3PL its hard to give you concrete advice. I'm kind of lost as to how your stock and their stock can be so different and how you are using MB1B to fix this. I mean the inventory physically exists or it doesn't. You can't just transfer/add/remove qty to your batches.

Are you sure its errors at the 3PL and not issues in you system and how batches are tracked and inventory updated.

Do you have some type of real-time file transfer, (I-docs?) to control stock levels? Or are you using daily reports and manual updates in an attempt to keep the systems in sync?

As far as your specific question you might look at seeing if there are change records created in CDHDR and CDPOS tables. If not, see if they can be. I don't know if they are or if they can be. But then you could build your report off of those tables. I have had clients use a user exit to add their own change records to CDHDR and CDPOS when SAP didn't provide that. So you could look at doing that whenever an order is changed.

Craig