Friday, December 10, 2010

10. Profitability Analysis


11. Product Costing


8. Internal Order

Internal orders
Definition: Internal order is tool to gather the costs. At period end, we need to close the order.

Note: Set controlling area (Tcode: OKKS)
Controlling area                    :
Enter

1. Create internal Settlement Cost Element (Tcode: KA06)

Cost Element                                   : Settlement
Valid From                                       :
Enter
Name                                                 : Settlement
Description                                       : Settlement cost element
CElem category                               : 21
Save

2. Maintain Allocation Structures

During settlement, costs incurred under the primary and secondary cost elements by a sender are allocated to one or more receivers. When you settle by cost element, you settle using the appropriate original cost element.

Path: SPRO- SAP Reference IMG- Controlling- Internal Orders- Actual Postings- Settlement- Maintain Allocation Structures (Tcode:OKO6)
Execute

Select A1 Co allocation structure
Double click on assignments
Select 025 Settlement
Double click on Source
From Cost El                        .                       : 400000
To cost elem.                                     : 499999
Double click on Settlement cost elements
Click on New Entries (F5)
Receiver Cat.                                               : CTR
Settlement cost elem.                                 : Settlement
Save and enter

3. Create internal order

Path: Accounting- Controlling - Internal Orders - Master Data - Special Functions - Order - KO01 - Create (Tcode:KO01)
Order type                                        : 150
Enter
Controlling area                              :
Enter
Click on Settelement rule (Shift+F5)
Cat     Setle Rec.                              Percent         
CTR   111112           MM Class      30.00
CTR   111113           SD Class        20.00
CTR   111114           ABAP Class 50.00
Save
Ignore warning messages

Order number                                  :

Note: Order should be Release mode. In create mode, we can’t post costs to Internal order.

4. Change Internal order (Tcode: KO02)

Order                                                 :
Enter
Goto Control data Tab
click on release
Save
Ignore warning messages

5. Posting to Internal order (Tcode: F-02)

Enter header data (Type SA)
PstKy                                                 : 40
Account                                             : 400010
Enter
Amount                                             : 100000
Order                                                 :
PstKy                                                 : 50
Account                                             : 290100
Enter
Amount                                             :*
Go to Menu bar
Document - simulate
Save
  
6. Internal order report

Path: Accounting - Controlling - Internal Orders - Information System - Reports for Internal Orders - Line Items - KOB1 - Orders: Actual Line Items (Tcode:KOB1)
Order                                                 :
Execute (F8)

7. Planning

Path: Accounting - Controlling - Internal Orders - Planning - Cost and Activity Inputs - KPF6 - Change (Tcode: KPF6)
Version                                              : 0
From period                                      : 1
To period                                           : 12
Fiscal year                                        : 2009
Order                                                 :
Cost element                                    : 400000
To                                                       : 499999
Click on Overview screen (F5)
Cost element                                                   Total Plan Costs
400010           Rent A/C                               200,000.00
400020           Bank Charges A/C             50,000.00
400030           Cash Dis. Given A/C           75,000.00
400040           LS.Sale of Asset A/C           105,000.00
400050           Scrap on Asset A/C             125,000.00
400060           Depreciation A/C                   35,000.00
400100           Service A/C                            100,000.00
Save
  
8. Interanl order comparision report (Variance report)

Path: Accounting - Controlling - Internal Orders - Information System - Reports for Internal Orders - Plan/Actual Comparisons - S_ALR_87012993 - Orders: Actual/Plan/Variance (Tcode:S_ALR_87012993)
Controlling area                              :
Fiscal year                                        :
From period                                      : 1
To period                                           : 12
Plan version                                     : 0
Value (S)                                           :
Execute (F8)

9. Internal order budgets

Path: Accounting -Controlling - Internal Orders - Budgeting - Original Budget - KO22 - Change (Tcode: KO22)
Order                                                   :
Enter
Overall                                                : 300000
2009                                                    :300000
Save
           
10. Internal order Budget report

Path: Accounting - Controlling - Internal Orders - Information System - Reports for Internal Orders - More Reports - S_ALR_87013019 - List: Budget/Actual/Commitments (Tcode:S_ALR_87013019)

Controlling area                                  :
Value(S)                                              :
Execute (F8)

11. Change Internal order (Tcode: KO02)

Order                                                   :
Enter
Go to Control data Tab
Click on Tech.Comple
Save

12. Maintain Number ranges for Internal order settlement document

