LATEST POPULAR

CONTACT

Sap Fico Accounts Receivable Interview Questions

What is SAP FI - Accounts Receivable?

SAP FI Accounts Receivable component records and manages accounting data of all customers. It is also an integral part of sales management.

All postings in Accounts Receivable are also recorded directly in the General Ledger. Different G/L accounts are updated depending on the transaction involved (for example, receivables, down payments, and bills of exchange). The system contains a range of tools that you can use to monitor open items such as account analyses, alarm reports, due date lists, and a flexible dunning program.

The correspondence linked to these tools can be individually formulated to suit your requirements. This is also the case for payment notices, balance confirmations, account statements, and interest calculations. Incoming payments can be assigned to due receivables using user-friendly screen functions or by electronic means such as EDI.

The payment program can automatically carry out direct debiting and down-payments.

We have a range of tools available for documenting the transactions that occur in Accounts Receivable, including balance lists, journals, balance audit trails, and other standard reports. When drawing up financial statements, the items in foreign currency are revalued, customers who are also vendors are listed, and the balances on the accounts are sorted by their remaining life.

Accounts Receivable is not merely one of the branches of accounting that forms the basis of adequate and orderly accounting. It also provides the data required for effective credit management (as a result of its close integration with the Sales and Distribution component) as well as important information for the optimization of liquidity planning.

Explain What Are The Issues Related With Accounts Receivable?

As the Accounts Receivable Supervisor, you will:

Oversee and resolve all issues related to cash application to ensure accuracy.

Reconcile daily cash receipts to payment register.

Design and implement new Accounts Receivable processes and procedures.

Process short payment and accounts receivable adjustment forms.

Develop and maintain reports to assess team productivity.

Invoice special customer accounts.

Supervise five Accounts Receivable Associates.

Other duties as may be assigned.

What is the ‘Dunning Area’?

The ‘Dunning Area’ is optional and is required only if dunning is not done at the Company Code level. The Dunning area can correspond to a sales division, sales organization, etc.

Describe the ‘Dunning’ Process?

The ‘Dunning Process’ involves three major steps:

Maintaining the parameters for the dunning run

Creating/editing the dunning proposal generated by the system

Printing dunning notices

Maintaining Dunning Parameters

As the first step in dunning, you need to maintain certain parameters, which identify the current dunning run. Entering the date of execution and the dunning run identifier is the starting point, after which you will continue to maintain other parameters such as:

Dunning date to be printed on the notice

Document posted up to

iii. Company Code

Account restrictions (optional)

Now, you can save the parameters and display the log generated (to see if there were any errors), the dunning list (list of accounts and items), and some dunning statistics (blocked accounts/items, etc.).

Creating a Dunning Proposal

Once scheduled, the ‘dunning program’ prepares the ‘dunning proposal’ as described below:

The Dunning Program determines which accounts to dun:

System checks the fields ‘Dunn procedure’ and ‘Last dunned’ in the customer master record to determine whether the arrears date or the date of the last dunning run lies far enough back in the past.

Checks whether the account is blocked for dunning according to the dunning block field in the customer master record.

iii. Program processes all open items relating to the accounts thus released in

(ii) above that were posted to this account on or before the date entered

in the field ‘Documents posted up to.’

Program checks all the open items, as released in (iii) above, in an

account to decide:

Is the item blocked?

Is it overdue according to the date of issue, the base date, the

payment conditions, and the number of grace days granted?

Program then proceeds to process all open items thus released in (iv):

How many days the item is overdue

Which ‘dunning level’ for a particular open item

The program determines the highest ‘dunning level’ for the account based on (v) above. The highest ‘dunning level’ determined is stored in the master record of the account when you print the letters. This ‘dunning level’ determines the ‘dunning text’ and a ‘special dunning form,’ if defined.

vii. The program then proceeds to check each account:

Does the customer/vendor have a debit balance with regard to all open overdue items selected?

Is the total amount to be dunned and the percentage of all open items more than the minimum amount and percentage defined in the ‘dunning procedure’?

Is the ‘dunning level’ for the account or the overdue items higher than it was for the last ‘dunning run’? If not, are there new open items to be dunned (with a previous dunning level of 0)? If not, does the ‘dunning procedure’ for this level specify that dunning be repeated?

The program creates the dunning proposal list

Edit dunning proposal list

