cancel
Showing results for 
Search instead for 
Did you mean: 

Inventory Reconciliation problem at 3PL

former_member863701
Discoverer
0 Kudos
688

As a Master's Student working on a challenging problem in SAP WMS, I am currently facing a discrepancy related to inventory management. The situation arises from the fact that our company stores raw materials at a 3PL facility located 10 kilometers away from the main plant.

Complicating matters further, the raw materials have various variants based on their length. To illustrate, Material Number 2080 has three variants: 3m3m, 6m6m, and 9m*9m. Additionally, we encounter a difference in base units between our SAP system, which uses KG (kilograms), and the 3PL's ERP system, where the base unit is defined as Piece.

Moreover, the method of naming the materials differs between our systems. For instance, at the 3PL, materials are designated as SL 33 DV, ML 66 DV, and LL 99 DV, with SL representing Short Length, ML representing Medium Length, and LL representing Long Length. DV is an abbreviation for the company name.

Due to these differences in material naming and base units, inconsistencies have arisen in inventory levels between SAP and the warehouse at the 3PL.

I am seeking advice and possible solutions to address this inventory discrepancy and ensure seamless synchronization between the two systems. Any guidance and recommendations on how to resolve this matter would be greatly appreciated. Thank you for your assistance

Milan Jani

Accepted Solutions (1)

Accepted Solutions (1)

pratdhaw
Explorer
0 Kudos

Hi Milan,

If the naming of materials are different and you are not doing material to material transfer in some of your scenario's, then you should not have to face any discrepency in inventory.as per details provided by you.

Answers (1)

Answers (1)

Ajit_Routray
Active Contributor
0 Kudos

Hi milujani-1206

"Additionally, we encounter a difference in base units between our SAP system, which uses KG (kilograms)," -> Could you please ask Business and 3PL's ERP system stack holder about 1 PC would be how much.Example:- 2080 has three variants: 3m3m
3PL's ERP system SAP System
1 PC 5 Kgs Once you got that info. Please maintain in your SAP system, PC (Piece) as alternative unit of measure in material/product master (5 Kgs <==> 1 PC). And try to simulate the stocks in PC (do visual stock taking- which is easy in my opinion).Question: Are you using SAP EWM or WM ? Stock taking process would be different in transaction. Please let us know if you have further questions. Kind Regards,Ajit
former_member863701
Discoverer
0 Kudos

Hi Ajit

Thank you! We are using SAP WM. I have another question: Can we link material numbers between our ERP system and the 3PL's ERP system, considering that we use different names for the same material? The goal is that when I create a Purchase Order (PO) for material number 2080 in our SAP system, it should show the corresponding material number used by the 3PL's ERP system. Is this functionality possible within SAP WM?

Ajit_Routray
Active Contributor
0 Kudos

Hi milujani-1206

It would be Supplier Material Number, needs to maintain in the system. Please read the link.

https://answers.sap.com/questions/10764775/vendor-material-number-in-purchase-order.html

Kind Regards,

Ajit