Tuesday, March 27, 2012
SAP R/3 Company Code Configuration
Financial Accounting (FI) is central module in any business
system. Finance Module gets postings from other modules like Materials
Management (MM), Human Resource (HR), Sales and Distribution (SD) etc through
integration. FI module supplies data to Costing Module (CO). All external
reporting is from FI.
Most important Organizational Structure in FI is Company Code. Balance sheet is drawn on
a company code. Company code is the legal entity to the external world.
Organizational structures in other modules like Purchasing Organization in MM, Plant in Logistics, and Sales Organization in SD are all assigned to Company Code.
Further Company code is assigned to Controlling area.
Company code is represented in character length and usually in numerics like -1100.
Other Organiztional structures are attached to Company Code.
Basically the first peice of configuration done in an SAP implementation is Company Code!
Monday, March 26, 2012
SAP FI - GL Account Clearing
GL Account Clearing Methods
There are three methods to clear Accounts with Open Items management in SAP.
1.Posting with Clearing.
Emter document line item and select line item to be cleared. System creates offsetting postings for the items to be cleared.
2. GL Account Clearing.
Select open items that balance to zeros for a GL Account.
System marks these items as cleared with corresponding document reference in assignment field.
3. Automatic Clearing
Program uses pre-defined grouping criteria for open items of GL, Vendor, Customer. If the balance of grouped items equals zero in local, foreign and parallel currency (if available) then items are markes as cleared.
There are three methods to clear Accounts with Open Items management in SAP.
1.Posting with Clearing.
Emter document line item and select line item to be cleared. System creates offsetting postings for the items to be cleared.
2. GL Account Clearing.
Select open items that balance to zeros for a GL Account.
System marks these items as cleared with corresponding document reference in assignment field.
3. Automatic Clearing
Program uses pre-defined grouping criteria for open items of GL, Vendor, Customer. If the balance of grouped items equals zero in local, foreign and parallel currency (if available) then items are markes as cleared.
SAP FI - GL Manual Account Clearing
SAP Transaction: F-03
Clears open items on a single GL code
You want to clear open items on a GL code which is open item managed and showing uncleared.
Menu Path: Accounting->Financial Accounting->General Ledger->F-03 Clear
Double click on transaction code F-03 Clear
Enter the fields 'Account' (eg. 42000), Clearing date: (eg. 31.12.2008)
Enter 'Company Code' (3000) and 'Currency' (USD)
Click on 'Process Open Items'
Items fulfilling selection criteria are displayed.
Now you have to select items you want to clear.
Double click on each of these items.
The value of the field 'Not Assigned' is 0, means they are not cleared.
You can simulate before posting.
Clears open items on a single GL code
You want to clear open items on a GL code which is open item managed and showing uncleared.
Menu Path: Accounting->Financial Accounting->General Ledger->F-03 Clear
Double click on transaction code F-03 Clear
Enter the fields 'Account' (eg. 42000), Clearing date: (eg. 31.12.2008)
Enter 'Company Code' (3000) and 'Currency' (USD)
Click on 'Process Open Items'
Items fulfilling selection criteria are displayed.
Double click on each of these items.
The value of the field 'Not Assigned' is 0, means they are not cleared.
You can simulate before posting.
Sunday, March 25, 2012
End User Document - GL Automatic Clearing
Transaction code: F.13
Clears GL in one run.
You can define 3 fields for sort criteria (in the configuration). Eg, all documents with the same value in the field "Assignment".
Example:
GR/IR Accounts and Fright Clearing Accounts are managed open item clearing.
They have Debit / Credit transactions.
At the end of each period (month) you can match certain Debits to Credits automatically.
For this, the GL Accounts have to be marked as open item when they are created.
Follow the menu path: Accounting->Financial Accounting->Automatic Clearing->Without Specific Clearing Currency (F.13)
Double click on F.13 transaction
1. Enter the Company code, Fiscal year
2. Cleck on 'Select GL Account' Button (We want to process GL Accounts only)
Eg. GL account 191100
3. At the bottom of the screen click on 'Only Documents that can be cleared' (System will clear only documents that can be cleared as per predefined criteria (eg. same assignment number)
4. click Test Run (for test mode, by default it will be in test mode)
5. Click 'Execute' to run
Below is the screen you get
If you run it without 'Test mode', you will get a message 'Document number xxxxxx updated in compnay code: 3000'.
Clears GL in one run.
You can define 3 fields for sort criteria (in the configuration). Eg, all documents with the same value in the field "Assignment".
Example:
GR/IR Accounts and Fright Clearing Accounts are managed open item clearing.
They have Debit / Credit transactions.
At the end of each period (month) you can match certain Debits to Credits automatically.
For this, the GL Accounts have to be marked as open item when they are created.
Follow the menu path: Accounting->Financial Accounting->Automatic Clearing->Without Specific Clearing Currency (F.13)
Double click on F.13 transaction
2. Cleck on 'Select GL Account' Button (We want to process GL Accounts only)
Eg. GL account 191100
3. At the bottom of the screen click on 'Only Documents that can be cleared' (System will clear only documents that can be cleared as per predefined criteria (eg. same assignment number)
4. click Test Run (for test mode, by default it will be in test mode)
5. Click 'Execute' to run
Below is the screen you get
If you run it without 'Test mode', you will get a message 'Document number xxxxxx updated in compnay code: 3000'.
Subscribe to:
Posts (Atom)