You can edit the Dunning Proposal to:

Raise or lower the ‘dunning level’ of an item

Block an item from being dunned

Block an account for the current ‘dunning run’ or remove the block

Block an account in the master record for dunning or remove the block

Block a document for dunning or remove the block

You can view the sample print out to ascertain how the printed notice will look

(a maximum of 10 notices can be seen on the screen).

iii. You may also display ‘logs’ to see the changes made in the editing earlier, as a confirmation of what you wanted to change in the system generated proposal earlier. If necessary, you can go back and change the proposal.

Print Dunning Notices

You can use a ‘single form’ or ‘multiple forms,’ which will have different text, based on the ‘dunning levels.’ There may also be a requirement to use a completely different form for ‘legal dunning.’ Once the print option is activated, the program prints the notices, and the dunning related information such as ‘dunning level,’ ‘last dunned,’ etc., are updated in the customer/vendor masters. SAP provides the option of optically ‘archiving’ the notices as the system prints the dunning notices. There is also a provision to re-start the printing if it is interrupted before completing the printing.

What differentiates one ‘Dunning Level’ from another?

The ‘Dunning Level’ determines the ‘dunning text’ and (if one is required) a ‘special dunning form.’ The ‘dunning program’ determines what ‘dunning level’ should be used in the ‘dunning run.’ The dunning level so determined is stored in the master record of the account when the ‘dunning letter’ is printed. The dunning level may also determine whether there will be some ‘dunning charges.’

How many ‘Dunning Levels’ can be defined?

You may define up to nine dunning levels. If there is only one dunning level, then it is called a ‘payment reminder.’

Can you ‘dun’ customers across ‘Clients’ in a Single ‘Dunning Run’?

No. All the data processing is carried out per Client.

Explain ‘Customer/Vendor Master Records?

There are three categories of data maintained in a typical master record for a customer:

General Data includes general information such as account number, name, telephone, bank information, trading partner, vendor (if the customer is also a vendor), group key, bank key, bank account, alternate payee, etc., which are common to all the Company Codes using this master. Company Code Data comprises terms of payment, payment methods, tolerance group, clearing with vendor, dunning data (dunning procedure, dunning recipient, dunning block, dunning clerk, etc.), reconciliation account, sort key, sales area (purchasing organization in the case of vendor master), head office, etc. Except for sales (purchasing) related information, all other details are usually maintained for the finance people who can also access the sales data when the master is maintained ‘centrally.’

Sales Area Data in the Company Code area of a Customer master record contains the following:

During creation of a master record, the system checks for ‘duplicates’ for the same customer which is achieved by the system through the ‘Search-Id’ (Match Code) configured on the customer’s address information.

As in the case of the GL account master record, the creation of the customer/ vendor master record is also controlled by the ‘Account Group,’ which is called ‘Customer Account Group/Vendor Account Group’ (CPD/CPDL/KREDI/LIEF) and controls the numbering of customer/vendor master records, field status, whether an account is a regular one or a ‘One Time’ account, etc.

Open table as spreadsheet Activity in Accounting Centrally

Customer Vendor Customer Vendor

Create FD01 FK01 XD01 XK01

Change FD02 FK02 XD02 XK02

Display FD03 FK03 XD03 XK03

Block/Unblock FD05 FK05 XD05 XK05

Mark for Deletion FD06 FK06 XD06 XK06

Who is an ‘Alternate Payee’?

A customer who pays on behalf of another customer is known as an ‘Alternate Payee’ (or Alternate Payer). Though the alternate payee pays on behalf of another, the system maintains all the transaction details in the account of the original customer. Designating ‘alternate payee’ does not absolve the customer of his/her obligation for payment.

The ‘alternate payee’ can be maintained in Client-specific data or in the Company Code area. When maintained in the Company Code area you can use that payer only in that Company Code; if defined at the Client level you can use it across all Company Codes. There are three ways to ‘select’ the alternate payee when an invoice is processed:

The alternate payee (say, 1000) entered in the customer master record is the one

selected by the system as the default.

When there is more than one alternate payer (say, 1000, 1900, 2100, etc.) defined for a single customer in the master record (you will do this by clicking on the ‘allowed payer’ button and create more than one payer), you may select a payer (say, 2100) (other than the default, 1000) while processing the invoice. Now the system will ignore the alternate payer (1000) coming from the master record.

