FINANCIAL ACCOUNTING/CONTROLLING

Intercompany Asset Transfers in fico

2008-05-08T02:02:00.000-07:00

Purpose

Asset transfers involve the transfer of an asset between two companies (company codes) of the same corporate group. An intercompany transfer within a corporate group may be due to:

· A change of physical location that requires the asset to be assigned to a new company code.

· A change to the organizational structure of the corporate group that requires the existing assignment of the asset to be changed.

In both of these cases, you can not change the assignment of the asset to the company code through master record maintenance. For each asset that is to be transferred, you require a new asset master record (or an existing one for partial transfers) in the receiving company code. You can retain the identity of the asset using the inventory number in the asset master record.

The system provides you with a method that allows you to automate these activities to a large extent. With this method, the transfer is posted only on the sender company code. The posting in the target company code is executed automatically by the system. If a new asset needs to be created in the target company code, you can specify the asset class and other important master data in the relevant dialog box.

In this IDES process, you execute four transfers between company code 1000 and company code 2000, each with a different transfer variant.

You can find more information about this process under.

You can find the data for this process under .

Process Flow

You first

Create Four Asset Master Records

, one for each transfer variant.

To capitalize these asset master records, you

Post the Acquisition to a Clearing Account

1. Variant:

Transfer the Asset "Gross"

2. Variant:

Transfer the Asset "Net"

3. Variant:

Transfer the Asset Manually With Gains

4. Variant:

Transfer the Asset Manually With Losses

To check the effects of these transfers, you can

Display the Asset Explorer

Enhancements to Asset Accounting when Using Parallel Currencies in FI

2008-05-08T02:01:00.000-07:00

If you are using, or intend to use, parallel currencies in Financial Accounting (FI) additional Customizing settings are required for Asset Accounting (FI-AA). For example, you may want to use transfer prices.

The following Customizing changes are required:

You need to create depreciation areas that have the same currency and currency type as the parallel currency in the relevant company code.

The new depreciation areas must be capitalized in the asset classes, and

The new depreciation areas must be added to the existing assets.

You can find more information about this process under

Process Flow

You can find the data for this process under

You first create depreciation areas 33 (book depreciation per trade law in group currency, concern valuation) and 34 (book depreciation per trade law in group currency, profit center valuation). The same depreciation parameters and acquisition values apply for both depreciation areas, as used in 01 (book depreciation per trade law ). However, you require currency type 31 for DA 33 and currency type 32 for DA 34. To do this, you

Define New Depreciation Areas

For DA 51 you require two additional depreciation areas with identical depreciation parameters and acquisition values. Repeat the first step. Choose area 51 as the DA, then replace the entries for DA 33 with those of DA 53, and the entries for DA 34 with those of DA 54.

When you create the new depreciation areas, these are added to all asset classes. However, they are not capitalized at this stage. You now

Capitalize the Depreciation Areas in the Asset Classes

To use the new depreciation areas with the old assets, you

Add New Depreciation Areas to the Existing Assets

. This is executed automatically for all assets.

Mass Changes / Mass Retirements in fico

2008-05-08T02:00:00.000-07:00

Purpose

Asset Accounting provides you with three possibilities for mass processing. Mass changes to master records, mass retirements, and the mass transfer of assets.

The changes you make to the master records are automatically processed to a large extent. You first define the change rules, then you select the relevant assets, and finally you execute the changes. This method could be used, for example:

If changes are made to cost center planning and the cost center assignments of the affected assets need to be changed.

During period-end closing, when the depreciation parameters need to be changed.

Following legacy data transfer, when fields are to be filled with values that could not be transferred from the legacy system.

Changes made at the asset class level only apply to newly created assets. Therefore, any changes made at asset class level must also be carried out for all existing assets.

You use a work list to select the assets required for the mass retirement. When you generate a work list, you need to specify whether the retirement is to be made with or without revenues.

You can find more information about this process under

Process Flow

You can find the data for this process under

To define the rules for the mass changes to the master record using the substitution technique, you

Define the Change Rule

You then include the assets to be processed in a worklist. To do this, you

Create a Worklist

To process the assets according to the chosen method, you

Release the Worklist

. Mass changes are made to the master records, and during mass retirements, the system automatically generates retirement postings.

what is the Reasons For Archiving Financial Accounting Data in sap

2008-05-08T01:58:00.000-07:00

What is financial archiving? Where it is used? Why? Where is it configured in IMG?

There are both technical and legal reasons for archiving Financial Accounting data.

Archiving:
1) Reduces storage and runtime problems caused by the constant growth of transaction data.
2) Makes master data easier to manage and to keep up to date.
3) Enables data to be accessed at a later date.

You can archive data no longer required in the online system using certain standard functions. This data is then stored in archive files and deleted from the online system. For legal and commercial reasons, it is important that you are able to access archived data files online again, and the reloading function allows you to do this.

Data must meet certain conditions before it can be archived. Some of these controls are already defined in the system, for instance the fact that you cannot archive documents that contain open items. Certain other controls are user-defined.
Every archiving function can be accessed from archive management (SARA).

To reach archive management, choose:
Tools --> Administration --> Archiving or from the Accounting --> Financial Accounting --> General Ledger, Accounts
Receivable, Accounts Payable or Banks menus --> Periodic processing Archiving .

When you access archive management from these menus, the archiving object is defaulted by the system in the field Object name. Otherwise you must enter the name of the archiving object manually.

SAP Online Help in PDFs Free downloads

2008-05-07T07:10:00.000-07:00

SAP Exam Resource - Define Account Groups OBD2

2008-04-11T04:04:00.000-07:00

Q). In the FI module in SAP, where can a user maintain the screen field for a customer master record?

Answer:

In the IMG i.e. implementation guide in SAP, which can be reached via T-Code SPRO, the following menu path should be followed by the user to reach the Screen field for Customer master record.

Financial Accounting >> Accounts Receivable and Accounts Payable >> Customer Accounts >> Master Records >> Preparations for creating customer master records >> Define account groups with screen layouts.

The menu path mentioned above will lead to user to the transaction where screen filed for customer master record can be maintained. As a very easy alternative to the same the same can be viewed via transaction code [OBD2].

In SAP, it becomes easy if one knows the transaction code, so that any Transaction can be easily reached via the T-Code i.e. shortpath.

SAP R3 Data Entry Techniques Tips

2008-04-11T03:43:00.000-07:00

There are various forms, menus which users can access in SAP to make data entry. Entry can be of master data or transactional data. For making a data entry in SAP R/3 the user needs to have authorization in SAP. Without proper access authorization in SAP, a user may not be able to enter data. The manner is which postings are done can also be controlled through this technique. At the time of data entry also, SAP performs several edit and validation checks over the data to ensure that it is complete and accurate. These edit and validation checks are available through configurable controls in SAP.
To explain SAP data entry techniques more simply, below, certain examples are given as to how the user data entry in SAP can be controlled.

1. User can be restricted from posting to a particular account.
2. Users can be restricted to post only to accounts belonging to a specific company code.
3. Users in SAPR3 can be confined to a business area but not to specific company codes.
4. A user can be confined to a cost center or a cost object also in SAP.

To test FI/CO posting controls and your accounting knowledge

2008-04-11T03:35:00.001-07:00

Question : Can you post a document to a closed period?

Answer : Yes

Question : How do you do that in SAP?

Answer : Just reopen the closed period

Question : Isn't that against the accounting principles?

Answer : Not at all. As long as you document a proper reason for the auditing.

The chairman of a Co. wants to link each of his four company codes to three dunning areas and two credit control areas. Can this be done? Why or why n

2008-04-11T03:34:00.003-07:00

Technically, an individual company code can only be assigned to one credit control area; however, a list of allowable credit control areas may be created. A company code can have multiple dunning areas.

What is a credit control area? Describe its relationship to company codes?

2008-04-11T03:34:00.001-07:00

A credit control area (CCA) is used to set and control credit limits for customers. They include one or more company codes. There can only be one CCA per company code. Customers in several company codes can exist under several CCA's. As part of credit management, an individual customer's credit limit is set based on an individual credit control area or across several credit control areas.

Can you report on business areas across companies? If so, explain how this is accomplished conceptually in the system.

2008-04-11T03:33:00.003-07:00

Yes, because BA's are defined independent of company codes. They can be added to the detail of a line item in a document, thus enabling the system to keep track of business area information for reporting and controlling purposes.

Discuss three benefits of the SAP organizational structure

2008-04-11T03:33:00.001-07:00

It gives flexibility to reflect complex organizational structures

It helps to consider future changes in the organizational structure

It is clearly defined into logistical (sales, purchasing) and financial views (cost accounting, financial accounting).

Explain the relationship between company code, business areas and financial statements

2008-04-11T03:32:00.002-07:00

A Company Code represents an independent legal entity that is required by law to issue financial statements (Balance Sheet and P&L Statement). Business Areas are defined independently of Company Codes and can be shared across Company Codes. Internal Balance Sheets and P&L Statements can be generated by Business Area though they are not required.

What is the highest hierarchy level in SAP? Define this term and explain how it is used in the SAP system

2008-04-11T03:32:00.001-07:00

The Client is the highest level in the SAP organizational structure. Anything specified for a Client applies to all Company Codes that are attached to that Client. Clients have a one-to-many relationship with Company Codes. Clients are generally not reported on with balance sheet and P&L's, the company codes are the legal entities and serve for this purpose. However, clients can be reported on as part of consolidation or extended G/L.

Define the major organizational hierarchy elements within the Financial Accounting module and explain the relationship between each of them.

2008-04-11T03:31:00.004-07:00

The hierarchy, from the highest organizational unit to the lowest, is the Client, Chart of Accounts (COA), Company Code and the optional Business Areas (BA). Two other optional areas include the Dunning Area and the Credit Control Area (CCA). Credit Control Areas come above the Company Code, and Dunning Areas come below the Company Code. There is only one Client and its values are the same across all Company Codes that are attached to it. Every Company Code is a legal independent entity. Business Areas can be shared among Company Codes (many-to-many relationship) and they are used for internal reporting purposes. Each Company Code is assigned a COA. The COA may be the same for multiple Company Codes, but each Company Code may only use one COA.

Explain the relationship between posting keys and accounts

2008-04-11T03:31:00.003-07:00

Each posting key is linked to a specific account type and determines if the entry to that account will be a debit or credit entry.

Discuss all aspects of the posting key. Explain what it is, how it is used in the system, and any special properties that can be defined for it.

2008-04-11T03:31:00.001-07:00

The posting key:
	Defines the type of account (e.g., Customer, Vendor, G/L account, Material, Asset) Determines whether the entry is a debit or credit Indicates special properties (e.g. Reversal Posting Key, Special G/L transaction, etc.) Data entry screen for the line item via the field status group

What is a document type? Discuss its various uses in the system

2008-04-11T03:30:00.002-07:00

A document type is a 2-character alphanumeric key that is used to identify documents. It distinguishes between business transactions (e.g., SA - G/L postings, DR - customer invoice), controls the account types posted to (D - customer, K - Vendor, S - G/L account, A - Assets, M - Materials), assigns document numbers and is used as a sort criteria.

Discuss the various sections of a SAP document and give an example of the data stored in each section.

2008-04-11T03:30:00.001-07:00

Document header - posting date, document number, document type, currency, document date, document header text. Line items - Minimum of two line items and at most 999, consisting of posting key, account number, amount, and other account assignments.

What is the document principle?

2008-04-11T03:28:00.000-07:00

The document principle requires that one FI document is created for every business transaction. Each document receives a unique number. It is a 1:1 relationship

free download fico pdf books

2007-12-14T17:01:00.000-08:00

Check List for FI Year End Closing

2007-12-14T16:58:00.002-08:00

1 Execute Report for InterCompany Activity & Journal Entries

2 Open posting period for next yr

3 Run Business Area's Assignment report.

4 Review list of recurring journal entries

5 Execute Recurring Entries for A/R, A/P, G/L

6 Process Parked A/R, A/P, G/L accounting documents

7 Final Cutoff for the Maintenance of Fixed Asset- Add Transfer and Retire

8 Run Depreciation in Test Run and post

9 Verify Display Log for Depreciation Test Run

10 Capitalize AUC Assets if needed

11 Enter Payroll Data to SAP

12 Verify Depreciation Balances with GL balances

13 Post Depreciation

14 Execute Asset History Report, and retire assets if needed

15 Adjust specific depreciation areas if necessary

16 Reconcile AM subledger with GL

17 Check Bank Data

18 Review AR Open Items

19 Review AP Open Items

20 Execute Pending Invoices

21 Clear Open Item for GRIR, freight

22 Reconciliation of Financial Documents and transactional figures

23 Open new CO Posting Period

24 Compare current (cost estimates) with last current price (Moving Avg)

25 Update current cost price to material master price field.

26 Process Freight charges, Match SD freight to actual

27 Review Internal Order Postings

28 Settle All Orders

29 Verify All Post Goods Issue have been Invoiced (Billing Due List)

30 Review SD Billng Doc from prior mth that have not yet been released to accounting

31 Reconciliation of MM movements in Transit Intra-SAP to NonSAP

32 Reconcile PI Inventory with SAP

33 Perform Manual Adjustment if needed

34 Verify balance of the GR/IR account

35 Post Accruals and Deferrals

36 Clearing of Cancelled Documents

37 Check Profitability Segment Adjustment

38 Aging Report-Reconcile GL balances with subledger balances AP

39 Check the check run numbers

40 Bank reconciliation Data

41 Enter Tax Journal Entry

42 Reconcile GL balances with subledger balances AR/MM/AP

43 Display Balance Sheet Adjustments

44 Post Balance Sheet Adjustments

45 Post Foreign Currency Valuation (foreign exchange)

46 Check generic cost centers for posting with wrong accounts

47 Correct wrong postings on generic cost centers

48 Check Validation dates for Cost Centers, Cost Elements, CO area

49 Check COGI--for both month end and year end

50 Doubtful receiviables

51 Verify In-transist Inventory

52 Reconcile PA to G/L

53 Post Cost Centre Assessments and Distributions

54 Run CO-FI Reconciliation to balance

55 Run BW reports P&L and Balance Sheet

56 Maintain CO yr variant

57 Fiscal Yr Balance carryforward AP/AR/AM

58 Fiscal Yr Balance carryforward CO

59 Fiscal Yr balance carryforward FI

60 Fiscal Yr balance carryforward PCA

61 Set Document number ranges - FI - new year

62 Set Document number ranges AP/AR - new year

63 Generate Financial statement Reports

64 Change Fiscal Year For Assets

65 Year end Closing-- Asset Accounting--final for year end

66 Close CO Posting Period

67 Close Prior A/R Posting Period

68 Close Prior A/P Posting Period

69 Close Prior MM Posting Period

70 Reverse accruals and deferrals for the new month

71 Reconciliation of Financial Documents from old fiscal year and new fiscal year

72 Load Balances, Budget Data for Cost centers, sales

73 Update Retained Earning Account , balance carry fwd

Check List for FI Year End Closing

1 Execute Report for InterCompany Activity & Journal Entries

2 Open posting period for next yr

3 Run Business Area's Assignment report.

4 Review list of recurring journal entries

5 Execute Recurring Entries for A/R, A/P, G/L

6 Process Parked A/R, A/P, G/L accounting documents

7 Final Cutoff for the Maintenance of Fixed Asset- Add Transfer and Retire

8 Run Depreciation in Test Run and post

9 Verify Display Log for Depreciation Test Run

10 Capitalize AUC Assets if needed

11 Enter Payroll Data to SAP

12 Verify Depreciation Balances with GL balances

13 Post Depreciation

14 Execute Asset History Report, and retire assets if needed

15 Adjust specific depreciation areas if necessary

16 Reconcile AM subledger with GL

17 Check Bank Data

18 Review AR Open Items

19 Review AP Open Items

20 Execute Pending Invoices

21 Clear Open Item for GRIR, freight

22 Reconciliation of Financial Documents and transactional figures

23 Open new CO Posting Period

24 Compare current (cost estimates) with last current price (Moving Avg)

25 Update current cost price to material master price field.

26 Process Freight charges, Match SD freight to actual

27 Review Internal Order Postings

28 Settle All Orders

29 Verify All Post Goods Issue have been Invoiced (Billing Due List)

30 Review SD Billng Doc from prior mth that have not yet been released to accounting

31 Reconciliation of MM movements in Transit Intra-SAP to NonSAP

32 Reconcile PI Inventory with SAP

33 Perform Manual Adjustment if needed

34 Verify balance of the GR/IR account

35 Post Accruals and Deferrals

36 Clearing of Cancelled Documents

37 Check Profitability Segment Adjustment

38 Aging Report-Reconcile GL balances with subledger balances AP

39 Check the check run numbers

40 Bank reconciliation Data

41 Enter Tax Journal Entry

42 Reconcile GL balances with subledger balances AR/MM/AP

43 Display Balance Sheet Adjustments

44 Post Balance Sheet Adjustments

45 Post Foreign Currency Valuation (foreign exchange)

46 Check generic cost centers for posting with wrong accounts

47 Correct wrong postings on generic cost centers

48 Check Validation dates for Cost Centers, Cost Elements, CO area

49 Check COGI--for both month end and year end

50 Doubtful receiviables

51 Verify In-transist Inventory

52 Reconcile PA to G/L

53 Post Cost Centre Assessments and Distributions

54 Run CO-FI Reconciliation to balance

55 Run BW reports P&L and Balance Sheet

56 Maintain CO yr variant

57 Fiscal Yr Balance carryforward AP/AR/AM

58 Fiscal Yr Balance carryforward CO

59 Fiscal Yr balance carryforward FI

60 Fiscal Yr balance carryforward PCA

61 Set Document number ranges - FI - new year

62 Set Document number ranges AP/AR - new year

63 Generate Financial statement Reports

64 Change Fiscal Year For Assets

65 Year end Closing-- Asset Accounting--final for year end

66 Close CO Posting Period

67 Close Prior A/R Posting Period

68 Close Prior A/P Posting Period

69 Close Prior MM Posting Period

70 Reverse accruals and deferrals for the new month

71 Reconciliation of Financial Documents from old fiscal year and new fiscal year

72 Load Balances, Budget Data for Cost centers, sales

73 Update Retained Earning Account , balance carry fwd

Vendor Invoice Verification Accounting Entries

2007-12-14T16:58:00.001-08:00

VENDOR INVOICE VERIFICATION

The detail process related to invoice verification is documented in Materials Management Document.

On receipt of vendor bill the following entry will be passed:

GR/IR Account DR
Freight Clearing Account DR
Cenvat Clearing Account DR
Vendor Account CR

Invoice Verification for Foreign Vendor
On receipt of vendor bill the following entry will be passed:

GR/IR Account DR
Vendor Account CR

Invoice Verification for Custom vendor

On receipt of Vendor bill the follo wing entry will be passed:

1) RG 23A/RG 23C Part 2 A/c (CVD) A/c DR
Cenvat Clearing A/c CR

2) G/R I/R A/c DR
Cenvat Clearing A/c DR
Vendor A/c CR

3) Cost of Material A/c DR
Vendor A/c (Customs) CR

Invoice Verification for Freight / Clearing Agent
Cost of Material A/c DR
Vendor A/c (Clearing Agent) CR

Invoice Verification for Octroi Expenses
Cost of Material DR
Vendor A/c (Octroi) CR

TDS (Work Contract Tax) for Service Orders shall be calculated and deducted accordingly.
The following entry will be passed on bill passing:

Expenses Account DR
Vendor Account CR
TDS Account CR

The material shall be returned to the vendor using the
Return to vendor movement type in SAP
Creating a Return PO

These transactions will be processed in the MM module.

The accounting entries will be :

Returns after GRN
GR/IR A/c Dr
Stock A/c Cr

The accounting in respect of debit / credit memos for FI vendors, the process will be similar to that of invoice processing.

The accounting entries will be:

On issue of debit note
Vendor Account DR
Expenses Account CR

In respect of import vendor - capital goods exchange differences are to be accounted manually through a Journal Voucher for capitalization.

Exchange rate differences will be accounted at HO. An example of the accounting entry in this case shall be:

Invoice entry @ 40 INR: 1 USD

Asset / Expense A/c DR 100
Vendor A/c CR 100

Payment Entry @ 41 INR: 1 USD
Vendor A/c DR 100
Bank A/c CR 110
Exchange rate loss Capital A/c DR 10

Asset A/c DR 10
Exchange rate loss Capital A/c CR 10

A new G/L account shall be created for the special G/L transactions.

The accounting entry for making the down payment shall be:
Advance to supplier account Debit
Bank A/c Credit

When the invoice is booked the following entry is passed
GR/IR account Debit
Vendor account Credit
Clearing of Invoice against Down Payment
Vendor A/c Debit
Vendor down payment account Credit

Wherever, TDS is applicable, the TDS will be deducted at the time of down-payment to the vendor.
Down Payment for Capital (tangible) Assets

Down payment to vendors for capital acquisitions is to be reported separately in the Balance Sheet under the head Capital Work in Progress. Hence down payment for capital goods would be tracked through a separate special general ledger indicator.

The procedure to be followed is:

Definition of alternative reconciliation accounts for Accounts Payable for posting down payments made for Capital assets

Clearing the down payment in Accounts Payable with the closing invoice.

A new G/L account shall be created for the special G/L transactions.

The accounting entry for making the down payment shall be:

Vendor Advance for Capital Goods Account Debit
Bank A/c Credit
When the invoice is booked the following entry is passed
Asset A/c / Asset WIP Debit
Vendor A/c Credit
Clearing of Invoice against Down Payment
Vendor A/c Debit
Vendor Advance for Capital Goods Account Credit

