- Organizational Units
Client
- At highest level in ERP system
- Data entered at client level used for all organizational units
- Each client has its own set of master data
- Important organizational units in FI
Company code:
- Independent legal entity
For external purpose
Business Area
- For internal purpose
- Can be used across company codes
- Can have financial statement for each Business Area
- Exercise: Organizational Units
- Change company code definition
- Tcode: SPRO – ES- Def. – FA- Edit, copy, Del- Check co. code- Edit company code data
- Data:
Co. code | MR03 |
Country | US |
Currency | USD |
Language | EN |
| |
- Enter company code Global Parameters
Company code | MR03 |
Company | 1000 |
COA | INT |
Fiscal Year Variant | 33 |
Field status variant | 1000 |
Posting Period Variant | MR05 |
- Variant Principle
- Variant Principle: A 3 step method to assign properties to one / more objects
Steps:
- Define variant ( K4 Fiscal year variant)
- Determine values for the variant defined: Variant properties
- Assign variant to objects : Assign variant K4 to object company code
- Fiscal Year
Fiscal Year Variant:
- Define a fiscal year with posting periods
- Fiscal year contain posting periods + Special posting periods
- Maximum periods = 16
- System derive period for a document from the posting date
- Special posting period:
- Used for yearend closing transactions. Posting date falls in last period, can post in special posting period
- E.g.: FY with PP = 12 and special period = 4. Transaction date falls in 12th posting period can post in 4th special (16th) period.
- Exercise: Fiscal Year
FYV | 64 |
Description | 4 periods |
Number of posting periods | 4 ( Each period has 4 months) |
Number of special periods | 1 |
Provide necessary year shift | |
Define base currency:
- Tcode: SAP Net weaver – General settings – Currencies – Check Exchange Rate Type
Master Data:
- General Ledger Accounts
Chart of Accounts:
- A variant that contain basic of GL a/c
- Has a 4 character ID
- Define properties of GL a/c like language, Length of GL accounts
- COA assigned to a company code
- One COA can be assigned to one / more company codes (variant principle)
Balance sheet a/c
- Balance C/F to the same a/c
P/L a/c:
- Balance carried forward to retained earnings a/c and balance set to zero
- A key is assigned to RE a/c which is the entered in the P/L statement a/c type
Account Group for GL a/c
- Grouping of similar types of accounts. E.g. cash a/c, liquid funds a/c, fixed assets a/c, Expense a/c
- Account group has a number range. For G/L accounts it's always internal number assignment
- Account group controls the display of fields (Field status: Display/ Change ...) in the GL master (FS00)
Field Status
- Field status enable control and display of GL a/c' master data fields
- Field status ranking:
Status | Field Status | Rank |
Hide | Not used | 1 |
Display | Field display only | 2 |
Required | Field required value | 3 |
Optional | | 4 |
Reconciliation account
- This is a vendor / customer GL a/c in COA. Its corresponding account exist in vendor / customer sub ledger
- All postings to sub ledger posted to reconciliation GL a/c in GL
- Reconciliation a/c type: D: Customers, K: Vendors, Assets
- Cannot post directly to reconciliation a/c
- Details of customer / vendor reconciliation a/c: SE38 – RFDKVZ00
Line Item Display
- Show each transaction as a line in a GL a/c display
- Line Item display not possible in following cases:
- Reconciliation a/c (Line item display in sub ledger)
- Revenue a/c (Sales)
- Material Stock a/c
- Tax a/c (Tax amount per line item checked when document displayed)
Account Currency
- Can select company code currency / Local currency as Account currency
- Can also select foreign currency as account currency
- Where LC = A/C currency, can post in any currency
- Where FC = A/C currency can post in only the FC to this GL a/c.
FS00 | One step centrally |
FSP0 | COA Segment |
FSS0 | Co. Code segment |
OBY2 | Copy co. code segment from another company code |
OBY7 | Copy COA Segment from another COA |
- Customer / Vendor Accounts
- Can activate automatic duplication check
Number Range:
- Can be internal / external
- Each number range can be assigned to one / more account group
Dual Control Principle
- Can define certain customer / vendor fields in SPRO as sensitive. For e.g. vendor bank address
- Now if these fields are changed customer /vendor is blocked for payment
- Block removed when a second person with authorization confirms / reject such change
- Exercise General Ledger, Customer, Vendor
Copy from | Copy To |
SAKO | CD05 |
ERG | AE05 |
Display COA:
- Tcode: SAP Easy – FA – GL – Info System – GL Reports – Master Data – GL a/c list
- Reconciliation a/c (Vendor / Customer) contain total of sub ledger transaction figures
Number Assignment
- GL a/c: Only external number assignment
- Customer / Vendor master Record: Can have either external / internal number assignment
- Assign number range to vendor a/c group
- Bank Accounts
Bank master Record
- Bank master record table: BNKA
- Change to bank master record / Display of bank changes: SE38 – RFBKABL0
House Bank
- House bank contain bank master data
- Bank account information for electronic payment
- GL a/c for each bank account in the HB
Bank Type:
- In customer / vendor master record field bank type is used to distinguish different banks
- While processing vendor invoice (MIRO/FB60) user can chose the bank to which payment will be made by APP by selecting bank type in partner bank field
- Create Bank master record: FI01
- Create a saving a/c: FI12
Document Control
- Document Structure
Document Segment
- Document Header
- Document Line Items (2- 999 line items)
Document Type
- Tcode : OBA7
- Document Type defined at client level & applicable for all company codes
- Document Types : AB (Post all GL ac), DG ( Customer and GL), RV (Customer Invoice), RE ( MM billing document)
Document Type Controls:
Document Number Range:
- Can be internal / external
- Up to a Future Fiscal Year : Beginning of next fiscal year system uses number following the last number of the current fiscal year
- For Each Fiscal Year: System starts with a new number each fiscal year
- A document number range can be assigned to (02) multiple document types
Posting Key
- PK defined at client level & so valid for all company codes
PK Control:
Field Status Variant
- FSV is a Group of Field status groups ( G001, G003, G004, G005)
- Field status group: Is a group of similar features. E.g FSG G001: general characteristic, G003: Material consumption a/c general data, additional a/c assignment etc master fields, G004 : Cost Account general data, payment transactions, additional a/c assignments etc
- FSG assigned to GL a/c in tcode FS00 to decide field status of these GL a/c during transactions
- FSV is assigned to a company code
- Posting Periods
Posting Period
- PP is defined in Fiscal Year Variant
- Usually current PP is open and all other PP close to prevent posting to incorrect PP
- Can have as many PP open as required
Posting Period Variant
- Several company codes can use the same PPV
Posting period check
- PP for a document is determined by the posting date
- PPV must contain the a/c type +
- Other a/c types are for further control of accounts D/K/S/M.
- Account type + must always be open if posting to be made to any other a/c type
Year End Closing
- During year end 2 periods are open. Special PP for the last fiscal year and normal PP for the current fiscal year
- E.g. FY: Apr to Mar. In Apr Special PP 13 and normal PP 1 are open
- Posting Authorizations
- Exercises:
GL a/c posting | FB50 |
Vendor Invoice | FB60 |
Vendor Credit Memo | FB65 |
Customer Invoice | FB70 |
Customer Credit Memo | FB75 |
Define/ Display / Copy document number range | FBN1 |
Display customer line item | FBL1N |
| |
- Button Tree: Access screen variants, A/C assignments, Held documents
Posting Control
- Default Values
Can control:
- Whether fiscal year is proposed when document displayed / changed
- CPU date proposed as value date
- Maximum exchange rate difference between exchange rate in document header and exchange rate in table TCURR. If it exceed warning display can be set
- Change Control
- Document Change
- Document header: Only text and reference fields can be changed
- Line Item: No change can be made to amount, account and PK
- When a document is changed following information is logged
- Fields that was changed
- New and Old values
- User who made changes
- Time and date of change
- Display changed documents
- Tcode : SE38 – RFBABL00
- Document Reversal
- Can reverse GL, Customer, and vendor document
- Document can be reversed by:
- Normal reversal posting
- Negative posting
- Payment Terms and Cash Discounts
- Terms of payment
- Enable the system to calculate cash discount and Invoice due date. To calculate Invoice due date and cash discount system needs following information:
- Base Line Date: Date from which Invoice due date is calculated
- Cash discount % and Cash discount Terms
- Terms of payment can be specified in customer / vendor master record in:
- Company code segment
- Sales Area segment
- Purchase Org. segment
- Terms of Payment defaulted:
- FI Invoice: Entered in company code segment
- Sales Order: Entered in Sales Area Segment
- Purchase Order: Entered in Purchase Org. Segment
- Cross Company code Transactions
- Tax posting in cross company code transactions
- Whole amount of tax posted to the company code of 1st line
- If tax is to be distributed use report: SE38 – RFBUST10
- Exercise
Ensure document assignment field is not changed in tcode FB02( Restriction at company code level)
- Tcode : SPRO – FA – FAGS – Document – Line Item – Document change rules
- Ne w entries – Field name assignment (BSEG-ZUNOR) – Applicable for what a/c type (S/K/D/A) – Company code
Ensure document assignment field is not changed in tcode FB02( Restriction at client level)
Prerequisite for negative reversal:
- Company code allow negative posting (OBY6)
- Reversal reason code allow negative posting ( SPRO- FA- GL – BT – Adjustment posting – Define reason for reversal)
- FI Document reversal : FB08
Reset cleared items: FBRA
Create a new terms of Payment
- Tcode : SPRO – FA – AR/AP- BT – Incoming invoices / Credit Memos – Maintain terms of payment – New entries
Terms of payment | AC03 |
Customer Blank | Blank |
Vendor | Select |
Default base line date | Posting date |
% | %% |
No. of days | Blank |
% | 2% |
No. of days | 14 |
No. of days | 30 |
Explanation area of payment terms automatically defaulted
Country | GB |
Tax code | 03 |
Account Type | Output tax |
Acct Key | MWS |
Tax Percent | 20% |
COA | INT |
Tax a/c | 175000 |
Clearing
- Clearing
Two ways to clear OI
- Account clearing (F-32)
- Post with clearing
Customer a/c Dr | 5000 |
To sales a/c | 5000 |
Sales a/c Dr | 5000 |
To Customer a/c | 5000 |
- Posting with Clearing
- Invoice is posted to customer
- Customer pays invoice and payment assigned to the Open Item
- Invoice cleared with above payment & balance is zero
- Clearing transaction creates a clearing document
- Clearing document no line items as no account posting
- Clearing Tcode:
- Automatic: F.13
- Manual: F-03
- Automatic Clearing Program
Program groups items in a GL a/c where they have same entries in the following fields:
- GL a/c number
- Currency
- Special GL indicator
- Five definition criteria ( Assignment field)
- If balance is Zero in Local currency, program clears the items
Account to be cleared defined in SPRO
Automatic Program does not clear following items:
- Assignment Field: Value comes from sort fields in FS00
- Tolerances:
- Tolerances:
- Rules that define acceptable differences during posting
- Tolerance Group Assignment:
- Employee Tolerance Group: Assigned to employees
- GL a/c Tolerance Group: Assigned to GL a/c in FS00
- Customer / Vendor Tolerance Group: Assigned to customer / vendor in customer/ vendor master records
- If no tolerance group assigned then blank tolerance group applies
- Automatic clearing of Payment differences
- Payment differences should be with in both tolerance (amount & %) to be cleared automatically
- Entries in tolerance group always cleared in Local currency / company code currency
- Reason Codes:
- Reason codes used to analyze and post payment differences
- To assign more than one reason code to a payment difference click distribute differences
Reason code functions:
- Control type of payment notice sent to the customer
- Control account to which residual item posted
- Exclusion of residual item from credit limit check
- Exchange Rate Differences
- When clearing open items against payment received exchange rate difference may occur due to exchange rate fluctuation. This is posted to exchange rate difference realized account
- Exchange rate difference also occurs when valuating foreign currency open items for financial statements. These are posted to separate Exchange rate difference account and reverse in next period.
Reason code | Z03 |
Text | Damaged in Transit |
C | Charge of difference via a separate a/c |
Type of correspondence with customer |
- Map GL a/c to Reason code
- Tcode: OBXL
- Data: 881000
Cash Journal
Cash Journal
Special GL Transactions
Down payment Request
- Noted Items, Not included in GL
- Only 1 line
- Reminders
- Payment Program and Dunning Program can access noted items
- FBL5N : Noted Items
- DP Request – Down payment received – DP request considered – Customer Invoice received – DP cleared against customer Invoice
Down Payment
- Part of Financial statement. Create a proper posting in GL a/c
- FBL5N – Special GL items
Guarantee
- Automatic offsetting entries
- Displayed in Notes to accounts
Customer alternative Reconciliation a/c Dr |
To Guarantee Clearing a/c |
Guarantee Clearing a/c Dr |
To Customer alternative reconciliation a/c |
|
- Configuration of Special GL Transactions: FBKP
Customer | Reconciliation a/c (FD03) | Alternative Reconciliation (FBKP) | Spl. Transaction Type |
21003 | 140000 | 196100 | G |
A/C Type (D/K/S/A/M) | Spl GL Indicator | Description | Reconciliation a/c | Alternative Reconciliation a/c |
D | F | Down Payment Request | 140000 | 196000 |
D | A | Down Payment | 140000 | 170000 |
D | E | Reserve for Bad Debt | 140000 | 142000 |
D | G | Guarantee | 140000 | 196100 |
- Exercises
- Enter a Guarantee:
- Tcode: F-38
- Tcode: easy – A/C – FA – AR – Document Entry – Other – Statistical Posting
- Data:
Document Type | DA |
PK | 09 |
Customer | 100196 |
Due on | After 3 months |
Display Guarantee
- Tcode: FBL5N (Select special GL transaction)
- Create a Down Payment Request:
Customer | 100196 |
Click process DP | |
Double click Transfer Posting | |
Save | |
- Individual Adjustments (PBDD)
- Use Special GL transaction E to make an individual value adjustment of 6000
- Tcode: F-21
- Tcode: Easy – A/C – FA – AR – DE – Other – Transfer w/o clearing
- Data:
Posting date | Last day of current month |
PK | 19 |
Customer | 100196 |
Special GL Indicator | E |
PK | 40 |
GL a/c ( Bad Debt / Uncollectible) | 210100 |
A/C Entry | |
Bad Debt / Uncollectible Expense a/c (210100) Dr | 6000 |
To Allowance for Bad debt (PBDD: 142000 alternative reconciliation a/c for customer 100196) B/S account | 6000 |
| |
Held / Park Documents
Park Document:
- Document number is assigned
- Considered for reports
- Document can be found with any user ID
- Can be used as part of principle of dual control