Monday, 20 April 2015

Customer Master Overview

Customer Master Overview


The Accounts Receivable application component records and manages accounting data of all customers.


Creating Customer Master Data

Customer master records are maintained in sub-ledger and are used in Sales and Distribution as well as Financial Accounting. By storing customer master data centrally, it is enabled to be accessed throughout the whole organisation, and avoid the need to enter the same information twice. It gives also the ability to avoid inconsistencies in master data by maintaining it centrally. If one of the customers changes his or her address, it is only necessary to enter this change once and accounting and sales departments will always have up-to-date information.


The customer master record contains:


o   General Data; containing the data for communication with the customer, such as address, fax, region, country and telephone numbers

o   Company Code Data; containing the dunning procedures and the date of the last dunning notice, reconciliation account, grouping, tax data


o   Sales Data; containing the order processing, shipping, and billing data


Customer Master Groups can be as given below:

Account Group
Definition
Number Ranges
ZD10
Customers Group – Domestic (Sold to Party)
100001-119999
ZD20
Customer Group – Domestic (Ship to Party)
120001-129999
ZD30
Customer Group – Domestic (Bill to Party)
130001-139999
ZD40
Customer Group – Domestic (Payer)
140001-149999
ZD50
Customers Group – Sales Employees
150001-169999
ZE10
Customers Group – Export (Sold to Party)
200001-219999
ZE20
Customer Group – Export (Ship to Party)
220001-229999
ZE30
Customer Group – Export (Bill to Party)
230001-239999
ZE40
Customer Group – Export (Payer)
240001-249999
ZS10
Customer Group – Stock Transfer
C1001-C9999
ZO10
Customers Group -  One time
      400001-499999

Editing & Blocking & Deleting Customer Master Data


Editing

o   The account group cannot be edited
o   The account assignment cannot be edited

Blocking

A customer account can be blocked and unblocked at any time.

Deleting

Customer accounts to be deleted are first marked for deletion.  No transaction figures should be stored for this customer account. The account must be blocked for posting before it can be deleted.

Displaying Changes

The system logs all changes to customer master records.  For each changed field, it stores the time of change, the user’s name, and the current and previous field contents.


Reconciliation Account

When any entry is posted to a subsidiary ledger, the system automatically posts the same data to the general ledger (see the following illustration). Each subsidiary ledger a reconciliation accounts in the general ledger. These reconciliation accounts ensure that the balance of G/L accounts is always matching with the sub ledger. This means that you can draw up balance sheets at any time without having to transfer totals from the sub ledgers to the general ledger. 


Note: Reconciliation account is mandatory while creation of Customer Master Data.


Tags#
Customer Account Group, Customer Master Data, Customer Reconciliation Account, SAP Customer Master, SAP Reconciliation Account,

Saturday, 18 April 2015

Controlling Area

Controlling Area


Definition

A Controlling Area is an organization unit used for Cost accounting purpose. A controlling area can be assigned to multiple company codes at the same time.

Controlling Area is a very important organization unit in SAP Controlling. This organization unit contains the most important configurations required for whole controlling module.

Use

Controlling Area receives primary costs from other modules like Finance, Sales & Distribution, Material Management, Production Planning, Project Systems etc. Controlling Area has its own processing of values, which is done using Cost Elements. These costs are broadly known as Secondary Costs.


Implementation Consideration

IMG Path: Controlling > Controlling > Organization > Maintain Controlling Area > Maintain Controlling Area

Here we can create a new Controlling Area.

Upon creation of Controlling Area, following assignments/settings are to be done for the same

Name

Enter the appropriate name for the Controlling Area.

Person Responsible

Here we can assign the User ID of the person responsible for this Controlling Area.


CoCd -> CO Area (Allocation Indicator)

Here we specify whether
The controlling area will be assigned to multiple company codes

The controlling area will be assigned to single company codes. In this case, the code of Company Code and Controlling Area has to be the same. For e.g. Company Code 1000 and Controlling Area 1000.


