Revaluate Activity Type at Actual Price

I just want to share if anyone may need. It is complete scenario from configuration to planning, actual posting and final revaluation. I used some of the comments/posts on the forum - That I see it valuable and clear

1. Master data & set up
1.1  KL01-Create activity type

• Set the ‘Price indicator’ to “1” (Plan price, automatically based on activity) in the ‘Allocation default values’ section in order that the plan prices are calculated automatically. -> This means that the cost center budget entered in transaction KP06 will be divided by the quantity entered in transaction KP26 when you run the plan price calculation in transaction KSPI.
• You need to set the ‘Act. Price indicator’ to “5” (Actual price, automatically based on activity) in the ‘Variance Values for Actual Allocation’ section in order that the actual prices are calculated automatically. This means that the actual costs posted a cost center will be divided by the actual quantity consumed in the cost center when you run the ‘Actual Price Calculation’ in transaction KSII.

GL Planning/Budgeting

Purpose

In this Document we will capture GL Planning/ Budgeting Process, Scenarios and requirement of an Organization.
This component is used to handle GL accounting transactions that you can Prepare Future forecast, Allocation in a Particular Department.
You can use the planning function in General Ledger accounting to enter and distribute plan data to create budgets, forecasts, and other reports.
You can quickly and easily enter large amounts of plan data. You have the following options for plan data entry:

1. You can enter amounts as plan totals that are (automatically or manually) distributed to the planning periods.
2. You can enter amounts as period amounts that are automatically totaled.
3. You can enter a combination of both totals and period amounts.

SAP Inventory Valuation through FIFO

The below article will explain one of the approaches through which Inventory can be valued on FIFO basis in SAP -

We have two approaches to present our Inventory on FIFO basis -
1. Batch Input Method - A batch capturing the Receipt Value and the Quantity for every GR is maintained in the system. At the time of Goods Issue, the system will fetch the value from the batches in the ascending order.
2. Balance Sheet Valuation Method - In this approach, the goods are valued at the Moving Average Price throughout the period and at the Period-end date, an adjustment entry is posted to bring the inventory at the FIFO method.

I will discuss the configuration steps of Balance Sheet Valuation Method here.
Before beginning with the configuration of this approach, let me explain with an example for what exactly this approach will do -