Define Tolerance for Customers and Vendors

Define Tolerance for Customers and Vendors (OBA3)

Path: Same

Click on new entries.

Company code – TAST

Tolerance group – TGMC (any code) Tolerance for Customers

Grace days due date – 3

Permitted payment differences

Gain – 1 %

Loss – 1 %

Press enter key and Save.

Come back wise.

Define Tolerance group for employees (OBA4)

Path: Same

Click on new entries.

Group – TGMC

Company code – TAST

Amount per documents – 9999999999

Amount per open line item – 9999999999

Cash discount per line item – 5 %

Press enter key and save.

Your Ad Here

Accounts Receivable Procedure

ACCOUNT RECEIVABLE

Customer Account Group creation

Path: Spro → Img → Financial Accounting (new) → Account receivables and Accounts Payable → Customer Account → Master Data → Preparation for creating customer master data.

Define Account group with screen layout (OBD2) (Customers)

Path: Same

Click on new entries

Account Group – TAMC (Any 4 code)

Name - Material Customers for TAST

Double click on General Data field.

Double click on Address tab

Keep Name as required entry.

Come back wise

Double click on Company code data field.

Double click on Account Management

Keep Reconciliation account as required entry.

Come back wise and Save.

Press F8 for next entry.

Account Group – TAMS (Any code)

Name – Service Customers for TAST

Double click on General Data field.

Double click on Address tab

Keep Name as required entry.

Come back wise

Double click on Company code data field.

Double click on Account Management

Keep Reconciliation account as required entry.

Come back wise and Save.

Note: Just like you can create any number of customer group.

Create Number ranges for Customers accounts (XDN1)

Path: Same

Click on Change intervals

Click on Insert intervals.

No	From Number	To Number
A1 (Any)	500001	500100

Press enter key and again click on insert intervals

No	From Number	To Number
A2 (Any)	500101	500200

Press enter key and Save it.

Come back wise.

Assign Number ranges to Customer account group (OBAR)

Path: Same

Click on position

Account Group – TAMC

Group	Name	Number range
TAMC	Material Customers for TAST	A1

Again Click on position

Account Group – TAMS

Group	Name	Number range
TAMS	Service Customers for TAST	A2

Press enter key and save.

Tolerance for Customer Documents

The tolerances are used for dealing with payment differences and residual items that may arise when payment clearing is carried out. You specify the tolerances in one or more tolerance groups and assign a tolerance group to each customer/vendor using the master record.

Path: Spro → Img → Financial Accounting (new) → Account receivables and Accounts Payable → Business Transaction → Open item Clearing → Clearing differences

Your Ad Here

Display general account line items

Display of GL line items

Path: Same as up to GL reports → Line items → GL line items → GL line items (S_ALR_87012282)

                

Chart of accounts – CHAC                GL Accounts - *

Company code – TAST                                 

Press F8 for execute

Display of GL Accounts List

Path: Same as up to GL Reports → Master data → Chart of accounts (S_ALR_87012326)

GL Accounts - *                     Chart of accounts – CHAC

Press F8 for execute

Your Ad Here

What is open item management

Open item management means that a line item needs to be cleared against another open item. At a particular point, the balance of an account is the sum of all open items of that account. Generally, you make these setting in the G/L Master for all clearing accounts, such as a Goods Receipts and Invoice Receipts [GRIR] account, customer account, vendor account, or bank G/L  account, or all accounts except the main bank account. Open item managed accounts always have line item management. You can switch open item management on and off through transaction code FS00.

Your Ad Here

manual reports

Reports

Display of GL Account balances

Path: Sap easy access → Accounting → Financial accounting → GL → Information system → General ledger report → Accounts balances → General → GL Account balances (S_ALR_87012277)

Chart of Accounts – CHAC

GL Accounts - *   (For all GL balances)

Company code – TAST

Fiscal year – 2009

Press F8 for execute

Your Ad Here

Manual Clearing Procedures (F-03)

Manual Clearing Procedures (F-03)

Path: Sap easy access → Accounting → Financial accounting → General ledger → Accounts → Clear

Accounts – Outstanding rent account

Clearing date – 30-06-09                    Company code –TAST

Click on process open item tab

Press enter key and Save

Activate the following line item

Simulate and Save it

Go to FBL3N check the outstanding rent status

Now we can see any balances

Residual Payments

In the residual payments when we are doing the particular payments remaining outstanding amount system generate separate open item.

Go to F-02 post the following documents on 30-04-09

Rent account – 10000

      To Outstanding rent account – 10000

     

Payout outstanding rent 6000 through bank on 01-05-09 (Its residual payments)

     

Path: Go to F-07

     

Documents date – 01-05-09   Type – SA                   Company code – TAST

Posting date – 01-05-09          Period – 02      Currency – INR

Documents header text – Residual Outstanding rent clearing

Clearing text – Residual Outstanding rent clearing

Bank Data

Account – SBI Account                     Business area – TAHY          

Amount – 6000                                  

Text – Residual payments (Rent outstanding )

Open item selection

Account – Outstanding Rent Account