Currency Type

The controlling area currency type determines which currency is allowed as controlling area currency and whether the CO area currency can differ from the currency of the assigned company codes.

The assignment control indicator, together with the currency type, determines the controlling area currency and whether to activate or deactivate the Other company code currency indicator. The following settings are possible:

You can select currency type 10 only if all company codes assigned to the controlling area use the same currency.
 If you select 1 as the assignment control, the system uses the default setting 10 as the currency type.

Currency

Enter the currency. If the allocation control indicator is set to 1, the SAP system makes an entry in the field automatically. If the indicator is set to 2, you must make an entry in the field yourself.

Chart of Accounts

Enter the Chart of Accounts here, note that the Company Code(s) assigned must use same Chart of Account as assigned here.

Fiscal Year Variant

Enter the Fiscal Year Variant here, note that the Company Code(s) assigned must use same Fiscal Year Variant as assigned here.

Cost Centre Standard Hierarchy

Enter the Hierarchy here.


Tags#

Activation of Components in Controlling Area, Assign COA & Fiscal year Variant to Controlling Area, Assignment of Company Code to Controlling Area, SAP Controlling Area, 


The creation of Controlling Area is further divided into Activation of Components and Assignment of Company Codes.


Activation of Components:

In this section, we have to activate the relevant components as explained below:

Cost Centres

The cost centre accounting is activated here. We have following options with regards to CCA activation

Inactive

CCA is not activated

Active

CCA is activated without limitations and cost centres can be used as account assignment objects

Active with validation

CCA is not active. Cost centers are validated against the cost center master. The cost centers can be used as account assignment objects but the relevant CO files are not updated on posting. If CCA is implemented at a later date, you can subsequently post the cost-relevant business transactions in cost centers to the relevant CO files.

Active for existence checks

Same as Active. The only difference is that the cost centers are not  created in full, but only in part using the "Rough entry" function.


Account Assignment Activity type active

This indicator controls whether the activity types can be used as account assignment objects for actual postings.

If this indicator is selected, actual primary costs can be assigned directly to the activity type of a cost center.


Order Management

This indicator controls the setting for order management

InactiveOrder are not validated and can’t be used as account assignment object.

ActiveOrder management is active without limitations. Orders are validated and can be used as account assignment object.
Active for validationsOrder management is inactive. Orders are validated against master data and can be used as account assignment objects, but the corresponding CO files are not updated.
Active for existence validationFunctions the same as indicator Active except that orders are checked to see if they exist and not whether they are allowable for the relevant posting transaction.

Commitment Management

Controls whether commitments are updated for the controlling area or not.

Profitability Analysis

Activation of Profitability Analysis is done separately in CO-PA component of Controlling Module.

Activity Based Costing

Indicates whether Activity Based Costing component of Controlling is active or not.

Profit Centre Accounting

Indicates whether PCA component of Controlling is active or not.

Projects

This indicator controls whether CO files are to be updated as additional account assignments for posting transactions that use WBS elements and networks or not.

Indicator selectedCO files are updated. The WBS element and network numbers are validated with the corresponding master data. Indicator not selectedCO files are not updated. Note that, even if you do not select this indicator, the system validates the master data for additional account assignments to a WBS element. The network number, however, is not validated.

Select this option if you are planning to implement PS Module.


Sales Order

This indicator controls the use of Sales Orders in Make to Order production.

Indicator selected
System allows following
Posting of actual costs and revenues to the Sales Order.
Production Order, Networks to settle the costs to the Sales Order Item.
Result Analysis

Indicator not selected
If the indicator is not active, the SAP system neither checks the CO object for sales order items during posting to Financial Accounting, nor updates costs and revenues to the sales order item.


Variance

This indicator activates calculation of variance.

This Indicator controls whether the system calculates price variances for primary cost postings by transaction (that is, by posting) and posts them in the Controlling component (CO). If the indicator is active, the system makes the calculations and postings.




Assignment of Company Codes