The Following are the TDS Rates (to be confirmed with the recent changes) Particulars Tax Rate Surcharge Rate Total

Contractors – 194 C 2% 5% 2.10%

Advertising – 194 C 1% 5% 1.05%

Prof. Fees – 194 J 5% 5% 5.25%

Rent – Others – 194 I 15% 5% 15.75%

Rent – Company – 194 I 20% 5% 21%

Commission – 194H 5% 5% 5.25%

Interest - Others – 194 A 10% 5% 10.50%

Interest – Company – 194 A 20% 5% 21%

Special Concessional Tax

Works Contract Tax

SECURITY DEPOSITS /EARNEST MONEY DEPOSIT RECEIVED FROM VENDORS

Bank A/c DR
Security Deposit Vendor CR

EMD to give the age so as to enable the same to be transferred to unclaimed EMD account.
PAYMENT OF TOUR ADVANCE DOMESTIC TOURS

Employee Advances will be paid by the Accounts Department unit wise based on the requisition or recommendation of the respective departmental head.
Employee Travel Advance A/c DR
Cash / Bank Account CR

UNDERSTANDING LOCK BOX

2007-12-14T16:55:00.000-08:00

Payment advice Processing

Matching of customer open items

The lockbox program uses detailed information from the payment advice to automatically search and match customer open items. The document number on the payment advice is matched against the document number in the customer open item file. Therefore, accurate payment data is necessary for automatic clearing to take place.

Payment Advice Status

If the checks were applied or partially applied, the advice is deleted from the system after processing. If the check was unprocessed or placed on account of customer, the advice is kept on file for further processing.

Post Processing

The post process function entails reviewing the status of the checks applied through the lock box function. User must manually clear any checks that were on-account of customer or not applied to customer account.

The Lockbox overview screen details the number of checks in each category. Depending on the status of the check, the user determines what needs to occur to apply checks.

On account: If the bank keyed in the correct invoice number, the Lockbox Import Program posts the payment on account. In the post processing step, you access the payment advice and correct the document number and upon saving the changes, the post process function clears the open item, deletes the payment advice and sets the check status to applied.

Partially Applied: Checks that are partially applied may require further processing. Ex: Check may have paid 5 invoices, but one was in correctly keyed. The first 4 invoices would clear. The payment amount for the 5th invoice would be put on-account and would have to be post processed to clear.

Unprocessed: Any payment that could not be identified either by customer MICR number (check) or the document number would remain Unprocessed. Once the payment is researched and the customer and invoice is identified, it would be applied during post processing.

What configuration needs to be done?

Control Parameters: It determines the import format BAI, BAI2 & ANSI and the types of postings generated by the lockbox program. These control parameters are needed for importing lockbox file sent by bank.

Posting Data: Company code, Bank Information, G/L accounts for posting and clearing, document types and Posting keys.

RFEBLB30 or FLBP transaction

Lock Box data, Processing parameters (Procedure & Algorithm) Account assignment (Profit center), output control and Mode of call transaction.

Understanding Lockbox

2007-12-14T16:54:00.002-08:00

Difference between EDI 820 and 823:

In general EDI 820 formats will be used to send information to Vendor furnishing details of payment for his supplies. From business standpoint, EDI 820 information comes from customer as the business is vendor to its customer. In fact EDI 820 is not a lockbox format but can be used in place of lockbox for customer open item processing. This information however is not a real payment but only a remittance advice.

Where as lockbox format is an exclusive format that comes from bank confirming the payments received from customer. This is real payment information which got credited in business account at Lockbox /Bank. Besides this basic difference between these two formats some other differences can be summarized as under.

EDI 820 will have one to one information. Each customer will send remittance information to the business. EDI 823 format will have several customer information in one format.
Customer can not use EDI 823 format where as Bank can use EDI 820 format.
EDI 820 is only an advice but 823 is a payment.
Technical settings viz., Partner profiles, Basic type, Message type, function modules used in SAP are different between these two.
Level of information will be different. EDI 823 will have Total number of checks involved, total payment amount involved, break up of checks and amount per batch, per customer etc will not be available in case of EDI 820.

BAI vs. EDI in Lockbox:

Both the formats are acceptable and can be used in SAP for processing customer open items. However the earlier one is (BAI) is file based and the later format is (EDI) is idoc based. File based is batch mode and EDI is real time information. BAI can not be made as real time process but EDI can be made as batch process.

EDI technology requires mapping tool. It creates intermediate document holding the information for further process. On the other side BAI format doesn’t require this.

As far as processing and of clearing customer open items in SAP is concerned, whether the format is BAI or EDI system will follow same transactions. FB01 > FBE1 > FB05. In either of the case if information is not sufficient to clear open items, it is available for manual process.

Some additional advantages of EDI are:

Data Accuracy
Reduce Technical Complexity.
Lowe Personnel needs.
Accelerates information exchange.

LOCKBOX PROCESS - DATA FILE TO SAP OPEN ITEM CLEARING

What Bank will do?	Bank Receives the payments, create a data file of the customer remittance information and payment amounts, and deposit the checks into client bank account. On regular basis, Client company receives this data file for processing to update in their accounts.
What lockbox data file contain?	Depending upon the choice of services with the Bank, the lock box file will contain information viz., Customer name, Customer Number, Customer MICR number ( Bank routing and Account Number), Check amount, Invoice number, Payment date, Payment amounts and other information.
Lockbox Data Flow	As shown in the following picture, customers send their payments to a lockbox. Then bank collects the data and sends (either through EDI 820 and 823 formats) to R/3 users EDI server (standard Process). The server translates the message using as standard EDI interface into an IDOC (Intermediary documents) and sends it to the SAP Server.
What happens in SAP server	Once the message is received and stored in SAP table, a program is clicked (RFEBLB30 or FLBP transaction) to check the information stored in bank statement tables and create payment advices with Payment amount, invoice numbers and customer number.

Understanding Lockbox

2007-12-14T16:54:00.001-08:00

Objective of this document is to explain the meaning, purpose, advantages and disadvantages of the lockbox. This document also explains various types of formats that can be used to process the lockbox data.

What is a lockbox?

A company can create accounts called ‘lockbox’ accounts at its bank (or banks) that act as payment collection accounts for customer payments. The company then informs their customers that all open item payments for their accounts must be submitted to one of the established bank lockbox accounts. The bank collects these payments along with the customers’ remittance information that indicates what open items the customer payments intend to clear. Data entry clerks at the bank manually enter the information into an electronic file for transmission to the company to which the lockbox account belongs. These files are typically transferred nightly to the various lockbox owners (companies). The files adhere to one of two standard banking industry transmission formats: BAI, BAI2, EDI820 and EDI 823.

Advantages of Lockbox:

Lockbox process has several advantages. Some of them can be illustrated as under.

Avoid Manual handling of checks
Timely processing of Checks
Easy reconciliation
Reduction of manpower cost
Avoid clearing Errors

What is BAI?

The standards for lockbox transmission files are defined by the Bank Administration Institute (BAI). Founded in 1924, the BAI organization is a partnership composed of its own BAI membership, a Board of Directors, various banking industry advisory groups and a professional staff. The organizational mission is “to help bank administrators achieve high levels of professional effectiveness and to help solve significant banking problems.” Activities include the definition of industry file formats, such as lockbox transmissions. BAI and BAI2 are the two defined lockbox transmission formats, however, BAI is considered ‘outdated’ by the BAI organization and is no longer supported (ie. standards are no longer updated or improved). Nonetheless, many banks still offer transmissions in the old BAI format.

BAI vs. BAI2?

BAI and BAI2 formats differ in their level of information detail. BAI does not separate out the incoming check line items by invoice subtotal reference. Instead, one check total amount simply has all invoices listed underneath it. Thus, in BAI format files, the entire check amount must match perfectly (or within configured payment difference tolerances) the total amount for all invoices listed. Otherwise, the entire check will enter into SAP as:

an “On account” posting (if the payment and invoice totals don’t match), or
An “Unprocessed” posting (if no customer account and documents could be identified from the transmission).
In these scenarios, your Accounts Receivable cash application clerks will have to perform manual application to clear payments against open items on the proper accounts.

Conversely, BAI2 splits the check total into separate invoice references and associated payment amounts. Thus, within a large batch, BAI2 format files will allow a “Partially applied” status in which some identifiable payments within the check total will be matched and cleared, others will land on account. As a result, your ‘hit rate’ percentage of payment-invoice matching from each transmission is likely to be higher when using BAI2 rather than BAI formats.

Electronic Data Interchange:

Network transfer of structured electronic data from one computer application to another using standard message formats. EDI is described as the interchange of structured data according to agreed message standards between computer systems by electronic means. This standard format is nothing but a Set of rules, agreed upon, accepted, and voluntarily adhered to, by which data is structured into message formats for exchange of business and operational information. Lockbox related formats are Edi 820 and 823.

EDI 820:

The 820 Payment Order/Remittance Advice transactions can be used to make a payment, send a remittance advice, or make a payment and send a remittance advice. The 820 transaction can be an order to a financial institution to make a payment to a payee. It can also be a remittance advice identifying the detail needed to perform cash application to the payee’s accounts receivable system. The remittance advice can go directly from payer to payee, through a financial institution, or through a third party agent.

EDI 823

The 823 Lockbox formats are sent by bank as confirmation of payments received from customers of lockbox owner. EDI 823 format contains information like Bank details of lockbox service provider, total quantity of checks in each format transmission, total amount involved in total checks, number of batch involved ( batch represents maximum quantity of checks in each lot). Further break up like, customer name, customer bank routing number, customer bank account number, check number and amount, number of invoices paid, amount per invoice, discounts for each invoice, deductions if any involved and credit memos etc.

Information available in these formats are generally used for clearing customer open items in SAP depends upon the business requirement. Following EDI configuration is required to read the data from corresponding format and process customer open items.

Format

Idoc type

Message type

Process code

EDI 820

Pexer2002

REMADV

REMA

EDI 823

FINSTA01

LOCKBOX

LBX

Tcodes for Configuring Assets Accounting

2007-12-14T16:52:00.000-08:00

