Initial Inventory Upload in SAP Using Movement Type 561 |
What You’re Trying to Do (in simple terms)You're uploading your inventory from a legacy system into SAP so that everything’s in place by November 1st go-live. You're using Movement Type 561, which is perfect, it’s designed for initial stock entries. But here's the twist: SAP treats materials differently depending on whether they are using Standard Price (S) or Moving Average Price (V). That affects how inventory values are calculated and what happens behind the scenes in accounting.Standard Price vs. Moving Average: What Really HappensStandard Price (Price Control = ‘S’)
If standard price = $10 You upload 100 units at $12 each → SAP will value at $10 x 100 = $1000 The $200 extra? → Goes to price difference account Moving Average Price (Price Control = ‘V’)
If you upload 100 units for $1500 → SAP sets MAP = $15 BUT if you don’t enter any value, SAP just uses the current MAP in the material master, and MAP stays unchanged. How to Actually Do the UploadYou’ll use transaction MB1C (or MIGO in newer SAP versions) with Movement Type 561. This is inventory without PO. Here's the workflow:Path in SAP GUI:Logistics → Materials Management → Inventory Management → Goods Movement → Goods Receipt → OtherInput Fields:
Then:
Common Error: G/L Account BlockedIf you get an error like:“G/L account 399999 blocked for posting in company code 3000”, here’s the fix: Fixing It:1. Go to: Accounting → Financial Accounting → GL → Master Records → Individual Processing → CentrallyAlso check 79999 if you're uploading Finished Goods. Important: Do this in the master client, not a test or sandbox one. Pro Tips1. Double-check your price control (S or V) before uploading anything. TL;DR Cheat Sheet
|
|
|
See also MM Consultant Year End Activities Get help for your SAP MM problems
SAP MM Books
SAP Material Management Tips
Main Index
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|