In this section we assign the Company Codes to Controlling Area. The Company codes can be assigned to controlling area if following conditions are met:

Controlling Area and Company Codes have same Chart of Accounts
Controlling Area and Company Codes have same Fiscal Year Variant

If any of above two conditions are not met, system does not allow assignment of company code to the controlling area.



Reference Material



  




Tags#
Activation of Components in Controlling Area, Assign COA & Fiscal year Variant to Controlling Area, Assignment of Company Code to Controlling Area, SAP Controlling Area,

Chart of Depreciation

Chart of Depreciation


Definition

The chart of depreciation contains the list of defined depreciation areas. It also contains rules for the evaluation of assets that are valid in a given country or economic area. Each company code is allocated to one chart of depreciation. Several company codes can work with the same chart of depreciation. The chart of depreciation and the chart of accounts are completely independent of one another.

Depreciation is a non cash expenditure which is allowed to be charged to Profit & Loss Account. In India, the depreciation allowed under companies act and the Income tax act are different. This requirement can be met by creating two different depreciation areas.


Implementation Consideration

SAP supplies typical reference charts of depreciation for each country. They have different depreciation areas and depreciation keys depending on that country’s specific requirements. You cannot use these charts of depreciation directly. You must create your own chart of depreciation by copying the reference chart of depreciation. Delete any depreciation areas that are not needed.


Creating Chart of Depreciation

IMG Path: Financial Accounting (New) > Asset Accounting > Asset Accounting (Lean Implementation) > Organizational Structures > Copy Reference Chart of Depreciation/Depreciation Areas

We can’t create a new Chart of depreciation from the scratch. We have to copy the country specific reference Chart of Depreciation provided by SAP to create a new one.


Specify Description of Chart of Depreciation

Change the name of Chart of Depreciation here.


Assign to Company Code

The next step in Chart of Depreciation is assignment to Company Code

IMG Path: Financial Accounting (New) > Asset Accounting > Asset Accounting (Lean Implementation) > Organizational Structures > Assign Chart of Depreciation to Company Code

Here we can assign the newly created Chart of Depreciation to the Company Code. One Chart of Depreciation can be assigned to multiple Company Codes.

Once Chart of Depreciation is assigned to Company Code, we can start working on the same.

Reference Material




Tags#

Assign Chart of Depreciation, SAP Chart of Depreciation, 

G/L Account Master Data

G/L Account Master Data

Please refer SAP Chart of Accounts before starting on this part of Master Data.


The G/L Account Master data is divided into following two parts:


Chart of Accounts Data

This part contains information about G/L Account that will not change from company code to company code and will be constant for all.

Company Code Data

This part contains information about G/L Account that will be relevant to Company Code. This can be maintained separately for every company code after extension of G/L Account.


The Chart of Accounts data includes:


Account Number

Enter the appropriate G/L Account number as per numbering maintained for Account Groups.

Account Group

Select the appropriate Account Group from drop down list available.

Nature of Account

Select if this is Profit & Loss or Balance Sheet Account

Short Text

Maintain short text for the G/L Account. Please maintain some logical text here as many reports show this text against the G/L account number.

Long Text

Enter complete description of the G/L account.



The major fields in company code data are explained below:


The account currency

G/L account will be posted with currency assigned in master data only. In case of G/L with foreign currency will be posted in foreign currency only and then system will convert in to local currency based on exchange rate maintain in the system. It also helps to revaluate open items in foreign currency.

Balances in local currency only indicator

This indicator is set for clearing accounts, to clear line items in various currencies with one local currency amount and without posting any exchange rate difference that may occur.

Tax Category

This field determines if the G/L Account is tax relevant, a tax account or a G/L where specific type of tax will be posted. This field has a drop down list from where one can select the appropriate indicator. Following options are available for selection:

-              Only input tax allowed
+             Only output tax allowed
*             All tax types allowed
<             Input Tax Account
>             Output Tax Account

