on 2024 Feb 22 5:14 PM
Hello Community members,
Our client needs inventory valuation on basis of FIFO method, please guide us how it can be achieved in public cloud.
FIFO based Consumption of material having Price control V and Material Type ROH
Qty | Rate | Amount | |
GR1 | 1000 | 45 | 45000 |
GR2 | 1000 | 50 | 50000 |
Total | 2000 | 47.5 | 95000 |
Issue | 1500 | 47.5 | 71250 |
Remaining | 500 | 47.5 | 23750 |
|
|
| 95000 |
first GR | 1000 | 45 | 45000 |
Second GR | 500 | 50 | 25000 |
|
|
| 70000 |
Remaining | 500 | 50 | 25000 |
As 2000 Qty of Material is purchased at two different rates, while doing goods issue (consumption) of 1500 Qty Material system should issue first 1000 Qty @45 rate and second 500 Qty @50 and remaining invetory value should be 25000 for Qty 500@50
As per above scenario valuation should be done on FIFO basis and same should be reflected in report MB5B ( Stocks on Posting Date) or Analyze stocks in Date Range.
MB5B à
Analyze stocks in Date Range
Request clarification before answering.
FIFO Valuation is available in SAP Public Cloud:
Below are the steps to achieve that requirement which is mostly raised by the clients:
1.Flagging FIFO Check Box in Material Master:
In the material master accounting 2 view, FIFO check box can be marked individually as well as in mass via App: Schedule Inventory Accounting Jobs
2. Execution of FIFO Valuation:
We run FIFO valuation via APP: Execute FIFO Valuation by selecting the method that meets our requirement along with other parameters which can be seen in the below screenshot.
Below are the different methods which can be selected:
There are multiple FIFO methods and you can select anyone of them as per your requirement but there are two most common to calculate FIFO values based on goods receipts: – monthly receipts and single receipts:
3. Display FIFO Valuation:
you can display the results in the APP: FIFO Results:
Conclusion:
This requirement is one of the most frequent asked by the SAP customers and SAP Public Cloud has offered this to facilitate its customers.
Regards,
Muhammad Humayun
SAP FICO Managing Consultant
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
120 | |
10 | |
8 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.