If you have put a check mark in the ‘individual entries’ check box in the ‘alternate payer in document’ section in the customer master record, then this will allow you to propose a new alternate payer, say, 3000 (other than those already defined in the system). Now, after defining this alternate payer you can use it to process the invoice. In this case, the alternate payer (3000) takes precedence over the payers (1000 and 2100) in step 1 and 2 above.

What is the ‘Trading Partner’ concept?

The ‘Trading Partner’ concept is used to settle and reconcile ‘inter-company transactions,’ both sales and purchases. This is generally achieved by entering the Company-ID (not the Company Code) to which a customer belongs in the ‘trading partner’ field under the tab ‘Account Control’ in the customer master record. You can do a similar entry in the vendor master record.

Explain ‘Tolerance’ in Transaction Processing?

‘Tolerances’ are defined in the system to facilitate dealing with the differences arising out of accounting transactions and to instruct the system on how to proceed further. Normally, you define tolerances (either in ‘absolute terms’ or in ‘percentages’) beyond which the system will not allow you to post a document should there be a difference.

In SAP, tolerances are defined per Company Code and there are several types:

Employee tolerance

Customer/vendor tolerance

GL account clearing tolerance

You will define an ‘employee tolerance group’ in the system and assign the employees to these groups.

While defining the tolerance group you will specify:

Upper limits for various posting procedures

Amount per document

Amount per open account item

Cash discount, in percentage

Permitted payment differences

How much over or under payment an employee is allowed to process. This is defined both in absolute values and in percentages. Besides defining the above two, at the Company Code level, you will also define similar tolerances for customer/vendor tolerance group. Once defined, each of the customers (vendors) is assigned to one of these groups. Here also, you define the ‘permitted payment differences’:

While processing, the system compares the tolerance of an employee against the customer tolerance (or vendor tolerance or the GL) and applies the most restrictive of the two.

What is ‘Dual Control’ in Master Records?

‘Dual Control’ helps to prevent unauthorized changes to the important and ‘sensitive’ fields in the master records in the system. (All such sensitive fields are defined in the Table T055F when customizing the application. And these fields are defined per Company Code and per Client.) Consider, for example, a sensitive field such as ‘payment block’ in a vendor master record. When a user changes this field’s content, the system requires another user (usually of higher authority) to approve this change and an audit trail is maintained of all such changes. Unless ‘ the change is approved, in this example, this particular master is blocked by the system for considering the same in the next ‘payment run.’

Open table as spreadsheet Activity Customer Vendor

Display changes (accounting area) FD04 FK04

Display changes (centrally) XD04 XK04

Confirm changes, individually FD08 FK08

Confirm changes, in a list FD09 FK09

What is a ‘Bank Director’ in SAP?

SAP stores the master data (details such as bank key, bank name, bank country, bank address, and so on) relating to the banks in the ‘Bank Directory’ (Table: BNKA). Remember, the ‘bank masters’ are not created in the application but in the implementation side using the IMG. (Of course, you can also create the bank master in the application side in FI-TR and not in FI-GL or AP or AR.) However, if you are in the process of creating a master record for a vendor or a customer and you enter some bank details, which the system does not find in the ‘Bank Directory,’ then the system automatically brings in the relevant screens for you to maintain and update the bank details in the bank directory.

What is a ‘House Bank’?

A ‘House Bank’ is the bank (or financial institution) in which the Company Code in question keeps its money and does the transactions from. A house bank in SAP is identified by a 5 character alphanumeric code. You can have any number of house banks for your Company Code, and the details of all these house banks are available in the ‘bank directory.’

Each ‘house bank’ in the system is associated with a country key (U.S., IN, etc.) representing the country where the bank is located, and a unique country specific code called a ‘bank key.’ The system makes use of both the ‘country key’ and the ‘bank key’ to identify a ‘house bank.’

For each of the ‘house banks,’ you can maintain more than one bank account; each such account is identified by an account ID; i.e., Chek1, Check2, Pybl1, etc. Here, ‘Chek1’ may denote Checking account 1, ‘Pybl1’ may denote Payables account 1, and so on. You may name the accounts in a way that it is easily comprehensible. The ‘Account ID’ is referenced in the customer/vendor master record and it is used in the payment program by the system.