Apart from above options, system shows tax codes, which can also be selected. In this case, system will not allow the user to post document with any other tax codes in the G/L account.

Posting without tax allowed

If this field is selected it indicates that the account can still be posted to even if a tax code has not been entered.

Reconciliation for account type

The reconciliation accounts are defined by specifying in the G/L master data the account type for which the account is used. When there is a posting to an account in the sub-ledger, the system automatically posts to the corresponding reconciliation account. The accounts for receivables and payables are typical reconciliation accounts. Using the reconciliation account procedure, it is possible to create a balance sheet and a profit and loss statement at any time, since the amounts that are posted to the sub-ledger accounts are also posted automatically to the general ledger.
During regular reconciliation, it is checked whether the balance of the reconciliation account corresponds to the balance of the corresponding sub-ledger accounts. Reconciliation accounts are defined by specifying in the G/L account master record the account type (such as fixed assets, vendor or customer) for which the account is to be used. In this way, the account can only be assigned to accounts in the corresponding sub-ledger. The assignment of the sub-ledger account to a reconciliation account is set in the master record of the sub-ledger account. It is not possible to post to reconciliation accounts manually from the general ledger.


Open item management

If this indicator is set it mark the line item as open or cleared. If this field is selected, the system starts treating every posted document as open item. The items are to be cleared by the user either manually or automatically against other line items.

In case of these G/L accounts the balance is always amount equal to the total of open items. The line item indicator has to be activated if open item management is to be used.

Line item display

For an account defined with line item display, all items that have been posed to this account are displayed if they have not been archived.

Note: Please use Line Item and Open item Management options with care, as it may cause the system to store additional data and also activation/deactivation of these indicators after posting of documents may cause inconsistency.

Sort key

It specifies which entry the system transfers from the document header or from the line item to the Allocation field on the date of posting. After the value is transferred it is helpful to clear or search items on the account according to the Allocation field value. 

Field status group

The field status group specified in the G/L account controls which fields are displayed when posting transaction to a G/L account. A field may be suppressed, required or optional during transaction postings.

Post Automatically only

Set this option for the G/L accounts where no manual transactions are to be posted. This indicator plays a very vital role to control the postings in any G/L accounts.

For e.g. all Inventory accounts should be marked as Post Automatically only, this will avoid any difference in FI-MM reconciliation (T Code MB5L)

Recon account ready for input


This indicator is applicable in case of reconciliation accounts. If this indicator is activated, system allows the user to change the reconciliation account for the entry during document processing. In order to make this functionality work, you need to assign the alternate G/L accounts in customizing. IMG Path: Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Postings with Alternative Reconciliation Account > Define Alternative Reconciliation Accounts



Reference Material







Tags#

Automatic posting in General Ledger in SAP, SAP Chart of Account data of G/L, SAP Company Code Data of G/L, SAP General Ledger Master Data, SAP Post Automatically, SAP Recon Account Ready for Input, 

Friday, 17 April 2015

Company Code Global Parameters (Part II)


Continued from Part I

Fields under Processing Parameters


Pstng period variant

Enter the Posting Period Variant relevant for the Company Code.
Please refer Posting Period Variant for further information.

Max. exchange rate deviation

Enter the maximum exchange rate deviation in percentage

CoCd -> CO Area

This field is not editable. The system assigns number 1 in case where the Company Code is equal to Controlling area and in case of assignment of multiple company codes to single controlling area, system assigns no. 2 here.


Negative Postings Permitted

In some countries, the regulations do not allow increase of value on opposite side of account in case of reversal. In such cases, the reversal is shown as reversal posting on the same side of account if this indicator is activated. This indicator works in conjunction with the Negative posting parameter in document type. For e.g. the Reversal of debit amount is shown as negative amount on the debit side of the account, instead of showing on the credit side.

Business Area fin. Statements

This indicator should be activated if Profit & Loss & Balance Sheet is are to be drawn at Business Area Level. If this indicator is set, the field Business Area is always ready for input during document posting regardless of field status of Posting Keys/Accounts.