Path: SPRO - SAP Reference IMG- Controlling- Internal Orders- Actual Postings- Settlement- Maintain Number Ranges for Settlement Documents (Tcode:KO8N)
Execute

Click on Maintain groups (F6)
Select Standard Accounting document
Double click on
Click on Element/Group (F5)
Save and enter



13. Settlement of internal order

Path: Accounting - Controlling - Internal Orders - Period-End Closing - Single Functions - Settlement - KO88 - Individual Processing (Tcode:KO88)

Order                                                   :
Settlement period                                :
Fiscal year                                           :
Select Test run
Execute
Click on Details list (Ctrl+Shift+F3)
Two time go back
Deselect Test run
Execute

14. Close Internal order (Tcode: KO02)
Order                                                   :
Enter
Go to control data Tab
Click on close
Save

Hence:
Internal order creation: We can’t post documents to internal order
Internal order release: We can post documents to internal order and settlement the order
Technically Complete: We can post documents and Settle the order
Internal order close: We can’t post documents to internal orders

 

9. Profit Center Accounting


7. Cost Center Accounting


6. Asset Accounting


3. Accounts Receivable


2. Accounts Payables



Accounts payables:

This component will deal with vendors, Terms and conditions, Invoices, outgoing payments, Advance to vendors, Etc. Vendors are subsidiary ledgers. AP component integrates with General ledger component.

1.    Define Account Groups


Definition: It controls fields in master record and number range intervals.

Path: SPRO- Financial Accounting(New)- Accounts Receivable and Accounts Payable- Vendor Accounts- Master Data- Preparations for Creating Vendor Master Data- Define Account Groups with Screen Layout (Vendors) (Tcode:OBD3)
Execute

Click on New Entries (F5)
Account Group                                 :
Name                                                 : Dom.Vendors
Save and enter









Create Number Ranges for Vendor Accounts


Path: Same path (Tcode: XKN1)
Execute                                             

Click on Change interval
Click on Insert interval (shift+S)
No                                                       :
From Number                                  :
To Number                                       :
Enter
Save and enter

Assign Number Ranges to Vendor Account Groups


Path: same path (Tcode: OBAS)
Execute

Go to Position button
Account group                                 :
Enter
Number range                                 :
Save and enter







Define Tolerances (Vendors)


Path: SPRO- Financial Accounting(New)- Accounts Receivable and Accounts Payable- Business Transactions- Outgoing Payments- Manual Outgoing Payments- Define Tolerances (Vendors) (Tcode:OBA3)
Execute

Click on New Entries (F5)
Company code                                 :
Save and enter




















Maintain Number ranges 19, 15, 17 for KR, KZ, KA document types respectively (KR: Vendor Invoice, KZ: Vendor payment, KA: Vendor Document)


Path: SPRO- SAP Reference IMG- Financial Accounting (New)- Financial Accounting Global Settings (New) - Document- Document Number Ranges- Documents in Entry View- Define Document Number Ranges for Entry View (Tcode:FBN1)
Execute

Company Code                                :
Click on change interval
Click on Insert interval (Shift+F1)
No                                                       : 19
Year                                                   : 2009
From number                                   : 1900000000
To Number                                       : 1999999999
Enter
Click on Insert interval (Shift+F1)
No                                                       : 15
Year                                                   : 2009
From number                                   : 1500000000
To Number                                       : 1599999999
Enter
Click on Insert interval (Shift+F1)
No                                                       : 17
Year                                                   : 2009
From number                                   : 1700000000
To Number                                       : 1799999999
Enter
Save and enter

Create Vendor Reconciliation Account (Tcode: FS00)


G/L Account                                     : 190100
Company Code                                :
Click on create
Go to Type/Description Tab
Account Group                                 : LIAB Liabilities
Select Balance sheet Account
Short Text                                        : Dom.Vendors A/C
G/L Acct Long Text                                    : Domestic Vendors Account
Go to Control data Tab
Recon.account for Acct type          : K Vendors
Select Line item display
Sort Key                                            : 012 (Vendor Number)
Go to Create/Bank/Interest tab
Field Status Group                         : G067
Save













Create Vendor Master Record


Path: Accounting - Financial Accounting - Accounts Payable - Master Records - FK01 - Create (Tcode: FK01)

Company Code                                :
Account Group                                 :
Enter
Title                                                   : Company
Name                                                 : OMC
Search Term                                                : Hyderabad
Street                                                 :
House number                                 :
Postal code                                        : 500020
City                                                    : Hyderabad
Country                                             : IN
Enter, enter and enter
Recon.account                                  :190100
Sort Key                                            : 012
Cash mgmnt group                         : A1
Enter
Payt terms                                        : 0001 (Immediately)
Save