For each ‘account ID’ you will also specify the bank account number (maximum length of this identifier is 18 characters). You may name this in such a way that it is also easily comprehensible.

For each ‘bank account number’ so defined in the ‘house bank,’ you need to create a GL account master record, and while doing so you will incorporate the ‘house bank id’ and the ‘account id’ in that particular GL master record.

Explain a ‘Sales Cycle’ in SAP?

The following are the various processes within SAP that complete a sales cycle:

Typically, the following are the documents created during a sales cycle:

Inquiry

Quotation

Sales Order

Delivery Note

Goods Issue

Order Invoice

Credit/Debit Note

Explain ‘Automatic Account Assignment’ in SD?

During goods issue in the sales cycle, the system is usually configured to update the relevant GL accounts automatically and to create the relevant accounting documents. This customization in IMG is also called material account assignment and is achieved through a number of steps as detailed below:

Determine ‘valuation level’ (Company Code or plant).

Activate ‘valuation grouping code’ and link it with the ‘chart of accounts’ for each

Depending on the ‘plant’ entered during goods issue (GI), the ‘Company Code’ is

determined by the system which in turn determines the relevant ‘Chart of Accounts.’

The plant thus entered in goods issue determines the ‘valuation class’ and then the ‘valuation grouping code.’

The ‘valuation class’ is determined from the ‘material master.’

Since the ‘account modification code’ is assigned to a ‘process key’ which is already linked to a ‘movement type,’ the ‘transaction key’ (DIF, GBB, AUM, BSX, etc.) determines the ‘GL account’ as posting transactions are predefined for each ‘movement type’ in ‘inventory management.’

Outline ‘Credit Management’ in SAP?

‘Credit Management’ helps to determine credit limits of customers, aids in the creation of ‘credit check’ policies, as well as helps companies monitor and evaluate their customers. This is a cross-functional responsibility in SAP, covering both the Sales and Distribution and Financial Accounting modules. As in the case of any automated process such as dunning, payment, etc., credit management in

SAP requires certain prerequisites be defined beforehand:

Customer master data has been created both in SD and FI.

Credit control area has been defined and assigned to a Company Code.

SAP makes use of the concept ‘credit control area’ for credit management. As explained elsewhere, the credit control area is an organizational element defined to which one or more Company Codes are attached. In the case of customers defined under more than one Company Code, they may fall under different credit control areas. But note that:

A Client can have more than one credit control area, but the converse is not true: one credit control area cannot be assigned to more than one Client.

A credit control area can be assigned to more than one Company Code, but the converse is not true: one Company Code cannot be assigned to more than one credit control area.

While defining the credit limit for a customer:

You will define a maximum limit per credit control area (Example: Credit Control

Area AAAA->USD 500,000, Credit Control Area BBBB ->USD 200,000)

You will define a global maximum limit for all credit control areas put together

(USD 600,000)

Credit data (per credit control area ‘maximum limit’ as well as the ‘total’ for all areas, in the control data screen) for the customer has been created.

information system, credit overview, credit master list, early warning list, oldest open item, last payment, customer master, account analysis, etc.), processes this blocked order either (1) from the ‘blocked SD documents list’ or (2) the mailbox, and releases the order, if necessary.

Delivery is created, the billing document is generated and posted, and A/R is updated.

Customer pays the invoice and A/R is posted.

What is a ‘Credit Check?

A ‘Credit Check’ is defined for any valid combination of the following:

Credit control area

Risk category

Document credit group

Differentiate ‘Static Credit Check’ from Dynamic Check?

Under ‘Static Credit Check,’ the system calculates the credit exposure of a particular customer as the total of:

Open order (delivery not yet done)

Open delivery (value of deliveries yet to be invoiced)

Open billing documents (not transferred to accounting)

Open items (AR item not yet settled by the customer)

Customer’s credit exposure is not to exceed the established credit limit.

The ‘Dynamic Credit Check’ is split into two parts:

Static limit: Total of open items, open billing, and open delivery values.

Dynamic limit (Open Order Value): The value of all undelivered and partially delivered orders totalled and stored on a time-scale in the future (10 days, 1 week, etc.) known as a ‘horizon date.’ During the ‘dynamic credit check,’ the system will ignore all orders beyond the ‘horizon date.’ The sum total of ‘static’ and ‘dynamic’ limits should not exceed the credit limit established for the customer.