FG99    Flexible G/L: Report Selection
FGI0    Execute Report
FGI1    Create Report
FGI2    Change Report
FGI3    Display Report
FGI4    Create Form
FGI5    Change Form
FGI6    Display Form
FGIB    Background Processing
FGIC    Maintain Currency Translation Type
FGIK    Maintain Key Figures
FGIM    Report Monitor
FGIO    Transport Reports
FGIP    Transport Forms
FGIQ    Import Reports from Client 000
FGIR    Import Forms from Client 000
FGIT    Translation Tool - Drilldown Report.
FGIV    Maintain Global Variable
FGIX    Reorganize Drilldown Reports
FGIY    Reorganize Report Data
FGIZ    Reorganize Forms
FGM0    Special Purpose Ledger Menu
FGRP    Report Painter
FGRW    Report Writer Menu
FI01    Create Bank
FI02    Change Bank
FI03    Display Bank
FI04    Display Bank Changes
FI06    Mark Bank for Deletion
FI07    Change Current Number Range Number
FI12    Change House Banks/Bank Accounts
FI12CORE   Change House Banks/Bank Accounts
FI13    Display House Banks/Bank Accounts
FIBB    Bank chain determination
FIBC    Scenarios for Bank Chain Determin.
FIBD    Allocation client
FIBF    Maintenance transaction BTE
FIBHS   Display bank chains for house banks
FIBHU   Maintain bank chains for house banks
FIBL1   Control Origin Indicator
FIBL2   Assign Origin
FIBL3   Group of House Bank Accounts
FIBPS   Display bank chians for partners
FIBPU   Maintain bank chains for partner
FIBTS   Dis. bank chains for acct carry over
FIBTU   Main. bank chains for acctCarry over
FIHC    Create Inhouse Cash Center
FILAUF_WF_CUST  Store Order: Workflow Customizing
FILE    Cross-Client File Names/Paths
FILINV_WF_CUST  Store Inventory:Workflow Customizing
FINA    Branch to Financial Accounting
FINF    Info System Events
FINP    Info System Processes
FITP_RESPO      Contact Partner Responsibilities
FITP_SETTINGS   Settings for Travel Planning
FITP_SETTINGS_TREE      Tree Maintenance Current Settings
FITVFELD        Tree
FJA1    Inflation Adjustment of G/L Accounts
FJA2    Reset Transaction Data G/L Acc.Infl.
FJA3    Balance Sheet/P&L with Inflation
FJA4    Infl. Adjustment of Open Items (FC)
FJA5    Infl. Adj. of Open Receivables (LC)
FJA6    Infl. Adj. of Open Payables (LC)
FJEE    Exercise Subscription Right
FK01    Create Vendor (Accounting)
FK02    Change Vendor (Accounting)
FK02CORE   Maintain vendor
FK03    Display Vendor (Accounting)
FK04    Vendor Changes (Accounting)
FK05    Block Vendor (Accounting)
FK06    Mark Vendor for Deletion (Acctng)
FK08    Confirm Vendor Individually (Acctng)
FK09    Confirm Vendor List (Accounting)
FK10    Vendor Account Balance
FK10N   Vendor Balance Display
FK10NA  Vendor Balance Display
FK15    Transfer vendor changes: receive
FK16    Transfer vendor changes: receive
FKI0    Execute Report
FKI1    Create Report
FKI2    Change Report
FKI3    Display Report
FKI4    Create Form
FKI5    Change Form
FKI6    Display Form
FKIB    Background Processing
FKIC    Maintain Currency Translation Type
FKIK    Maintain Key Figures
FKIM    Report Monitor
FKIO    Transport Reports
FKIP    Transport Forms
FKIQ    Import Reports from Client 000
FKIR    Import Forms from Client 000
FKIT    Translation Tool - Drilldown Report.
FKIV    Maintain Global Variable
FKIX    Reorganize Drilldown Reports
FKIY    Reorganize Report Data
FKIZ    Reorganize Forms
FKMN
FKMT    FI Acct Assignment Model Management
FLB1    Postprocessing Lockbox Data
FLB2    Import Lockbox File
FLBP    Post Lockbox Data
FLCV    Create/Edit Document Template WF
FM+0    Display FM Main Role Definition
FM+1    Maintain FM Main Role Definition
FM+2    Display FM Amount Groups
FM+3    Maintain FM Amount Groups
FM+4    Display FM Budget Line Groups
FM+5    Maintain FM Budget Line Groups
FM+6    Display FM Document Classes
FM+7    Maintain FM Document Classes
FM+8    Display FM Activity Categories
FM+9    Maintain FM Activity Categories
FM+A    Display Doc.Class->Doc.Cat. Assgmt
FM+B    Maintain Doc.Clase->Doc.Cat.Assgmt
FM03    Display FM Document
FM21    Change Original Budget
FM22    Display Original Budget
FM25    Change Supplement
FM26    Display Supplement
FM27    Change Return
FM28    Transfer Budget
FM29    Display Return
FM2D    Display Funds Center Hierarchy
FM2E    Change Budget Document
FM2F    Display Budget Document
FM2G    Funds Center Hierarchy
FM2H    Maintain Funds Center Hierarchy
FM2I    Create Funds Center
FM2S    Display Funds Center
FM2T    Change Releases
FM2U    Change Funds Center
FM2V    Display Releases
FM3D    Display Commitment Item Hierarchy
FM3G    Commitment Item Hierarchy
FM3H    Maintain Commitment Item Hierarchy
FM3I    Create Commitment Item
FM3N    Commitment Items for G/L Accounts
FM3S    Display Commitment Item
FM3U    Change Commitment Item
FM48    Change Financial Budget: Initial Scn
FM48_1  PS-CM: Create Planning Layout
FM48_2  PS-CM: Change Planning Layout
FM48_3  PS-CM: Display Planning Layout
FM49    Display Financial Budget: Init.Scrn
FM4G    Budget Structure Element Hierarchy
FM5I    Create Fund
FM5S    Display Fund
FM5U    Change Fund
FM5_DEL    Delete fund preselection
FM5_DISP   Display fund preselection
FM5_SEL    Preselection Fund
FM6I    Create Application of Funds
FM6S    Display Application of Funds
FM6U    Change Application of Funds
FM71    Maintain Cover Pools
FM72    Assign FM Acct Asst to Cover Pool
FM78    Charact.Groups for Cover Pools
FM79    Grouping Chars for Cover Pool
FM7A    Display Cover Eligibility Rules
FM7I    Create Attributes for FM Acct Asst
FM7P    Maintain Cover Eligibility Rules
FM7S    Display Cover Eligibility Rules
FM7U    Maintain Cover Eligibility Rules
FM9B    Copy Budget Version
FM9C    Plan Data Transfer from CO
FM9D    Lock Budget Version
FM9E    Unlock Budget Version
FM9F    Delete Budget Version
FM9G    Roll Up Supplement
FM9H    Roll up Original Budget
FM9I    Roll Up Return
FM9J    Roll Up Releases
FM9K    Change Budget Structure
FM9L    Display Budget Structure
FM9M    Delete Budget Structure
FM9N    Generate Budget Object
FM9P    Reconstruct Budget Distrbtd Values
FM9Q    Total Up Budget
FM9W    Adjust Funds Management Budget
FMA1    Matching: Totals and Balances (CBM)
FMA2    Matching: CBM Line Items and Totals
FMA3    Matching: FI Line Items (CBM)
FMA4    Matching: FI Bank Line Items (CBM)
FMAA    Matching: Line Items and Totals (FM)
FMAB    Matching: FI FM Line Items
FMAC    Leveling: FM Commitment Line Items
FMAD    Leveling: FI-FM Totals Records
FMAE    Display Change Documents
FMAF    Level Line Items and Totals Items
FMB0    CO Document Transfer
FMB1    Display Security Prices-Collect.
FMBI    Use Revenues to Increase Expend.Bdgt
FMBUD005   FIFM Budget Data Export
FMBUD006   FIFM Budget Data Import
FMBV    Activate Availability Control
FMC2    Customizing in Day-to-Day Business
FMCB    Reassignment: Document Selection
FMCC    Reassignment: FM-CO Assignment
FMCD    Reassignment: Delete Work List
FMCG    Reassignment: Overall Assignment
FMCN    Reassignment: Supplement.Acct Assgt
FMCR    Reassignment: Display Work List
FMCT    Reassignment: Transfer
FMD1    Change Carryforward Rules
FMD2    Display Carryforward Rules
FMDM    Monitor Closing Operations
FMDS    Copy Carryforward Rules
FMDT    Display Carryforward Rules
FME1    Import Forms from Client 000
FME2    Import Reports from Client 000
FME3    Transport Forms
FME4    Transport Reports
FME5    Reorganize Forms
FME6    Reorganize Drilldown Reports
FME7    Reorganize Report Data
FME8    Maintain Batch Variants
FME9    Translation Tool - Drilldown
FMEB    Structure Report Backgrnd Processing
FMEH    SAP-EIS: Hierarchy Maintenance
FMEK    FMCA: Create Drilldown Report
FMEL    FMCA: Change Drilldown Report
FMEM    FMCA: Display Drilldown Report
FMEN    FMCA: Create Form
FMEO    FMCA: Change Form
FMEP    FMCA: Display Form
FMEQ    FMCA: Run Drilldown Report
FMER    FMCA: Drilldown Tool Test Monitor
FMEURO1 Create Euro FM Area
FMEURO2 Refresh Euro Master Data
FMEURO3 Display Euro FM Areas
FMEURO4 Deactivate Euro FM Areas
FMEV    Maintain Global Variable
FMF0    Payment Selection
FMF1    Revenue Transfer
FMG1    FM: Create Commitment Item Group
FMG2    FM: Change Commitment Item Group
FMG3    FM: Display Commitment Item Group
FMG4    FM: Delete Commitment Item Group
FMG5    Generate BS Objects fr.Cmmt Item Grp
FMHC    Check Bdgt Structure Elements in HR
FMHG    Generate Bdgt Struc Elements in HR
FMHGG   Generate BS Elements f. Several Fnds
FMHH    Master Data Check
FMHIST  Apportion Document in FM
FMHV    Budget Memo Texts
FMIA    Display Rules for Revs.Incr.Budget
FMIB    Increase Budget by Revenues
FMIC    Generate Additional Budget Incr.Data
FMIL    Delete Rules for Revs Incr. Budget
FMIP    Maintain Rules for Revs.Incr.Budget
FMIS    Display Rules for Revs.Incr.Budget
FMIU    Maintain Rules for Revs.Incr.Budget
FMJ1    Fiscal Year Close: Select Commitment
FMJ1_TR Settlement: Select Commitment
FMJ2    Fiscal Year Close: Carr.Fwd Commts
FMJ2_TR Settlement: Transfer Commitment
FMJ3    Reverse Commitments Carryforward
FMJA    Budget Fiscal Year Close: Prepare
FMJA_TR Budget Settlement: Prepare
FMJB    Determine Budget Year-End Closing
FMJB_TR Budget Settlement: Determine
FMJC    Budget Fiscal-Year Close: Carry Fwd
FMJC_TR Budget Settlement: Transfer
FMJD    Reverse Fiscal Year Close: Budget
FMLD    Ledger Deletion
FMLF    Classify Movement Types
FMN0    Subsequent Posting of FI Documents
FMN1    Subsequent Posting of MM Documents
FMN2    Subsequent Posting of Billing Docs
FMN3    Transfer Purchase Req. Documents
FMN4    Transfer Purchase Order Documents
FMN5    Transfer Funds Reservation Documents
FMN8    Simulation Lists Debit Position
FMN8_OLD   Simulation Lists Debit Position
FMN9    Posted Debit Position List
FMN9_OLD   Posted Debit Position List
FMNA    Display CBA Rules
FMNP    Maintain CBA Rules
FMNR    Assign SN-BUSTL to CBA
FMNS    Display CBA Rules
FMNU    Maintain CBA Rules
FMP0    Maintain Financial Budget
FMP1    Display Financial Budget
FMP2    Delete Financial Budget Version
FMR0    Reconstruct Parked Documents
FMR1    Actual/Commitment Report
FMR2    Actual/Commitment per Company Code
FMR3    Plan/Actual/Commitment Report
FMR4    Plan/Commitment Report w.Hierarchy
FMR5A   12 Period Forecast: Actual and Plan
FMR6A   Three Period Display: Plan/Actual
FMRA    Access Report Tree
FMRB    Access Report Tree
FMRE_ARCH    Archive Earmarked Funds
FMRE_EWU01   Earmarked Funds: Euro Preprocessing
FMRE_EWU02   Earmarked Funds: Euro Postprocessing
FMRE_SERLK   Close Earmarked Funds
FMRP18  Clear Subsequent Postings
FMSS    Display Status Assignment
FMSU    Change Assigned Status
FMU0    Display Funds Reservation Doc.Types
FMU1    Maintain Funds Reservation Doc.Types
FMU2    Display Funds Reservtn Fld Variants
FMU3    Maintain Funds Resvtn Field Variants
FMU4    Display Funds Reservation Fld Groups
FMU5    Maintain Funds Reservatn Fld Groups
FMU6    Display Funds Reservtn Field Selctn
FMU7    Maintain Funds Resvtn Field Selctn
FMU8    Display Template Type for Fds Resvtn
FMU9    Maintain Template Type for Fds Resvn
FMUA    Dispay Fds Res.Template Type Fields
FMUB    Maintain Fds Res.Template Type Flds
FMUC    Display Funds Res. Reference Type
FMUD    Maintain Funds Res.Reference Type
FMUE    Display Funds Res.Ref.Type Fields
FMUF    Maintaine Fds Rsvtn Ref.Type Fields
FMUG    Display Reasons for Decision
FMUH    Maintain Reasons for Decisions
FMUI    Display Groups for Workflow Fields
FMUJ    Maintain Groups for Workflow Fields
FMUK    Display Fields in Groups for WF
FMUL    Maintain Fields in Groups for WF
FMUM    Display Field Selctn ->Variant/Group
FMUN    Display Field Seln->Variant/Group
FMUV    Funds Resvtn Field Status Var.Asst
FMV1    Create Forecast of Revenue
FMV2    Change Forecast of Revenue
FMV3    Display Forecast of Revenue
FMV4    Approve Forecast of Revenue
FMV5    Change FM Acct Asst in Fcst of Rev.
FMV6    Reduce Forecast of Revenue Manually
FMVI    Create Summarization Item
FMVO    Fund Balance Carryforward
FMVS    Display Summarization Item
FMVT    Carry Forward Fund Balance
FMVU    Change Summarization Item
FMW1    Create Funds Blocking
FMW2    Change Funds Blocking
FMW3    Display Funds Blocking
FMW4    Approve Funds Blocking
FMW5    Change FM Acct Asst in Funds Blkg
FMWA    Create Funds Transfer
FMWAZ   Payment Transfer
FMWB    Change Funds Transfer
FMWC    Display Funds Transfer
FMWD    Approve Funds Transfer
FMWE    Change FM Acct Asst in Funds Trsfr
FMX1    Create Funds Reservation
FMX2    Change Funds Reservation
FMX3    Display Funds Reservation
FMX4    Approve Funds Reservation
FMX5    Change FM Acct Asst in Funds Resvn
FMX6    Funds Reservation: Manual Reduction
FMY1    Create Funds Commitment
FMY2    Change Funds Commitment
FMY3    Display Funds Precommitment
FMY4    Approve Funds Precommitment
FMY5    Change FM Acct Asst in Funds Prcmmt
FMY6    Reduce Funds Precommitment Manually
FMZ1    Create Funds Commitment
FMZ2    Change Funds Commitment
FMZ3    Display Funds Commitment
FMZ4    Approve Funds Commitment
FMZ5    Change FM Acct Asst in Funds Commt
FMZ6    Reduce Funds Commitment Manually
FMZBVT  Carry Forward Balance
FMZZ    Revalue Funds Commitments
FM_DL07    Delete Worklist
FM_DLFI    Deletes FI Documnts Transferred from
FM_DLFM    Deletes all FM Data (fast)
FM_DLOI    Deletes Cmmts Transferred from FM
FM_EURO_M  Parameter maintenance for euro conv.
FM_RC06    Reconcile FI Paymts-> FM Totals Itms
FM_RC07    Reconcile FI Paymts-> FM Line Items
FM_RC08    Reconcile FM Paymts -> FM Line Items
FM_RC11    Select Old Payments
FM_S123    GR/IR: Post OIs to FM Again
FM_S201    Post Payments on Account to FIFM
FM_SD07    Display Worklist
FN-1    No.range: FVVD_RANL (Loan number)
FN-4    Number range maintenance: FVVD_PNNR
FN-5    Number range maintenance: FVVD_SNBNR
FN-6    Number range maintenance: FVVD_RPNR
FN09    Create Borrower's Note Order
FN11    Change borrower's note order
FN12    Display borrower's note order
FN13    Delete borrower's note order
FN15    Create borrower's note contract
FN16    Change borrower's note contract
FN17    Display borrower's note contract
FN18    Payoff borrower's note contract
FN19    Reverse borrower's note contract
FN1A    Create other loan contract
FN1V    Create other loan contract
FN20    Create borrower's note offer
FN21    Change borrower's note offer
FN22    Display borrower's note offer
FN23    Delete borrower's note offer
FN24    Activate borrower's note offer
FN2A    Change other loan application
FN2V    Change other loan contract
FN30    Create policy interested party
FN31    Change policy interested party
FN32    Display policy interested party
FN33    Delete policy interested party
FN34    Policy interested party in applic.
FN35    Policy interested party in contract
FN37    Loan Reversal Chain
FN3A    Display other loan application
FN3V    Display other loan contract
FN40    Create other loan interested party
FN41    Change other loan interested party
FN42    Display other loan interested party
FN43    Delete other loan interested party
FN44    Other loan interest.party in applic.
FN45    Other loan interested prty in cntrct
FN4A    Delete other loan application
FN4V    Delete other loan contract
FN5A    Other loan application in contract
FN5V    Payoff other loan contract
FN61    Create collateral value
FN62    Change collateral value
FN63    Display collateral value
FN70    List 25
FN72    List 54
FN80    Enter manual debit position
FN81    Change manual debit position
FN82    Display manual debit position
FN83    Create waiver
FN84    Change waiver
FN85    Display waiver
FN86    Enter debit position depreciation
FN87    Change debit position depreciation
FN88    Display debit position depreciation
FN8A    Manual Entry: Unsched. Repayment
FN8B    Manual Entry: Other Bus. Operations
FN8C    Manual Entry: Charges
FN8D    Post Planned Records
FNA0    Policy application in contract
FNA1    Create mortgage application
FNA2    Change mortgage application
FNA3    Display mortgage application
FNA4    Complete mortgage application
FNA5    Mortgage application in contract
FNA6    Create policy application
FNA7    Change policy application
FNA8    Display policy application
FNA9    Delete policy application
FNAA    Reactivate deleted mortgage applic.
FNAB    Reactivate deleted mortg. int.party
FNAC    Reactivate deleted mortgage contract
FNAD    Reactivate deleted policy applicat.
FNAE    Reactivate deleted policy contract
FNAG    Reactivate deleted other loan applic
FNAH    Reactivate del. other loan int.party
FNAI    Reactivate deleted other loan cntrct
FNAK    Select file character
FNAL    Reactivate deleted BNL contract
FNAM    Reactivate deleted policy contract
FNASL   Loans: Account Analysis
FNB1    Transfer to a Loan
FNB2    Transfer from a Loan
FNB3    Document Reversal - Loans
FNB8    BAV Information
FNB9    BAV transfer
FNBD    Loans-Automatic bal.sheet transfer
FNBG    Guarantee charges list
FNBU    DARWIN- Loans accounting menu
FNCD    Transfer Customizing for Dunning
FNCW1   Maintain Standard Role
FNCW2   Transaction Release: Adjust Workflow
FNDD    Convert Dunning Data in Dunn.History
FNEN    Create Loan
FNENALG   Create General Loan
FNENHYP   Create Mortgage Loan
FNENPOL   Create Policy Loan
FNENSSD   Create Borrower's Note Loan
FNF1    Rollover: Create file
FNF2    Rollover: Change file
FNF3    Rollover: Display file
FNF4    Rollover: Fill file
FNF9    Rollover: Evaluations
FNFO    ISIS: Create file
FNFP    ISIS: Change file
FNFQ    ISIS: Display file
FNFR    ISIS: Fill file
FNFT    Rollover: File evaluation
FNFU    Rollover: Update file
FNG2    Total Loan Commitment
FNG3    Total Commitment
FNI0
FNI1    Create mortgage application
FNI2    Change mortgage application
FNI3    Display mortgage application
FNI4    Delete mortgage application
FNI5    Mortgage application to offer
FNI6    Mortgage application in contract
FNIA    Create interested party
FNIB    Change interested party
FNIC    Display interested party
FNID    Delete interested party
FNIE    Reactivate interested party
FNIH    Decision-making
FNIJ    Create credit standing
FNIK    Change credit standing
FNIL    Display credit standing
FNIN    Create collateral value
FNIO    Change collateral value
FNIP    Display collateral value
FNK0    Multimillion Loan Display (GBA14)
FNK1    Loans to Managers (GBA15)
FNKO    Cond.types - Cond.groups allocation
FNL1    Rollover: Create Main File
FNL2    Rollover: Change Main File
FNL3    Rollover: Displ. Main File Structure
FNL4    New business
FNL5    New business
FNL6    New business
FNM1    Automatic Posting
FNM1S   Automatic Posting - Single
FNM2    Balance sheet transfer
FNM3    Loans reversal module
FNM4    Undisclosed assignment
FNM5    Automatic debit position simulation
FNM6    Post dunning charges/int.on arrears
FNM7    Loan reversal chain
FNMA    Partner data: Settings menu
FNMD    Submenu General Loans
FNME    Loans management menu
FNMEC   Loans Management Menu
FNMH    Loans management menu
FNMI    Loans information system
FNMO    Loans Menu Policy Loans
FNMP    Rollover
FNMS    Loans Menu Borrower's Notes
FNN4    Display general file
FNN5    Edit general file
FNN6    Display general main file
FNN7    Edit general main file
FNN8    Display general main file
FNN9    Edit general overall file
FNO1    Create Object
FNO2    Change Object
FNO3    Display Object
FNO5    Create collateral
FNO6    Change collateral
FNO7    Display collateral
FNO8    Create Objects from File
FNO9    Create Collateral from File
FNP0    Edit rollover manually
FNP4    Rollover: Display file
FNP5    Rollover: Edit File
FNP6    Rollover: Display main file
FNP7    Rollover: Edit main file
FNP8    Rollover: Display overall file
FNP9    Rollover: Edit overall file
FNQ2    New Business Statistics
FNQ3    Postprocessing IP rejection
FNQ4    Customer Inc. Payment Postprocessing
FNQ5    Transact.type - Acct determinat.adj.
FNQ6    Compare Flow Type/Account Determin.
FNQ7    Generate flow type
FNQ8    Automatic Clearing for Overpayments
FNQ9    Int. adjustment run
FNQF    Swiss interest adjustment run
FNQG    Swiss special interest run
FNR0    Loans: Posting Journal
FNR6    Insur.prtfolio trends - NEW
FNR7    Totals and Balance List
FNR8    Account statement
FNR9    Planning list
FNRA    Other accruals/deferrals
FNRB    Memo record update
FNRC    Accruals/deferrals reset
FNRD    Display incoming payments
FNRE    Reverse incoming payments
FNRI    Portfolio Analysis Discount/Premium
FNRS    Reversal Accrual/Deferral
FNS1    Collateral number range
FNS4    Cust. list parameters for loan order
FNS6    Installation parameter lists
FNS7    Loan Portfolio Trend Customizing
FNSA    Foreign currency valuation
FNSB    Master data summary
FNSL    Balance reconciliation list
FNT0    Loan correspondence (Switzerland)
FNT1    Autom. deadline monitoring
FNT2    Copy text modules to client
FNUB    Treasury transfer
FNV0    Payoff policy contract
FNV1    Create mortgage contract
FNV2    Change mortgage contract
FNV3    Display mortgage contract
FNV4    Delete mortgage contract
FNV5    Payoff mortgage contract
FNV6    Create policy contract
FNV7    Change policy contract
FNV8    Display policy contract
FNV9    Delete policy contract
FNVA    Create paid off contracts
FNVCOMPRESSION  Loans: Document Data Summarization
FNVD    Disburse Contract
FNVI    Loans: General Overview
FNVM    Change Contract
FNVR    Reactivate Contract
FNVS    Display Contract
FNVW    Waive Contract
FNWF    WF Loans Release: List of Work Items
FNWF_REP   Release Workflow: Synchronization
FNWO    Loans: Fast Processing
FNWS    Housing statistics
FNX1    Rollover: Create Table
FNX2    Rollover: Change Table
FNX3    Rollover: Display Table
FNX6    Rollover: Delete Table
FNX7    Rollover: Deactivate Table
FNX8    Rollover: Print Table
FNXD    TR-EDT: Documentation
FNXG    List of Bus. Partners Transferred
FNXU    List of Imported Loans
FNY1    New Business: Create Table
FNY2    New Business: Change Table
FNY3    New Business: Display Table
FNY6    New Business: Delete Table
FNY7    New Business: Deactivate Table
FNY8    New Business: Print Table
FNZ0    Rejections report
FNZ1    Postprocessing payment transactions
FNZA    Account Determination Customizing
FN_1    Table maint. transferred loans
FN_2    Table maintenance transf. partner
FN_UPD_FELDAUSW   Update Program for Field Selection

SAP FI Transaction Code List 1

How to reverse a cleared documents?

The following procedure is to be followed to reverse the cleared document.

1. Reset the cleared document and reverse the document.

Path # Accounting --> financial Accounting --> C/L --> Document--> Reset Cleared items - T. code : FBRA

In this screen select resetting and reverse radio button and give the reversal reason. : 01 and save the settings.

F-01    Enter Sample Document

F-02    Enter G/L Account Posting

F-03    Clear G/L Account

F-04    Post with Clearing

F-05    Post Foreign Currency Valuation

F-06    Post Incoming Payments

F-07    Post Outgoing Payments

F-18    Payment with Printout

F-19    Reverse Statistical Posting

F-20    Reverse Bill Liability

F-21    Enter Transfer Posting

F-22    Enter Customer Invoice

F-23    Return Bill of Exchange Pmt Request

F-25    Reverse Check/Bill of Exch.

F-26    Incoming Payments Fast Entry

F-27    Enter Customer Credit Memo

F-28    Post Incoming Payments

F-29    Post Customer Down Payment

F-30    Post with Clearing

F-31    Post Outgoing Payments

F-32    Clear Customer

F-33    Post Bill of Exchange Usage

F-34    Post Collection

F-35    Post Forfaiting

F-36    Bill of Exchange Payment

F-37    Customer Down Payment Request

F-38    Enter Statistical Posting

F-39    Clear Customer Down Payment

F-40    Bill of Exchange Payment

F-41    Enter Vendor Credit Memo

F-42    Enter Transfer Posting

F-43    Enter Vendor Invoice

F-44    Clear Vendor

F-46    Reverse Refinancing Acceptance

F-47    Down Payment Request

F-48    Post Vendor Down Payment

F-49    Customer Noted Item

F-51    Post with Clearing

F-52    Post Incoming Payments

F-53    Post Outgoing Payments

F-54    Clear Vendor Down Payment

F-55    Enter Statistical Posting

F-56    Reverse Statistical Posting

F-57    Vendor Noted Item

F-58    Payment with Printout

F-59    Payment Request


F-60    Maintain Table: Posting Periods

F-62    Maintain Table: Exchange Rates

F-63    Park Vendor Invoice


F-64    Park Customer Invoice

F-65    Preliminary Posting

F-66    Park Vendor Credit Memo

F-67    Park Customer Credit Memo

F-90    Acquisition from purchase w. vendor

F-91    Asset acquis. to clearing account

F-92    Asset Retire. frm Sale w/ Customer

F.01    ABAP/4 Report: Balance Sheet

F.02    Compact Journal

F.03    Reconciliation

F.04    G/L: Create Foreign Trade Report

F.05    Foreign Currency Val.: Open Items

F.06    Foreign Currency Valuation:G/L Assts

F.07    G/L: Balance Carried Forward

F.08    G/L: Account Balances

F.09    G/L: Account List

F.0A    G/L: FTR Report on Disk

F.0B    G/L: Create Z2 to Z4

F.10    G/L: Chart of Accounts

F.11    G/L: General Ledger from Doc.File

F.12    Advance Tax Return

F.13    ABAP/4 Report: Automatic Clearing

F.14    ABAP/4 Report: Recurring Entries

F.15    ABAP/4 Report: List Recurr.Entries

F.16    ABAP/4 Report: G/L Bal.Carried Fwd

F.17    ABAP/4 Report: Cust.Bal.Confirmation

F.18    ABAP/4 Report: Vend.Bal.Confirmation

F.19    G/L: Goods/Invoice Received Clearing

F.1A    Customer/Vendor Statistics

F.1B    Head Office and Branch Index

F.20    A/R: Account List

F.21    A/R: Open Items

F.22    A/R: Open Item Sorted List

F.23    A/R: Account Balances

F.24    A/R: Interest for Days Overdue

F.25    Bill of Exchange List

F.26    A/R: Balance Interest Calculation

F.27    A/R: Periodic Account Statements

F.28    Customers: Reset Credit Limit

F.29    A/R: Set Up Info System 1

F.2A    Calc.cust.int.on arr.: Post (w/o OI)

F.2B    Calc.cust.int.on arr.: Post(with OI)

F.2C    Calc.cust.int.on arr.: w/o postings

F.2D    Customrs: FI-SD mast.data comparison

F.2E    Reconciliation Btwn Affiliated Comps

F.2F    Management Acct Group Reconciliation

F.2G    Create Account Group Reconcil. G/L

F.30    A/R: Evaluate Info System

F.31    Credit Management - Overview

F.32    Credit Management - Missing Data

F.33    Credit Management - Brief Overview

F.34    Credit Management - Mass Change

F.35    Credit Master Sheet

F.36    Adv.Ret.on Sls/Pur.Form Printout(DE)