Propose Fiscal Year

This indicator, if set default fiscal year which is open for editing while document posting.


Define Default value date

Indicates that the current date is used as the default value for the value date when entering line items.


No forex rate diff. when clearing in LC

Indicates that when items in foreign currency are cleared in local currency, the local currency amount stored in the document is used asthe amount to be cleared.

  

Purchase acct proc.

Specifies that purchase account management is active in the system.


Reference Material:






Tags#
SAP Company Code Global Parameters, 

Document Splitting (Part II)

Document Splitting (Part II)

Continued from Part I

Step VI

IMG Path: Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions>Extended Document Splitting>Define Document Splitting Method

In this activity we create document splitting method. This method determines how individual item categories are dealt with. Standard methods provided by SAP are generally sufficient.


Step VII


IMG Path: Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions>Extended Document Splitting>Define Document Splitting Rule

This is a very important setting to understand. Here we assign the item categories to the combination of Document Splitting Method, Transaction and Variant. 

This setting works in two parts, Item Categories to be edited and base item categories.

Item categories to be edited are the item categories (G/L Accounts) which do not have the account assignment object (Profit Centre/Business Area) and depend on the item categories (G/L Accounts) assigned under Base Item Categories.

Base Item Categories are the item the item categories (G/L Accounts) which have account assignment object (Profit Centre/Business Area) and they pass it to the item categories to be edited.

For e.g. the combination of Splitting Method “0000000012” Business Transaction “0300” and Transaction Variant “0001” i.e. Vendor Payment have following Item Categories that can be edited:

01100    Company Code Clearing
01100    Company Code Clearing
01300    Cash Discount Clearing
03000    Vendor
05100    Taxes on Sales/Purchases
05200    Withholding Tax

The above item categories i.e. G/L Accounts do not have any profit centre/business area in line item and have to depend on following base item categories assigned to every Item Category:

01000    Balance Sheet Account
01100    Company Code Clearing
01300    Cash Discount Clearing
05100    Taxes on Sales/Purchases
05200    Withholding Tax
06000    Material
07000    Fixed Assets
20000    Expense
30000    Revenue


Step VIII


IMG Path: Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions>Extended Document Splitting>Assign Document Splitting Method

In this section, we assign the Document Splitting method that will be applicable. Here we also activate inheritance and assign constant (default characteristics)


Step IX

IMG Path: Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions>Extended Document Splitting>Define Business Transaction Variants

This is another important setting where item categories are assigned to the business transaction. Here we can specify if any particular item category (G/L account) is mandatory in document splitting.

For e.g. Item Category vendor is mandatory for Business Transaction 0300 i.e. Vendor Invoice. This means the vendor invoice can’t be processed without vendor line item.



Reference material





Tags#

document splitting inheritance, document splitting method, document splitting rule, extended document splitting, SAP document splitting,

Document Splitting (Part I)

Document Splitting (Part I)


Background

Document splitting is a feature introduced by SAP in New G/L Accounting. This feature was introduced to do away with the users’ requirement to transfer the balances of Balance Sheet items at period ends.

Document Splitting automatically splits the line items based on the dimensions configured or to effect zero balance setting. It creates additional lines for the same.

Given below is the list of dimensions that can be set for splitting:

Segments
Profit Centres
Business Areas

Use
The document splitting helps in drawing financial statements at above dimensions on real time basis. For e.g. the Balance Sheet can be drawn at Business Area level, which may be one of the requirement of Management.


Implementation Consideration

The functionality of Document Splitting needs following assignments/configurations


Step I

Specifying the characteristics for which splitting is to be performed:

IMG Path: Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions>Document Splitting > Define Document Splitting Characteristics for General Ledger Accounting

This is the first and foremost important step in document splitting. In this step we define the characteristics for which document splitting needs to be done. Here we have to define the following

Fields: Business Area/Profit Centre/Segment

Zero Balance
Activating this indicator will check the transactions values to total to zero. If the total of is not zero, then the system generates additional line items in “General Ledger View” of the document.

