Interview Questions

An accounts receivable aging is a report that lists unpaid customer invoices and unused credit memos by date ranges. A typical aging report lists invoices in 30-day "buckets," where the left-most column contains all invoices that are 30 days old or less, the next column contains invoices that are 31-60 days old, the next column contains invoices that are 61-90 days old, and the final column contains all older invoices. The report is sorted by customer name, with all invoices for each customer itemized directly below the customer name, usually sorted by either invoice number or invoice date. A sample report follows, though without the individual invoice detail that is usually found in such a report:

Customer Name 

Total A/R 0-30

Days 31-60

Days 61-90

Days 90+

Days

Abercrombie $15,000 $10,000 $5,000 

Bufford Inc. 29,000 20,000 9,000 

Chesterton Co. 83,000 47,000 21,000 12,000 3,000

Denver Brothers 8,000 8,000

Totals $135,000 $57,000 $46,000 $21,000 $11,000

If the report is generated by an accounting software system (which is usually the case), then you can usually reconfigure the report for different date ranges. For example, if your payment terms are net 15 days, then the date range in the left-most column should only be for the first 15 days. This drops 16-day old invoices into the second column, which highlights that they are now overdue for payment.

The report primarily contains invoices, but it may also contain credit memos that have not been used by customers, or which have not yet been matched against an unpaid invoice.

The aging report is the primary tool used by collections personnel to determine which invoices are overdue for payment, and which therefore require them to contact customers. Given its use as a collection tool, the report may be configured to also contain contact information for each customer.

The aging report is also used as a tool for estimating potential bad debts, which are then used to revise the allowance for doubtful accounts. The usual method for doing so is to derive the historical percentage of invoice dollar amounts in each date range that usually become a bad debt, and apply these percentages to the column totals in the most recent aging report.

An additional use of the aging report is by the credit department, which can view the current payment status of any outstanding invoices to see if customer credit limits should be changed. This is not an ideal use of the report, since the credit department should also review invoices that have already been paid in the recent past. Nonetheless, the report does give a good indication of the near-term financial situation of customers.

In direct marketing, there is a direct interaction of the customers with the seller without any intermediaries. Here, the role of the intermediaries is nil. The medium used is more direct using telephone, mail, internet where the seller can directly reach out to the consumer. Examples of such marketing include telemarketing, email, voicemail marketing, door-to-door selling etc. This kind of marketing is more time saving as the problem of distance which may otherwise exist between the buyer and seller is eliminated and is also cost effective as it minimizes commuting costs.

Multiple inheritance is not supported directly but it is achieved through the concept of Interface

Asc() - Returns ANSI Character Code 

Chr() - Returns Character from ANSI Code 

InStr() - Find a string within another 

InStrRev() - Find a string within another (Reverse) 

LCase() - Convert a string to lowercase 

Left() - Crops a string from left 

Len() - Determine the length of a string 

LTrim() - Remove leading spaces from a string 

Mid() - Crops a string 

Replace() - Replace a substring within a string 

Right() - Crops a string from right 

RTrim() - Remove trailing spaces from a string 

Space() - Creates a string with the specified number of spaces 

StrComp() - Compare two strings 

String() - Creates a repeated character string 

StrReverse() - Reverse the characters of a string 

Trim() - Remove both leading and trailing spaces from a string 

UCase() - Convert a string to uppercase 

Buffer class could be a global class and may be accessed in application without importing buffer module. A Buffercould be a quite an array of integers and corresponds to a raw memory allocation outside the V8 heap. A Buffer can not be resized.

A package is a collection of related PL/SQL objects. The package contains a body and a specification. The package specification has the declaration which is public and can be used in the PL/SQL sub programs inside the package.

The package body holds the implementation of all the PL/SQL objects declared in the specification.

Example of a PL/SQL Package.

CREATE OR REPLACE PACKAGE emp_data AS 

PROCEDURE add_employee (

      ename VARCHAR2,

      job VARCHAR2,

      mgr NUMBER,

      sal NUMBER,

      deptno NUMBER);

END emp_actions;

CREATE OR REPLACE PACKAGE BODY emp_data AS 

PROCEDURE add_employee (

       ename VARCHAR2,

       job VARCHAR2,

       mgr NUMBER,

       sal NUMBER,

       deptno NUMBER) IS

BEGIN

         INSERT INTO emp VALUES (empno_seq.NEXTVAL, ename, job, mgr, SYSDATE, comm, deptno);

END add_employee;

END emp_data;

Advantages of  PL/SQL packages :

Packages are easier for application designing, encapsulating data, additional functionality and better performance. An application has various modules which can be placed in packages and handled easier.

The advantage of equity finance for a company – raising money by selling shares – is that this money does not have to be repaid. However, new shareholders usually get to have a say in how the company is run. Despite these rights, equity is often seen as a risky choice for investors as they will lose all their money if the company doesn’t prosper. If it does well, on the other hand, they may see their stake multiply in value many times over.

Debt finance – money raised through loans – must be repaid eventually by a company, usually with interest, but lenders won’t be able to exert as much influence as shareholders over how the company does business. The debt of a reliable company is usually seen as a safe investment, but fixed repayment schedules means that there are few opportunities for large returns.

By using two types of function modules to be called in SAP Script:

1)HELP_OBJECT_SHOW_FOR_FIELD
2)HELP_OBJECT_SHOW