Click on process open items tab

Click on Residual Payments tab

Activate the clearing line item

Double click on Residual item dailar box

Now we will get the 4000 (Its remaining outstanding)

Click on simulate and Save

     

Go to FBL3N check the outstanding rent status

     

Paid Outstanding Rent 4000 on the 01-06-09 through bank (Its residual Payments)

     

Go to F-07

     

Documents date – 01-06-09               Type – SA                   Company code – TAST

Posting date – 01-06-09                      Period – 03                  Currency – INR

Documents header text – Residual Outstanding rent clearing

Clearing text – Residual Outstanding rent clearing

Bank Data

Account – SBI Account                     Business area – TAHY          

Amount – 4000                                  

Text – Residual payments (Rent outstanding )

Open item selection

Account – Outstanding Rent Account

Click on process open items tab

Click on Residual Payments tab

Activate the clearing line item

Click on simulate and Save

Go to FBL3N check the outstanding rent status

Your Ad Here

OPEN ITEM MANAGEMENTS

Open item managements

Open item managements we are using for clearing for documents

     

Go to FS00 Create the following GL Account

Outstanding rent account – Liabilities

GL Account  - Outstanding account

Company code – TAST

Account group – Liabilities

Select Balance sheet items

Activate Open item managements

Field status variants – G001

All other process are same when crating GL Accounts

     

Go to F-02 Post the following documents

     

First documents on 30-04-09

     

Rent Account              10000

      To Outstanding rent a/c          10000

     

Second Documents on 31-05-2009

     

Rent Account              10000

      To Outstanding rent a.c          10000

Go to FBL3N for Display of Outstanding Rent account status. In this status report we find out the which month outstanding rent is open and Which month outstanding rent is clear.

     

Paid Outstanding Rent 10000 through bank on 01-06-09 against the April month Outstanding rent Clear

     

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Posting → Out going payments (F-07)

     

Documents date – 01-06-09               Type – SA                   Company code – TAST

Posting date – 01-06-09                      Period – 03                  Currency – INR

Documents header text – Outstanding rent clearing

Clearing text – Outstanding rent clearing

Bank Data

Account – SBI Account                     Business area – TAHY          

Amount – 10000                                

Text – Std payments (Rent outstanding )

Open item selection

Account – Outstanding Rent Account

Click on process open items tab

Deactivate the 31-05-2009 outstanding rent line item (Double click on amount) Activate the 30-04-09 outstanding rent line item it is already active and Save it

     

Go to FBL3N check the outstanding rent status

     

Partial Payments

Pay outstanding rent account 5000 through bank on 05-06-2009 against May month

     

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Posting → Out going payments (F-07)

     

Documents date – 05-06-09               Type – SA                   Company code – TAST

Posting date – 05-06-09                      Period – 03                  Currency – INR

Documents header text – Partial Outstanding rent clearing

Clearing text – Partial Outstanding rent clearing

Bank Data

Account – SBI Account                     Business area – TAHY          

Amount – 6000                                  

Text – Partial payments (Rent outstanding )

Open item selection

Account – Outstanding Rent Account

Click on process open items tab

Deactivate the already cleared outstanding rent amount in net amount box. Double click on partial amount Dailar box at the time we can see which amount we are going to clear.

Click on simulate and Save

     

Go to FBL3N check the outstanding rent status

Paying outstanding rent 4000 through bank on 30-06-09 (May month)

     

Documents date – 30-06-09               Type – SA                   Company code – TAST

Posting date – 30-06-09                      Period – 03                  Currency – INR

Documents header text – Partial Outstanding rent clearing

Clearing text – Partial Outstanding rent clearing

Bank Data

Account – SBI Account                     Business area – TAHY          

Amount – 6000                                  

Text – Partial payments (Rent outstanding )

Open item selection

Account – Outstanding Rent Account

Click on process open items tab

Click on Partial Payments tab

Deactivate the already cleared outstanding rent amount 6000 in net amount box. Double click on partial amount Dailar box in front of your cleared line item.

Click on simulate and Save

Go to FBL3N check the outstanding rent status

Here Outstanding rent account showing Zero balances but line items are still showing as a open items. If you want to clear this line item do the manual clearing procedures..

Your Ad Here

Manual Posting

Manual Posting

     

Pay Consultation fee 100  USD through bank on 30-05-09 exchange rate 48

     

Go to F-02

     

Documents Date – 30-05-09               Type – SA                   Company code – TAST

Posting Date      - 30-05-09                 Period – 02                  Currency/ Rate – USD/ 48

Header text – Consultation fee paid

Post key – 40  Account – Consultation fee paid

Press enter key ignore the warning messages enter

Amount – 100

Text  - Consultation fee paid  Business area – TAHY

Post key – 50  Account – Bank Account

Amount - *      Business area – TAHY

Text - +

Press enter key simulate and Save

     

Line item Layout Preparation for foreign currency Transaction

     

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Accounts → Display/ change line items (FBL3N)

     

GL Account – Consultation fee account

Company code – TAST

Select All items

Press F8 for execute