F.37    Adv.rept.tx sls/purch.form print (BE

F.38    Transfer Posting of Deferred Tax

F.39    C FI Maint. table T042Z (BillExcTyp)

F.40    A/P: Account List

F.41    A/P: Open Items

F.42    A/P: Account Balances

F.44    A/P: Balance Interest Calculation

F.45    A/P: Set Up Info System 1

F.46    A/P: Evaluate Info System

F.47    Vendors: calc.of interest on arrears

F.48    Vendors: FI-MM mast.data comparison

F.4A    Calc.vend.int.on arr.: Post (w/o OI)

F.4B    Calc.vend.int.on arr.: Post(with OI)

F.4C    Calc.vend.int.on arr.: w/o postings

F.50    G/L: Profitability Segment Adjustmnt


F.51    G/L: Open Items

F.52    G/L: Acct Bal.Interest Calculation

F.53    G/L: Account Assignment Manual

F.54    G/L: Structured Account Balances

F.56    Delete Recurring Document

F.57    G/L: Delete Sample Documents

F.58    OI Bal.Audit Trail: fr.Document File

F.59    Accum.Clas.Aud.Trail: Create Extract

F.5A    Accum.Clas.Aud.Trail: Eval.Extract

F.5B    Accum.OI Aud.Trail: Create Extract

F.5C    Accum.OI Audit Trail: Display Extr.

F.5D    G/L: Update Bal. Sheet Adjustment

F.5E    G/L: Post Balance Sheet Adjustment

F.5F    G/L: Balance Sheet Adjustment Log

F.5G    G/L: Subseq.Adjustment(BA/PC) Sp.ErA

F.5I    G/L: Adv.Rep.f.Tx on Sls/Purch.w.Jur

F.61    Correspondence: Print Requests

F.62    Correspondence: Print Int.Documents

F.63    Correspondence: Delete Requests

F.64    Correspondence: Maintain Requests

F.65    Correspondence: Print Letters (Cust)

F.66    Correspondence: Print Letters (Vend)

F.70    Bill/Exchange Pmnt Request Dunning

F.71    DME with Disk: B/Excha. Presentation

F.75    Extended Bill/Exchange Information

F.77    C FI Maintain Table T045D

F.78    C FI Maintain Table T045B

F.79    C FI Maintain Table T045G

F.80    Mass Reversal of Documents

F.81    Reverse Posting for Accr./Defer.Docs

F.90    C FI Maintain Table T045F

F.91    C FI Maintain Table T045L

F.92    C FI Maintain T012K (Bill/Exch.)

F.93    Maintain Bill Liability and Rem.Risk

F.97    General Ledger: Report Selection

F.98    Vendors: Report Selection

F.99    Customers: Report Selection

F/LA    Create Pricing Report

F/LB    Change pricing reports

F/LC    Display pricing reports

F/LD    Execute pricing reports

F00     SAPoffice: Short Message

F000    Accounting

F010    ABAP/4 Reporting: Fiscal Year Change

F01N    Debit position RA single reversal

F01O    Vacancy RU single reversal

F01P    Accruals/deferrals single reversal

F01Q    Debit position MC single reversal

F01R    MC settlement single reversal

F01S    Reverse Periodic Posting

F01T    Reverse Acc./Def. General Contract

F040    Reorganization

F041    Bank Master Data Archiving

F042    G/L Accounts Archiving

F043    Customer Archiving

F044    Vendor Archiving

F045    Document Archiving

F046    Transaction Figures Archiving

F101    ABAP/4 Reporting: Balance Sheet Adj.

F103    ABAP/4 Reporting: Transfer Receivbls

F104    ABAP/4 Reporting: Receivbls Provisn

F107    FI Valuation Run

F110    Parameters for Automatic Payment

F111    Parameters for Payment of PRequest

F13E    ABAP/4 Report: Automatic Clearing

F150    Dunning Run

F48A    Document Archiving

F53A    Archiving of G/L Accounts


F53V    Management of G/L Account Archives

F56A    Customer Archiving

F58A    Archiving of Vendors

F61A    Bank archiving

F64A    Transaction Figure Archiving

F66A    Archiving of Bank Data Storage

F8+0    Display FI Main Role Definition


F8+1    Maintain FI Main Role Definition

F8+2    Display FI Amount Groups

F8+3    Maintain FI Amount Groups

F8B4    C FI Maintain Table TBKDC

F8B6N   C FI Maintain Table TBKPV

F8BC    C FI Maintain Table TBKFK

F8BF    C FI Maintain Table T042Y

F8BG    Maintain Global Data for F111

F8BH    Inconsistencies T042I and T042Y

F8BJ    Maintain Clearing Accts (Rec.Bank)

F8BK    Maintain ALE-Compatible Pmnt Methods

F8BM    Maintain numb.range: Payment request

F8BN    Corr.Acctg Documents Payment Block

F8BO    Payment request archiving

F8BR    Levels for Payment Requests

F8BS    Detail display of payment requests

F8BT    Display Payment Requests

F8BU    Create payment runs automatically

F8BV    Reversal of Bank-to-Bank Transfers

F8BW    Reset Cleared Items: Payt Requests

F8BZ    F111 Customizing

F8XX    Payment Request No. Ranges KI3-F8BM

FA39    Call up report with report variant

FAKA    Config.: Show Display Format

FAKP    Config.: Maintain Display Format

FAR1    S FI-ARI Maint. table T061A

FARA    S FI-ARI Maint. table T061P/Q

FARB    C FI-ARI Maint. table T061R

FARI    AR Interface: Third-party applicatns

FARY    Table T061S

FARZ    Table T061V

FAX1    BC sample SAP DE 2.1

FAX2    BC sample 2 SAP DE 2.1

FB00    Accounting Editing Options

FB01    Post Document

FB02    Change Document

FB03    Display Document

FB03Z   Display Document/Payment Usage

FB04    Document Changes

FB05    Post with Clearing

FB05_OLD Post with clearing

FB07    Control Totals

FB08    Reverse Document

FB09    Change Line Items

FB10    Invoice/Credit Fast Entry

FB11    Post Held Document

FB12    Request from Correspondence

FB13    Release for Payments

FB1D    Clear Customer

FB1K    Clear Vendor

FB1S    Clear G/L Account

FB21    Enter Statistical Posting

FB22    Reverse Statistical Posting

FB31    Enter Noted Item

FB41    Post Tax Payable

FB50    G/L Acct Pstg: Single Screen Trans.

FB60    Enter Incoming Invoices

FB65    Enter Incoming Credit Memos

FB70    Enter Outgoing Invoices

FB75    Enter Outgoing Credit Memos

FB99    Check if Documents can be Archived

FBA1    Customer Down Payment Request

FBA2    Post Customer Down Payment

FBA3    Clear Customer Down Payment


FBA6    Vendor Down Payment Request


FBA7    Post Vendor Down Payment

FBA7_OLD Post Vendor Down Payment

FBA8     Clear Vendor Down Payment

FBA8_OLD Clear Vendor Down Payment

FBB1    Post Foreign Currency Valn

FBBA    Display Acct Determination Config.

FBBP    Maintain Acct Determination Config.

FBCJ    Cash Journal

FBCJC0  C FI Maintain Tables TCJ_C_JOURNALS

FBCJC1  Cash Journal Document Number Range

FBCJC2  C FI Maint. Tables TCJ_TRANSACTIONS

FBCJC3  C FI Maintain Tables TCJ_PRINT

FBCOPY  Copy Function Module

FBD1    Enter Recurring Entry

FBD2    Change Recurring Entry


FBD3    Display Recurring Entry

FBD4    Display Recurring Entry Changes

FBD5    Realize Recurring Entry

FBD9    Enter Recurring Entry

FBDF    Menu Banque de France

FBE1    Create Payment Advice

FBE2    Change Payment Advice


FBE3    Display Payment Advice


FBE6    Delete Payment Advice

FBE7    Add to Payment Advice Account

FBF1    C80 Reporting Minus Sp.G/L Ind.

FBF2    Financial Transactions

FBF3    Control Report

FBF4    Download Documents

FBF5    Reports Minus Vendor Accounts

FBF6    Document Changes

FBF7    C80 Reports Minus Sp.G/L Ind.

FBF8    C84 Reports

FBFT    Customizing BDF

FBIPU   Maintain bank chains for partner

FBKA    Display Accounting Configuration

FBKF    FBKP/Carry Out Function (Internal)

FBKP    Maintain Accounting Configuration

FBL1    Display Vendor Line Items

FBL1N   Vendor Line Items

FBL2    Change Vendor Line Items

FBL2N   Vendor Line Items

FBL3    Display G/L Account Line Items

FBL3N   G/L Account Line Items

FBL4    Change G/L Account Line Items

FBL4N   G/L Account Line Items

FBL5    Display Customer Line Items

FBL5N   Customer Line Items

FBL6    Change Customer Line Items

FBL6N   Customer Line Items

FBM1    Enter Sample Document

FBM2    Change Sample Document

FBM3    Display Sample Document

FBM4    Display Sample Document Changes

FBMA    Display Dunning Procedure

FBME    Banks

FBMP    Maintain Dunning Procedure

FBN1    Accounting Document Number Ranges

FBN2    Number Range Maintenance: FI_PYORD

FBP1    Enter Payment Request

FBR1    Post with Reference Document

FBR2    Post Document

FBRA    Reset Cleared Items

FBRC    Reset Cleared Items (Payment Cards)

FBS1    Enter Accrual/Deferral Doc.

FBTA    Display Text Determin.Configuration

FBTP    Maintain Text Determin.Configuration

FBU2    Change Intercompany Document

FBU3    Display Intercompany Document

FBU8    Reverse Cross-Company Code Document

FBV0    Post Parked Document

FBV1    Park Document

FBV2    Change Parked Document

FBV3    Display Parked Document

FBV4    Change Parked Document (Header)

FBV5    Document Changes of Parked Documents

FBV6    Parked Document $

FBVB    Post Parked Document

FBW1    Enter Bill of Exchange Pmnt Request

FBW2    Post Bill of Exch.acc.to Pmt Request

FBW3    Post Bill of Exchange Usage

FBW4    Reverse Bill Liability

FBW5    Customer Check/Bill of Exchange

FBW6    Vendor Check/Bill of Exchange

FBW7    Bank file to file system (for FBWD)

FBW8    File to Bank (for Transaction FBWD)

FBW9    C FI Maintain Table T045DTA

FBWA    C FI Maintain Table T046a

FBWD    Returned Bills of Exchange Payable

FBWD2   Parameter Transaction for FBWD

FBWE    Bill/Exch.Presentatn - International

FBWQ    C FI Maintain Table T045T

FBWR    C FI Maintain Table T045W

FBWS    C FI Maintain Table T046s

FBZ0    Display/Edit Payment Proposal

FBZ1    Post Incoming Payments

FBZ2    Post Outgoing Payments

FBZ3    Incoming Payments Fast Entry

FBZ4    Payment with Printout

FBZ5    Print Check For Payment Document

FBZ8    Display Payment Run

FBZA    Display Pmnt Program Configuration

FBZG    Failed Customer Payments

FBZP    Maintain Pmnt Program Configuration

FC10    Financial Statements Comparison

FC11    Data Extract for FI Transfer
FC80    Document C80

FC82    Document C82

FCAA    Check Archiving

FCC1    Payment Cards: Settlement

FCC2    Payment Cards: Repeat Settlement

FCC3    Payment Cards: Delete Logs

FCC4    Payment Cards: Display Logs

FCCR    Payment Card Evaluations

FCH1    Display Check Information

FCH2    Display Payment Document Checks

FCH3    Void Checks

FCH4    Renumber Checks

FCH5    Create Check Information

FCH6    Change Check Information/Cash Check

FCH7    Reprint Check

FCH8    Reverse Check Payment

FCH9    Void Issued Check

FCHA    Check archiving

FCHB    Check retrieval

FCHD    Delete Payment Run Check Information

FCHE    Delete Voided Checks

FCHF    Delete Manual Checks

FCHG    Delete cashing/extract data

FCHI    Check Lots

FCHK    Check Tracing Initial Menu

FCHN    Check Register

FCHR    Online Cashed Checks

FCHT    Change check/payment allocation

FCHU    Create Reference for Check

FCHV    C FI Maintain Table TVOID

FCHX    Check Extract - Creation

FCIWCU  BW Customizing for CS

FCIWD00 Download InfoObject text

FCIWD10 Download InfoObject hierarchies

FCKR    International cashed checks

FCMM    C FI Preparations for consolidation

FCMN    FI Initial Consolidation Menu

FCV1    Create A/R Summary

FCV2    Delete A/R Summary

FCV3    Early Warning List

FC_BW_BEX       Business Explorer Analyser

FC_BW_RSA1      BW Administrator Workbench

FC_BW_RSZDELETE Delete BW Query Objects

FC_BW_RSZV      Maintain BW Variables

FD-1    Number range maintenance: FVVD_RANL

FD01    Create Customer (Accounting)

FD02    Change Customer (Accounting)

FD02CORE Maintain customer

FD03    Display Customer (Accounting)


FD04    Customer Changes (Accounting)

FD05    Block Customer (Accounting)

FD06    Mark Customer for Deletion (Acctng)

FD08    Confirm Customer Individually(Actng)

FD09    Confirm Customer List (Accounting)

FD10    Customer Account Balance

FD10N   Customer Balance Display

FD10NA  Customer Bal. Display with Worklist

FD11    Customer Account Analysis

FD15    Transfer customer changes: send
FD16    Transfer customer changes: receive

FD24    Credit Limit Changes

FD32    Change Customer Credit Management

FD33    Display Customer Credit Management

FD37    Credit Management Mass Change

FDCU    Loans customizing menu

FDFD    Cash Management Implementation Tool

FDI0    Execute Report

FDI1    Create Report

FDI2    Change Report

FDI3    Display Report

FDI4    Create Form

FDI5    Change Form

FDI6    Display Form

FDIB    Background Processing

FDIC    Maintain Currency Translation Type

FDIK    Maintain Key Figures

FDIM    Report Monitor

FDIO    Transport Reports

FDIP    Transport Forms

FDIQ    Import Reports from Client 000

FDIR    Import Forms from Client 000

FDIT    Translation Tool - Drilldown Report

FDIV    Maintain Global Variable

FDIX    Reorganize Drilldown Reports

FDIY    Reorganize Report Data

FDIZ    Reorganize Forms

FDK43   Credit Management - Master Data List

FDMN

FDOO    Borrower's notes order overview

FDTA    TemSe/REGUT Data Administration

FDTT    Treasury Data Medium Administration

FEBA    Postprocess Electronic Bank Statmt

FEBC    Generate Multicash format

FEBMSG  Display Internet Messages

FEBOAS  Request Account Statement via OFX

FEBOFX  OFX Functions

FEBP    Post Electronic Bank Statement

FEBSTS  Search String Search Simulation

FESR    Importing of POR File (Switzerland)

FEUB    Adjust VIBEPP after EURO conversion

FEUI    Real Estate Implementation Guide

FF$3    Send planning data to central system

FF$4    Retrieve planning data

FF$5    Retrieve transmission results

FF$6    Check settings

FF$7    Check all external systems

FF$A    Maintain TR-CM subsystems

FF$B    Convert Planning Group

FF$C    Convert planning level

FF$D    Convert business areas

FF$L    Display transmission information

FF$S    Display transmission information

FF$X    Configure the central TR-CM system

FF-1    Outstanding Checks

FF-2    Outstanding Bills of Exchange

FF-3    Cash Management Summary Records

FF-4    CMF Data In Accounting Documents

FF-5    CMF Records fr.Materials Management

FF-6    CMF Records from Sales

FF-7    Forecast Item Journal

FF-8    Payment Advice Journal

FF-9    Journal

FF.1    Standard G/L Account Interest Scale

FF.3    G/L Account Cashed Checks

FF.4    Vendor Cashed Checks

FF.5    Import Electronic Bank Statement

FF.6    Display Electronic Bank Statement

FF.7    Payment Advice Comparison

FF.8    Print Payment Orders

FF.9    Post Payment Orders

FF.D    Generate payt req. from advices

FF/1    Compare Bank Terms

FF/2    Compare value date

FF/3    Archive advices from bank statements
FF/4    Import electronic check deposit list

FF/5    Post electronic check deposit list

FF/6    Deposit/loan mgmt analysis/posting

FF/7    Deposit/loan management int accruals

FF/8    Import Bank Statement into Cash Mgmt

FF/9    Compare Advices with Bank Statement

FF63    Create Planning Memo Record

FF65    List of Cash Management Memo Records

FF67    Manual Bank Statement

FF68    Manual Check Deposit Transaction

FF6A    Edit Cash Mgmt Pos Payment Advices

FF6B    Edit liquidity forecast planned item

FF70    Cash Mgmt Posit./Liquidity Forecast

FF71    Cash Position

FF72    Liquidity forecast

FF73    Cash Concentration

FF74    Use Program to Access Cash Concntn

FF7A    Cash Position

FF7B    Liquidity forecast

FF:1    Maintain exchange rates

FFB4    Import electronic check deposit list

FFB5    Post electronic check deposit list

FFL_OLD Display Transmission Information

FFS_OLD Display Transmission Information

FFTL    Telephone list

FFW1    Wire Authorization

FFWR    Post Payment Requests from Advice

FFWR_REQUESTS   Create Payment Requests from Advice

FF_1    Standard G/L Account Interest Scale

FF_3    G/L Account Cashed Checks

FF_4    Vendor Cashed Checks

FF_5    Import Electronic Bank Statement

FF_6    Display Electronic Bank Statement

Some Important Tcodes for FI GL AR AP Asset

2007-12-14T16:50:00.002-08:00

T Codes Details Financial Accounting

 
SPRO    Enter IMG

OX02    Company Code - Create, Check, Delete

OX03    Create Business Area

OKBD    Functional Areas

OB45    Create Credit Control Area

OB29    Maintain Fiscal Year Variant

OB37    Assign Co. Code to Fiscal Year Variant

OB13    Creation of Chart of Account (CoA)

OBY7    Copy Chart of Account (CoA)

OBY9    Transport Chart of Account

OBD4    Define Account Group

OBY2    Copy GL Accounts from the Chart to Co. Code

OB53    Define Retained Earnings

OB58    Maintain Financial Statement Versions

OBC4    Maintain Field Status Variant

OBBO    Define Posting Period Variant

OBA7    Define Document Type & Number Ranges

OB41    Maintain Posting Keys

OBA4    Create Tolerance Groups

FBN1    Create GL Number Ranges

OBL1    Automatic Posting Documentation

FBKP    Automatic Account Assignment

OBYC    MM Automatic Account Assignment

OBY6    Enter Global Parameters

FS00    Creation of GL Master Records

(F-02)  Posting of GL Transactions

(FB03)  Display of GL Document

(FS10N) Display of GL Accounts

OB46    Define Interest Calculation Types

OBD3    Define Vendor Account Group

(XK01)  Creation of Vendor Master

(F-43)  Purchase Invoice Posting

(FK10N) Display Vendor Account

F112    Define House Bank

OBB8    Maintain Terms of Payment (ToP)

OBD2    Creation of Customer Account Group

OBA3    Customer Tolerance Groups

(XD01)  Creation of Customer Master

(FD10N) Display Customer Account

(F-28)  Incoming Payment Posting

OB61    Define Dunning Area

EC08    Copy Reference Chart of Depreciation (CoD)

OADB    Define Depreciation Area

OAOB    Assign Chart of Depreciation to Co. Code

OAOA    Define Asset Class

AO90    Assignment of Account in Asset Class

OAY2    Determination of Depreciation Area in Asset Class

(AS01)  Creation of Asset Master

(AS11)  Creation of Sub Asset

(F-90)  Asset Purchase Posting

(AFAB)  Depreciation Run

(F-92)  Asset Sale Posting

(AW01N) Asset Explorer

Sales and Distribution Accounting Entries

2007-12-14T16:50:00.001-08:00

INVOICE GENERATION

Invoices will be generated at the Smelters and stock points. The accounting entries for the sale of goods despatched will flow from the Sales invoice generated in SAP Sales and Distribution module.

The following entries shall be passed

Customer Account Dr
Revenue Cr
Excise Duty Payable Cr
Sales Tax Payable (local or central) Cr

Note:

As mentioned above in the FI document, which is created in the background, the SD invoice number shall be captured. However as per the current accounting procedure the accounting entry passed is as follows :-
Customer Account Dr
Revenue Cr
Excise Duty Billed Cr
Sales Tax Payable (local or central) Cr

Excise duty paid a/c Dr
Excise duty payable a/c Cr

EXPORT SALES

There have been very few export transactions in the past. SAP system will be designed to handle export business. Exports are mainly from the mines and will be handled at the mines, however the documentation part will be taken care at the Head Office. The accounting entry is:
Customer Account Dr
Revenue (Exports) Cr

The realisation of export sales will be directly credited to the bank. The accounting entries will be as follow:
Bank Dr
Customer Cr
Exchange Fluctuation Dr/ Cr

The accounting entries will be:
Rebates/Discounts Dr
Customer Cr

DEBIT MEMOS

Debit Memos shall be issued in case of price difference, sale tax difference and interest on usance period and overdue payments.

The accounting entries for two possible scenarios are as follows:
Price Undercharged:
Customer Account Dr.
Revenue Cr.
Sales tax payable Cr.
Sales tax undercharged
Customer Account Dr.
Sales tax adjustment Cr.

Interest on delayed payments/usance period and other charges
Customer Account Dr.
Interest Others Cr.

In case of HZL a complete retirement or a partial retirement of asset is done. The system uses the asset retirement date to determine the amount to be charged off for each depreciation area. The existing accounting policy is to provide depreciation for the full quarter in which the asset is sold/discarded, recommended that the depreciation be provided from the date of acquisition on prorata basis .

Accounting entry for sale of Asset to customers:

Customer Account Dr
Asset Sale Cr
Accumulated Depreciation Dr
Loss on Sale (if applicable) Dr
Asset Sale account Dr
Asset account Cr
Profit on sale (if applicable) Cr

Note:

In case of any Sales Tax /Excise duty applicable for this transaction, SAP will calculate the Sales Tax/Excise Duty based on the Tax Code selected the entry is posted to the GL Account (Sales Tax Payable)

Accounting entry for sale without a customer:

Accumulated Depreciation Dr
Loss on Sale (if applicable) Dr
Asset Sale account Dr
Asset account Cr
Profit on sale (if applicable) Cr

Accounting entry for scrap
Accumulated Depreciation Dr
Loss on Sale of Assets Dr
Asset account Cr

SALE OF SCRAP

The sale of scrap (non-stock) shall be mapped as a direct manual FI entry. The customer will be created as a FI customer. No Logistics module will be involved in the process.

A FI Invoice will be prepared for the sale of scrap with the following entries:
Customer Dr
Sale of Scrap Cr
Excise Duty Payable Cr

ADVANCES FROM CUSTOMERS

Advances are received from the customers against delivery. These advances will be recorded in a special general ledger account. The accounting entry for the same will be:
Bank Account Dr
Advance Customer Payments Cr

These advances will be later on adjusted against the invoices raised on the customers. Advances can be adjusted against more than one invoice at the time of clearing of the invoices against advances.

Adjustment of Advances
Customer Account Cr
Advance Customer Payments Dr

A financial document would be created for each Bank Guarantee received and this document number will be referred to in the Sales Order which would then monitor the value and the validity of the of the Bank Guarantee instrument wise while doing the billing.The letter of credit /Bank guarantee given will be recorded as a noted item.

Accounting Entry for Goods receipt
Stock/Inventory account Dr
GR/IR account Cr
Freight clearing account Cr

Accounting Entry on invoice verification of supplier
GR/IR Dr
Vendor account Cr

Accounting Entry on invoice verification of freight vendor
Freight clearing account Dr
Freight Vendor account Cr

GOODS RECEIPT

Based on the Purchase order and the Quantity actually received Goods Receipts (GR) will be done. Based on the GR done the following accounting entry will be passed in the Financial Accounts

RM/PM Stock Account Dr
GR/IR Account Cr
Freight Clearing Account Cr

EXCISE INVOICE VERIFICATION

On receipt of the excise invoice cum gate pass the following entry will be passed
RG 23 A / RG 23 C Part 2 Account Dr
Cenvat Clearing Account Cr

Reversal Entry In Accounting

2007-12-14T16:49:00.001-08:00

Why do we pass reversal enteries?

At times some incorrect documents might have been entered in the systems.

If you have entered an incorrect document, you can reverse it.

Note that R/3 can reverse a document only if the following conditions are met:

- Contains no cleared items

- Contains only vendor, customer, or G/L line items

- Was posted within the FI system

- Contains only valid values, such as business areas, cost centers, and tax codes

Ordinarily, you post a reversing document in the same period you posted the original document. The period of the original document must be open to post a reversing document. If the period is not open, you can overwrite the posting date field with a date in an open period, such as the current period.

Reversal can be done individually - FB08 or Mass F.80.

If the document to be reveresed contain cleared items, then cleared item must be reset before the reversal of document.

Useful Reports Tcode in SAP Financial Accounting

2007-12-14T16:48:00.000-08:00

GENERAL LEDGER

Information Systems

1. Structured Account Balances (Balance Sheet & P&L Account in FS Version Format)

S_ALR_87012279

2. GL Account Balances (Totals & Balances ) S_ALR_87012301

3. GL Line Items S_ALR_87012282

4. Statements for GL Accounts, Customers & Vendors S_ALR_87012332

5. Document Journal S_ALR_87012287

6. Compact Document Journal S_ALR_87012289

7. Line Item Journal S_ALR_87012291

8. Display of Changed Documents S_ALR_87012293

9. Invoice Numbers assigned Twice S_ALR_87012341

10. Gaps in Document Number Assignments S_ALR_87012342

11. Posting Totals Document Type wise S_ALR_87012344

12. Recurring Entry Documents S_ALR_87012346

Master Data

13. Chart of Accounts S_AL:R_87012326

14. GL Account List S_AL:R_87012328

15. Display Changes to GL Accounts S_ALR_87012308

16. Financial Statement Version FSE2

CASH & BANK REPORTS

1. Check Information List FCH6

2. Check Register FCHN

3. Check Number Ranges S_P99_41000102

TAX REPORTS & REGISTERS

1. List of Internally generated Excise Invoices J1I7

2. Capital Goods Transfer of Credit J2I8

3. List of GRs without Excise Invoice J1IGR

4. List of SubContract Challans J1IFR

5. CENVAT Register J2I9
(Monthly Return under Rule 57AE of the Central excise Rules from which Monthly Return under Rule 7 of the CENVAT Credit Rules 2001)

6. Registers : RG 23A/C Part I &II , RG1, PLA J1I5,J2I5,J2I6


ACCOUNTS RECEIVABLE

Information Systems

1. Bill Holdings (Bill of Exchange Receivable List  with ALV facility)
                                                       S-ALR_87009987

2. Customer Balances in Local Currency                   S_ALR_87012172

3. Customer Line Items                                   S_ALR_87012197

4. Due Dates Analysis for Open Items                     S_ALR_87012168

5. List of Customer Open Items                           S_ALR_87012173

6. Customer Evaluation with Open Item Sorted List        S_ALR_87012176

7. Customer Payment History                              S_ALR_87012177

8. Customer Open Item Analysis (Overdue Items Balance)   S_ALR_87012178

9. List of Customer Cleared Line Items                   S_ALR_87012198

10.List of Down Payments open at key date                S_ALR_87012199

11. Debit & Credit Notes Register – Monthly              S_ALR_87012287

12. Customer wise Sales                                  S_ALR_87012186                        


ACCOUNTS PAYABLE


(Note : Similar Reports available for A/R are available for A/P also)


1. Vendor Balances                                       S_ALR_87012082

2. Vendor Debit/Credit Memo Register                     S_ALR_87012287

Profit and Loss Closing Tcodes

2007-12-14T16:45:00.000-08:00

1. Capital Investment Projects – Settle Order to AUC
Accounting -> Investment management -> Internal orders -> Period-end closing -> Single functions -> Settlement ->… Various

2. Capital Investment Projects – Settle AUC to asset in service
Accounting -> Investment management -> Fixed assets -> Postings -> Cap. asset u. const. -> Settle AIBU

3. PP/CO Period-End Closing
Logistics -> Production -> Production Control -> Period-end closing ->…

Accounting -> Controlling -> Product Cost Controlling -> Cost Object Controlling -> Product Cost by Order -> Period-End Closing -> Single Functions ->… Various

4. Internal Order Period-End Closing
Accounting -> Controlling -> Internal Orders -> Period-end closing -> Single functions ->… Various

5. Cost Center Accounting Period-End Closing
Accounting -> Controlling -> Cost Center Accounting -> Period-end closing -> Single functions ->… Various

6. Profitability Analysis Period-End Closing
Accounting -> Controlling -> Profitability Analysis -> Actual Postings -> Cost Center Costs/Process Costs ->… KEU5, KEG5, CPAE

7. Lock Controlling Transactions
Accounting -> Controlling -> Cost Center Accounting -> Environment -> Period lock -> Change OKP1

8. Reconciliation Ledger
Accounting -> Controlling -> Cost Element Accounting -> Actual postings -> Reconciliation withFI KALC

9. Reconciliation Ledger Follow Up Postings
Accounting -> Controlling -> Cost Element Accounting -> Environment -> Reconciliation ledger -> Follow up posting KAL1

10. Reconciliation Ledger Configuration
IMG -> Controlling -> Overhead Cost Controlling -> Cost and Revenue Element Accounting -> Reconciliation Ledger Various

11. Post payroll information to accounting
Human Resources -> Payroll -> (Country-specific) PC00_ M99_ CIPE

12. Configure Payroll for posting to accounting
IMG -> Payroll -> Payroll: (country-specific) Various Customizing Technical, Organizational and Documentary Steps

13. Define fiscal year variants
IMG -> Financial Accounting -> Financial Accounting Global Settings -> Fiscal Year -> Maintain Fiscal Year Variant (Maintain Shortened Fisc. Year) OB29

14. Allocate fiscal year variant to a company code
IMG -> Financial Accounting -> Financial Accounting Global Settings -> Fiscal Year -> Assign Company Code to a Fiscal Year Variant OB37

15. Define Variants for Open Posting Periods
IMG -> Financial Accounting -> Financial Accounting Global Settings -> Document -> Posting
Periods -> Define Variants for Open Posting Periods OBBO

16. Allocate Posting Period Variant to Company Code
IMG -> Financial Accounting -> Financial Accounting Global Settings -> Document -> Posting Periods -> Assign Variants to Company Code OBBP

17. Open and Close Posting Periods
Accounting -> Financial accounting -> General ledger -> Environment -> Current settings -> Open and Close Posting Periods OB52

18. Carry Forward Balance to New Fiscal Year
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Carry Forward -> Balances F.16

19. Define Retained Earning account
IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Carrying Forward -> Define Retained Rarnings Account OB53

20. Schedule Manager
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Schedule Manager SCMA

21. Subsequent Business Area/Profit Center Adjustment – Calculate
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Regroup -> Balance Sheet Readjustment -> Calculate F.5D

22. Subsequent Business Area/Profit Center Adjustment – Post
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Regroup -> Balance Sheet Readjustment -> Post F.5E

23. Transfer B/S Items to Profit Center Accounting
Accounting -> Enterprise Controlling -> Profit Center Accounting -> Actual Postings -> Period-End Closing -> Transfer Payables/Receivables 1KEK

24. PCA Balance Carried Forward
Accounting -> Enterprise Controlling -> Profit Center Accounting -> Actual Postings -> Period-End Closing -> Carrying Forward of Balances 2KES

25. Profit and Loss Adjustment
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Regroup -> Profit and Loss Adjustment F.50

26. Run Compact Document Journal
Accounting -> Financial accounting -> General ledger -> Information system -> General Ledger Reports -> Document -> General -> Compact Document Journal

27. Create Balance Audit Work Files
IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Documenting -> Define Accumulated Work Files for Balance Audit Trail OBBQ

28. Run Monthly Balance Audit Trail for Open Item Accounts
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> Open item accounts -> Open Item Account Balance Audit Trail from the Document File

29. Run Monthly Balance Audit Trail for Other Accounts
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> All accounts -> General Ledger from the Document File

30. Create Extract for Accumulated Open Item Balance Audit Trail
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> Open item accounts -> From balance audit trail -> Extract for Accumulated Open Item Audit Trail

31. Run Accumulated Open Item Balance Audit Trail
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> Open item accounts -> From balance audit trail -> Accts Detailed Listing from Open Item Account Accumulated Audit Trail

32. Create Extract for Accumulated Balance Audit Trail for Other Accounts
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> All accounts -> From balance audit trail -> Extract for the Accumulated Historical Balance Audit Trail

33. Run Accumulated Balance Audit Trail for Other Accounts
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing ->
Document -> Balance audit trail -> All accounts -> From balance audit trail -> Account Details from Historical Accumulated Balance Audit Trail

Open and Close Posting Periods

2007-12-14T16:44:00.000-08:00

Define the posting company code variant in SM30 - V_T010O

Assign the company code variant in SM30 - V_001_R

Maintain the open and close posting period with OB52.

You can control period by : -

1. G/L number range.

2. Company code.

3. Company code and G/L range.

More FI configuration considerations:

2007-12-14T16:42:00.000-08:00

Business Area, COA, GL, Fiscal year and Currencies

Business Area is optional and is equivalent to a specific area of responsibility within your company or business segment. BA (Business Area) also allows for internal and external reporting.

Another configuration requirement for set-up in SAP are the Basic settings consisting of the following:

Chart of Accounts(COA)

Fiscal Year Variants.

Currencies

The COA(Chart of Accounts) lists all General Ledger accounts that are used by the organization. It is assigned in configuration to each company code and allows for daily General Ledger postings.

The General Ledger accounts are made up of such data as account number, company code, a description of the account , classification of whether the account is a P & L Statement Account or a Balance Sheet Account.

Control data of the GL Account is where currency is specified, Tax category (posting without tax allowed) , marking the account as a reconciliation account ( e.g. Customer, Asset, Vendors, Accounts Receivable) or not.

Marking the G/L Account as a “reconciliation” account allows for postings to an Asset Account ( for example) as well as automatic update to the G/L Account.

Configuration prevents direct postings to reconciliation accounts thereby assisting in maintaining integrity of the data.

This allows reconciliation between the sub-ledger and general ledger to always be guaranteed.

Within the General Ledger control data , you can also designate whether line item display is possible in the account. The system then stores an entry per line in an index table which links back to the account. (Display of line item details are then available for reporting purposes ,etc.)

Open Item Indicators can be set on the G/L Account allowing for better management of open items. Examples include: Bank Clearing Accounts, GR/IR Clearing Accounts, Payroll, etc.

Fiscal Year configuration is a must and can be defined to meet your company’s reporting periods whether Fiscal (any period combination that is not calendar) or Calendar( Jan-Dec).

Posting Periods are defined and assigned to the Fiscal Year.

Within the periods you specify start dates and finished dates.

SAP allows for 12 posting periods along with specially defined periods that can be used for year-end financial closing.

Currencies are another basic configuration setting requirement which defines your company’s legal means of payment by country.

It is recommended that all Currency set-ups in SAP follow the ISO Standards.

The ISO Standards ensure Global conformity across businesses worldwide utilizing SAP.

2007-12-14T16:41:00.002-08:00

All the Inventory transactions will look for the valuation class and the corresponding G.L. Accounts and post
the values in the G.L accounts.

For Example: During Goods Receipt

Stock Account - Dr
G/R I/R Account - Cr
Freight Clearing account - Cr
Other expenses payable - Cr

During Invoice Verification

G/R I/R Account - Dr
Vendor - Cr

When the Goods are issued to the Production Order the following transactions takes place:

Consumption of Raw Materials - Dr
Stock A/c - Cr

When the Goods are received from the Production Order the following transactions takes place:

Inventory A/c - Dr
Cost of Goods Produced - Cr
Price difference - Dr/Cr
(depending on the difference between standard cost and actual cost)

When the Goods are dispatched to customer through delivery the following transactions takes place:

Cost of Goods Sold - Dr
Inventory A/c - Cr

When the Goods are issued to a Cost Center or charged off against expenses the following transactions takes place:

Repairs and Maintenance - Dr
Inventory A/c - Cr

When the Goods are stock transferred from one plant to another, the following transactions takes place:

Stock A/c - Dr (Receiving location)
Stock A/c - Cr (Sending location)
Price difference - Dr/Cr
(due to any difference between the standard costs between the two locations)

When the stocks are revalued, the following transactions takes place:

Stock A/c - Dr/Cr
Inventory Revaluation A/c - Cr / Dr

When the Work in Progress is calculated the following transaction takes place:

Work in Progress A/c - Dr
Change WIP A/c - Cr

Physical verification /shortages and excesses : Shortages/excesses on authorizations shall be adjusted using the physical inventory count transaction.

What is the SAP FI Module ?

2007-12-14T16:41:00.001-08:00

IntroductionThe SAP FI Module has the capability of meeting all the accounting and financial needs of an organization. It is within this module that Financial Managers as well as other Managers within your business can review the financial position of the company in real time as compared to legacy systems which often times require overnight updates before financial statements can be generated and run for management review.

The real-time functionality of the SAP modules allows for better decision making and strategic planning. The FI (Financial Accounting) Module integrates with other SAP Modules such as MM (Materials Management), PP (Production Planning), SD(Sales and Distribution), PM (Plant Maintenance),and PS (Project Systems).

The FI Module also integrates with HR(Human Resources) which includes PM(Personnel Management), Time Management, Travel Management, Payroll.Document transactions occurring within the specific modules generate account postings via account determination tables.

The FI (Financial Accounting) Module components.

The FI Module comprises several sub-modules as follows:

Accounts Receivables

Accounts Payable

Asset Accounting

Bank Accounting

Consolidation

Funds Management

General Ledger

Special Purpose Ledger

Travel Management

Accounts Receivables records all account postings generated as a result of Customer sales activity. These postings are automatically updated in the General Ledger . It is within the Accounts

Receivables Module that you can monitor aging of the receivables and generate customer analysis. The Accounts Receivable Module also integrates with the General ledger, Sales and Distribution, and Cash Management Modules.

Accounts Payable records account postings generated as a result of Vendor purchasing activity. Automatic postings are generated in the General Ledger as well. Payment programs within SAP enables the payment of payable documents by check, EDI, or transfers.

Asset Accounting is utilized for managing your company’s Fixed Assets. SAP allows you to categorize assets and to set values for depreciation calculations in each asset class.

Bank Accounting allows for management of bank transactions in the system including cash management.

Consolidation enables the combining of financial statements for multiple entities within an organization. These statements provide an overview of the financial position of the company as a whole.

Funds Management allows management to set budgets for revenues and expenses within your company as well as track these to the area of responsibility.

General Ledger is fully integrated with the other SAP Modules. It is within the General Ledger that all accounting postings are recorded. These postings are displayed in real-time providing up-to-date visibility of the financial accounts.

Special Purpose Ledger is used to define ledgers for reporting purposes. Data can be gathered from internal and external applications.

Travel Management provides management of all travel activities including booking trips and handling of expenses associated with travel..

SAF FI Technical Interview Questions 2

2007-12-14T16:39:00.002-08:00

Questions are answer best of my knowledge, if I am wrong, please correct me..anyone…………

1. How can be or in what way baseline date is important in Automatic Payment Program run?

The Baseline date is used to calculate the due date by taking into account the payment terms. On the APP, the baseline date helps to pick the relevant invoices for payment. During the APP run when invoices are pulled into the run, the system checks the ‘Next Payment Date’ before picking the invoices to be paid.

2. Please tell me the procurement cycle how it works?

Procurement cycle – a sales order is placed on a requirement made by a customer, after which it is passed on to create a purchase order (this could either happen based on the requirements on the SO, or a planned SO). the value flow gets passed on to FI at the time of goods movement. In the case of SD, the impact on FI happens only at the time of billing.

3. Difference between Depreciation ,Accumulated Depreciation and APC?
What is APC?

Depreciation – a decrease in the value of an asset due to wear and tear
Accumulated Depreciation – the total amount of depreciation calculated on a particular asset.
APC – refers to Asset transactions other than depreciation

4. What is GR/IR?What journal entries we should pass for this?

The GR/IR – the goods receipt/Invoice Receipt account is used to post to whenever goods that are not yet invoiced have been received or when invoices arrive b4 the the delivery of goods.

During the time between the invoice being created and delivery of goods, there can be a timing difference, in order to accommodate this timing difference, a GR/IR account is maintained temporarily to record the flow .

5. What are the accounting entries take place in MM and SD?

Value from MM to FI is defined in OBYC…. on the material master the flow of values are assigned on the Costing, acctg, etc tabs where the system helps to post the necessary stock values into the appropriate GL accounts. helps to determine, the GL accounts updated when there is a movement of goods.

SD-FI - VKOA

6. Can we assign one Controlling area to two different Company Codes (but the company codes having different fiscal years/different currencies

Company code should have same financial year, may have different currencies.

You can assign 2 or more company codes to one controlling area as long as the chart of accounts are same. Furthermore, if you have different fiscal year variant in the company code, then make sure that the number of period remain the same.

7. While posting transaction, can we give cost centre / production order at time.

Yes it is posiiable , but in such situation cost centre will be real and production order is stastical.

If you assign both cost center and Prd Order then since Prod. Order are real co object, Cost center entry would be statistical.

8. Which Master data uploads will be done?

The question is not very clear. If you are talking about CO Master data. Then Cost center need to be uploaded. You can use Data Transfer Workbench or write abap for it.

9. Can we run Payment Programe giving ( Hdfc vendor detailes ) City bank in Payment run programe?

Yes can be possible , this can resolved through ranking order and bank optimization in FBZP.

You use use further selection in proposal paramater, if you would like to filter the open item based on the city

10. What does document header control?

Field status.

11. After entering a document can you delete the entry? Can you change the document?Which fields’ can/not is changed?

Document header cannont be changed, after posting the document you cannot change. only if you want to change the document the reseversal entry.

12. What is a special GL transaction?

The transaction other than A/P and A/R is called the special g/l transaction for ex: Bills of exchange, Interest payable , aqusition

13. How do you reverse cleared documents?

By doing reversal posting.

14. What is base line date? Why is that used? Can this be changed?

For paymentterms it is used. base line date is the due date.

15. How many statistical objects can be selected in when you post an FI document? Where CCtr, PCtr, OM are active?

Only two

SAF FI Technical Interview Questions 1

2007-12-14T16:39:00.001-08:00

1. Tell me about FI Organizational structure?

Ans: Client
|
Operating Concern
|
Controlling area1 Controlling Area 2
|
Co. Code 1 Co. Code 2
|
Bus area 1 Bus area2 Bus Area3 Bus Area 4

2. How many Normal and Special periods will be there in fiscal year, why do u use special periods?

Ans: 12 Normal posting period and 4 special periods are in the fiscal year which can be used for posting tax and audit adjustments to a closed fiscal year.

3.Where do you open and close periods?

Ans: PPV is used to open and close the periods based on a/c types considering GL Accounts. Tr. Code. OB52.

4.What do you enter in Company code Global settings?

Ans: 4 digit Alphanumeric key.
Name of the company
City
Country
Currency
Language
Address

5.What is document type, and what does it control? Examples.

Ans: Document type is nothing vouchers containing line items. Several business transac! tions can be identified within a particular document type.
It controls the document number ranges.
It controls the Header part of document
IT controls the line item level of the document
Helps filing of physical document

6. What is posting key and what does it control?

Ans: These are special classification keys. Two character numerical key it controls the entry of line items.
Posting key determines Account type, Debit/credit posting, Field status of transaction.

7. What is field status group, what does it control?

Ans: FSG is mandatory field in ! GL Creation. You use this field to define which fields are displayed when you post business transactions to a G/L account.
A field may have one of the following statuses.
- Suppressed
- Display
- Optional
- Required

8. What is chart of account and how many charts of accounts can be assigned to a company?

Ans: Chart of account is a list of all G/L accounts used by one or several company codes.

For each G/L account, the chart of accounts contains the account number, account name, and the information that controls how an account functions and how a G/L account is created in a Company code.

You have to assign a chart of accounts to each company code. This chart of accounts is the Operating chart of accounts and is used for the daily postings in this company code.

You have the following options when using multiple company codes.
You can use the same chart of accounts for all company codes

If the company codes all have the same requirements for the chart of accounts set up, assign all of the individual company codes to the same chart of accounts. This could be the case if all company codes are in the same country.

In addition to the operating chart of accounts, you can use two additional charts of accounts If the individual company codes need different charts of accounts, you can assign up to two charts of accounts in addition to the operating chart of accounts. This could be the case if company codes lie in multiple countries.

The use of different charts of accounts has no effect on the balance sheet and profit and loss statement. When creating the balance sheet or the profit and loss statement, you can choose whether to balance the co! mpany codes which use different charts of accounts together or separately.

9. What does definition of a chart of account contains?

Ans: chart of account key
Name
Maintenance language
Length of the GL Account Number
Controlling Integration
Group chart of accounts (Consolidation)
Block Indicator

10. Can one COA be assigned to several companies?

Ans: yes. One COA can be assigned to several companies.

11) What is account group and what does it control?

Ans: Account group determines which fields you can configure on the G/L master record. It is necessary to have at least two one for B/S and another one for P&L a/c.
It controls the Number ranges of GL A/C.
The status of fields of the master record of GL belongs to company code area.

12) What is reconciliation account; can you directly enter documents in that a/c?

