Residual Payments

Residual Payments

Step1: Go to F-22 Post customer invoice  100000 on 20.05.2008

Step2: Go to F-28 Post customer incoming payments 60000 on 25.05.2008

Setp3: Go to FBL5N Check the customer line item

Step4: Go to F-28 Post Customer incoming payments of 40 on 30.05.2008

Setp5: Go to FBL5N Check the customer line item

Note: In Residual payment method system automatically clear the pen line item. So there is no need for manual payments.

Your Ad Here

Manual clearing procedures

Manual clearing procedures (F-32)

Path: Sap easy Access → Accounting → Financial Accounting → Account receivables → Accounts → Clear.

Account – Customer Account

Clearing date – 10.05.2008

Click on process open item tab

Activate the following line items

DR – 50000

DZ - 30000

DZ – 20000

Press enter key and save.

Go to FBL5N and check the customer status.

Note: After clearing the customer partial payments user should done this manual clearing procedures.

Your Ad Here

Customer Partial Payments

Customer Partial Payments

Step1: Go to F-22 Post customer invoice 50000 on 01.05.2008

Step2: Go to F-28 Post customer incoming payments 30000 on 01.05.2008

Step3: Go to F-28 Post Customer incoming payments of 20000 on 10.05.2008

Setp4: Go to FBL5N Check the customer line item

Customer – Customer account

Company code – TAST

Select all item radio buttons.

Press F8 for executes.

Here Customer account showing Zero Balances but line shown still open item.. If you want to clear the open item do the manual clearing procedures.

Your Ad Here

Display of Customer status

Display of Customer status (FBL5N)

In this status report we find out which invoice is open and which invoice is clear and which invoice is overdue.

Path: Sap easy Access → Accounting → Financial Accounting → Account receivables → Accounts → display/ change line item.

Customer – Customer account

Company code – TAST

Select all item radio buttons.

Press F8 for executes.

Now go to Settings in menu bar → legend on /off  → icon.

Your Ad Here

Display of Customer reconciliation Account balances

Display of Customer reconciliation Account balances

Go to FS10N for display of GL account balances

GL account – Sundry debtors account

Company code – TAST

Fiscal year – 2008

Press F8 for executes

Your Ad Here

Display of customer balance

Display of customer balance (FD10N)

Path: Sap easy Access → Accounting → Financial Accounting → Account receivables → Account display balances.

Customer – Customer account

Company code – TAST

Fiscal year – 2008

Press F8 for executes.

Your Ad Here

Display of customer documents

Display of customer documents (FB03)

Path: Sap easy Access → Accounting → Financial Accounting → Account receivables → Documents display.

Documents Number – enter the document number

Company code – TAST

Fiscal year – 2008

Click on documents list tab

Document type - DR

Click on the arrow mark in front of the documents type

Press enter key

Assign – DR, DZ,DG in single value column

Press F8 for copy and again press F8 for execute.

Your Ad Here

second step for customer invoice posting procedure

Step2: Customer Payment Posting (Receipts)

Documents	Debit/Credit	Posting key
Cash / bank Account	Debit	40
Customer Account	Credit	15

Customer Payment Posting Procedure(F-28)

Transaction

Received 100000 amounts from customer (SAIL) on 05.04.2008 and this amount is deposited in Bank.

Path: Sap easy Access → Accounting → Financial Accounting → Account receivables → Document entry → Incoming Payments.

Document Date – 05.04.2008             Type – DZ                   Company code - TAST

Posting Date –            05.04.2008                  Period – 01                  Currency - INR

Documents header text – Customer Payments

Clearing text – Payment received from Customer SAIL.

Bank data

Account -        200008 (SBI Account)           Business Area – TAMU

Amount – 100000

Text – Payment Received from Customer

Open item selection

Account – 400100 (Customer SAIL account)

Click on process open item tab.

Activate the clearing line item.

Simulate and save.

Your Ad Here

Customer Invoice Postings Procedure

Customer Invoice Postings Procedure (F-22)

Transaction

Sold 100000 goods to Customer (Sail) on 05.04.2008

Path: Sap easy Access → Accounting → Financial Accounting → Account receivables → Document entry → Invoice- general

Document Date	05.04.2008		Type	DR	Company code	TAST
Posting Date	05.04.2008		Period	01	Currency / Rate	INR
Documents Header text		Sales Invoice Posting

Pstky – 01       Account – 401000 (Customer SAIL Account)

Press enter key

Amount – 100000

Business Area – TAST

Text – Customer SAIL invoice posting.

Pstky – 50       Account – 300001 (Sales Account)

Press enter key

Amount - *

Business Area – TAMU

Text - +

Press enter key and simulate

Click on save.

Your Ad Here

Customer Documents Number ranges Settings

Customer Documents Number ranges Settings (OBA7)

Documents	Documents type	Nature of Data
Customer Invoice	DR	Sales documents
Customer Payments	DZ	Receipts
Customer Credit	DG	Sales returns

Go to OBA7 for documents type list

Click on position

Documents Type – DR    ( √ )

Double click on DR documents type.

Click on number range Information tab

Company code - TASL

Click on change Intervals

Click on Insert intervals

No	Year	From Number	To Number
18	2008	400001	500000

Press enter key and save.

Come back three times.

Click on position

Documents type – DZ   ( √ )

Double click on DZ documents type.

Click on number range Information tab

Company code - TASL

Click on change Intervals

Click on Insert intervals

No	Year	From Number	To Number
14	2008	500001	600000

Press enter key and save.

Come back three times

Click on position

Documents type – DG   ( √ )

Double click on DG documents type.

Click on number range Information tab

Company code - TASL

Click on change Intervals

Click on Insert intervals

No	Year	From Number	To Number
16	2008	600001	700000

Press enter key and save.

Customer Documents Posting

Customer Invoice Posting (Sales)

Documents	Debit/Credit	Posting key
Customer Account	Debit	01
Sales Account	Credit	50

Your Ad Here

Customer Reconciliation Account Creation (Sundry Debtors Account)

Customer Reconciliation Account Creation (Sundry Debtors Account)

Reconciliation account is nothing but those values we are posting to our sub ledgers that values is updated to the main ledger that types of accounts are called reconciliation accounts.

Go to FS00 and select - 200012 (Sundry Debtors Account)

Click on change fields

Click on Control Data tab

Deactivate the only balance is local currency check box

Reconciliation Account for Account type – Customers

Click on Create/bank/ interest tab

Field Status Group – G067 (Reconciliation Account)

Press enter key and save.

Customer Master Data Creation ( FD01) (Customer Account Creation)

Path: Sap easy Access → Accounting → Financial Accounting → Account receivables → Master records → Create.

Account Group – TAMC

Company code – TAST

Press enter key.

Titles – Company

Name – Steel Authority of India Ltd

Search term – A

Street/house No – YS Industrial area.

Postal code/city – 123456 - Mumbai

Country – IN

Region  - 13

Click on Company Code Data tab

Account Management

Reconciliation Account – 200012

Sort key – 031 (Customer Number wise)

Click on Payments Transaction tab

Terms of Payment – 0001 (Immediate payments)

Tolerance group – TGMC

Press enter key and Click on save.

Note: Just like you can create any number of Customers.

For Changing of Customers Master Data (FD02)

Path: Same.

For Customers Display (FD03)

Path: Same.

Your Ad Here

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