Create Service G/L Master Record (Tcode: FS00)


G/L Account                                     : 400100
Company Code                                :
Click on create
Go to Type/Descripition Tab
Account Group                                 : EXPN Expense
Select P&L Statement acct
Short Text                                        : Service A/C
G/L Acct Long Text                                    : Service Account
Go to Control Data Tab
Select only balances in local crcy
Select Line item display
Sort Key                                            : 001
Go to Create/bank/interest Tab
Field status group                           : G001
Save


Enter Vendor Invoice


Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - F-43 - Invoice - General (Tcode: F-43)

Enter header data (Type KR)
PstKy                                                 : 31 (Credit)
Account                                             : __________ (Vendor Number)
Enter
Amount                                             : 25000
Business Area                                  :
PstKy                                                 : 40 (Debit)
Account                                             : 400100 (Service G/L)
Enter
Amount                                             :*
Click on More
Business Area                                  :
Enter
Go to menu bar
Document - simulate
Save

Vendor Line item report


Path: Accounting - Financial Accounting - Accounts Payable - Account - FBL1N - Display/Change Line Items (Tcode: FBL1N)

Vendor Account                               :
Company Code                                :
Select open items   
Execute (F8)


Outgoing payments

Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Outgoing Payment - F-53 - Post (Tcode: F-53)

Enter Header Data (Type KZ)
Account                                             : 290100 (Bank A/C)
Amount                                             : 25000
Account                                             :__________ (Vendor Number)
Enter
Note: Select Invoice amount against which invoice we are paying, Deselect Remaining invoices. Select means Blue color and Deselect means block color.
Note: Amount entered and Assigned amount should be same
See Report (Tcode: FBL1N)

 Partial payments (Tcode: F-53)


Enter header data (Type KZ)
Account                                             290100 (Bank A/C)
Amount                                             10000
Account                                             : _________ (Vendor Number)
Enter
Go to Partial pmt Tab
Payment amount                            : 10000
Save
See Report (Tcode: FBL1N)



 Residual items (Tcode:F-53)


Definition: In Residual items, system will re determine terms of payments.
Enter header data (Type KZ)
Account                                             : 290100
Amount                                             : 5000
Account                                             :          
Enter
Go to Res.items Tab
Residual items                                 : 30000-
Enter
Go to Menu bar
Document - simulate
Double click on blue color line item
Text                                                    : Being Residual items
Payment terms                                : 0002
One time go back
Save
See Report (Tcode: FBL1N)

 Automation of Bank Charges and Cash discount

Creation of Bank Charges G/L Account (Tcode: FS00)

                 
G/L Account                                     : 400020
Company Code                                :
Click on create
Go to Type/Description Tab
Account Group                                 : EXPN Expenses
Select P&L statement acct
Short Text                                        : Bank Charges A/C
G/L Acct Long Text                                    : Bank Charges Account
Go to Control data Tab
Select only balances in local crcy
Select Line item display
Sort Key                                            : 001
Go to Create/bank/Interest Tab
Field status group                           : G001
Save

15. Creation of Cash Discount Taken G/L Account (Tcode: FS00)


G/L Account                                     : 300010
Company Code                                :
Click on create
Go to Type/Description Tab
Account Group                                 : INCO Incomes
Select P&L statement acct
Short Text                                        : Cash Dis.Taken A/C
G/L Acct Long Text                                    : Cash Discount Taken Account
Go to Control data Tab
Select only balances in local crcy
Select Line item display
Sort Key                                            : 001
Go to Create/bank/Interest Tab
Field status group                           : G001
Save


Creation Accounts for Cash Discount Taken


Path: SPRO- SAP Reference IMG- Financial Accounting (New)- Accounts Receivable and Accounts Payable- Business Transactions- Outgoing Payments- Outgoing Payments Global Settings- Define Accounts for Cash Discount Taken
 (Tcode: OBXU)
Execute

Chart of Accounts                           :
Enter
Save
Account                                             : 300010
Save and enter

Define Accounts for Bank Charges (Vendors)


Path: Same path (Tcode: OBXK)
Execute

Double click on Bank Charges BSP
Chart of Accounts                           :
Enter
Account                                             : 400020
Save and enter






Outgoing payment to vendor with bank charges and cash discount (Tcode: F-53)