Ans: When you p! ost items to a subsidiary ledger, the system automatically posts the same data to the general ledger. Each subsidiary ledger has one or more reconciliation accounts in the general ledger.
We can’t use reconciliation account for direct postings.

13) How do you control field status of GL master records and from where do you control!

Ans: Field status variant is maintained all FSGs.

14) What are the segments of GL master record?

Ans:
- COA Segment
A/C group
Nature of account
Short text
GL a/c long text
Trading partner
Group Account Number
- Company code segment
Account currency
Tax
Reconciliation a/c for a/c type
OIM,LID,FSG.

15) What does Field status group assigned to a GL master record controls?

Ans: It controls the account assignments that are made to the account. Specifically the field status group controls whether postings to cost centers, internal orders, profitability segments and so on are required, not allowed (suppressed), or optional.

16) What is Country and operational chart of account? Why do you use group chart of account?

Ans: Operational chart of account – Day to day activities It is mandatory.
Country COA – It’s used for legal specific requirement of each country. It’s additional and optional.
Group COA used for consolidation of Company codes. This is for group consolidation purpose.

17) What are all the segments in a Customer/Vendor master record?

Ans: Segments in Customer Segments in Vendor
- General Data segment General data segment
- Company code segment Company code segment
- Sales area segment Purchasing organization Segment