Click on change field on application tool bar ( cltr + F5)

Select Tax code, clearing documents in line one

Click on right arrow →

Select Amount in documents currency, Documents currency from hidden fields

Click on left arrow ←             (Tick mark)

Click on Save Layout on application tool bar

Layout – UBAID Click on Save

Your Ad Here

Mass Reversal Entry

Mass Reversal

     

This Mass reversal we are using when number of documents reverse of a time

     

Mass Reversal Procedures (F.80)

     

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Documents → Reverse → Mass Reversal

     

Company code – TAST                     

Documents No – 17    to – 20

Fiscal year - 2009

Reason for Reversal – A1

Activate Test Run

Press F8 for execute

Comeback and Deactivate the Test run check box and again Press F8 for Execute

FOREIGN CURRENCY POSTING

Company code currency = Local currency

Other currency is called foreign currency also called Documents currency

     

There are two types of foreign currency posting

1-      Automatic Posting

2-      Manual Posting

Automatic Posting

In this automatic posting we defined the exchange rate in exchange rate type. by the time of documents posting system directly pick up the exchange rate from that table based on value date

     

Manual Posting

In this manual posting no need to define the exchange rate in exchange rate table. By the time of documents posting user directly assign the exchange rate.

Automatic Posting

Paid Consultant fee with 100 US dollar on 20-05-09 through bank exchange rate 45

     

Go to FS00 Create the consultant fee Account under expenses

     

Define Exchange rate (OB08)

Path: Spro → Img → Sap net weaver → General settings → Currencies → Enter exchange rate

                 

Click on new entries

Exchange rate Valid from      From                Direct quote                 To

      M                     20-05-09          USD                     45                           INR

Press enter key and Save

Note: M = Average rate

     

Go to F-02

     

Documents Date – 20-05-09               Type – SA                   Company code – TAST

Posting Date      - 20-05-09                 Period – 02                  Currency – USD

Header text – Consultation fee paid

Post key – 40  Account – Consultation fee paid

Amount – 100

Text  - Consultation fee paid  Business area – TAHY

Post key – 50  Account – Bank Account

Amount - *      Business area – TAHY

Text - +

Press enter key we can see amount in 100 – USD

Simulate the Documents

Here mount is shown in US Dollar for changing this it to local currency

Click on Display Currency tab

Your Ad Here

Reversal of Reversal

Reversal of Reversal

     

Before going to do the reversal of reverse you should know the Reversal documents Number – 15

     

Go to F-02 click on Post with reference tab

Documents No – 15                Company code – TAST

Fiscal year – 2009

Activate Generated Reverse Posting

Press enter key and Change the documents type in to SA

Press enter key and Save

Your Ad Here

Individual Reversal documents

Individual Reversal documents

     

Go to F-02 Post the following documents on 30-05-09

     

Salaries Account                     10000

      To Cash account                     10000

     

Note on the Documents number – 14

     

Actually we have to post the documents on 30-04-09 but user wrongly assigned it to 30-05-09

Individual Reversal Procedures (FB08)

     

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Documents → Reverse → Individual Reversal

     

Documents No – 14                Company code – TAST

Fiscal year – 2009                   Reversal reason – A1

Click on Save

     

Display of Reverse Documents (FB08)

Go to documents in Menu bar Select Display

     

Note: All reversed documents will be posted in under AB documents type

Your Ad Here

REVERSAL DOCUMENTS

Reversal reason for creation (0416)

     

Path: Spro → Img → Financial Accounting new → General ledger → Business transaction → Adjustments posting/ Reversal → Define reason for reversal

     

Click on new entries

Reason                                    Text

A1                               For wrong period

A2                               For wrong date assignments

A3                               For wrong account Assignments

A4                               For wrong amount assignments

Press enter key and Save

Your Ad Here

Recurring documents for Wages

Recurring documents for Wages (FBD1)

     

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Posting → Reference documents → Recurring documents.

     

Company code – TAST

Documents type – SA

Documents header text – Wages paid

Pstky

40

Account

400004 (Wages account)

Press enter key tow times

Amount		5000
Text		Wages paid
Business area		TAMU
Pstky	50	Account	200007 (Cash account)

Press enter key

Amount	*
Text	+
Business area	TAMU

     

Press enter key and simulate the documents

Click on save. (Note the documents number 200002)

Recurring document program run (F.14)

For week

Company code – TAST

Documents Number – 200001

Fiscal year – 2008

Settlement period – 01.04.2008          to         07.04.2008

Batch input Session name – UBAID (any name)

Press enter key

Press F8 for execute

Run the Session.

     

Display of Recurring Documents (FBD3)

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Documents → Reference Documents → Recurring Documents

     

Change of Recurring Documents (FBD2)

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Documents → Reference Documents → Recurring Documents

     

Display changes Recurring Documents (FBD4)

     

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Documents → Reference Documents → Recurring Documents

     

Deleting of  Recurring Documents (F.56)

     

Path: Sap easy access → Accounting → Financial Accounting → General ledger → Documents → Reference Documents → Recurring Documents.

Your Ad Here