ACCOUNTS RECEIVABLE (A/R)

ACCOUNTS RECEIVABLE (A/R)

    

This is also a Sub Ledger (Subsidiary Ledger)                                                                                                             

                                                                                                                       

This is used when Sales & Distribution (SD) Module Is not implemented-All types of sales.                                                                                                                  

Eg: Product Sale/Raw Material Sale/Scrap Sale                                                                                              

When Sales & Distribution(SD) Module is implemented-This is used for Raw Material Sale /Scrap Sale/Asset Sale-(Other than Product Sale)                                                                                                                                                                                                       

At the time of sale:  

                                                                                                           

Customer Account Dr                                 Sub ledger    Sundry Debtors(General Ledger)                                                                         |                                   |                                      TO SALES                                        General Ledger                    |                      

                                                                                                            |                                                                                                                                               |                                                                                                                                   Reconciliation Account                                                                                                                  Or                                   

                                                                                                Control Account                                                                  

BASIC SETTINGS FOR ACCOUNTS RECEIVABLE:

1.Creation Of Customer Account Groups                                                                                                          

A)FI Customers                                                                                                       

Asset Sale/Scrap Sale/RM Sale                            Reconciliation account field

Parties

                                                                                                           

B)SD  CUSTOMERS                                                           Required Entry field

PRODUCT SALE PARTIES                                                                                             

2.Create number ranges for customer accounts                                                                                                          

3.Assign number ranges to customer account groups                                                                                                

4.Creation of 2 GL masters                                                                                                           

A)Sundry Debtors-                                                   "Current Assets,Loans&Advances"                                                        

B)Sales Account                                                      Sales                                                 

5.Creation Of Customer Master                                                                           

6. Document Types And No.Ranges                                                                   OBA7

                                    DR      Customer Invoice                           

                                    DZ       Customer Payment                        

                                    DA      Customer Document For                          

                                                Transfers/Reversals           

                       

7.Posting Keys                                 01        Customer Debit                               

                                                            15        Customer Credit                              

We test a scenario where vendor is a customer                                                                                   

                        Party BCL                                                     Party BCL      

Purchase                                           100000           Sales                100000

Sales                                                    20000           Purchase        20000

                                                            --------                                        -------

Net Payable                                        80000           Net Receivable  80000

When we Pay/Receive net amount we have to clear vendor transactions and customer transactions at a time                                                                           

Note : Create receipt terms (if any cash discount debit -  Debit expenses )

                                                                                   

1.SALES INVOICE POSTING:

Creation of customer account groups

Path: SPRO- Financial Accounting- Account Receivables and accounts payables customer accounts – Master data- Preparation for creating customer master data- Define account groups with screen layout (customers)  

Select new entries button

Account group          : AML1

Name                         : FI Customers for AML

Double lick company code data

Double click account management

Reconciliation account make it required entry filed

Save

Select create request button

Short description for AR customization for AML

Press enter

Enter once again to Save in your request

Select next entry button

Account group                      : AML2

Name                                     : SD customers for AML

Double click on company code data

Double click on account management

Reconciliation account make it required entry filed.

Save.

Create No. range for customer accounts:

Path :Upto preparation for creating customer master data the path is same.-Create no. range for customer accounts (Tr.code is XDN1)

Select change intervals button

Select interval button

No. range                              :23

From no.                                :6600001

To no.                                     :6700000.

Enter

Select interval button once again

No.range                               :24

From no.                                :6700001

To no.                                     :6800000

Enter and Save

Ignore the warning message press enter

Assign Number ranges to customer account groups:

Same path

Select position button

Account group                      : AML1

Enter

For AML1       Assign no.range :23

For AML2       Assign no.range :24

Save

Press enter to save in your request

Define tolerance group for Customer

Path :SPRO-Financial accounting-Account receivable and account payable-Business truncations-incoming payments-manual incoming payments-Define tolerances(Customers)

Select new entries button

Company code                                 :AML

Tolerance group                               : Blank