18) What is open line item management? What do you mean by clearing open line items?

Ans: Open item management is further reconciliation function. OIM allows you to display the open and cleared items and amounts in an account. OIM should be used if an offsetting entry is made for every line item posted in the account. The a/c is reconciled and cleared against another account. Ex. Salary clearing account and GR/IR Clearing account.

19) What is residual payment and part payment?

Ans: Residual payment it clears original invoice with incoming amount and create new line item for remaining outstanding amount.
Partial payment it leaves the original invoice amount and creates new
line item for incoming amount.

20) What is internal and external number ranges?

Ans: Internal Number Ranges: Doc. No will be provided by the system automatically in serial order allotting the next available progressive number. The number must be in numerical.
External Number ranges: Doc. No will be given manually by the end user. System will not lock no automatically in this case. User can pick the number randomly. Number may be an alpha numeric.

FI/CO Interview Questions

2007-12-14T16:37:00.000-08:00

What is APC?

APC stands for Acquisition and Production costs. Acquisition means any asset which you may acquire/ purchase externally. It includes invoice price and other related exp. Associated with it like customs, octroi, freight which you add and arrive at total cost of acquisition for capitalisation of the asset.For ex Say a computer. The total cost which you incurr for the acquisition of the computer including installation will be your APC

Production cost means any asset which is created internally within the organisation. This is normally created by means of AUC and you go on adding cost to the AUC as and when you incurr exp. for the same.For ex. say addition to the office building. Therefore APC incudes any external acquisition or internal construction of exp. which needs to be capitalised.

In OADB under 01 deprn area Acquisition & prod Cost tick is activated.

This is umapathy, I have intereview tomorrow, if anybody have taken interview with any company, kindly let me know what the questions they will be asking, how will be the interview. How the questions will be on configuration, implementation side and other questions plz.. share with me.

Pl. prepare yourself on the following broad lines:

Implementation exp.:

Brief about the project you did: w.r.t. the main activity of the client, How many plants they had, What modules were implemented, Who were the implementers, What’s the implementation team size, How many were in your module team, What’s your role in the project with respect to the activities you partook in the project, The Enterprise Structure with regard to the no. of Company Codes, any Business Areas or Profit Centers defined, Cost Centers defined, What’s the period of the project, When did they Go-Live?, Any issues you’d solved during ‘Support’ phase?

Questions on conceptual understanding:

a) SAP R/3 definition and 3-Tier Architecture

b) ‘Real time integration’ advantage of SAP

c) ASAP methodology

d) Solution Manager

e) Client / Company / Company Code / Business Area

f) Business Area vs Profit Center Approach

g) How effective will be the Financial Statements generated through Business Areas

h) With Holding Taxes vs Extended WHT

i) Field Status Concepts (G/L master fields controlled through Account Group and Document
entry through Field Status Group set in the G/L master)

j) Special G/L transactions

k) Open item management

l) Reconciliation Accounts

m) Subsidiary Ledgers

n) Sort key

o) Negative Postings Allowed

p) Special periods

q) Only balances in local currency

r) Important Posting keys for G/L, A/R, A/P, AA, Stock Entries

s) Assessment vs Distribution

t) Org. Structure for FI

u) Org. Structure for CO

v) Product Costing: How the values flow in the system

Configuration:

a) Extended With Holding Taxes configuration steps – right from creation of WH Tax Types, Codes to Annual Return

b) FI-MM Integration (OBYC configuration with particular reference to Off-Setting entries)

c) FI-SD integration

d) Down Payments transactions

e) Interest – Balances / Arrears

f) Asset Accounting: Asset Class, Main Asset, Sub-Asset, Group Asset, Dep. Areas, Dep. Key,

Transaction No.s (100- External acquisition, 210 – Retirement with Revenue, etc.), Imp.

Transaction Codes.

General questions:

a) Educational Background

b) What influenced you to go in for SAP career?

c) Functional Career

d) Present earnings vs Expected pay

e) Inclination to relocate

FI/CO Interview Questions

What is APC?

In OADB under 01 deprn area Acquisition & prod Cost tick is activated.

Pl. prepare yourself on the following broad lines:

Implementation exp.:
Brief about the project you did: w.r.t. the main activity of the client, How many plants they had, What modules were implemented, Who were the implementers, What’s the implementation team size, How many were in your module team, What’s your role in the project with respect to the activities you partook in the project, The Enterprise Structure with regard to the no. of Company Codes, any Business Areas or Profit Centers defined, Cost Centers defined, What’s the period of the project, When did they Go-Live?, Any issues you’d solved during ‘Support’ phase?

Questions on conceptual understanding:
a) SAP R/3 definition and 3-Tier Architecture
b) ‘Real time integration’ advantage of SAP
c) ASAP methodology
d) Solution Manager
e) Client / Company / Company Code / Business Area
f) Business Area vs Profit Center Approach
g) How effective will be the Financial Statements generated through Business Areas
h) With Holding Taxes vs Extended WHT
i) Field Status Concepts (G/L master fields controlled through Account Group and Document entry through Field Status Group set in the G/L master)
j) Special G/L transactions
k) Open item management
l) Reconciliation Accounts
m) Subsidiary Ledgers
n) Sort key
o) Negative Postings Allowed
p) Special periods
q) Only balances in local currency
r) Important Posting keys for G/L, A/R, A/P, AA, Stock Entries
s) Assessment vs Distribution
t) Org. Structure for FI
u) Org. Structure for CO
v) Product Costing: How the values flow in the system

Configuration:
a) Extended With Holding Taxes configuration steps – right from creation of WH Tax Types, Codes to Annual Return
b) FI-MM Integration (OBYC configuration with particular reference to Off-Setting entries)
c) FI-SD integration
d) Down Payments transactions
e) Interest – Balances / Arrears
f) Asset Accounting: Asset Class, Main Asset, Sub-Asset, Group Asset, Dep. Areas, Dep. Key, Transaction No.s (100- External acquisition, 210 – Retirement with Revenue, etc.), Imp. Transaction Codes.

General questions:
a) Educational Background
b) What influenced you to go in for SAP career?
c) Functional Career
d) Present earnings vs Expected pay
e) Inclination to relocate

What are some of the integration points of the FI module?

2007-12-14T16:36:00.000-08:00

SAP is marketed as a fully integrated system, therefore knowing some of the integration points enables the Users to better understand the Modules.

· Organization units are not only defined in FI(Financial Accounting) but also in other SAP Modules. The SD( Sales & Distribution) Module requires the set-up of Sales Organizations, Distribution Channels and Divisions ; Purchasing requires purchasing organizations, plants, and storage locations; and CO (Controlling) requires a Controlling area to be defined.

· To transfer data between FI(Financial Accounting) and CO (controlling) as well as other modules, a Company Code must be assigned to each of the Modules.

· Business Areas must be entered when generating business transactions if you would like visibility of those transactions impacting a certain BA(Business Area). You can also update your Master Records to include BA(Business Area) for example Cost Center.

· Document postings are automatically posted in the year and periods that you created in the Fiscal Year variant set-ups based on the month, start and end dates to which postings are allowed within a given period as defined.

· There are several integration points in SAP, the above lists a few .

Integration of FICO with Other Modules

2007-12-14T16:35:00.001-08:00

Integration of FICO with Other Modules

What are the steps for integration of FICO with other modules SD, MM etc. ?

Some basic information :

FI-MM: The integration between FI-MM happens in T-code OBYC.

1. When PO is created :

---- No Entry -----

2. When GR is posted

Inventory Account dr (Transaction Key BSX in OBYC)
To GRIR account (T.Key WRX in T-code OBYC)

3. When Invoice is posted

GRIR account Dr.
Vendor account Cr.

4. Payment made to Vendor

Vendor A/c Dr
To Bank Clearing A/c Cr.

Points to know : Movement Types, Assignment of Movement types to T-keys (T-code OMJJ), Value string (I also need some information on this) , OMWN and OMWB transactions.

---

There is a close integration b/w FI & MM, actually document flows from MM to FI in the following areas such as,

1. Movement Types:

Used to enable the system to find the predefined posting rules determining how the accounts of financial accounting system are to be posted & to update the stock fields in the matrl master data.(Goods Receipt, Goods Issue, etc)

2. Valuation Class:

Assignment of material to grp of gl account, used to determine the gl accounts that are updated as a result of goods movement.

3. Transaction/Event key:

Used to control the storage or filing of documents & assignment of documents.Used to differeniate b/w various transactions such as goods movement tht occur in inventory.

4. Material Type:

Each material should assign mtrl type in mtrl master record used to update whether changes made in qty are updated in material master record & change in value also updated in stock account.

FI-SD Integration: The integration is done in T-code VKOA

1. Sales Order Created

---No Entry---

2. PGI done (Goods issue)

Cost of Goods Sold Dr (Configured in OBYC GBB T-Key)
To Inventory Account

3. Billing document released to Accounting

Customer Account Dr.
To Sales Revenue Account (ERL T-key in Pricing procedure)

Note : The GL account is assigned to this ERL in VKOA

4. Payment Received

Bank Clearing A/c Dr
Customer A/c Cr.

Points to Know : Good to understand the pricing procedure and how the different transaction keys are used like ERL, ERS etc

Information on FI-CA (Financials and Contract Accounts)

2007-12-14T16:33:00.000-08:00

The term FI-CA stands for “Contract accounts receivable and payable.“ FI-CA contains the range of functions needed by different industries or projects for their accounts receivable and payable management. Currently, these industries include public sector, utilities and telecommunications companies.

The common factor among these companies is a multitude of customers, which means even more open items. The number of customers in each system may go into the millions, and the number of open items several times that.

Such volumes of data can be processed by FI-CA because the memory space required for storing open and cleared items was reduced and critical activities such as posting, paying, dunning and returns processing were accelerated.

The FI-CA documents provide for the current account assignments from the following application components:

The general ledger. Here it is the company code, business area, G/L account.
The overhead costs Controlling and the Profitability Analysis (CO-PA). Here it is cost center, order, project, Profit Center, profitability segment.

The documents update FI-CA posting totals which are subdivided according to the account assignments named above. However, because the FI-CA documents often only differ from each other with regard to amount, business partner and contract account, a large summarization effect arises in the FI-CA posting totals. So experience from IS-U shows that several hundred thousand FI-CA document items meet on a few hundred totals records.

The FI-CA posting totals form the basis for generating G/L documents, via which not only the general ledger, but also, by transferring the corresponding Controlling account assignments, the different areas of Controlling are updated.
In addition to the account assignment characteristics of G/L accounting and Controlling, the FI-CA posting totals can be grouped according to a freely definable reconciliation key.

This reconciliation key is stored:

• in the FI-CA document header
• in the FI-CA posting totals
• in the document header of the general ledger document as external reference

This makes it possible to understand from which FI-CA documents a general ledger transfer document has been formed. This is a way in which, for instance, a reconciliation between contract accounts receivable and payable and the general ledger for a complete payment run, billing run or a given pile of FI-CA documents can be executed.

The FI-CA documents provide for the current account assignments from the following application components:

• The general ledger. Here it is the company code, business area, G/L account.
• The overhead costs Controlling and the Profitability Analysis (CO-PA). Here it is cost center, order, project, Profit Center, profitability segment.

Integration

This reconciliation key is stored:

• in the FI-CA document header
• in the FI-CA posting totals
• in the document header of the general ledger document as external reference

It is thus in a way a subledger of FICO. FI-CA, though not a complete subledger accounting system, it is always a component of an industry solution or a project solution.

FI-CA is first and foremost a component of the following industry solutions:

• Utilities (IS-U)
• Insurance (IS-IS/PP)
• Public sector (IS-PS)
• Tele communication (IS-T)

FI-CA mainly covers the functionality of those areas in which at least two of the industries reveal the same type of requirements. Individual requirements from exactly one industry are to be achieved as an industry solution on the basis of the FI-CA.

Financial Accounting

2007-12-14T16:31:00.000-08:00

BVOR	Inter Company Posting Procedure	BVORG / BUKRS / GJAHR / BELNR
EBKPF	Accounting Document Header (docs from External Systems)	GLSBK / BELNR / GJHAR / GLEBK

FRUN	Run Date of a Program	PRGID
KLPA	Customer / Vendor Linking	NKULI / NBUKR / NKOAR / PNTYP / VKULI / VBUKR / VKOAR
KNB4	Customer Payment History	KUNNR / BUKRS
KNB5	Customer Master Dunning Data	KUNNR / BUKRS / MABER
KNBK	Customer Master Bank Details	KUNNR / BANKS / BANKL / BANKN
KNC1	Customer Master Transaction Figures	KUNNR / BUKRS / GJHAR
KNC3	Customer Master Special GL Transactions Figures	KUNNR / BUKRS / GJAHR / SHBKZ
LFB5	Vendor Master Dunning Data	LIFNR / BUKRS / MABER
LFBK	Vendor Master Bank Details	LIFNR / BANKS / BANKL / BANKN
LFC1	Vendor Master Transaction Figures	LIFNR / BUKRS / GJHAR
LFC3	Vendor Master Special GL Transactions Figures	LIFNR / BUKRS / GJHAR / SHBKZ
VBKPF	Document Header for Document Parking	AUSBK / BUKRS / BELNR / GJHAR

FBASCORE	Financial Accounting General Services “Basis”
KNB1	Customer Master (Company Code)	KUNNR / BUKRS
LFA1	Vendor Master (General Section)	LIFNR
LFB1	Vendor Master (company Code Section)	LIFNR / BUKRS
SKA1	G/L Account Master (Chart of Accounts)	KTOPL / SAKNR
SKAT	G/L Account Master (Chart of Accounts – Description)	SPRAS / KTOPL / SAKNR
MAHNS	Accounts Blocked by Dunning Selection	KOART / BUKRS / KONKO / MABER
MHNK	Dunning Data (Account Entries)	LAUFD / LAUFI / KOART / BUKRS / KUNNR / LIFNR / CPDKY / SKNRZE / SMABER / SMAHSK / BUSAB


FI-GL-GL (FBS)	General Ledger Accounting: Basic Functions- G/L Accounts

SKAS	G/L Account Master (Chart of Accounts Key Word list)			SPRAS/KTOPL/SAKNR/SCHLW
SKB1	G/L Account Master (Company Code)			BUKRS / SAKNR
FI-GL-GL (FBSC)	General Ledger Accounting: Basic Functions - R/3 Customizing for G/L Accounts
FIGLREP	Settings for G/L Posting Reports			MANDT
TSAKR	Create G/L account with reference			BUKRS / SAKNR
FI-GL-GL(FFE)	General Ledger Accounting: Basic Functions - Fast Data Entry
KOMU	Account Assignment Templates for G/L Account items			KMNAM / KMZEI

FI-AR-AR(FBD)	Accounts Receivable: Basic Functions - Customers
KNKA	Customer Master Credit Management: Central Data			KUNNR
KNKK	Customer Master Credit Management: Control Area Data			KUNNR / KKBER
KNKKF1	Credit Management: FI Status data			LOGSYS / KUNNR / KKBER / REGUL
RFRR	Accounting Data – A/R and A/P Information System			RELID / SRTFD / SRTF2

FI-BL-PT	Bank Accounting: Payment (BFIBL_CHECK_D) Transactions – General Sections
PAYR	Payment Medium File		ZBUKR/HBKID/HKTID /RZAWE /CHECT
PCEC	Pre-numbered Check		ZBUKR / HBKID / HKTID / STAPL

FI-BL-PT-AP (FMZA)	Bank Accounting: Payment Transactions – Automatic Payments
F111G	Global Settings for Payment Program for Payment Requests				MANDT
FDZA	Cash Management Line Items in Payment Requests				KEYNO
PAYRQ	Payment Requests				KEYNO

What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?

As far as general ledger master data is concerned, the following tables are involved :

Table name : SKB1 : G/L Account Master ( Company Code)

Fields:

BUKRS : Company Code
SAKNR : G/L Account

Table name : SKA1 : G/L Account Master ( Chart of Accounts )

Fields:

KTOPL : Char of Accounts
SAKNR : G/L Account

Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )

Fields:

SPRAS : Language
KTOPL : Char of Accounts
SAKNR : G/L Account

Important Tables in SAP CO

2007-12-14T16:30:00.000-08:00

CO-KBASCORE          Overhead Cost Controlling: General Services

