FI_GL
General Ledger
- SAP FI Module
FI module receive posting from MM, SD & HR module. It feeds data to CO modules Cost center accounting, Profit center accounting & Profitability Analysis module. FI module is geared for external reporting BS & P/L.
- Define Group Company
- Tcode: OX15
Explanation- A company is an organization unit. A company can comprise one / more company codes.
- All company codes for a company must work with same Operational COA & Fiscal year
- Company codes can use different currencies
- A company is an organization unit. A company can comprise one / more company codes.
- Define Company code
- Tcode: OX02
- Copy company code along with all data : EC01
Explanation- Legal entity. Separate BS & PL can be maintained
- Two options 1) Copy co. code 2) Edit co. code
- In copy co. code all Config, tables, assignments get copied. Edit them as per need. Copy co. code 0001. In 2nd option manually configure all assignments
- Currency: This is local/ company code currency. All accounts are managed in this currency. All other currencies treated as FC.
- Local currency: Currency defined in company code
- Country Key: Specifies which country to be regarded as home country. System regards all other countries as foreign countries
- Company code 1000 contains all necessary data. So copy and use company code 1000
- Legal entity. Separate BS & PL can be maintained
- Edit Chart of Accounts
- Tcode: OB13
- Tcode (Copy Chart of Accounts) : OBY7
- Tcode ( Copy from an existing company code): EC01
- Directory of GL Accts in COA: SE38 - RFSKPL00 / RFSKVZ00
- Display COA: S_ALR_87012328
Explanation- Copy CAUS
- Define : COA key, Maintenance Language (English), Length of GL acct number(1-10), Manual / Automatic creation of CE, Group COA, Blocked ( A COA that is not completed can be blocked)
- Directory of GL Accts in COA: SE38 - RFSKPL00 / RFSKVZ00
- COA accts grouped under account groups.
- Acct Group control number range, Field status
- Reconciliation Acct.:
Open Item Management: To be used for- Bank clearing acct,
- Salary clearing acct.,
- Goods / Invoice receipt clears acct.
- For these accts (clearing accounts) also select line item display
- Bank clearing acct,
- Only balances in local currency: Selected for clearing accounts
- Group COA: Multiple CC. Some CC use different operational COA. Create a Group COA. Group COA contain a/c from all operation COA. This Group COA assigned to all operational COA. In FS00 enter group COA a/c number
Steps in creating a new COA:- Define Chart of Account
- Define the properties of COA
- Assign COA to company code
- Define Chart of Account
- If company codes intend to use cross-company code controlling, they must use the same chart of accounts.
- For balance sheet accounts, the balance is carried forward to the same account.
- For profit and loss statement accounts, the balance is carried forward to a retained earnings account and the profit and loss statement account is set to zero. A key (for example, X) is assigned to the account to which the balance is carried forward. You enter this key in the field "P&L Statement Type" in the chart of accounts segment.
The field status enables you to control the display and maintenance of an account's master data.- You can assign fields that you do not use the status Hide.
- Fields whose values must not be changed can have the status Display
- For fields where you must enter a value, you can define the status Required Entry.
- Fields that can contain an entry, but are not required, can be set to Optional Entry
- You can assign fields that you do not use the status Hide.
Reconciliation Account:- All posting to sub ledger accts. (AP/AR/AA) are automatically posted to reconciliation GL accts. For this specify "Reconciliation Acct Type". There can be a same reconciliation account for a number of sub reconciliation accounts. Line items are managed in sub ledger accounts
- To see the business partner accounts assigned to reconciliation account: SE38-RFDKVZ00
- Note: You cannot post amounts directly to reconciliation accounts.
- All posting to sub ledger accts. (AP/AR/AA) are automatically posted to reconciliation GL accts. For this specify "Reconciliation Acct Type". There can be a same reconciliation account for a number of sub reconciliation accounts. Line items are managed in sub ledger accounts
- Internal Reporting:
- If company codes want to use cross company code controlling, they must use the same operational chart of accounts
Group COA: If company codes use different operational chart of accounts they can have group chart of accounts for consolidated reporting.- The group chart of accounts must be assigned to each operational chart of accounts. After you have done this, the Group Account Number field in the operational charts of accounts becomes a required entry field.
- The group chart of accounts must be assigned to each operational chart of accounts. After you have done this, the Group Account Number field in the operational charts of accounts becomes a required entry field.
- Country COA: Company codes use same operational COA. But they have local reporting requirements. So use country COA. Country COA GL a/c number is assigned in alternative reconciliation account no. Also since all company codes use same operational COA we can have cross company code controlling
- Copy CAUS
- Assign Company code to Chart of Accounts
- Tcode: OB62
Explanation- For each company code specify which COA to be used.
- Several company codes can use same COA.
- Operative COA : COA assigned to company code
- Country Specific COA: COA structures as per country legal requirements
- Group COA : COA structured as per consolidation requirements
- For each company code specify which COA to be used.
- Define Account Groups
- Tcode: OBD4
Explanation- Account group used to combine GL a/c's with similar functions. E.g. expenses, asset accounting, Cash etc
Account Group determines:- GL a/c number interval in FS00 for the GL A/C created
- Fields in GL master records (Required/ optional/hidden)
- GL a/c number interval in FS00 for the GL A/C created
- Account group used to combine GL a/c's with similar functions. E.g. expenses, asset accounting, Cash etc
- Define Retained Earnings
- Tcode: OB53
Explanation- At the end of Fiscal year system carries P/L balance to retained earnings a/c. This account appears in BS as P/L carry forward.
- For this you define one/more P/L statement a/c type (X, Y, Z…) & assign these PL statement a/c types to GL a/c ( retained earnings a/c) in the COA
- At the end of Fiscal year system carries P/L balance to retained earnings a/c. This account appears in BS as P/L carry forward.
- Maintain Fiscal Year Variant
- Tcode: OB29
- Data : K4 ( Jan to Dec)
Explanation- Fiscal Year normally has 12 posting period & 4 special period for yearend closing transactions
- Fiscal year can be Calendar Year ( Jan to Dec) / Not Calendar Year ( Apr to March)
- Fiscal Year (Not Calendar Year) can be year dependent or Not year dependent
- Year dependent fiscal year variant are used: If the start and end date of the posting periods differ from year to year. If one fiscal year has fewer posting periods than the others (shortened fiscal year)
SAP standard FYV : K4 ( Jan to Dec), V3 ( Apr to March)
- Fiscal Year normally has 12 posting period & 4 special period for yearend closing transactions
- Assign Company code to Fiscal Year Variant
- Tcode: OB37
Explanation:- This control which periods the company code will post
- This control which periods the company code will post
- Define Posting Period Variant
- Tcode: OBBO
Explanation:- A separate variant for posting period is defined for every company code
- One PPV can be assigned to multiple company codes
- Total 16 periods. 12 normal periods & 4 special periods.
- System derives posting period from posting date. If a transaction posting date falls in normal period can be posted in special posting period.
- Variant Principle: Define Variant-Determine value for variant-Assign variant to object
- If start & end date of each period is same every year, it is year independent PPV. If the period reconcile with calendar months it is calendar year PPV else non calendar year PPV.
- If the start & end date of period differ each year it is year dependent PPV
- To prevent documents from being posted to an incorrect posting period, we can close certain posting periods. We can have as many posting periods open as desired. Several company codes can use the same posting period variant.
- The account type + must be open for all periods that are supposed to be open for all other account types. However a/c type (S/D/K/M) may / may not be open
- A separate variant for posting period is defined for every company code
- Open & Close Posting Period
- Tcode: OB52
Explanation:- Here specify which periods (Jan, Feb, Mar ...) are open for posting for each variant (100). There are 2 time intervals for both specify lower limit period, Upper limit period & Fiscal year.
- First enter periods permitted for posting for all variants. Next add entries for a/c type (D, K, A...) if periods to be restricted for specific a/c's
- At the end of each calendar month, this transaction is executed to close the sub ledgers (accounts receivable, accounts payable, fixed assets) so that the financial month-end close process can begin. Once the financial month-end close process is completed and statutory and management reports have been published, this transaction is executed a second time to close the general ledger for the period. This transaction is also used to reopen fiscal periods in the event that prior period adjustments are necessary. Once the fiscal periods are changed, the inventory accounting period must also be changed to allow posting of goods issues and goods receipts in the new fiscal period.
- Here specify which periods (Jan, Feb, Mar ...) are open for posting for each variant (100). There are 2 time intervals for both specify lower limit period, Upper limit period & Fiscal year.
- Assign Posting Period Variant to Company Code
- Tcode: OBBP
- Create number range for Company code
- Tcode: FBN1
Explanation:- Here we create number ranges
- Each number range specify a interval from which document numbers are selected
- Number range can be internal / external
- Assign one / more document types to each number range
- Number range assigned to document types. Doc types specified during doc. entry. Thus number range for this doc. type becomes effective for this document entry
- Number range for doc. is company code dependent
- Year dependent Number range: can specify same number interval with the same key again in different fiscal year
- Year Independent Number Range: Enter 9999 in the to fiscal year field
- Sample Doc's No. range Key: X2
- Recurring Entry Doc: No. range key: X1
- Transport: Interval – Transport
- Here we create number ranges
- Define document type & assign document number range
- Tcode: OBA7
Explanation:- Create doc type for Customer, Vendor & GL business transactions
- Specify a number range for each document type. Can use one number range key for several doc. types? Document numbers are chosen from this number range.
- Doc. Types valid for all clients
- Assign an individual reverse doc. Type for each doc. type.
- Required during doc. entry: Can specify whether Reference number / document header text are mandatory during doc. entry
- Use standard sap doc. Types
- Create doc type for Customer, Vendor & GL business transactions
- Key Document Types:
Sub Component | Use | Default Document Type |
Asset Accounting | Asset Posting | AA |
Depreciation | AF | |
General Ledger | Journal | SA |
Accounts Receivable | Customer Invoice | DR |
Customer Payment | DZ | |
Internal Transfer from billing | RV | |
Payment Clearing | ZV | |
Accounts Payable | Vendor Invoice | KR |
Vendor Payment | KZ | |
Goods Issue | WA | |
Goods Receipt | WE |
- Key fields in Document Types Screen
Field | Usage |
Account Types | Select account type that uses this document type. Document type KR ( Vendor invoice) don't select D thus this document cannot be used for customers |
Reversal Document Type | Can specify the reversal document type |
Reference Number | Can select & make reference field mandatory in this document type |
Document Header text | Can select & make reference field mandatory in this document type |
Batch input only | Can select & ensure document type used only through batch |
Ex. Rate for foreign crncy docs. | If not specified here transaction in FC for this document types will be according to avg rate M |
- Define Document Posting Keys
- Tcode: OB41
Explanation:- SAP Config. Allows you to use different posting keys per transaction type. Use default posting keys. Here we can Config additional posting keys
- SAP Config. Allows you to use different posting keys per transaction type. Use default posting keys. Here we can Config additional posting keys
Explanation: Posting key determine:- To which type of account(S/D/K) line item can be posted
- Whether item posted as debit / credit
Field status of additional fields
- To which type of account(S/D/K) line item can be posted
- Maintain Field Status Variant
- Tcode: OBC4
- Data : 100
Co. code | PPV |
1000 | 1000 |
Explanation:- FS Group determine what fields are available for entry during GL posting
- Here define & edit Field status variant & Field status group
- Document screen fields are grouped under Field status group
- Several field status groups are grouped under Field Status variant
- Field Status Variant is assigned to company code
- Field Status Group determine which fields are Required/ Optional/ Hidden during document entry
- Copy FSV 0001
- FS Group determine what fields are available for entry during GL posting
- Assign Field Status Variant to Company code
- Tcode: OBC5
- Define Tolerance groups for employees
- Tcode: OBA4
Explanation:- Here you define various amt. limits for your employees:
- Maximum document amt. employee is authorized to post
- Maxi amt. employee can enter as line item in Vendor/ Customer a/c
- Maxi cash dis. % an employee can grant in a line item
- Can also define tolerance w/o specifying tolerance group. Leave group field blank. Valid for all employees not allocated to a group.
- User id's to be assigned to the tolerance group in the next step (OB57)
- Can create as many tolerance groups as required (OBA4). Every user can be explicitly assigned to a tolerance group (OB57). If a user is not assigned to any special tolerance group, then entries in the blank tolerance group are valid for him.
- Here you define various amt. limits for your employees:
- Assign user Tolerance group
- Tcode: OB57
In our example we have define blank tolerance group for company code 100. Thus all unassigned users will be able to post this company code.
- Maximum Exchange Rate Difference
- Tcode: OB64
Explanation:- Specifications are company code dependent
- Here we define how much the exchange rate manually entered in the doc. Header may differ in terms of % from the one stored in the system
- If deviation occur a warning appear
- Specifications are company code dependent
- Check co. code settings in global parameters
- Tcode: OBY6
Explanation:- Check important company code settings here
- No FC diff when clearing in LC: FC documents are cleared in the LC.
- Tax base is net value : Discount is deducted from the base amount in sales documents before calculating taxes
- Discount base net value: Tax on sale/purchase not included in amount for calculating discount
- Check important company code settings here
- Data:
Company code | Currency | COA | Credit control Area | FYV | FSV | PPV |
1000 | EUR | INT | 1000 | K4 | 1000 | 1000 |
- Document Change
- Display document changes for all documents: SE38 - RFBABL00
- Create new document change rule: SPRO - Financial Accounting → Financial Accounting Global Settings → Document → Line Item → Document Change Rules, Line Item → New Entries
Explanation:- Users can change documents that have already been posted. However, based on different rules, only certain fields can be changed. These rules can either be predefined by the system or be user-specific.
- Document header: Only the reference number and text fields can be changed
- Line items: The system does not permit changes to the amount, the posting key, the account, or any other fields that would affect the reconciliation of a posting.
- Users can change documents that have already been posted. However, based on different rules, only certain fields can be changed. These rules can either be predefined by the system or be user-specific.
- Define Additional Local currencies
- Tcode: SPRO-FA-FAGS-Co. Code- || Currencies-Define Additional local currencies
- Tcode: OB22
Explanation:- Here we define additional currencies for company code
- Can define two more || currencies for a company code. Thus we can have three currencies for a company code.
Currency Types :- Group Currency: Currency Specified in the client table
- Hard Currency: Country specific 2nd currency used in countries with inflation
- Global Co. currency: Currency used for an internal trading partner
- Group Currency: Currency Specified in the client table
For Addl currencies define following data:- Currency Type: Define role of the currency. e.g.: Group currency/ hard currency
- Exchange rate type for translation: Define which exchange rate stored in the system is used for calculating additional amount field (additional local currency). e.g.: M (average exchange rate) or any other exchange rate.
- Base Currency: The amount in the additional currencies can be calculated based on the document currency (USD, INR..) or local currency (INR).
- Date for translation: Date on which exchange rate translation is done. Can be document date, Posting date, Translation date.
- Valuation: Can select valuation 1 only if currency and valuation profile configured in the controlling area. Can select valuation 2 if there is profit center valuation view. Valuation 1 & 2 require two additional ledgers to store data
- Currency Type: Define role of the currency. e.g.: Group currency/ hard currency
- Here we define additional currencies for company code
OB22 Explanation:
- Company Code: Enter the four-digit identifier of the company code that you wish to configure.
- 1st Local Currency: These fields will fill in automatically with default information based on the currency defined in the company code definition.
- 2nd and 3rd Local Currency: As explained earlier, each company code can have two additional parallel currencies that can be used in conjunction with local currency defined for the company code
- Curr. Type: The currency type field specifies which type of parallel currency you want to configure. The following options are available.
- Group Currency: Group currencies are defined at the client level in table T000. Group currencies are used to enable cross-company postings in controlling for company codes that use different company code currencies.
- Hard Currency: Hard currencies are used for subsidiaries in countries with a lot of inflation. Hard currencies allow you to better valuate transactions in an inflationary economic environment.
- Index-Based Currency: Index-based currencies are used for statutory reporting purposes for subsidiaries in some countries that have extreme amount of inflation.
- Ex. Rt. Type: The exchange rate type determines how foreign currencies are revalued at the time of foreign currency revaluation and translation. The number of possible entries is too numerous to list here J
- Srce Curr: Enter the source currency that the foreign currency is to be translated against. The possible entries are as follows:
- Translation taking transaction currency as basis: This option always tries to translate the parallel current against the transaction currency of the document.
- Translation Taking First Local Currency as Basis: This option always translates the parallel currency against the first local currency (company code currency).
- TrsDte Typ: This setting is used to determine which date is used for foreign currency translations. The available options are as follows:
- 1. Document Date: Select this option if you want the translation calculation to use the exchange rate that was In effect on the day the document was dated.
- 2. Posting Date: Select this option if you want the translation calculation to use the exchange rate that was in effect on the posting date in the document.
- 3. Translation Date: Select this option if you want the translation calculation to use the exchange rate that is in effect on the date of the foreign currency translation.
- Company Code: Enter the four-digit identifier of the company code that you wish to configure.
- Assign Company code to Company
- Tcode: OX16
- Automatic clearing settings
- Tcode: SPRO-FA-GL-BT-OI Clearing-Prepare Automatic clearing
Tcode : OB74- There are five criteria's you can mention. Normal practice is giving ZUONR (Assignment) as one criterion. The sort key in the vendor master defines the assignment field in the document. A meaningful sort key should be used to facilitate the automatic clearing process. Use tcode OB74 to check automatic clearing settings.
- Clearing program clears open items grouped together if their balance is zero in local & foreign currency ( Check local currency & group currency)
Grouping criteria to be entered:- Account Type ( D, K, S)
- Account Interval ( 1 to 999999)
- If possible also provide fields (ZUONR.) which are in table BSEG, BKPF, BSIS, BSID, and BSIK.
- Account Type ( D, K, S)
- There are five criteria's you can mention. Normal practice is giving ZUONR (Assignment) as one criterion. The sort key in the vendor master defines the assignment field in the document. A meaningful sort key should be used to facilitate the automatic clearing process. Use tcode OB74 to check automatic clearing settings.
- Define Tolerance groups for GL Accounts
Tcode: SPRO-FA-GL-BT-OI Clearing – Clearing diff. – Define tolerance group for G/L accounts
- GL accts for clearing diff
- Tcode: OBXZ
Explanation:- Tolerance group define the limit within which differences are accepted
- Here assign the GL a/c to which these diff. are posted
- SAP delivers an exp./ rev a/c in COA INT for this assignment
- Tolerance group define the limit within which differences are accepted
- Data:
COA | Account |
INT | 230110, 280110 |
- Define Foreign Currency Valuation Method
- Tcode: OB59
Explanation:- Here we define foreign currency valuation method for the open item
- SAP uses exchange rate type M to value all foreign currency items
- In the valuation method we group together specifications used for valuation
- Before every valuation run we specify the valuation method
- M is the average rate of any FC
- Here we define foreign currency valuation method for the open item
- Assign GL Accts for foreign currency valuation difference
- Tcode: OBA1
Explanation:- GL account to which exchange rate differences due to valuation are posted
Double click KDB:- Exchange Rate difference key: It can be kept blank. If entered same has to be updated in the GL Account control data tab (Exchange rate difference key) to revalue the foreign currency account
- Expense Account: Enter GL Account for unrealized foreign exchange loss. Loss is unrealized and automatically reversed next month.
- E/R gains: GL Account for unrealized foreign exchange gain. Can be same as expense account
- Exchange Rate difference key: It can be kept blank. If entered same has to be updated in the GL Account control data tab (Exchange rate difference key) to revalue the foreign currency account
Exchange Rate difference in open items (A/R, A/P) KDF : Enter GL codes for accounts receivable/ accounts payable (reconciliation accounts)
- GL Account: GL account mapped to customer in customer master
- Loss : GL Account for exchange rate loss realized
- Gain: GL Account for exchange gain realized
- Val. Loss1: GL account for unrealized exchange loss on valuation of open items (AR, AP)
- Val. Gain 1 : GL account for unrealized exchange gain on valuation of open items (AR, AP)
- SAP system supports two valuation areas in parallel. This account used for first valuation area. First valuation shows local view of company code.
- GL Account: GL account mapped to customer in customer master
- A currency key must be assigned to every currency used
- For every combination of currencies there can be different exchange rate types (M...)
- Exchange rate is maintained as translation ratio
- Report RFTBFF00: Can update exchange rate table by uploading a exchange rate file in multicash form
- Exchange rate tool: Use a Base currency for exchange rate M. Use the exchange rate spread (-) for buying & (+) for selling.
- Direct Quotation: 1 unit of FC quoted for local currency. 1 USD = 47 INR
- Indirect Quotation: 1 unit of LC quoted for FC.
- Exchange rate table: TCURR
- GL account to which exchange rate differences due to valuation are posted
- Define Adjustment for GR/IR clearing acct
- Tcode: OBYP
Explanation:- Goods receipt / invoice receipt clearing account is a provisional account & is posted to when we receive goods not invoiced or receive invoice for goods not received.
- Adjustment entries have to be made at the BS date.
Tcode F.19 analyze GR/IR clearing account and post adjustment entries for goods received but not invoiced & invoice received but goods not received.- Reconciliation Account
- Adjustment Account
- Target Account
- Reconciliation Account
- Goods receipt / invoice receipt clearing account is a provisional account & is posted to when we receive goods not invoiced or receive invoice for goods not received.
- Create GL Acct centrally
- Tcode: FS00
Explanation:- Create and Maintain (change, display, block and mark for deletion) GL Accounts Centrally
- Activate the field "Recon. account for acct. type" for accounts considered as reconciliation account e.g. A/R select customer recon account type ,A/P select vendor recon account type ... etc,.
To lock/ unlock account: Select your account and click Lock/Unlock Button.- Click Blocked for creation. ( At Chart Of Accounts Level )
- Click Blocked for posting. ( At Chart Of Accounts Level )
- Click Blocked for planning. ( At Chart Of Accounts Level )
- Click Blocked for posting. ( At Company Code Level)
- Click Blocked for creation. ( At Chart Of Accounts Level )
The GL account may be deleted only if no posting has been made to this account. The GL account deletion process is performed be a special program- Click Delete Button
- Click Mark for deletion. ( At Chart Of Accounts Level )
- Click Mark for deletion. ( At Company Code Level)
- Click Delete Button
- Create and Maintain (change, display, block and mark for deletion) GL Accounts Centrally
Explanation:- Create and maintain GL a/c centrally ( create, change, display, block & mark for deletion)
- Can also create GL A/C with reference to sample a/c
- Type / Description: Data at COA level.
- Control data : At company code level
- Recon a/c : AR select customer recon, AP select vendor recon
- Block GL a/c: Click (lock) - block at COA / co. code level
- Mark GL a/c for deletion: Click (del dustbin icon) - GL a/c deleted by a spl program
- Maintenance / change of GL a/c
- Create and maintain GL a/c centrally ( create, change, display, block & mark for deletion)
- Create Sample account
- Tcode: FSM1
Explanation:- A sample account is a master record containing data that is transferred when you create G/L account master records in the company code area.
- Sample accounts are dependent on the chart of accounts.
- You must not enter sample accounts in the chart of accounts as G/L account master records
- Cannot post to a sample a/c
- Change sample a/c : FSM2
- Display sample a/c : FSM3
- Delete sample a/c : FSM5
- A sample account is a master record containing data that is transferred when you create G/L account master records in the company code area.
- Copy GL master data from Source company code to Target company code
- Tcode: FS15
- Mass maintenance of GL a/c
- Tcode: OB_GLACC11
- Tcode: OB_GLACC12
- Tcode: OB_GLACC13
Explanation:- If individual change in GL a/c use FS00
- If mass change in GL a/c use OB_GLACC11. Can change a/c group, nature of a/c
- Mass maintenance of GL a/c (FS00) company code data. i.e. Field status group, Currency, Tax category use OB_GLACC12
- For name change OB_GLACC13
- If individual change in GL a/c use FS00
- GL a/c posting
- Tcode: F-02
Explanation:- Can post to any General Ledger & sub ledger (Vendor/Customer/AA) using proper posting key
- PstKy Determine: This key determines several factors: account type (K, D, S, A) type of posting (debit or credit) and layout of entry screens. Fields : Type SA Identifying the type of doc. Posted
- Can post to any General Ledger & sub ledger (Vendor/Customer/AA) using proper posting key
- Posting with Reference Document
- Tcode: FBR2
Explanation:- Allows you to post a new accounting document using a previously posted FI document as a reference
- Allows you to post a new accounting document using a previously posted FI document as a reference
- Incoming Payment
- Tcode: F-06
Explanation:- Post incoming payment.
- DR Bank A/c. CR Customer / Vendor / GL a/c.
- Clear OI on this a/c
- e.g.: payment received from customer, cleared against customer invoice. During clearing, the system enters a clearing document number and the clearing date in these items. In this way, invoices in a customer account are indicated as paid, and items in a bank clearing account are indicated as cleared
To post your entry, click Save Button. The system stored two documents:- A payment document,
- A separated clearing document that contains the information about cleared documents.
- A payment document,
- Post incoming payment.
- GL Account line item analysis
- Tcode: FBL3N
Explanation:
Report allows to display & change GL line items provided- This G/L accounts is managed with line item display
- The account master is not defined as a Reconciliation account.
- This G/L accounts is managed with line item display
- Double-click on the document number to display document details
- GL Account analysis
- Tcode: FS10N
Explanation:- The account balance displays:
- The opening balance (the balance carried forward from the previous year)
- The total of all transactions for each posting period, broken down into debit and credit postings (transaction figures)
- The account balance displays:
- GL manual a/c clearing
- Tcode: F-03
Explanation:- There are some postings on GL account that are not cleared. You want to clear these postings manually
- To clear open line items in GL accounts
You can clear also the transactions posted in different currencies. The system will automatically calculate and post exchange rate differences
- There are some postings on GL account that are not cleared. You want to clear these postings manually
- Outgoing payment
- Tcode: F-07
Explanation:- Post outgoing payment
- You credit your bank account and on the debit side you can post a GL, Customer or Vendor account and clear open item(s) on this account.
- Typical example of an open item is a vendor invoice that has not been settled
- During clearing, the system enters a clearing document number and the clearing date in these items. In this way, invoices in a vendor account are indicated as paid, and items in a bank clearing account are indicated as cleared
- Post outgoing payment
- Change a posted GL document
- Tcode: FB02
Explanation:- To add more information to already created documents like change text or assignment field.
- To add more information to already created documents like change text or assignment field.
- Display GL Document
- Tcode: FB03
- To find any document in the system: SE38 - RFBUEB00 and RFBUEB01
- To find gaps in document number assignment: SE38 - RFBNUM00
Explanation:- Display a previously posted document and print it. You can display any document that was posted in FI module (including document that was created e.g. in Logistics, but it was followed by automatic FI document posting).
- You can display your document in different currency. Click Display currency Button.
- You can display also other document details, like e.g. who posted this document. Choose Document Header button. You can see that the user SBTP000197 posted this document on 18th July 2002
- Display a previously posted document and print it. You can display any document that was posted in FI module (including document that was created e.g. in Logistics, but it was followed by automatic FI document posting).
Document type define following:- Number ranges for document
- Account types(S/D/K/M) permitted for postings
- The field status of the document header fields (Display, Hide...)
- Number ranges for document
Document Type | Purpose |
AB | Posting to all document types |
DG | Posting to customer / GL accounts |
RV | Sales Order billing |
RE | Material Management billing |
- Individual Document Reversal
- Reverse Individual Document: FB08
- Check which reversal reasons can be used to perform reversal by negative postings / Alternative posting date allowed : SPRO- Financial Accounting→General Ledger Accounting -Business Transactions → Adjustment Posting/Reversal → Define Reasons for Reversal
- If you don't know the document number, click Find documents Button.
- The system provides a function to reverse G/L, customer, and vendor documents both individually or in a mass reversal. When you reverse a document, you have to enter a reversal reason that explains the reversal. Documents with cleared items cannot be reversed. The document must first be reset (FBRA)
- 01 Reversal in current period
- 02 Reversal in closed period
- 03 Actual reversal in current period
- 04 Actual reversal in closed period
- 05 Accrual/deferral posting
- Reasons 03 and 04 allow "negative" postings. To post a negative reversal, the following prerequisites must be fulfilled: The company code must be defined as allowing negative postings (OBY6). The document type must allow negative postings.
- 01 Reversal in current period
- If you don't know the document number, click Find documents Button.
- Tcode: FB50 ( Post/Hold / Park)
- Tcode: FV50 ( Edit & Post Park documents)
- FB11 (To see Hold document)
- Can hold a doc before posting it. Can be a single entry doc. Can be edited & posted.
- Hold doc to be converted using. SE16-RFTMPBL4
- To post a hold doc. - FB50 / FB11-Tree on- Select hold doc.-edit- post
- Diff. between hold & Park doc.: Hold has user defined number & can be edited & posted by same user. Park has number range derived number & can be edited & posted by other users
- Table name to check MIRO held documents: RBKP
- Press Push Button Editing Option- Here we can select doc type option and other master data options
- Maximum Line item allowed is 999. For more line items need to create routine which will split the incoming entry into more than one document.
- Can hold a doc before posting it. Can be a single entry doc. Can be edited & posted.
- Tcode: F-04
- With manual clearing there are 3 way of clearing an open item (full , partial , residual)
- A residual item results when a payment is made for less than the actual amount outstanding. You clear the original open item, and the system posts a new open item. This new open item is for the same amount as the original open item minus the amount paid
- A partial payment is a payment that is posted to an account without any open items being cleared. You assign this partial payment to an open item. The original open item and the partial payment remain open.
- A residual item results when a payment is made for less than the actual amount outstanding. You clear the original open item, and the system posts a new open item. This new open item is for the same amount as the original open item minus the amount paid
- Tcode: F.13
- Tcode : F13E ( Automatic clearing with clearing currency specified)
- Configure F.13 : OB74
- Automatic clearing allows you to clear many GL accounts in one transaction run. In customizing we can define up to three fields that are treated by the system as the sort criteria for clearing. For instance, we can decide that all the documents with the same value in the field "Assignment" can be cleared
- Automatic clearing is run through batch job nscfia3946_786-pgrir5. When we run F.13 for GR/IR acct 20802000 systems considers the matching amount for clearing. Then it matches the assignment field for these amounts. Further the sort key in the GL master defines the assignment field in the document. For GL acct 20802000 sort key is 014 (Purchase Order) thus if PO number matches for these two amounts the amounts are cleared against each other.
- The GL account for automatic clearing of items must be flagged as open item
- Activate check box include tolerances if you want the system to clear the GL a/c line item balances within the tolerances defined
- Check the tolerance group assigned to the GL a/c in FS00, under tolerance group.
- Now check the GL a/c tolerance in OBA0
- There are five criteria's you can mention. Normal practice is giving ZUONR (Assignment) as one criterion. The sort key in the vendor master defines the assignment field in the document. A meaningful sort key should be used to facilitate the automatic clearing process. Use tcode OB74 to check automatic clearing settings.
- Automatic clearing allows you to clear many GL accounts in one transaction run. In customizing we can define up to three fields that are treated by the system as the sort criteria for clearing. For instance, we can decide that all the documents with the same value in the field "Assignment" can be cleared
- Tcode : FBRA
- The document that contains cleared items cannot be reversed directly. You need to first reset cleared items. During clearing open items the system always creates a clearing document
- If you don't know the clearing document number, open another SAP session, select transaction code FB03 (document display) and press List button to search for the required document
- You can display some details regarding the clearing document before resetting it. Click e.g. Accounts Button. The system will display all the accounts involved in clearing operation:
- Click Items Button to display documents cleared by the clearing operation
- You can choose to only reset cleared items or reset items and reverse the accounting document that is connected with clearing operation
- Tables to check Clearing documents in SE16 / ZSE16N:
- The document that contains cleared items cannot be reversed directly. You need to first reset cleared items. During clearing open items the system always creates a clearing document
Table name | Category |
BSAK | Vendor |
BSAD | Customer |
BSAS | GL |
- Display forex exchange rates: OB08
- Tcode: S_BCE_68000174
- Tcode: FBS1
- Accruals
Expenditure/ Prepaid Expense: Any expenditure before the closing key date which represents an expense for any period after this date.
- Deferrals Income: Deferred income is any receipts before the closing key date that represent revenue for any period after this date.
- The accruals can be reversed later automatically or manually using F.81
- Accruals
- FBU2 - Cross Company Code Document – Change
- FBU3 - Cross Company Code Document – Display
- FBU8 - Cross Company Code Document – Reverse
Description | Tcode |
Define Group Company | OX15 |
Define Company code | OX02 |
Edit COA | OB13 |
Copy COA | OBY7 |
Assign Company code to COA | Ob62 |
Define account group | OBD4 |
Define Retained earnings | OB53 |
Maintain Fiscal Year Variant | OB29 |
Assign Company code to FYV | OB37 |
Define Posting Period Variant | OBBO |
Change Fiscal Period | OB52 |
Assign PPV to company code | OBBP |
Create number range for company code | FBN1 |
Define document type | OBA7 |
Define document posting keys | OB41 |
G/L a/c default setting | OBU1 |
Define rules to change text in a field | OB32 |
Maintain Field Status Variant | OBC4 |
Assign Field status variant to company code | OBC5 |
Define Tolerance Group for employees | OBA4 |
Maximum Exchange Rate difference | OB64 |
Company code Global parameters | OBY6 |
Document Change | SE38- RFBABL00 |
Define Additional Local currencies | OB22 |
Assign Company code to Company | OX16 |
Check Tax calculation procedure | OBYZ |
Assign Tax Procedure to Company code | OBBG |
Check Access sequence | OBYZ |
Define Tax code for sales & purchase | FTXP |
Configure automatic (F.13) clearing | OB74 |
GL a/c for clearing differences | OBXZ |
Define Foreign Currency valuation method | OB59 |
Define Adjustment a/c for GRIR clearing | OBYP |
FI integration with CO | OBYB |
FI integration with MM | OBYC |
FI integration with SD | VKOA |
Create GL a/c centrally | FS00 |
Copy GL a/c from source company code to target company code | FS15 |
GL a/c posting | F-02 |
Post incoming payments | F-06 |
G/L a/c line item display | FBL3N |
G/L a/c analysis display | FS10N |
G/L a/c MANUAL CLEARING | F-03 |
Post outgoing payment | F-07 |
Change posted GL document | FB02 |
Display GL document | FB03 |
Individual document reversal | FB08 |
Mass document reversal | F.80 |
Post / Park / Hold GL a/c document | FB50 FV50 |
Display GL hold document | FB11 |
Copy GL a/c to company code | OBY2 |
Automatic a/c determination | FBKP |
GL post with clearing | F-04 |
Automatic clearing | F.13 |
User master data settings | FB00 |
Reset cleared items | FBRA |
Recurring entry documents | FBD1 / FBD2 / FBD3 |
Display forex exchange rate | OB08 |
Post Accruals (Prepaid expense/ Accrual Income) | FBS1 |
Reverse accruals, if automatic reversal not selected | F.81 |
Cross company code documents display | FBU3 |
No comments:
Post a Comment