Description                                        :Tolerance group for AML

Save

Press enter save in your request

Creation of GL Masters (FS00):

Give the GL account no.                 :200110

Company code                                 :AML

Select with template button

Give the GL account no.200150 advance to vendors

Company code                                 : AML

Enter

Change short text and GL account long text to Sundry Debtors

Select control data tab

Change reconciliation account for account type to customers

Change sort key to 031 customer number

Select Create / Bank / Interest tab

Field status group                            :G067

Save

GL account no                                  :300000

Company code                                 :AML

Select with template button

Change GL account 300100 Exchange gain

Company code                                 :AML

Enter

Select type/description tab

Change the account group to sales/.

Change short text and GL account loge text to sales account

Other fields are common

Select save button or Ctrl+S

Creation of customer master

Path: Accounting- Financial accounting –Accounts receivables-Master records-Maintain Centrally-Create (Tr.Code is XD01)

Account group                                  :select FI customer for AML

Company code                                 :AML

Enter

Title :                                                   : select Company

Name                                                 : BIRLA Chemicals Limited

Country                                              : IN for India

Select control data tab

Vendor                                               :4200001

Select company code data button

Reconciliation account                   :200110 Sundry debtors

Sort key                                              :031 (Customer no.)

Select payment transaction tab

Terms of payment                            :0001 payable immediately due net

Save

Document type number ranges (OBA7)

Select type Dr customer invoice

Select details button

No.range                                           :18

Select no.range information button

Company code                                 :AML

Select change intervals button

Select intervals button

No.range                                           :18

Year                                                    :2008

Form no.                                            :400001

To no.                                                 :500000

Enter and save

Ignore the warning message press enter

Select back arrow 3 times

Select type                                        :DZ (Customer payment )

Select details button

No. range                                          :14

Select no.range information button

Company code                                 ::AML

Select change intervals button

Select interval button

No.range                                           :14

Year                                                    :2008

From no.                                            :500001

To no.                                                 :600000

Enter and save

Ignore the message press enter

Select back arrow three times

Select type                                        :DA (customer document)

Select details button

No.range                                           :16

Select no.range information button

Company code                                 :AML

Select change interval button

Select interval button

No.range                                           :16

Year                                                    :2008

Form no.                                            :600001

To no.                                                 :700000

Enter and save

Ignore the warning message press enter

END USER AREA

END USER AREA

Purchase invoice posting (F-43)

Document date                    :Today’s date

Type                                       :KR

Company code                     :AML

Posting key                           :31

Account no.                          :4200001

Enter

Give the amount                  :9999

Business area                      :AMLH

Text                                         :Purchase invoice posting

Posting key                           :40

Account no.                          :200120 Inventory raw material

Enter

Amount                                  :*

Business area                      :AMLH

Text                                         :+

Document –Simulate and save

Setup bank determination:

Path :Accounting –Financial accounting –Accounts payable-Periodic processing-Payments (Tr code is FBZP)

From the menu select Environment maintain -Configuration

Automatic payment program –Customization one –Screen FBZP

Select bank determination button

Select position button

Paying company code        :AML

Enter

Select AML

Double click on ranking order folder

Select new entries button

Payment method                 :B

Currency                               :INR
Bank order                            :1

House bank                          :SBI

Save

Press enter to save in your request

Double click on bank accounts folder

Select new entries button

House bank                          :SBI

Payment method                 :B

Currency                               :INR
Account ID                            :SBI1

Bank sub account               :200105 (SBI current account)

Business area                      :AMLH
save

Double click available amounts folder

Select new entries button

House bank                          :SBI

Account ID                            :SBI1

Days                                       :999

Currency                               :INR
available for outgoing payment :1000000

Save

Automatic payment program run (Tr code is F110)

Path :Up to  periodic processing the path is same- Payments (Tr code is F110)

Run date                               :Today’s date

Identification                         :AML1

Select parameter tab

Company codes                   :AML

Payment methods               :B

Though we have given the date, we can run tomorrow it self