CSKA                 Cost Elements (Data Dependent on  MANDT / KTOPL / KSTAR
CSKB                 Cost Elements (Data Dependent on  MANDT / KOKRS / KSTAR / DATBI
CSKS                 Cost Center Master Data           MANDT / KOKRS / KOSTL / DATBI
CSLA                 Activity Master                   MANDT / KOKRS / LSTAR / DATBI




CO-OM (KACC)         Overhead Cost Controlling

COBK                 CO Object: Document Header        MANDT / KOKRS / BELNR
COEJ                 CO Object: Line Items (by Fiscal  MANDT / KOKRS / BELNR / BUZEI
COEJL                CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEJR                CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEJT                CO Object: Line Items for Prices  MANDT / KOKRS / BELNR / BUZEI
COEP                 CO Object: Line Items (by Period) MANDT / KOKRS / BELNR / BUZEI
COEPL                CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEPR                CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEPT                CO Object: Line Items for Prices  MANDT / KOKRS / BELNR / BUZEI
COKA                 CO Object: Control Data for Cost  MANDT / OBJNR / GJAHR / KSTAR
COKL                 CO Object: Control Data for Activ MANDT / LEDNR / OBJNR / GJAHR
COKP                 CO Object: Control Data for Prima MANDT / LEDNR / OBJNR / GJAHR
COKR                 CO Object: Control Data for Stati MANDT / LEDNR / OBJNR / GJAHR
COKS                 CO Object: Control Data for Secon MANDT / LEDNR / OBJNR / GJAHR



CO-OM-CEL (KKAL)     Cost Element Accounting (Reconciliation Ledger)

COFI01               Object Table for Reconciliation L MANDT / OBJNR
COFI02               Transaction Dependent Fields for  MANDT / OBJNR
COFIP                Single Plan Items for Reconciliat RCLNT / GL_SIRID
COFIS                Actual Line Items for Reconciliat RCLNT / GL_SIRID



CO-OM-CCA            Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S

A138                 Price per Company Code            MANDT / KAPPL / KSCHL / KOKRS
A139                 Price per Profit Center           MANDT / KAPPL / KSCHL / KOKRS



CO-OM-OPA (KABR)     Overhead Orders: Application Development R/3 Cost Accounting Settlement

AUAA                 Settlement Document: Receiver Seg MANDT / BELNR / LFDNR
AUAB                 Settlement Document: Distribution MANDT / BELNR / BUREG / LFDNR
AUAI                 Settlement Rules per Depreciation MANDT / BELNR / LFDNR / AFABE
AUAK                 Document Header for Settlement    MANDT / BELNR
AUAO                 Document Segment: CO Objects to b MANDT / BELNR / LFDNR
AUAV                 Document Segment: Transactions    MANDT / BELNR / LFDNR
COBRA                Settlement Rule for Order Settlem MANDT / OBJNR
COBRB                Distribution Rules Settlement Rul MANDT / OBJNR / BUREG / LFDNR



CO-OM-OPA (KAUF)     Overhead Orders: Cost Accounting Orders

AUFK                 Order Master Data                 MANDT / AUFNR
AUFLAY0              Enttity Table: Order Layouts      MANDT / LAYOUT



EC-PCA (KE1)         Profit Center Accounting

CEPC                 Profit Center Master Data Table   MANDT / PRCTR / DATBI / KOKRS
CEPCT                Texts for Profit Center Master Da MANDT / SPRAS / PRCTR / DATBI
CEPC_BUKRS           Assignment of Profit Center to a  MANDT / KOKRS / PRCTR / BUKRS
GLPCA                EC-PCA: Actual Line Items         RCLNT / GL_SIRID
GLPCC                EC-PCA: Transaction Attributes    MANDT / OBJNR
GLPCO                EC-PCA: Object Table for Account  MANDT / OBJNR
GLPCP                EC-PCA: Plan Line Items           RCLNT / GL_SIRID



EC-PCA BS (KE1C)     PCA Basic Settings: Customizing for Profit Center Accounting

A141                 Dependent on Material and Receive MANDT / KAPPL / KSCHL / KOKRS
A142                 Dependent on Material             MANDT / KAPPL / KSCHL / WERKS
A143                 Dependent on Material Group       MANDT / KAPPL / KSCHL / WERKS

SAP FI Functional Consultant Responsibilities

2007-12-14T16:28:00.002-08:00

What is the meaning of SAP FICO Functional and SAP FICO Technical?

SAP FICO Functional means functional knowledge, by which one can proceed in terms of functional process with FICO area as well as FICO configuration knowledge.

Whereas SAP FICO Technical consultant may be an ABAPER, who have short of knowledge of FICO configuration and functional knowledge as well and can proceed for technical jobs e.g. reports development, client requirement, system modification etc.

To become a Pure Hard Core FI functional consultant

Q: Can via T.Code FBL1N by selecting vendor with plant reference in selection using search help field group.

Plant is not a field for finance or in sap it is FI module - this is for PP and MM module, In case required, please define that as FI object for FI reports - like BA and so on. Configure the plant as a BA and in all FI places you can capture BA in line items of vendors.

Spent little time on going through various standard reports of SAP which are very rich in itself - for each report it has options of all fields of master data , all fields of FI document means around in my opinion around 400+ options to select. Hence we should first get an idea of fields in masters and documents and how they are updated.

To become a good consultant.... Every report of SAP standard is a gem - but we always look for FAST FOOD without understanding the quality of how standard is the solutions..

Spent time in understanding - there are lot of chapters available for reading . Suggestions ... Understand the Finance function first upto closing of books and management reportings done in a practical way. Go to sap img screen - you will find all options are there... If you go reverse way , sitting inside the car and asking - anyone can help me in understanding what is the wheel in front of driver used and how to use it??

All the best - take it in the right spirit for a successful future

2007-12-14T16:28:00.001-08:00

I have created Company Code and all other configuration related to the CCode. Also in MM I have created purchase order, created vendor, material etc. I couldn't activate the PO due to the following error messages in red:

1. MAINTAIN TOLERANCE LIMITS FOR TOLERANCE KEY PE ACCOUNT ASSIGNMENT
2. CONTROL INDICATORS FOR CONTROLLING AREA DO NOT EXIST.

I have assigned controlling area to company code and I could see the controlling area in existance via master file and gl verification.

1. MAINTAIN TOLERANCE LIMITS FOR TOLERANCE KEY PE ACCOUNT ASSIGNMENT ----> Please follow this link --> SPRO ---> MM---> Purchasing --> Purchase Order --> Set Tolerance limits for price variance --> Here you have to set for Tolerance keys PE and SE. Just copy them from std co. code.

2. CONTROL INDICATORS FOR CONTROLLING AREA DO NOT EXIST. ---->

In Controlling --> General Controlling --> Maintain Controlling Area --> Maintain Controlling Area --> Activate Components/Control Indicators --> You need to check if you want to activate the order management/activity based costing/commitment management etc.

2007-12-14T16:27:00.003-08:00

How many financial statement versions can be assigned to co.code?

Answer: As many FSVs as you want can be assigned to the co code i.e. 1:n as of Co Code: FSV.

2007-12-14T16:27:00.001-08:00

5 How many chart of accounts can be assigned to company code we can assign company code to chart of account through OB62? Now my question is in what way we can assign three types of chart of account to company code in one transaction code (I might be wrong plz correct me)

Answer: Three, although the group and country chart of accounts are optional. The group chart of accounts is assigned to the operational chart of accounts, and the only mandatory CoA is the Operational CoA.

2007-12-14T16:26:00.002-08:00

Suppose in 2004 I have depreciation key 'AB&in 2005 depreciation key I have changed to"CD". In what way my balances would be affected like balances of depreciation,accumulated depreciation,assets etc.

Answer: The difference in the depreciation that is posted already, and what should be posted with historical effect will be posted in the current accounting period.

2007-12-14T16:26:00.001-08:00

We always copy company code or we can create manually also? If possible give reasons also.

Answer: There are loads of tables that get copied over when copying co codes. This might be incomplete in a manual copy, and hence the manual route is not advisable.

2007-12-14T16:25:00.002-08:00

Suppose I have purchased goods of 10 units(raw materials or semi-finished goods) worth Rs10000 from vendor A (suppose) and also made payment for the same. Now during the manufacturing process, it was observed that 3 units are defective, now my question is how do we deal with the defective units in SAP as I have already made payment for the 10 units(i.e Rs10000).

Answer: If you have a GRN against these materials, then the same can be return delivered. An appropriate movement type needs to be configured for the same. As for the payment, raise a credit note on the vendor.

* Using Debit Memo you can get the money for defective 3 units.

2007-12-14T16:25:00.001-08:00

What are adjustment postings and its use? Give t.codes and paths if possible?

Answer: fb50,f-02 and others could be used for adjustments. These adjustments are to correct any financial representation that has already been booked into the accounts.

FI Errors and Probable Solutions

2007-12-14T16:23:00.000-08:00

These are some of the issue for which probable solutions are given, hope they are helpful :

Scenario 1:

I have configured FBZP, Fi12 for house bank. But when I am doing payment run in F110 I am getting following error:

Company codes X1YZ/X1YZ do not appear in proposal 05/03/2006 REMI2.

Diagnosis
No data exists for the specified paying company code X1YZ and the specified sending company code X1YZ in payment proposal 05/03/2006 REMI2.

System response
The payment proposal cannot be edited.

Procedure
Check the flow trace and payment proposal list in order to determine why the specified company codes are not contained in the proposal

Solution :

* That’s generic error for payment run, check whether there are any due items as on date (tcode fbl1n). You can also change the baseline date there and rerun it. if you still get same error.. Check the proposal log, you will find the reason.

* Try to see first whether any open items exist. By using FBL1N.

Scenario 2:

How to make the payment through automatic payment program, through F-110 .What are the prerequisites?

Solution :

For Down payments to be paid using APP we have create a Down Payment request F-47.

Scenario 3:

While doing APP, after, " the payment proposal has been created message " if edit proposal is selected, I am getting the error as "Company code ABC/ABC do no appear in the proposal "

Solution :

This type of error comes when your Payment proposal doesn't have any items to process. Check the parameters and ensure invoices are due as on run date.

Scenario 4 :

While posting customer invoice (FB70) why system asks for G/L account? As per accounting rules customer is debited and Customer reconciliation a/c is credited that ends double entry book keeping rule. Why one more G/L account on top of Recon a/c, which is posted automatically?

Solution :

* Entry gets posted to Customer a/c through reconciliation account. You have to give a GL a/c for revenue.

Your entry would be
Customer (Reconciliation a/c) Dr
To Revenue Cr

* Reconciliation is a fictious entry so you cannot consider as an entry to be entered by the user. This rule is derived from the fact that 'we cannot enter/post directly to RECON account'.

That is why system needs a GL account to make the account balance as zero. Manual entry could be:

Customer a/c Dr
To Domestic Sales a/c
(Sales invoiced posted)

Recon entry is automatically made once you post this entry since you have configured your RECON in the IMG.

Scenario 5 :

I am unable to figure out how to attach my GL Accounts to my company code [copied chart of accounts, have my own company code, assigned my company code to the chart of accounts].

Solution :

You can attach the GL Accounts by just filling the details in the company code segment of the GL A/c. Hence you can use that gl a/c for your co code.
But that would be individually creating the accounts. Right?? How about creating all accounts at one shot. Create in FS00

Scenario 6 :

Difference between Standard Hierarchy and Alternate Hierarchy.

Solution :
Standard Hierarchy is basic structure of company but alternative hierarchy is just for reporting or temporary usage.

Scenario 7:

I have created depreciation keys (diminishing balance) and assigned to asset classes respectively. But at the time of asset master creation the system ask for Useful Life of the asset while my understanding is that in diminishing balance method there is useful life, just percentage is defined.

Solution :

Useful life is required for depreciation change. Normally a company with WDV depreciation may want to write off its assets which have crossed their useful life in 2 or 3 installments. This is achieved by depreciation change, where after useful life, a new method takes over.

Scenario 8 :

I have some conceptual problem in Internal Order.

Solution :

Internal order can only take a statistical posting & cost centre shall take a true posting when the relevant internal order is defined as statistical I/O IN T. code KO01(CONTROL DATA ) tab. So while making a posting in FB50 and assigning both I/O & COST CENTRE as relevant cost object in the transaction you shall get the stated status of these 2 cost object.

Scenario 9 :

In fb50, in the details tab, only if I tick 'calculate tax' will the tax get calculated.
Our user wants this to happen always (by default), i.e. he does not want to tick this for each transaction. Is there any setup to be done for the tax to get calculated always?

Solution :

Even now you are not clear. T_Code FB50 is used for posting GL account only. I fail to understand how you can calculate tax which is generally from purchase / vendor or Sales / Customer oriented through FB50.

In case of local distribution, if we forget to pay taxes on certain items and we need to pass tax entries, then such a case is needed. This can be achieved thru default parameter id for that particular user through transaction code SU3.

In SU3, in Parameters Tab put "XTX" in Parameter ID column and in Parameter Value column put "X".

Scenario 10 :

We have an issue here where by the system is calculating the tax for an invoice with a wrong tax base amount. How do i change the tax base amount? I get the tax rates from VERTEX and they are showing right. Where does the system pull this tax base amount for an Invoice and how can I change it.

Solution :

Kindly check this:

spro - financial accounting - f.a global setting - with holding setting - extended with holding setting -- calculation -- with holding tax type .

Check your withholding tax type, go in it and check the setting.

Banking Transaction Financial Accounting Entries

2007-12-14T16:22:00.000-08:00

Direct Debit In Bank

26) Direct debit instructions will be given to the bank for example, LC payments or certain bank charges are directly debited in the Bank Statement. In this case accounting entry is passed only after the entry is passed in the bank statement.

Vendor / Expense Account Debit

Bank clearing account Credit

Direct Credit In Bank

27) Customer receipts are sometimes directly credited in Bank. E.g. export receipts. In this scenario accounting entry is passed only at the time of bank statement entry. The following accounting entry is passed

Bank clearing account Debit
Customer account Credit

Main Bank A/c Debit

Bank Clearing A/c Credit

MTO - Make to Order

2007-12-14T16:21:00.002-08:00

Make-to-order production with capacity checking enables vendors to trigger production of a requested product as soon as a sales order reaches the system. An automatic process checks machine capacity, schedules production, and determines the requested product’s availability date.

This enables vendors to make immediate, reliable offers and commitments to their customers for the requested quantities and delivery dates. While particularly well-suited to high-tech manufacturers and makers of industrial machinery and equipment, this method also addresses the requirements of other make-to-order manufacturers.

MTS - Make to Stock

Make-to-stock production is designed for manufacturers that usually operate on the make-to-order model – configuring their finished goods after sales order entry – but that nevertheless manufacture the components of the finished goods in a make-to-stock process.

The SAP best practice definition describes how manufacturers can accurately predict the future demand for components, communicate with suppliers of critical parts, and plan the production and distribution of finished goods, all based on actual material and capacity restrictions.

Banking Transaction Financial Accounting Entries

2007-12-14T16:21:00.001-08:00

Bank Fixed Deposits

28) HZL has a practice of converting any amount above Rs. 1 crore in its Main bank account, to a fixed deposit subject to a minimum of Rs. 1.01 crores. The FDR number can be filled in one of the fields available in the accounting document.

Cheque Management / Cheque Printing Cum Advice

29) The function of cheque management will enable printing of cheque through SAP. Cheque series will be defined for a combination of a Company code and Bank Account. Cheque numbering will be sequential order.

30) Cheque series for automatic payment has to be in sequential order. Cheque printing facility will be available for the bank account.

Cash Management / Liquidity Analysis

31) The day-to-day treasury process in a company includes a number of transactions. This includes determining the current liquidity using bank account balances (cash position), determining open receivables and liabilities (liquidity forecast), manually entering planned cash flows (payment advice notes), through to clearing bank accounts, that is, collecting multiple bank account balances on one target account.

32) The main objective is to ensure liquidity for all due payment obligations. It is also important to control and monitor effectively the incoming and outgoing cash flows.

33) This section shows you the overall liquidity status of your company by displaying together the cash position and the liquidity forecast. The cash position is used in Cash Management to show the value-date-dependent bank accounts and bank clearing accounts, as well as the planned cash flows (payment advice notes). The liquidity forecast comprises the incoming and outgoing cash flows, as well as the planned items on the sub-ledger accounts.

Primary configuration considerations:

2007-12-14T16:19:00.000-08:00

Client, company and company code

Once a business has decided to use the SAP FI(Financial Accounting) Module, there are several Configurations prerequisite steps that must be completed.Determining the organizational structure is one of the first steps in setting up the business functions in SAP as well as your reporting requirements.

The Organizational structure is created by defining the organizational units consisting of the following:

Client

Company

Company Code

Business Area

A Client is the highest unit within an SAP system and contains Master records and Tables. Data entered at this level are valid for all company code data and organizational structures allowing for data consistency. User access and authorizations are assigned to each client created. Users must specify which client they are working in at the point of logon to the SAP system.

A Company is the unit to which your financial statements are created and can have one to many company codes assigned to it. A company is equivalent to your legal business organization. Consolidated financial statements are based on the company’s financial statements. Companies are defined in configuration and assigned to company codes. Each company code must use the same COA( Chart of Accounts) and Fiscal Year. Also note that local currency for the company can be different.

Company Codes are the smallest unit within your organizational structure and is used for internal and external reporting purposes. Company Codes are not optional within SAP and are required to be defined. Financial transactions are viewed at the company code level. Company Codes can be created for any business organization whether national or international.

It is recommended that once a Company Code has been defined in Configuration with all the required settings then other company codes later created should be copied from the existing company code.

You can then make changes as needed. This reduces repetitive input of information that does not change from company code to company code as well as eliminate the possibility of missed data input.

When defining company codes, the following key areas must be updated:

Company Code Key- identifies the company code and consists of four alpha-numeric characters. Master data and business transactions are created by this key.

Company Code Name- identifies the name of the business organization within your organizational structure.

Address- identifies the street address, city, state, zip code for the company code created. This information is also used on correspondence and reports.

Country- identifies the country to which your business is based. Country codes within SAP are based on ISO Standards.

Country currency- identifies the local currency for the company code that you have defined.

Language- identifies the language to be used for you company code and is also used for text in your documents. SAP unlike other applications, offers over thirty languages including EN( English) , ES (Spanish), FR (French), DE (German), EL (Greek), IT(Italian), AR( Arabic), ZH (Chinese) , SV (Swedish) , and JA (Japanese) to name a few.

Comparison of FI and FI-CA

2007-12-14T16:18:00.000-08:00

FI-CA: The business partner is not confined to a role on the debit side or on the credit side. This role can change in the course of time. For example: with a supplementary pension public sector there is the contribution phase and the pension payment phase.

FI: A business partner is created as a customer or vendor, which fixes its role and the functionality available with it at the outset.

FI-CA: The contract account does not automatically exist in a one-to-one relationship with a business partner and several other partners are also permitted for one account.

FI: It is only possible to have several accounts for a business partner with separate account agreements, by creating parallel customer and vendor master records.
There is no possibility of keeping one account for several business partners. A common view to the accounts of several partners is only supported in subareas (e.g. via the worklists).

FI-CA: The document of the contract accounts payable and receivable represents an all but complete business transaction relevant to accounts. It is not necessary to generate several documents if different company codes or posting data are addressed in this business transaction.
The document does not directly serve to reconcile the G/L account transaction figures.

FI: The FI document only reflects one segment of a business transaction which affects a company code and a posting date. The FI documents give a direct explanation of the general ledger transaction figures.

The Financial Statement Closing Tcodes

2007-12-14T16:17:00.001-08:00

1. Maintain Financial Statement Versions

IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Documenting -> Define Financial Statement Versions - OB58

2. Execute a Balance Sheet (RFBILA00)

Information Systems -> Accounting -> Financial Accounting -> General ledger -> Information System-> Balance Sheet

Accounting -> Financial accounting -> General ledger -> Information system -> General LedgerReports -> Balance Sheet/Profit and Loss Statement/Cash Flow -> General -> Actual/Actual Comparisons -> Balance Sheet/P+L - F.01

3. Execute a Balance Sheet Drill Down Report

Accounting -> Financial accounting -> General ledger -> Information system -> General LedgerReports -> Balance Sheet/Profit and Loss Statement/Cash Flow -> General - Various

4. Execute a Cost-of-Sales Profit and Loss Report

Accounting -> Financial accounting -> Special Purpose Ledger -> Tools -> Report Painter -> Report -> Display -> Library 0F1, Report 0F-GUV1 -> Display -> Execute - GRR3

Banking Transaction Financial Accounting Entries

2007-12-14T16:15:00.000-08:00

Cheque Received From Customer

20) Accounting entry at the time of cheque deposit entry

Bank Cheque deposit account Debit
Customer Credit

21) Accounting entry after cheque has been cleared in the Bank statement Main Bank account
Debit Bank

Cheque deposit account Credit

22) The clearing criteria for updating the bank main account and bank sub account will be amount and document number which will be captured in the allocation field of the bank sub account. The items, which have not been cleared in the bank statement, will remain open in the bank sub account and will form part of the bank reconciliation statement.

Cheque Issued To Vendors

23) Accounting entry at the time of cheque issue

Vendor account Debit
Bank cheque payment account Credit

24) Accounting entry after cheque has been presented in the Bank

Bank cheque payment account Debit
Main Bank account Credit

25) The clearing criteria used for updating vendor account and Bank cheque payment account will be amount and cheque number. The cheques presented to the bank and are cleared are transferred to the bank main account. The remaining cheque issued will form part of the bank reconciliation statement.

Banking Transaction Financial Accounting Entries

2007-12-14T16:14:00.000-08:00

Bank Fixed Deposits

Cheque Management / Cheque Printing Cum Advice

30) Cheque series for automatic payment has to be in sequential order. Cheque printing facility will be available for the bank account.

Cash Management / Liquidity Analysis

32) The main objective is to ensure liquidity for all due payment obligations. It is also important to control and monitor effectively the incoming and outgoing cash flows.

SAP FI/CO Sample Questions and Answers

2007-12-14T16:13:00.001-08:00

1. About evolution in the world of business, we can affirmate that (Please choose the correct sentence):

a) [ ] The internet revolution could turn available to companies the use of ERP functionality.
b) [ ] The next generation of Â“new dimensionÂ” products appeared taking functionality out of the company, to bring value through extending the Internet Revolution.
c) [ ] The internet has driven to a collaborative environment where value is created through collaboration within business comunities.
d) [ ] In the first the companies were looking at Cost reduction and efficiency through integration of business comunities.

2. About the definition of ERP and e-business functionalities, we can say that (Note: we can have more than one correct sentence. Please select the sentences you think they are correct):

a) [ ] ERP offers enterprise centric functionality (general ledger, payroll, order entry) to integrate core, internal processes.
b) [ ] ERP is mySAP Financials and mySAP HR.
c) [ ] ERP is SAP R/3, while e-business is mySAP.com.
d) [ ] About Business Model, ERP can be considered as enterprise centric and e-business, as extended and collaborative.
e) [ ] About Architecture, ERP can be considered as an integrated system and e-business, as an integrated system and an open integration platform.
f) [ ] About Processes, ERP can have them integrated, core within enterprises and collaborative, beyond company boundaries.

3. What is a SAP Business Object (Please choose the correct sentence)?

a) [ ] It is all the transaction data generated via transactions.
b) [ ] It is the instancied class of the Class Builder.
c) [ ] It is composed of tables that are related in a business context, including the related appplication programs and it is maintained in the Class Repository.
d) [ ] It is the representation of a central business object in the real world, such as an employee, sales order, purchase requisition, invoice and so on.
e) [ ] It is a sequence of dialog steps that are consistent in a business context and that belong together logically.

4. About BAPI (Business Application Programming Interface), what is true (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] It is a well-defined interface providing access to processes and data of business application systems.
b) [ ] BAPIs offer a stable, standardized interface for integrating third-party applications and components in the Business Framework.
c) [ ] A BAPI is assigned to one and only one business object.
d) [ ] In the R/3 Enterprise version (4.7) we can use BAPI to create an internal order inside a customized ABAP program.
e) [ ] A business object in the Business Object Repository (BOR) can have many methods from which one or several are implemented as BAPIs.

5. What can we say about ALE (Application Link Enabling, Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Business processes cannot be distributed using ALE.
b) [ ] The ALE concept is related to an enterprise structure with areas that have central tasks and areas with tasks that are decentralized.
c) [ ] The applications are integrated via a central database.
d) [ ] The applications are integrated via the message exchange.
e) [ ] The ALE concept supports the implementation and operation of distributed SAP applications.

6. A company code is:

a) [ ] an independent accounting entity (the smallest organization element for which a complete self-contained set of accounts can be drawn up).
b) [ ] an organizational unit in an enterprise that represents a closed system used for cost accounting purposes.
c) [ ] an organizational unit that provides an additional evaluation level for the purpose of segment reporting, for example.
d) [ ] a dependent accounting entity, according to Fiscal Year.
e) [ ] the highest level in the R/3 system hierarchy.

7. Consider the following sentences:

7.1. The variant principle is a three-step method used in R/3 to assign special properties to one or more R/3 objects.
7.2. One of the disadvantages to use variants is that it can't deal with the maintenance of properties, which are common among several business objects.
7.3. For using the variant principle, you must define the variant, populate it with values and assign it to the R/3 objects.
7.4. This principle is used for Fiscal Years, Posting Periods and so on.

Which of them is false?

a) [ ] 7.1 and 7.2.
b) [ ] 7.1 and 7.3.
c) [ ] 7.1.
d) [ ] 7.2.
e) [ ] 7.3.

8. Consider the following sentences:

8.1. A fiscal year has to be defined by means of separating business transactions into different periods.
8.2. Special periods are used for postings, which are related to the process of the year-end closing. In total, 16 special periods can be used.
8.3. The Fiscal Year variant only defines the amount of periods and their start and finish dates.
8.4. The Fiscal Year is defined as a variant, which is assigned to the chart of accounts.

