Sunday 16 August 2015

how to run automatic payment programme

Assignment of account for automatic postings:


Path :SPRO-Financial accounting-Accounts receivable and Accounts payable-Business transactions-Out going payments-Out going payments global settings –Define accounts for cash discount taken. (Tr Code is OBXU)

Give the Chart of Accounts                        :AML
Enter
Save
Give the account no.300101 cash discount received
Save
Press enter to save in your request

Purchase invoice posting (F-43)

Document date                                 :25.10.2008
Posting date                                      :01.11.2008
Entry date                                          :Today’s date
Type                                                   :KR
Company code                                 :AML
Currency                                           :INR
Posting key                                       :31
Account                                             :4200001
Enter
Amount                                              :100000
Payment terms                                 :Select AML1
Text                                                     :Purchase invoice posting
Enter
Ignore the warning message press enter
Posting key                                       :40
Account no.                                      :200120 Inventory raw material
Enter
Amount                                              :*
Business area                                  :AMLH
Text                                                     :+
From the menu select document –Simulate and Save



Go and see the vendor account (Transaction code is FBL1N):

Vendor account                               :4200001
Company code                                 :AML
Select open item radio button
Select normal items check box
Execute
Form the menu select change layout button
Form the hidden fields column
Select current cash discount amount
Select amount in document currency under column-contain
Select left arrow or show selected fields button
Select copy button

Outgoing payment with clearing (F-53)

Document date                                 :Today’s date
Type                                                   :KZ
Company code                                 :AML
Clearing text                                     :Out going payment
Account under bank data               :200105 SBI current account
Business area                                  :AMLH
Amount                                              :97000
Text                                                     :out going payment
Account                                             :Under open item selection 4200001
Select process open items button
Double click on payable amount              :100000
From the menu select document Simulate
We get a message correct the marked line items.
Double click on blue font
Text enter                                          :+
Save

Automatic payment program (APP)

System will                                        -Check due dates
                                                            -Issue check
                                                            -Pass the enter and cleared party account
                                                            -Generate payment advance
                                                            - update check register
The check lot should be sequential –we are not programmer –system given payment program.
Check format and payment advice format
APP will be used by cash rich companies
They run weekly / for every 10 days /For every 15 days

At the time of APP run, we have to give bankwise ranking with available amounts.
            SBI                  1                      1000000
            IDBI                2                      500000
            ICICI               3                      300000
It will issue checks from SBI upto 10 lakhs. Then afterwards it issued form IDBI upto 500000 – Then it goes to ICICI and issued up to 3000000

After run, it gives a proposal – In the proposal it shows for which parties for which bills from which bank it is going to issue to checks.

We can edit proposal                                  By blocking some invoices for payment
                                                                        Or
                                                            By charging bank

Due                Party X                       Party Y
1                                             1
2                                             2
3                                             3
4                                             4
5                                             5

Black invoices 4,5 and make the payment for 1,2 and 3 use the fund for party bill payments.

System is issuing form SBI for party X 3 bills –party is having account in ICICI-Change bank from SBI to ICICI.

Setup payment methods for country for payment transactions

Path :SPRO –Financial accounting-Account receivable and account payable –Business transactions-Outgoing payments –Automatic outgoing payments  -Payment method /Bank selection for payment program-Setup payment method per country for payment transactions 

Select new entries button
Country                                                          :IN
Payment method                                          :B
Description                                                    :Check
Select outgoing payments radio button
Select check radio button
Document type for payment                       :KZ
Clearing document type                             :KZ
Payment medium program                         :RFFOUS_C
Name of print date set                                 :LIST1S
Save
Press enter to save in your request


Setup payment methods per company code for payment transactions:

Same path
Select new entries button
Paying company code        :AML
Payment method                  :B
Minimum amount                 :10
Maximum amount                :9999999999
Select payment per due day check box
Select from data button
From for the payment medium:
_PRENUM_CHECK
Drawer on the form              : for Aravind Mills Limited
Authorized signatory
Save
Press enter to save in your request

Setup all company codes for payment transactions:

Same path

Select new entries button
Company code                     :AML
Paying company code                    :AML
Separate payment per business area  check box
Out going payment with cash discount from : Bank interest rate  1.5% per month
                                                                                            18% per annum
Payment term:         
If we make the payment within 30 days we get -1% cash discount
Due within 60 days
System will payment 60 days since discount is less than bank interest rate.
Within 30 days         :Interest for  month 1.5
Within 60 days         :Interest for month 1.5+1.5

Payment terms:
If we make the payment within 30 days we get 2% cash discount.
Due with in 60 days
System will within 30 days since discount more than bank interest rate.

Maximum cash discount:
Payment term:
If we make the payment within 30 days we get 1% cash discount. Due within 60 days.
Though we are not entitled, system claims 1% cash discount and make the balance payment only even if it is paid with 60 days.
Special GL transaction to be paid under vendors : Select  A (Advances)
Save
Press enter to save in your request


Setup paying company codes for payment transactions:

Same path

Select new entries button
Paying company code                    :AML
Select forms button
From for the payment advise F110_D_AVIS
Select sender details button
Text ID            :Select ST (ST stands for Text)
Letter header                                                :F_0001_HEADER
Footer                                                             :F_0001_FOOTER
Sender                                                           :F_0001_SENDER
Save and Press enter to save in your request

Creation of sequential check lots (FCHI)

Paying company code                                :AML
House bank                                                  :SBI
Account ID                                                    :SBI1
Select change button
Select create button
Lot number                                                    :2
Check number                                             :800001
To                                                                    :801000
Deselect non-sequential check box
Short information                                         :SBI
Purchase date                                              :Today’s
Enter and save

Assign payment methods in vendor master:

Path :Accounting-Financial accounting –Accounts payable-Master records –Maintain centrally-Change (XK02)

Give the vendor no.             :4200001
Company code                     :AML
Select payment transaction check box under company code data
Enter
Payment methods                :Select ‘B’
Payment block                      :If we don’t want to make the payment to this party in this
run,  select -Skip account

Alternative payee                 :We have purchased from Birla Chemicals Limtied –BCL has to make the payment to party XYZ –BCL instructs us to make the payment to XYZ-in alternative payee give XYZ no. when we run APP ,check will be in the name of XYZ and party clearing will be BCL

House bank                          :BCL in having account in ICICI –It instructs us to issue check from ICICI only – We give house bank ICICI- check we issued only form ICICI.
Individual payment              :When we run APP, it will issue one check only for all the bills due –some parties ask us to issue separate check for each bill. Select individual payment check box.
Separate check  will be issued for each bill.
Select save button or Ctrl+S



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
Rank 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





No comments:

Post a Comment