Partner Field
If you specify a partner field, a sender/receiver relationship is thendocumented in the additionally created clearing lines.


Mandatory Field
This indicator verifies every line item for the values for characteristics. If any of the values is missing then system throws error “Balancing field ______ in line item ____ not filled”


Step II

G/L Accounts

IMG Path: Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions> Document Splitting > Classify G/L Accounts for Document Splitting

In this step, we assign Item Categories to G/L Accounts. The item category assigned to a G/L account determines the nature of G/L Account.

Note: The numbering of G/L Accounts in Chart of Accounts becomes very critical, as one can assign item category to a particular number range of G/L Accounts. For e.g. all the G/L Accounts starting from 21400000 to 21499999 shall be assigned to Category “04000” i.e. Bank account.


Following Item Categories are available in standard system:

Cat.      Desccription
01000    Balance Sheet Account
01001    Zero Balance Posting (Free Balancing Units)
01100    Company Code Clearing
01300    Cash Discount Clearing
02000    Customer
02100    Customer: Special G/L Transaction
03000    Vendor
03100    Vendor: Special G/L Transaction
04000    Cash Account
05100    Taxes on Sales/Purchases
05200    Withholding Tax
06000    Material
07000    Fixed Assets
20000    Expense
30000    Revenue
40100    Cash Discount (Expense/Revenue/Loss)
40200    Exchange Rate Difference
80000    Customer-Specific Item Category


Step III

Document Types

Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions> Document Splitting > Classify Document Types for Document Splitting

In this step, we assign every document type to Transaction and Variant.

List of Transactions that can be assigned to the document types

0000       Unspecified posting
0100       Transfer posting from P&L to B/S account
0200       Customer invoice
0300       Vendor invoice
0400       Bank account statement
0500       Advance tax return (regular tax burden)
0600       Goods Receipt for Purchase Order
1000       Payments
1010       Clearing transactions (account maint.)
1020       Resetting cleared items

The combination of transaction and variant determine the splitting method to be used during document splitting process. The transaction and variant also identifies the type of accounts allowed in the document during document splitting. Refer Document splitting Rule section in the post.

For e.g. the accounting transaction 0200 (customer invoice), variant 0001 (standard), is delivered. In this accounting transaction, the following item categories are allowed: customer, value added tax, withholding tax, expense, revenue, exchange rate differences, and company code clearing.


Tip

SAP system comes with this assignment for standard document types. In case of customized document types, the assignment should be done by referring relevant standard document type. For e.g. if we create a customized document type for Bank Receipt, then the assignment done for standard document type KZ should be used for the new document type.


Step IV

Zero Balancing
Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions> Document Splitting > Define Zero-Balance Clearing Account

Here we can define the account assignment objects for which we want system to have zero balance setting, by doing this we ask the system to verify if the balance of account assignment object (balance at the level of Business Area/Profit Centre/Segment) is zero. If system does not find the balance to be zero, then it generates additional line items to make the balance zero.

Note: A G/L Account should be created to assign for zero balance functionality.


Step V

Activating Document Splitting

IMG Path: Financial Accounting (New)>General Ledger Accounting (New)>Business Transactions> Document Splitting > Activate Document Splitting

In this step we activate Document Splitting functionality by assigning the Document Splitting Method.

Further, following options are available at this screen:

Inheritance: With this option, system forwards the characteristics from the lines which contain them to the lines which do not.

For e.g. in case of Vendor invoice booking, the Profit Centre is passed from expense line items to vendor line items.

Standard A/c. Assignment

This option if activated along with Constant, the characteristics under the Constant are forwarded to the line items without characteristics. If this option is activated alongwith Inheritance, system forwards the characteristics as per Inheritance as explained above.

Tags#

Account Assignment Category, Balancing field profit centre, Business Transaction Variant, document splitting, SAP document splitting, 

I am SAP FICO Consultant with 7+ years of SAP experience having done 4 Projects.