Which of them are true?

a) [ ] 8.1 and 8.2.
b) [ ] 8.1 and 8.3.
c) [ ] 8.2 and 8.3.
d) [ ] 8.2 and 8.4.
e) [ ] 8.3 and 8.4.

9. What is an independent fiscal year variant (Please choose the correct sentence)?

a) [ ] It is a variant which the postings periods are only equal to the months of the year.
b) [ ] It is a variant which you can define different number of periods, according to the year.
c) [ ] It is a variant which each own fiscal year uses the same number of periods, and the postings periods always start and end at the same day of the year.
d) [ ] It is a variant which allows the use of different number of posting periods.
e) [ ] It is a variant not normally used because of its particularity.

10. Consider the following statements about currencies concepts:

10.1. The currency code identifies each currrency that will be used into R/3 system.
10.2. You have to define all the worldÂ’s currency into R/3 system
10.3. Exchange rate types distinguishes the exchange rates to be considered for various purposes, such as valuation, translation, conversion, planning, etc.

Which of them is true (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] 10.1.
b) [ ] 10.2.
c) [ ] 10.3.
d) [ ] none of them.
e) [ ] all of them.

11. Consider the following sentences:

11.1. A base currency can be assigned to an exchange rate type.
11.2. To deal with exchange rate spreads, two very efficient combinations of the exchange rate tools are using a base currency for the average rate (M) and using the exchange rate spreads to calculate the buying and selling rates (B and G).
11.3. A base currency can be used for an average, a buying or a selling rate.
11.4. The relations between currencies have to be maintained per exchange rate type and currency pair in the translation factors.

Which of these combinations is true?

a) [ ] 11.1, 11.3 and 11.4.
b) [ ] 11.1, 11.2 and 11.4.
c) [ ] 11.2, 11.3 and 11.4.
d) [ ] 11.1, 11.2 and 11.3.
e) [ ] 11.1, 11.2, 11.3 and 11.4.

12. Consider the following sentences about the direct quotation:

12.1. It is also known as price notation.
12.2. The currency value is expressed in units of the foreign currency per unit of local currency.
12.3. For direct quotation, the prefix to indicate the rate is Â“/Â”.

What is the correct option?

a) [ ] 12.1.
b) [ ] 12.2.
c) [ ] 12.3.
d) [ ] none of them.
e) [ ] all of them.

13. Consider the following sentences about the indirect quotation:

13.1. It is also known as volume notation.
13.2. The currency value is expressed in the local currency per unit of foreign currency.
13.3. For indirect quotation, there is no prefix to difference between direct quotation.

What is the correct option?

a) [ ] all of them.
b) [ ] none of them.
c) [ ] 12.3.
d) [ ] 12.2.
e) [ ] 12.1.

14. What of these alternatives are considered master data (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Chart of Accounts.
b) [ ] G/L Accounts.
c) [ ] Vendor.
d) [ ] Customer.
e) [ ] Asset.

15. What can we define into the chart of accounts customizing transaction (OB13 transaction, Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Description.
b) [ ] Maintenance language.
c) [ ] Length of the company code.
d) [ ] Length of the G/L account number.
e) [ ] Blocking / unblocking chart of accounts.

16. Consider the following sentences about the chart of accounts segment:

16.1. It contains the Company Code, Account number and the field status group.
16.2. Whenever you need to enter information for a company code for an account number, you have to type again the information related to chart of accounts segment.
16.3. Texts can be displayed using the program Â“Account assignment manualÂ”(RFSKTH00).
16.4. Key words facilitate the search for account numbers.

Which of these combinations are false (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] 16.1.
b) [ ] 16.2.
c) [ ] 16.3.
d) [ ] 16.4.
e) [ ] none of them.

17. True or false?

17.1. Every company code that needs to use an account from the assigned chart of accounts has to create its own company code segment.
a) [ ] True b) [ ] False

17.2. For P+L statement accounts, the balance is carried forward to the same account.
a) [ ] True b) [ ] False

17.3. In the chart of accounts segment, it is necessary to indicate whether the account will be a balance sheet or a profit+loss statement account.
a) [ ] True b) [ ] False

17.4. Number intervals for G/L account master records can overlap.
a) [ ] True b) [ ] False

17.5. It is not possible to influence the appearance of an account’s master data.
a) [ ] True b) [ ] False

18. Consider the following sentences about field status:

18.1. Fields which are _____________ can be ____________.
18.2. Fields which have an entry that ________________ can be set to
_________ only (even in change mode).

Which of the options below matches the blank spaces of those sentences?

a) [ ] used/supressed for 18.1; must be changed/display for 18.2.
b) [ ] not used/supressed for 18.1; must be changed/display for 18.2.
c) [ ] not used/optional for 18.1; should not be changed/supressed for 18.2.
d) [ ] not used/supressed for 18.1; should not be changed /display for 18.2.
e) [ ] used/optional for 18.1; must be changed/display for 18.2.

19. Consider the following sentences about field status:

19.1. Fields which _____________ can be made ____________.
19.2. Fields that can be entered, but are not required, can be set to _________ entry.

Which of the options below matches the blank spaces of those sentences?

a) [ ] must not have an entry/optional for 19.1; suppresed for 19.2.
b) [ ] must have an entry/supressed for 19.1; suppresed for 19.2.
c) [ ] must have an entry/optional for 19.1; optional for 19.2.
d) [ ] must have an entry/required for 19.1; optional for 19.2.
e) [ ] must not have an entry/required for 19.1; optional for 19.2.

20. Consider the following sentences:

20.1. Reconciliation accounts are general ledger accounts assigned to the business partner master records to record all transactions in the sub-ledger.
20.2. For accounts without line item display, the most important data from the posted line items is stored in a special index table.
20.3. The account currency must be in the local currency.
20.4. Items in accounts with open item management means the G/L accounts should have a offsetting posting for a given business transaction.

Which of these are true (Please choose the correct sentence)?

a) [ ] 20.1 and 20.3.
b) [ ] 20.2 and 20.4.
c) [ ] 20.1 and 20.2.
d) [ ] 20.2 and 20.3.
e) [ ] 20.1 and 20.4.

Answers:

1. C

2. A, C, D, E.

3. D

4. A, B, C, D, E.

5. B, D, E.

6. A

Item Â“BÂ” is the definition of controlling area.
Item Â“CÂ” is the definition of business area.
Item Â“DÂ” is not any definition.
Item Â“EÂ” is the definition of client.

7. D
In fact, the main advantage of using variants is that it is easier to maintain properties, which are common among several business objects.

8. B

9. C

10. A, C.
Most of the world’s currencies are already defined into R/3 system.

11. B
Be careful: A base currency can only be used for an average rate, not for a selling or a buying rate.

12. A

13. E

14. B, C, D, E.
A chart of accounts is a variant, which contains the structure and the basic information about general ledger accounts.

15. A, B, D, E.

16. A, B.

17. True or false:

17.1. True.

17.2. False. For P+L statement accounts the balance is carried forward to a retained earnings account and the P+L statement account is set to zero.

17.3. True.

17.4. True.

17.5. False. It is possible to influence the appearance of an account’s master data using the field status.

18. D

19. D

20. E

SAP FI/CO Sample Questions and Answers

2007-12-14T16:13:00.000-08:00

SAP FI/CO Sample Questions and Answers 2

2007-12-14T16:11:00.000-08:00

1. Since the line item display takes up additional system resources, you should only use it if there is no other way of looking at the line items. So, you should not activate the line item display for the following accounts (Note: we can have more than one correct sentence. Please select the sentences you think they are correct):

a) [ ] P+L Statement.
b) [ ] Reconciliation.
c) [ ] Revenue.
d) [ ] Material Stock.
e) [ ] Tax.

2. Consider the following statements:

2.1. Accounts with open item management must have line item display activated.
2.2. You can activate or deactivate open item management everytime, even if the account hasnÂ’t a zero balance.
2.3. You can select both local and foreign currencies as account currency.
2.4. If the account is the local currency, the account can only be posted to this currency.
2.5. When using the Â“Only Balances in Local CurrencyÂ” indicator in the master data record, transaction figures are only managed for amounts translated into local currency.

Which of the above statements are true (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?
a) [ ] 2.1.
b) [ ] 2.2.
c) [ ] 2.3.
d) [ ] 2.4.
e) [ ] 2.5.

3. True or false?

3.1. The “Only Balances in Local Currency” indicator must not be set in reconciliation accounts for customers or vendors.
a) [ ] True. b) [ ] False.

3.2. The “Only Balances in Local Currency” indicator is usually set in balance sheet accounts that are not managed in foreign currencies and not managed on an open item basis.
a) [ ] True. b) [ ] False.

3.3. Accounts with a foreign currency as an account currency can be posted to any currency.
a) [ ] True. b) [ ] False.

3.4. You can use a group chart of accounts for internal purposes.
a) [ ] True. b) [ ] False.

3.5. The usage of a financial statement version for the group chart of accounts is optional.
a) [ ] True. b) [ ] False.

4. What is the disadvantage of using the group chart of accounts (Please choose the correct sentence)?

a) [ ] Because changes to existing G/L Accounts are effective as soon as they have been saved and could have extensive consequences.
b) [ ] Because accounts with the account currency as local currency can only be posted to this local currency.
c) [ ] Because the company codes use different operational chart of accounts, you cannot carry out cross-company code controlling.
d) [ ] Because the group chart of accounts must be assigned to each operational chart of accounts.
e) [ ] Because you must enter the group account number in the chart of acounts segment of the operational account.

5. Consider the following statements:

5.1. You cannot use the country chart of accounts if you desire to use the cross-company code controlling.
5.2. The disadvantage of using country chart of accounts is the accounting clerks who may be familiar with the country chart of accounts first have to get used to using the operational chart of accounts.
5.3. Reconciliation accounts are updated on a daily basis.

Which of them are false (Please choose the correct sentence)?

a) [ ] 5.1 and 5.2.
b) [ ] 5.1 and 5.3.
c) [ ] 5.2 and 5.3.
d) [ ] all of them.
e) [ ] none of them.

6. Which are the segments of the SD view of the customer account master data (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Client.
b) [ ] Company Code.
c) [ ] Controlling Area.
d) [ ] Sales Area.
e) [ ] Purchasing Organization.

7. Which are the segments of the MM view of the customer account master data (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Client.
b) [ ] Company Code.
c) [ ] Controlling Area.
d) [ ] Sales Area.
e) [ ] Purchasing Organization.

8. What is the segment that makes complete both customer and vendor accounts (Please choose the correct sentence)?

a) [ ] Client.
b) [ ] Company Code.
c) [ ] Controlling Area.
d) [ ] Sales Area.
e) [ ] Purchasing Organization.

9. What characteristics are configured as standard for every customer/vendor account (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Line Item Display.
b) [ ] Company Code.
c) [ ] Currency.
d) [ ] Open Item Management.
e) [ ] Purchasing Organization.

10. Consider the following statements:

10.1. Number ranges for customer/vendor accounts can overlap.
10.2. An one-time account is a special customer/vendor master record which a company rarely do business.
10.3. The account group is used to control the fields displayed in the master record.
10.4. If you enter an alternative payer, the amount to clear the open items due in the account is paid by the alternative payer.
10.5. One number range can only be assigned to one account group.

Which of the above statements are true (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] 10.1.
b) [ ] 10.2.
c) [ ] 10.3.
d) [ ] 10.4.
e) [ ] 10.5.

11. True or false?

11.1. For every bank that is used in the system (for example, as a house bank or as a customer/vendor bank) you have to create a bank master record.
a) [ ] True. b) [ ] False.

11.2. Banks that are used by your company are defined as house banks.a) [ ] True. b) [ ] False.

11.3. You cannot create bank master data when entering bank information in the customer or vendor master record.
a) [ ] True. b) [ ] False.

11.4. Bank Account and G/L Account are the same master data object.
a) [ ] True. b) [ ] False.

11.5. Customers that use the lockbox function can create a batch input session that automatically updates customer banking information in the master record.
a) [ ] True. b) [ ] False.

12. Consider the following statements:

12.1. The system can assign the document numbers or the user can assign
the number during document entry.
12.1. A business transaction creates only one document.
12.3. Document types are defined at company code level.
12.4. Number ranges for document numbers and account types defined for postings are defined by the document types.
12.5. Document types also define whether invoices are posted with the net procedure.

Choose the correct option:

a) [ ] 12.1, 12.4 and 12.5 are correct.
b) [ ] 12.2, 12.4 and 12.5 are correct.
c) [ ] 12.3, 12.4 and 12.5 are correct.
d) [ ] 12.1, 12.3 and 12.4 are correct.
e) [ ] 12.1, 12.2 and 12.5 are correct.

13. What do the posting keys specify (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Whether the line item is connected to a payment transaction or not.
b) [ ] Whether the posting is sales-relevant and the sales figure of the account is to be updated by the transaction, for example, by the posting of a customer invoice.
c) [ ] Whether the line items contain “credit” or “debit” values.
d) [ ] Whether the line items are valid for a business transaction.
e) [ ] Whether the accounts are allowed for posting.

14. Consider the following statements:

14.1. A company code must be assigned to a posting period variant to have the control for posting periods.
14.2.‘+’ symbol represents all account types in the posting period customizing screen.
14.3. The account interval in the posting period customizing screen can be both G/L and subledger accounts.
14.4. The maximum amounts are defined per company code in “tolerance groups”.
14.5. It is not possible to assign tolerance groups to user logon ID’s.

Choose the correct option:

a) [ ] 14.1, 14.4 and 14.5 are correct.
b) [ ] 14.2, 14.4 and 14.5 are correct.
c) [ ] 14.3, 14.4 and 14.5 are correct.
d) [ ] 14.1, 14.2 and 14.4 are correct.
e) [ ] 14.1, 14.2 and 14.5 are correct.

15. What fields of a FI Document Header section can be changed after a document has already been posted (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Fiscal Year.
b) [ ] Reference Number.
c) [ ] Text fields.
d) [ ] Header text.
e) [ ] Posting date.

16. About the change control, what conditions below are applicable (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

16.1. The posting period is already closed.
16.2. The line item is not yet cleared.
16.3. The document is a credit memo for an invoice.
16.4. The document is not a credit memo from a down payment.
16.5. The line item is either a debit in a customer account or a credit in a vendor account.

a) [ ] 16.1.
b) [ ] 16.2.
c) [ ] 16.3.
d) [ ] 16.4.
e) [ ] 16.5.

17. What are the prerequisites to enable negative postings (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] You have to define reversal reasons for negative reversal.
b) [ ] You have to ensure company code permits negative postings.
c) [ ] You have to define the document type that explicitly allows negative postings.
d) [ ] You have to use cleared items.
e) [ ] You have to reset cleared items.

18. What is the purpose of the terms of payment (Please choose the correct sentence)?

a) [ ] Calculate a cash discount and invoice due date.
b) [ ] Calculate the tax amounts.
c) [ ] Enable the cross-company code transactions.
d) [ ] Define the baseline date.
e) [ ] Calculate only the required conditions for SD invoices.

19. Consider the following statements:

19.1. Terms of payments are copied from invoice to credit memos when they are linked to.
19.2. Inserting a Â“VÂ” in the invoice reference field during document entry means the terms of payment are activated in the
non-invoice-related credit memos.
19.3. The account type field in terms of payment basic data screen should be defined separately, to prevent any done change in the term of payment.
19.4. The system cannot define the splitment of an installment payment, at least you define it in the terms of payment.
19.5. The day limits define the dates of the cash discount periods.

Which of the statements above is false (Please choose the correct sentence)?

a) [ ] 19.1.
b) [ ] 19.2.
c) [ ] 19.3.
d) [ ] 19.4.
e) [ ] 19.5.

20. True or false?

20.1. SAP supports tax on sales and purchases, US sales tax, additional taxes and withholding tax as tax systems for different countries.
a) [ ] True. b) [ ] False.
20.2. Only national level of taxation is allowed in the R/3 system.
a) [ ] True. b) [ ] False.
20.3. A tax calculation procedure is assigned to every company code for carrying out tax calculations.
a) [ ] True. b) [ ] False.
20.4.A jurisdiction code is a combination of the codes of tax authorities that tax movements of goods and use their own tax rates.
a) [ ] True. b) [ ] False.
20.5. If you desire to post manual tax postings, you have to flag the “Post Automatically Only” field of the account master record.
a) [ ] True. b) [ ] False.

Answers

1. B, C, D, E.

2. A, C, E.

3. True or false:

3.1. True.
3.2. True.
3.3. False. Accounts with a foreign currency as an account currency can only be posted to in this foreign currency.
3.4. True.
3.5. False. You must use a financial statement version for the group chart of accounts.

4. C.
Item “a” is related to Collective Processing for G;L Accounts Master Data.
Item “b” is not true for the R/3 system concept. If the account currency is the local currency, the account can be posted to in any currency.
Item “d” and “e” are some actions to be done for using group chart of accounts, so, they are not the disadvantage.

5. B.
In fact, since all company codes use the same operational chart of accounts for postings, you can carry out cross-company code controlling. About Reconciliation accounts, they are updated realtime.

6. A, D.

7. A, E.

8. B.

9. A, D.

10. B, C, D.

NOTE: A number range can be assigned to several account groups.

11. True or false?

11.1. True.

11.2. True.
11.3. False. In fact, we can create bank master data when entering bank
information in the customer or vendor master record.

11.4. False. Each bank account is reflected in the SAP System by a combination of house bank ID and account ID. This combination is entered in a G/L account that represents the bank accounting the general ledger.

11.5. True.

12. A.

13. A, B, C, E.

14. D.

15. B, C.

16. B, D, E.

17. A, B, C.

18. A.

19. E.

The day limits are used to store several versions of terms of payment under the same terms of payment key.

20. True or false:

20.1. True.

20.2. False. Two types of taxation can be represented in the R/3 system: taxation at national level and taxation at regional/jurisdiction level.

20.3. False. A tax calculation procedure is assigned to every country for carrying out tax calculations.

20.4. True

20.5. False. If you have selected this field, no manual tax postings are allowed.

Banking Transaction Financial Accounting Entries

2007-12-14T16:10:00.000-08:00

) Settlement of advance will be done by the Accounts Department based on the Travel Expense Statement submitted by the employee, which is approved by the Concerned Department Head.

2) Expenses Account DR
Cash/Bank Account DR (if, refund)
Employee Advance Account CR
Cash/Bank Sub ledger Account CR (if, payable)

3) Banking Operations - Maintenance Of Bank Master

4) A House Bank is a combination of a Bank and a Branch. Account id is the account number. A house bank can have multiple account IDs.. There could be a main account as also payable account, which will be defined as separate account ids. General Ledger accounts have to be created for each combination of a house bank and account ID. The bank master details are to be provided by HZL.

5) General Ledger accounts have to be created for each account ID in the house bank. Bank Account Master data will be maintained by the Finance Department centrally.

6) Each house bank and account ID combination shall have one main general ledger account and several sub accounts mainly based on broad transaction types. These sub accounts are necessary to facilitate automatic bank reconciliation process in R/3 system.

Bank Accounting

7) The accounting entries will be generated automatically according to the posting rules attached to the Transaction type. The following accounting entry is passed by the system in respect of cheque deposit on account of collection from domestic customers.

Bank cheque deposit account Debit
Customer account Credit

8) In this case, a bank sub account is selected based on the transaction code entered by the user. The customer account is cleared i.e. invoice is cleared against the receipt. In respect of any other deposits, the relevant accounts to be credited will depend on the nature of transaction.

9) Payment against bills for collection. Based on the bank advices falling due on a particular day one payment advice is made debiting the vendors and crediting bank.

Cheque Deposit - Customer Receipts

10) All cheques received from customers shall be accounted at the point of receipt. The entry posted shall be

Bank Sub account Dr
Customer Account Cr

Cheque Deposit - Other Than Customer Receipts

11) All other receipts will be accounted through the Incoming Payment Transaction of the Accounts Receivables module.

Cheque Bouncing – Other Than Customer Receipts

12) Based on the information of cheque bounced from the Bank, the accounts Department will pass accounting entries for the cheque that have been bounced. The procedure to handle bouncing of a cheque has been discussed under the following

13) Reset the clearing document – If the document has been cleared i.e. an open outstanding item has been cleared against an incoming receipt, then the clearing document has to be reset to its original status of open item. This process is known as reset of cleared document.

14) Reverse the entry passed for cheque deposited earlier – Once the document has been reset it will be reversed. The following accounting entry will be passed.

FI Customer DR
Bank cheque deposit account CR

15) In case of cheques being damaged while printing, the concerned cheques no. has to be voided and the payment will be rerun.

Bank Reconciliation

2007-12-14T16:07:00.002-08:00

16) The Bank reconciliation process is based on the entries passed through the Bank sub account and main account. The process is dependent on the Bank Statement received from the Bank that will be entered into SAP. Accounting rules are to be defined for each transaction type and posting rule for posting accounting entries as per bank statement. Bank statements to be uploaded into SAP.

17) Bank Main account balance is the actual balance as per the bank statement whereas the Bank sub accounts denote the reconciliation items. These sub accounts show those entries, which will flow from the sub account which are not cleared in the bank statement.

18) Adding or subtracting the Bank sub accounts will help in preparing the Bank reconciliation statement.

19) The following scenarios would explain the reconciliation process:

- Cheque received from customer

- Cheque issued to vendors

- Cheque received from Other than Customers

- Direct Debits in Bank Statement

- Direct Credits in Bank Statement

- Fund Transfer between Bank Accounts