SAP FI Certification Material
- 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
- At highest level in ERP system
- Important organizational units in FI
- Company code:
- Independent legal entity
- For external purpose
- Independent legal entity
- Business Area
- For internal purpose
- Can be used across company codes
- Can have financial statement for each Business Area
- For internal purpose
- Create company code steps
- Copy co. code
- Copies :
- Definition (company name)
- Global parameters (COA, Fiscal year, Co code default)
- Tables
- G/L a/c's
- Account determination
- Definition (company name)
- Now edit this data
- Address
- Company code currency: This is company code / local currency. All other currencies are foreign currencies.
- Language Key
- Country key: This is home country. All other countries are foreign countries
- Address
- Copy co. code
- Exercise: Organizational Units
- Copy company code
- Tcode: EC01
- Data : MR03
- Tcode: EC01
- 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
- Define variant ( K4 Fiscal year variant)
- 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.
- Define a fiscal year with posting periods
- Year Independent Fiscal Year Variant:
- FYV uses same number of periods each year
- Posting period start and ends on the same date every year
- Can be Calendar Year .Here PP = 12 months of the year
- Can be non calendar year
- Here PP # 12 months of the year. PP can be from 1 to 16.
- Need to assign end date for each posting period
- Need to assign indicator -/+ as required
- e.g Apr to Mar. For Jan, Feb & Mar year shift of -1 as belongs to old fiscal year
- Here PP # 12 months of the year. PP can be from 1 to 16.
- FYV uses same number of periods each year
- Exercise: Fiscal Year
- When is the year specific fiscal year variant used?
- One fiscal year has fewer posting periods than others
- Start and End dates of posting periods differ from year to year
- One fiscal year has fewer posting periods than others
- Maintain a Fiscal Year Variant
- Tcode: OB29
- Data: FYV : 33
- Tcode: OB29
- Assign Fiscal Year Variant (33) to company code MR03
- Tcode: OB37
- Tcode: OB37
- Create a FYV (Non calendar year FYV)
- Tcode: OB29
- Data:
- Tcode: OB29
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
- 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
- A variant that contain basic of GL a/c
- Definition of Chart of Accounts
- Tcode: OB13
- Define:
- COA key
- Description
- Maintenance language
- Length of GL a/c
- Manual / Automatic creation of cost elements
- Group chart of account
- Blocked / unblocked. If COA blocked, no GL a/c can be created for this COA
- COA key
- Tcode: OB13
- Directory of GL a/c in COA:
- Tcode: SE38 – RFSKPL00
- Tcode: SE38 – RFSKPL00
- One COA can be assigned to one / more company codes (variant principle)
- COA contain information about GL in Company code segment and COA segment
- Co. code Segment:
- To use one of the GL account from COA need to create a company code segment
- Control data
- Bank / Interest
- Information
- To use one of the GL account from COA need to create a company code segment
- Chart of Account Segment:
- Type / Description
- Key word in COA
- Information in COA
- Type / Description
- Balance sheet a/c
- Balance C/F to the same 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
- Balance carried forward to retained earnings a/c and balance set to zero
- 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)
- Grouping of similar types of accounts. E.g. cash a/c, liquid funds a/c, fixed assets a/c, Expense a/c
- Field Status
- Field status enable control and display of GL a/c' master data fields
- Field status ranking:
- Field status enable control and display of GL a/c' master data fields
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
- This is a vendor / customer GL a/c in COA. Its corresponding account exist in vendor / customer sub ledger
- 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)
- Show each transaction as a line in a GL a/c display
- Open Item Management:
- These a/c have line item display activated
- Open Item display mandatory for a/c with offsetting entries
- OI management used for following a/c types:
- Bank clearing a/c
- GRIR a/c
- Salary clearing a/c
- Bank clearing a/c
- These a/c have line item display activated
- 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.
- Can select company code currency / Local currency as Account currency
- Only balance in Local currency:
- If selected transaction figures to this a/c posted in local currency only
- To be selected for clearing a/c like GRIR to avoid difference due to exchange rates fluctuation
- You would set this indicator for accounts in which you do not want the system to update transaction figures separately by currency.
- If selected transaction figures to this a/c posted in local currency only
- GL account creation
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
- Customer / Vendor Master Data have 3 segments
- General data:
- At client level
- At client level
- Company code data:
- Any company code that wishes to do business with customer / vendor has to have a company code segment
- Any company code that wishes to do business with customer / vendor has to have a company code segment
- Customer:
- Sales area segment
- Sales area segment
- Vendor:
- Purchasing org. Segment
- Purchasing org. Segment
- SE38 – RFBIDE10 / RFBIKR10:
- To transfer customer / vendor master data from Source Company code to another company code
- To transfer customer / vendor master data from Source Company code to another company code
- Can activate automatic duplication check
- Account Group for customer / Vendor:
- Once a customer / vendor created cannot change its a/c group in FI
- Controls field status of customer / vendor master records
- Controls customer / vendor number range
- Once a customer / vendor created cannot change its a/c group in FI
- Number Range:
- Can be internal / external
- Each number range can be assigned to one / more account group
- Can be internal / external
- Special Customer / Vendor master record
- These are one time customer / vendor
- No information about customer / vendor entered in the master record
- Customer / Vendor information entered at the time of document posting
- Special customer / vendor master record cam be used for more than one Customer / vendor
- These are one time customer / vendor
- 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
- Can define certain customer / vendor fields in SPRO as sensitive. For e.g. vendor bank address
- Exercise General Ledger, Customer, Vendor
- Copy GL Account group
- Tcode: OBD4
- Data:
- Tcode: OBD4
Copy from | Copy To |
SAKO | CD05 |
ERG | AE05 |
- Create a GL a/c in GL a/c group AE05
- Tcode: FS00
- Data: 176499 (Expense a/c)
- Tcode: FS00
- Display COA:
- Tcode: SAP Easy – FA – GL – Info System – GL Reports – Master Data – GL a/c list
- 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
- Create a/c group for customer
- Tcode: SPRO – FA – AR/AP – CA – MD – Preparation for creating CMD – Define a/c group with screen layout
- Data: Copy from KUNA to D05
- Tcode: SPRO – FA – AR/AP – CA – MD – Preparation for creating CMD – Define a/c group with screen layout
- Assign number range to a/c group (D05)
- Tcode: SPRO – FA – AR/AP – CA – MD – Preparation for creating CMD
- Tcode: SPRO – FA – AR/AP – CA – MD – Preparation for creating CMD
- Create customer A/C in the account group D05
- Tcode: FD01 / Sap Easy
- Tcode: FD01 / Sap Easy
- Search term field in Vendor master record
- Controlled by field status group
- Search term A: Required entry so appear
- Search Term B: Suppressed entry so not appear
- Controlled by field status group
- Define sensitive fields for dual control
- Tcode: SPRO – FA – AR/AP – Vendor a/c – Master data – Preparation for creating vendor master - Define sensitive fields for dual control
- Tcode: SPRO – FA – AR/AP – Vendor a/c – Master data – Preparation for creating vendor master - Define sensitive fields for dual control
- Confirm customer / vendor master changes (Dual control)
- Customer: FD09
- Vendor: FK09
- Customer: FD09
- Number Assignment
- GL a/c: Only external number assignment
- Customer / Vendor master Record: Can have either external / internal number assignment
- GL a/c: Only external number assignment
- Create a Vendor a/c group
- Tcode: SPRO- FA- AR/AP – MD – Preparation for creating vendor master record – Define screen layout
- Tcode: SPRO- FA- AR/AP – MD – Preparation for creating vendor master record – Define screen layout
- Assign number range to vendor a/c group
- Create Vendor a/c:
- Tcode: FK01
- Tcode: FK01
- Bank Accounts
- Bank master Record
- Bank master record table: BNKA
- Change to bank master record / Display of bank changes: SE38 – RFBKABL0
- Bank master record table: BNKA
- House Bank
- House bank contain bank master data
- Bank account information for electronic payment
- GL a/c for each bank account in the HB
- House bank contain bank master data
- 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
- In customer / vendor master record field bank type is used to distinguish different banks
- Create Bank master record: FI01
- Define HB: FI12
- Create a saving a/c: FI12
- Document Control
- Document Structure
- Document Principle:
- A document is saved for every posting
- Every document is identified by:
- Document number
- Company code
- Fiscal Year (Tcode: FB03)
- Document number
- A document is saved for every posting
- Document Segment
- Document Header
- Document Line Items (2- 999 line items)
- Document Header
- 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:
- Properties:
- Number Range
- Reverse Document Type
- Authorization group
- Number Range
- A/C Types Allowed:
- Asset
- Customer
- Vendor
- Material
- GL
- Asset
- Control data:
- Negative Postings permitted
- Intercompany posting
- Net document Type: system automatically deduct cash discounts from vendor invoices that are posted with this document type
- Negative Postings permitted
- Required during document Entry:
- Reference Number
- Document Header text
- Reference Number
- Tcode : OBA7
- 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
- Can be internal / external
- Posting Key
- PK defined at client level & so valid for all company codes
- PK Control:
- D/C indicator
- Account type that can be posted ( Customer / Vendor / GL/ Asset / Material)
- Other Attributes
- Whether line item connected with payment ( select where incoming / outgoing payment transactions)
- Indicator whether PK used for entering special GL transactions
- Whether line item connected with payment ( select where incoming / outgoing payment transactions)
- Maintain field status: (Field status : Suppress, Required, Optional)
- General Data (Assignment number, Text, Invoice reference)
- Additional a/c assignments (Cost center, PC, Sales Order)
- Payment transactions (Due date, Value date, Payment terms, Reason code)
- General Data (Assignment number, Text, Invoice reference)
- D/C indicator
- PK defined at client level & so valid for all company codes
- 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
- FSV is a Group of Field status groups ( G001, G003, G004, G005)
- 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
- PP is defined in Fiscal Year Variant
- Posting Period Variant
- Several company codes can use the same PPV
- 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
- PP for a document is determined by the posting date
- 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
- During year end 2 periods are open. Special PP for the last fiscal year and normal PP for the current fiscal year
- Posting Authorizations
- Tolerance Group
- Tcode: SPRO-FA-FAGS – Document – Line Item – Define tolerance group per employee
- Specify Upper limit for following:
- Amount per document: Maximum permitted posting amount per document for this user group.
- Amount per Open Item: Maximum posting amount permitted per customer or vendor item for this user group
- Cash discount per Line Item: Maximum cash discount percentage rate which may be assigned by an employee of the user group. The percentage rate is checked during the entry, change and clearing of open items
- Amount per document: Maximum permitted posting amount per document for this user group.
- Tcode: SPRO-FA-FAGS – Document – Line Item – Define tolerance group per employee
- Can create any number of tolerance group
- Tolerance group "_____" blank applies to all user not assigned to any specific tolerance group
- Exercises:
- Simple document posting
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
- Make the text field mandatory for GL a/c
- At client level: GL a/c posting document type: AB. For document type AB in tcode OBA7 make the text field as required entry
- At company code level: Find out FSV for the company code in OBY6. For this FSV in field status group G001 (General) make the text field as required. Now assign this FSG to the GL a/c in FS00
- At client level: GL a/c posting document type: AB. For document type AB in tcode OBA7 make the text field as required entry
- Define variant for open PP
- Tcode: SPRO-FA-FAGS-Document-PP- Define variant for open posting period
- Tcode: SPRO-FA-FAGS-Document-PP- Define variant for open posting period
- Define which periods are open for a posting period variant
- Tcode: OB52
- Tcode: OB52
- Assign PPV to a company code
- Tcode: SPRO-FA-FAGS-Document-PP- Define variant for open posting period
- Tcode: SPRO-FA-FAGS-Document-PP- Define variant for open posting period
- Create a tolerance group SUPV
- Tcode: SPRO-FA-FAGS – Document – Line Item – Define tolerance group per employee
- Tcode: SPRO-FA-FAGS – Document – Line Item – Define tolerance group per employee
- Assign tolerance group SUPV to your ID SAPUSER
- Tcode: SPRO-FA-FAGS – Document – Line Item – Define tolerance group per employee
- Tcode: SPRO-FA-FAGS – Document – Line Item – Define tolerance group per employee
- Posting Control
- Default Values
- Using editing option config screen for different views
- Document entry: Fields hidden (for specified user) if not relevant
- Document display: Use list viewer for different display options
- Open Items:
- Document entry: Fields hidden (for specified user) if not relevant
- When user log in his ID has following properties:
- Language
- Date format
- Decimal notation
- Language
- Can control:
- Whether fiscal year is proposed when document displayed / changed
- CPU date proposed as value date
- Whether fiscal year is proposed when document displayed / changed
- 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
- Reversal Reasons:
- The reason for the reverse posting is noted in the reversed document. The field is therefore used as information as to why a reversal was necessary. The reason for reversal also determines:
- Whether the reverse document is allowed to have an alternative posting date
- Whether the reverse document is to be created from negative postings
- Whether the reverse document is allowed to have an alternative posting date
- Documents with cleared items cannot be reversed. Reset the cleared items in FBRA
- 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
- Credit Memos
- Credit Memos related to Invoices:
- Enter Invoice number in Invoice reference field under payment Tab during credit memo entry.
- Invoice Terms of Payment copied to the credit memo
- Invoice and credit memo due on the same date
- Enter Invoice number in Invoice reference field under payment Tab during credit memo entry.
- Credit Memo not related to the Invoice
- For credit memo terms of payment to be valid enter V in invoice reference under payment Tab
- For credit memo terms of payment to be valid enter V in invoice reference under payment Tab
- Cross Company code Transactions
- Cross company code transactions
- Transactions involve 2/ more company codes. E.g.:
- 1 company code purchase for multiple company codes
- 1 company code pays for multiple company codes
- 1 company code sells for multiple company codes
- 1 company code purchase for multiple company codes
- One document can be posted in one company code so in cross company code transaction system post document in both company codes
- The documents are linked by a clearing a/c
- There are two or more documents linked with a common reference :
- 1st company code + 1st company code document number + Fiscal Year
- 1st company code + 1st company code document number + Fiscal Year
- 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
- Tcode : SPRO – FA – FAGS – Document – Line Item – Document change rules
- Ensure document assignment field is not changed in tcode FB02( Restriction at client level)
- Tcode : OBA7
- Tcode : OBA7
- 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)
- Company code allow negative posting (OBY6)
- 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
- 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 |
- Assign terms of payments to vendors
- Tcode: Easy – accounts – FA – AP – MR – Change – Company code data – Payment transactions
- Baseline Date
- Date system uses to calculate vendor/ customer invoice due date and cash discount amount
- Date system uses to calculate vendor/ customer invoice due date and cash discount amount
- Taxes steps:
- Create a new tax code (FTXP)
- Assign a GL A/C to tax code to enable automatic postings (FTXP)
- Define the tax code to be used in enjoy transaction ( OBZT, SPRO – FA – FAGS – AR/AP – BT – Outgoing invoice – Define tax code per transaction)
- Post a customer / vendor invoice to show automatic posting
- Create a new tax code (FTXP)
- Create a new tax code
- Tcode : FTXP
- Tcode : FTXP
Country | GB |
Tax code | 03 |
Account Type | Output tax |
Acct Key | MWS |
Tax Percent | 20% |
COA | INT |
Tax a/c | 175000 |
- Configure automatic postings for cross company code transactions
- Tcode: OBYA
- Display cross company code documents
- Tcode: Easy – Accounts- FA – AP – Document – Cross company code transactions
- Tcode : FBU2 / FBU3 / FBU8
- Tcode: Easy – Accounts- FA – AP – Document – Cross company code transactions
- Clearing
- Clearing
- Two ways to clear OI
- Account clearing (F-32)
- Post with clearing
- Account clearing (F-32)
- Documents with OI cannot be achieved
- Post a customer Invoice
- Tcode: FB70
- Tcode: FB70
Customer a/c Dr | 5000 |
To sales a/c | 5000 |
- Post a customer credit memo
- Tcode: FB75
- Tcode: FB75
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)
- GL a/c number
- 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:
- Noted Items (Only information)
- Statistical posting ( Same a/c both D/C posting)
- Down Payments
- Items with withholding tax entries
- Noted Items (Only information)
- Assignment Field: Value comes from sort fields in FS00
- Tolerances:
- Tolerances:
- Rules that define acceptable differences during posting
- Types of Tolerances:
- Employee Tolerance Group:
- Upper limit for posting transaction
- Permitted payment differences
- Upper limit for posting transaction
- GL a/c Tolerances
- Permitted payment differences (Clearing a/c, GRIR)
- Customer / Vendor Tolerance Group provides for
- Permitted payment differences
- Posting residual item for payment differences
- Permitted payment differences
- Tolerance Group defined in 2 steps:
- Group Definition: Tolerance group defined by:
- Group key
- Company code
- Currency code
- Group key
- The Key "___" blank is required as minimum tolerance group
- 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
- Manual Processing of Payment Differences
- High payment differences can be manually processed as follows:
- Partial Payment: Post as partial payment. Document remains open
- Residual Item: Post payment differences as residual item. Original document and payments are cleared. A new document is created for the residual item
- Write off: The difference is w/off to an a/c. Manual a/c assignment for w/off
- Partial Payment: Post as partial payment. Document remains open
- 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
- Control type of payment notice sent to the customer
- 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.
- Create a Reason Code goods damaged in transit (Z03) to w/off difference to GL a/c mapped to this reason code
- Tcode: SPRO – FA – AR/AP – BT – Incoming payments – Incoming payments Global settings – Overpayment / Underpayment – Define Reason codes
- Data:
- Tcode: SPRO – FA – AR/AP – BT – Incoming payments – Incoming payments Global settings – Overpayment / Underpayment – Define Reason codes
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
- Cash Journal: A tool for managing cash. Supports posting cash receipt and payments
- Features:
- Create separate cash journal for each currency
- Post to customer / vendor / GL account (D/K/S)
- Run several cash journal for a company code
- Create separate cash journal for each currency
- Steps in creating a new cash Journal: Specify following
- Company code in which cash journal will be created
- GL a/c's to which CJ entries will be posted
- Currency in which CJ runs
- Company code in which cash journal will be created
- Special GL Transactions
- Types of Special GL transactions
- Down Payments:
- Down Payment Request
- Down Payment
- Down Payment Request
- Bill of Exchange
- BOE Request
- BOE
- BOE Request
- Other Transactions
- Individual value Adjustments (PBDD)
- Guarantee
- Interest
- Individual value Adjustments (PBDD)
- 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
- Noted Items, Not included in GL
- Down Payment
- Part of Financial statement. Create a proper posting in GL a/c
- FBL5N – Special GL items
- Part of Financial statement. Create a proper posting in GL a/c
- Guarantee
- Automatic offsetting entries
- Displayed in Notes to accounts
- Automatic offsetting entries
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)
- Tcode: FBL5N (Select special GL transaction)
- Reverse Statistical Posting / Guarantee
- Tcode: F-19
- Tcode: easy – A/C – FA – AR – Document – Special GL Transaction – Reverse statistical posting
- Tcode: F-19
- Create a Down Payment Request:
- Tcode: F-37
- Data:
- Special GL indicator: A
- Special GL indicator: A
- Display Down Payment Request of Customer
- Tcode: FBL5N
- Select Noted Items
- Tcode: FBL5N
- Create a Down payment against the DP request created earlier
- Tcode: F-29
- Tcode: F-29
- Post a Customer Invoice
- Tcode: FB70
- Tcode: FB70
- Clear Customer Invoice against down payment
- Tcode: F-39
- Tcode: F-39
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 |
- Reverse Individual Value Adjustment / PBDD
- Tcode: FB08
- Tcode: FB08
- Held / Park Documents
- 2 ways of saving FI documents w/o fully completing it:
- Held document:
- Document is incomplete
- No document number is assigned
- No a/c balance are updated
- Not considered for reports
- Document can be found under only user ID
- Document is incomplete
- 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
- Document number is assigned