Enter header data (Type KZ)
Account                                             : 290100
Amount                                             :
Business Area                                  :
Bank charges                                   :
Account                                             : ______________ (Vendor A/c)
Enter
Cash Discnt                                      :
Go to Menu bar
Document - Simulate
Save

 

Down payments (Advance To vendors)

Create Advance to Vendor G/L Account (Tcode: FS00)

G/L Account                                     : 290200
Company Code                                :
Click on create
Go to Type/Description Tab
Account Group                                 : ASST Assets
Select Balance Sheet Account
Short Text                                        : Adv. to Vendors A/C
G/L Acct Long Text                                    : Advance to Vendors Account
Go to Control Data Tab
Recon. account for acct type         : K Vendors
Select Line item Display
Sort Key                                            : 012
Go to Create/Bank/Interest Tab
Field Status Group                         : G067
Save
Assign Adv. to Vendor Account

Path: SPRO- SAP Reference IMG- Financial Accounting (New)- Accounts Receivable and Accounts Payable- Business Transactions- Down Payment Made- Define Alternative Reconciliation Account for Down Payments (Tcode: OBYR)
Execute

Double click on
K    A     Dwn pmt         Down payment on current assets
Chart of Accounts                           :
Enter
Recon.acct                                         : 190100
Special G/L Account                       : 290200
Save and enter













Scenario 1

Advance to Vendor             :Rs 100000
Service                                   :Rs 100000
Advance to Vendor

Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-48 - Down Payment (Tcode:F-48)

Enter header data (Type KZ)
Account                                             :
Special G/L Ind.                               : A
Account                                             : 290100
Amount                                             : 100000
Enter
Amount                                             :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)














Service Invoice (Tcode: F-43)

Enter Header data (Type KR)
PstKy                                                 : 31
Account                                             :          
Enter
Amount                                             : 100000
PstKy                                                 : 40
Account                                             : 400100
Enter
Amount                                             :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)

Clearing advance against Invoice

Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Other - F-51 - With Clearing (Tcode: F-51)

Enter header data (Type AB)
Select transfer posting with clearing
Choose open items (F6)
Company Code                    :
Account                                 :
special G/L Ind.                   : A
Enter
Save
See Report (Tcode: FBL1N)

 Scenario 2

Advance to Vendor             :Rs 100000
Invoice                                   : Rs 50000

Advance to vendor (Tcode:F-48): Rs100000
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-48 - Down Payment (Tcode:F-48)

Enter header data (Type KZ)
Account                                             :
Special G/L Ind.                               : A
Account                                             : 290100
Amount                                             : 100000
Enter
Amount                                             :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)


Invoice (Tcode:F-43): Rs50000
Enter Header data (Type KR)
PstKy                                                 : 31
Account                                             :          
Enter
Amount                                             : 50000
PstKy                                                 : 40
Account                                             : 400100
Enter
Amount                                             :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)


Transfer posting

Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-54 - Clearing (Tcode:F-54)

Enter header data (Type KA)
Account                                             :
Keep blank invoice Field
Text                                                    : Being Transfer posting
Enter
Transfer posting                              : 50000
Save
                   



Clear Advance against Invoice (Tcode:F-51)

Enter header data (Type AB)
Select transfer posting with clearing
Choose open items (F6)
Company Code                                :
Account                                             :
Enter
Save
See Report (Tcode: FBL1N)

Scenario 3

Advance To Vendor            : Rs 100000
Invoice                                   : Rs 150000

Advance to Vendor (Tcode: F-48): Rs100000
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-48 - Down Payment (Tcode:F-48)

Enter header data (Type KZ)
Account                                             :
Special G/L Ind.                               : A
Account                                             : 290100
Amount                                             : 100000
Enter
Amount                                             :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)


Invoice (Tcode: F-43): Rs150000
Enter Header data (Type KR)
PstKy                                                 : 31
Account                                             :          
Enter
Amount                                             : 150000
PstKy                                                 : 40
Account                                             : 400100
Enter
Amount                                             :*
Go to Menu bar
Document - simulate
Save
See Report (Tcode: FBL1N)


Transfer posting (Tcode: F-54): Rs100000
Path: Accounting - Financial Accounting - Accounts Payable - Document Entry - Down Payment - F-54 - Clearing (Tcode:F-54)

Enter header data (Type KA)
Account                                             :
Keep blank invoice Field
Text                                                    : Being Transfer posting
Enter
Transfer posting                              : 100000
Save

Outgoing payment (Tcode: F-53): Rs 50000