Payment term                       :If we make the payment  within 10 days we get 2% cash discount  (Dues within 30 days)

Purchase today                    :07.11.2008

If we make the payment to day -2%

If we make the payment on 14.11.2008 2%

System will not issue check today’s – It will issue in the next run since the discount amount is same.

It control the cash flows

Party bill date                        :07.11.2008

Payment term                       :AML2             30 days credit 07-12-2008

APP run today                      : It  asks next Posting date :14.11.2008

APP run2                              :14.11.2008                           21.11.2008

Next payable date                :14.11.2008

Next posting date                 :14.11.2008

Vendor from                          :4200001

Vendor to                               :4300000

Save

Select bank arrow

Select proposal button (Shift +F1)

Select start immediately check box

Enter

Go on press enter (Basic Tr code box green tick mark box)

Till we get the message payment Proposal has been created

To edit the proposal -Select any proposal button enter (Shift +F4)

Double click on vendor no.

To block on invoice for payment

Double click on document no.      :100001

Payment block                                 :Select A (Block for payment )

Enter

To change bank for second bill

Double click on document no.      :100004

Select reallocation button

Payment method                             :B

House bank                                      :SBI

Account ID                                        :SBI1

Enter

Save

Select bank arrow two times

We get a message payment proposal has been edited

Select payment run button

Enter

Go on press enter .

It we get the message payment run has been carried out.

To take check printing:

Select printout / data medium tab for the program RFFOUS_C

Give the variant                                :A1

Select maintain variants button

Select for all selection screen radio button

Select continue button

Program run date                             :07.11.2008

Identification feature                       :AML1

Paying company code                    :AML

Payment method                             :B

Business area                                  :AMLH

House bank                                      :SBI

Account id                                         :SBI1

Check lot no.                                                :2

Select print checks check box

Printer                                                :LP01

Select print immediately check box

Select print payment advice notes check box printer :LP01

Select print immediately check box

Select print payment summary check box

Printer                                                            :LP01

Select print immediately check box

No.of sample print outs                              :0

Select don’t void any checks check box

Select attributes button (F5)          

Meaning                                                        :SBI check printing date 08.11.2008

Save

Select back arrow

Save once again

Select bank arrow

Select print out button

Select start immediately check box

For job name –in place of question of mark –Give variant A1

A1                   Company code         :AML

                        Business area                      :AMLH

                        Bank                           :SBI

                        Account ID                :SBI1

                        Check lot no.                        :2

Parameters are saved in the variant in place of question mark A1

Press enter

Enter once again

To view check printing 

From  the menu select system –Services output control

Select execute button

Select spool no.check box for check

Select display contents (F6)

Go and see the vendor Account FB11N

Give the vendor account                :4200001

Company code                                 :AML

Select cleared items radio button

Select normal items check box

Execute

Double click on document type    :KZ 

For the amount                                :9999

Select call up document overview button (F9)

Select display document header button

Enter

From the menu select Environment check information

Go and see the check register (FCHN)

Give the paying company code    :AML

Execute

Credit memo postings

Purchase from Birla Chemicals Limited

If the material is not good

Return the material or reduce the amount (Price)

BCL will issue credit note to mail or AML raises Debit note  on BCL

Both are same

Doc type                                :KG (Credit memo)               KA

No.range 17                                                                          17

No need to give no.range interval already we have given earlier

Path :Accounting- Financial accounting –Accounts payable –Document entry –Credit memo general (F-41)

Document date                    :Today’s date

Type                                       :KG (Vendor credit memo)

Company code                     :AML

Posting key                           :21 Credit memo

Account                                 :4200001

Enter

Give the amount                  :1000

Business area                      :AMLH

Text                                         : Credit memo posting

Posting key                           :500

Account no.                          :200120 Inventory raw material

Enter

Amount                                  :*

Business area                      :AMLH

Text                                         :+

From the menu select Document –Simulate and save

Note:   Cash journal postings – not accept negative balances

              Normal postings  Accept negative postings