Sunday, 20 March 2016

Change Reconciliation account during FI posting (Without using SGL indicator)

I was facing an issue regarding the necessity to edit the reconciliation account derived from the customer/vendor data without using a SGL indicator.

Many SCN discussion confirm that it’s not possible as in standard the GL account is derived from the customer/vendor master data, nevertheless, there is a “standard” way (no specific development) to edit and select the reconciliation account we need during posting  and without using the SGL indicator:
Here is the steps :

First, specify your GL accounts that you want to choose from, for example let say Recon. Accounts
  • 41110010 (entered in customer master data)
  • 41110011
  • 41110012 

Saturday, 19 March 2016

DMEE Configuration:Step By Step Part 2

This is the continuation of the document DMEE Configuration.
Please refer the below link for the DMEE Configuration:Step By Step Part 1.

Create/Assign Selection Variants (OBPM4)
A. Accounts Receivable and Accounts Payable ® Business Transactions ® Outgoing Payments ® Automatic Outgoing Payments ® Payment Media ® Make Settings for Payment Medium Formats from Payment Medium Workbench ® Create/Assign Selection Variants

SAP FICO Material and Certifications

Friday, 18 March 2016

DMEE Configuration:Step By Step Part 1

Introduction:
DME stands for Data Medium Exchange
A data medium exchange (DME) is a data exchange file which is used to send payment information of an enterprise to banks or tax authority. Basically these files contain financial data which can be in flat file or xml file format. Different File formats can be created for different countries and different banks based on their own norm which replaces conventional ABAP programs.

DMEE Configuration:Step By Step.

Create Payment Medium Formats (OBPM1) Accounts Receivable and Accounts Payable ® Business Transactions ® Outgoing Payments ® Automatic Outgoing Payments ® Payment Media ® Make Settings for Payment Medium Formats from Payment Medium Workbench ® Create Payment Medium Formats

Thursday, 17 March 2016

Understanding - Revenue Recognition

What is Revenue Recognition?

To understand what is Revenue Recognition, we need to understand what are the basic accounting principles which guide all the accounting standards across the world. There are two basic accounting principles
  1. Accrued System
  2. Cash System
In Accrued system of accounting principle, as far as revenues are concerned, revenue is recognized with, when it is either realized or realizable no matter when the cash is received.
  • Accrued system of accounting
  1. The below points make it clear to understand the accrual system of accounting
  2. The Accrual Method of Accounting matches revenues when they are earned against expenses associated with those revenues.

Wednesday, 16 March 2016

Automation of Actual Costing Run (CKMLCP) in Material Ledger

Introduction:
In Material ledger, Actual Cost calculation is an important part, which includes multiple steps that need to be executed by the business controllers. These steps include production/process order closing, overhead cost calculation, execution of assessment/distribution or indirect activity allocation cycles, actual cost split, actual activity price calculation and the most important CKMLCP execution in material ledger.
CKMLCP includes multiple steps that took many hours to get executed.  If we take an example of a MNC organization presence all over the world, then execution of period end closing took more than 10 to 15 hours. In this document, I will explain how we can atomize the execution of CKMLCP and reduce the execution of time.

Period End Closing CKMLCP Overview:

CKMLCP is executed to calculate Period Unit Price (PUP), which basically represent average actual cost for material or semi finished goods. Execution of CKMLCP includes the below steps:

Monday, 14 March 2016

Basics of Standard Costing - Understanding overhead cost flow-Part 4

This is in continuous of my other document of understanding Standard Costing and its flows.
Basics of Standard Costing - Understanding the Cost Component Structure-Part 3
Overhead costs are costs which can only indirectly be attributed to the product, such as electricity or general storage costs. We can allocate these overhead costs in various ways: Here I have discussed about overhead calculation through costing sheet. This is a beginner's guide to understand the costing Sheet.

Overhead application
In the conventional method, overhead is applied to the reference object as a percentage rate or a quantity-based rate. The overhead is applied by means of costing sheets. The very purpose of using a cost sheet is that we want to apply indirect costs to the final cost of the product or process. Costs that cannot be assigned to the product cost collector directly can be allocated by determining the overhead expenses and applying them to the cost collector. Overhead costing is the means by which we allocate indirect costs to the appropriate objects.
The costing sheet links all the functions of overhead calculation. The direct costs to which overhead is applied (calculation base),The conditions under which overhead is applied (dependency),Whether overhead is allocated on a percentage basis or on a quantity basis, The amount of the overhead percentage, or the amount of overhead for each unit of measure (overhead), The validity period for the overhead, Which object (cost center, process, or order) is credited, and under which cost element in the case of actual postings (credit key)

Friday, 11 March 2016

Basics of Standard Costing - Understanding the Cost Component Structure-Part 3

This document is in continuation of my second document Basics of SAP Standard Cost estimate- understanding costing variant-Part 2 and 3rd in the series

This document explains the Cost Component Structure (CCS) and components assigned to CCS.  Explaining various settings in background as previous part.

Cost Component Structure (CCS)
The cost component structure determines how the results of material costing are updated. The cost component structure groups the costs for each material according to cost component (such as material costs, internal activities, external activities, and overhead). If the material is used in the production of another material, the cost component split (which breaks down the costs according to material costs, internal activities, external activities, overhead, and so forth) remains in the system when the costs are rolled up.