Presentation

WELCOMEFOR

SAP KNOWLEDGE TRANSFER

NEW ADVANCE INTEREST

& CASH DISCOUNT PROGRAM

MAJOR CHANGES IN PROGRAM

No change in maximum claimable interest rate (i.e. 6% for 90 days) & cash discount rate (i.e. 6%)

Cash Discount applicable days reduced to 60 days, from earlier 90 days.

Cash Discount percentage rate on days slab base, earlier it was on days basis.


Interest on advance percentage rate on 15 days slab base, earlier it was on days basis

Cash discount will get calculated, but will not get posted till we got receipt realised in company’s bank account & same is reconciled.

Eliminated chance of posting of cash discount on bounced instruments.


Region has been added on selection criteria screen.

If the customer’s selected, does not belong to region selected on selection criteria, program will filter the parties belonging to region specified itself.

For customer receipts, the program will look for actual relisation date & will work out cash discount on the basis of difference in date of relisation & date of document knocked off.


Region wise applicable interest on advance’s & cash discount rates are :-

FOR NORTH,SOUTH & SOUTH CENTRAL-1.xlsx

FOR EAST,EAST-II,WEST,CENTRAL,NORTH CENTRAL & SOUTH CENTRAL-II.xlsx

ABOUT WORKING OF CASH DISCOUNT PROGRAM

Cash discount program, entirely works on document type’s.

When debit side document type’s “RV”, “AB” gets knocked off against credit side “DZ” or “SC” document types with in a clearing document , then only cash discount gets calculated.

Cash discount gets calculated on cleared amount only & not on open items.

Regular clearing is very important for correct & timely cash discount posting.

CLEARING OF OPEN ITEMS

TYPES OF CLEARING

Where receipt amount is same as of invoice amount . This is most suitable situation for standard SAP clearing, but not applicable in indofil senerio.

In case of mismatching of invoice amount and credit open balances, there can be two type’s of clearing, Indofil is following both:-First:- To partial off credit amount as according to

debit balance’s. (T.Code:- F-28)Second:- To partial off debit amount as according

to credit balances. (T.Code:- F-32).

IMPORTANCE OF CLEARING

Correct B.I aging report.

Correct, timely calculation & posting of advance interest & cash discount.

Correct working of credit limits admistration.

PARTIAL CREDIT KNOCK OFF(T.CODE :- F-28)

PARTIAL CREDIT KNOCK OFF(F-28)

While F-28, we are using very good feature of standard SAP.

“Distributing the Clearing Amount by Age”

Distributing the Clearing Amount by Age means ?

The system will automatically distribute the total clearing amount among the open items by age. In doing this, it includes the selected open items according to the sequence of the number of days in arrears.

The system will work on days is arrears & not on document date basis.

The system distributes the clearing amount as follows:

Payments on account from earlier payment transactions are always included.

Credit items have priority over debit items when items have the same number of days in arrears.

Items will be automatically activated until – the exact clearing amount is reached or

– the difference between the item total and the clearing amount does not exceed the tolerances for unauthorized deductions.

The system will work on days is arrears & not on document date basis.

The system distributes the clearing amount as follows:

System continues to activate items until the largest possible amount is reached without exceeding the clearing amount.

The remaining difference is posted on account to the account you are clearing.

PROCEDURE FOR F-28

Document date & Posting date should be same.

In case of cheques or demand draft’s the date should be the date on which you are depositing payment instrument in bank.

In case of RTGS or Fund transfer the date should be the date on which you got relisation of same in our bank account.

PROCEDURE FOR F-28

For cheque or demand draft date, one has to use value date cell.

Ticking of Distribute By Age, check box is very important for auto knocking off.

Then press “Open Process Items” push button

ON PAYMENT PROCESS OPEN ITEMS SCREEN

In process open items screen, one has to take care that:- Amount in “Not Assigned” cell should always be

zero.

Amount is “Difference Posting” cell should not be less than zero & should not be greater than “Amount Entered” amount.

MANUAL ADD-ON SELECTION OF OPEN ITEMS

While taking care of two points, just discussed, if required one can select open credit items of date of or before the document date of receipt entry.

Same way one can select add on debit items, by taking care of two earlier mentioned conditions.

WHILE SIMULATION OF ENTRY IN F-28

The differential posting entry should not be in active mode, if it is so, then the differential posting will happen in debit side of the customer account, which will be wrong.

The assignment & text field has to be copied to all the entries of customer account arm, for correct ZFI011 report.

F-28 IN CASE OF NO OPEN ITEM’S

Fill bank data, on first screen of F-28

Then on menu, select Goto, then Document overview.

Debit side of entry will appear, select posting key as 15.

Select customer code & complete the entry.

ANY DOUBTS ABOUT F-28

?

PARTIAL DEBIT KNOCK OFF (T.CODE :- F-32)

PROCEDURE OF PARTIAL DEBIT KNOCK OFF (F-32)

F-32 is to clear open items manually.

In F-32 we are adjusting credit side open item’s with debit side items, by making part of debit side items.

So we have to take the document date (clearing date), same as of last document, of which we are creating part.


Select all credit side (negative balance) open items, by sorting “INR Gross” column in ascending order.

The “Not Assigned” cell will show total of item selected in positive figure.

Sort “Document date” column in ascending order, so that debit side open items can be selected on FIFO basis.


Start selecting open debit side item of FIFO basis.

With each selection the balance in “not assigned” cell will get reduced by the amount of debit side entry selected.

One has to keep on selecting debit side open items, till amount of “Not assigned” column turns to negative


In process open items screen, one has to take care that:-

Amount is “Not Assigned” cell should always be zero.

Amount is “Difference Posting” cell should be zero or less than zero

Amount in “Assigned” column should be less than the amount of last selected debit side item

WHILE SIMULATION OF ENTRY IN F-32

The differential posting entry should always be in active mode, if it is not so, then the differential posting will happen in credit side of the customer account, which will be wrong.

In this active part of entry one has to change payment term’s to “Z002”

Text field of all the entries should be same.

IN CASE OF ADVANCE PAYMENTS

Clearing of advance can be done, only if goods have been invoiced to party of at least of same amount of advance document amount.

Cash discount & advance interest can be posted only after invoicing of at least same amount of advance document.

To get cash & advance discount posted in time, one can accept multiple cheques etc, while collecting advances.

SECURITY DEPOSIT RECEIPT (T.CODE :- F-29)

Security deposit receipt

In case of “Security deposit receipt” from customer:-

Entry is to be done by using T.Code “F-29”.

Special G/L indicator for customer security deposit is “H”

ADJUSTMENT OF SECURITY DEPOSIT

(T.CODE :- F-39)

Adjustment of Security deposit

For adjustment of “Customer Security deposit” :-

Adjustment is to be done by using T.Code “F-39”.

Document date & posting date is to be same.

Keep all other cells blank.

Adjustment of Security deposit

Press “process down payment” pushbutton.

Enter amount of security deposit to be adjusted, in “Transfer posting” cell against line item with “Special G/L indicator” “H” only

Advance payment in customer account with “special G/L indicator” “A” should not to be adjusted with T.code “F-39”

ADVANCE FROM CUSTOMER(T.CODE :- F-28 OR F-29)

ADVACE FROM CUSTOMER’S

Advance from customers can be entered in two way’s, depending on the requirement :-

First :- By T.code “F-28”, where we want that this advance payment should get adjusted on another receipt entry, if any open invoice will be there while entring next normal receipt entry of this customer.

ADVACE FROM CUSTOMER’S

Second :- By T.code “F-29” by using Special G/L indicator for “Advance from customer” “A”. where we want that this advance payment should not get adjusted on another receipt entry, & advance need to be adjusted manually.

F-28 IN CASE OF ADVANCE FROM CUSTOMER

Fill bank data, on first screen of F-28

Then on menu, select Goto, then Document overview.

Debit side of entry will appear, select posting key as 15.

Select customer code & complete the entry.

F-29 IN CASE OF ADVANCE FROM CUSTOMER

In case of “Advance from Customer” :-

Entry is to be done by using T.Code “F-29”.

Special G/L indicator for “Advance from customer” “A”

ADJUSTMENT OF “ADVANCE FROM CUSTOMER”

(T.CODE :- F-32)

Manual Adjustment of “Advance from Customer”

Adjustment is to be done by using T.Code “F-32” only & not by using “F-39”.

If entry of advance was done by using “F-29”, then we have to do adjustment by entering “Special G/L indicator” “A” in “F-32”

If entry of advance was done by using “F-28”, then we have to do adjustment by “F-32” in normal way.

CLEARING OF GENERAL LEDGER ACCOUNT’S

(T.CODE F-03)

CLEARING OF G/L OPEN ITMES

Some of general ledger accounts, we at regional level deals with, which requires clearing are :-

Cash clearing accounts

Provision for scheme accounts

Liability for expense accounts


T.code for G/L clearing is :- F-03

Incase of Clearing of “Cash Clearing accounts”

“Amount entered” column will be zero.

As amount of cash withdrawn from bank is same as cash receipt in cash journal, “Assigned” & “Not Assigned” columns should be zero.


In case of “Provision for scheme accounts” & “Liability for expense accounts”:-“Amount entered” column will be zero.

If we have consumed full amount of provision then only “Assigned” & “Not Assigned” columns should be zero.

Otherwise “Assigned” column should be in negative & “Not Assigned” column should be positive.

CHEQUE BOUNCING(T.CODE FB08 & FBRA)

WHEN TO USE FB08 OR FBRA

When while entering original receipt, no clearing of open items had happened in customer ledger, to reverse such receipts, we use “FB08”.

When while entering original receipt, clearing of open items had happened in customer ledger, to reverse such receipts, we use “FBRA”

WHEN TO RESET OTHER ENTRY TO REVERSE CHEQUE ENTRY

When partial of original receipt (which is to be reversed) got adjusted in another clearing document:-

First :- We have to reset only (by FBRA) the next clearing document.

Second:- After resetting, we have to reverse the original document by FBRA OR FB08 , depending upon, whether it was clearing document or not.

REVERSAL OF RECONCILED ENTRY

In this case one has to “Only Reset” the clearing document of bank account, by FBRA.

This document can be find out by giving “assignment” field in FBL3N.

To get clearing document of receipt entry in general ledger, change layout to get “Clearing Document”

TIPS FOR EFFICENT WORKING

FBL5N

Almost all the customer relating reporting, can be done by using FBL5N.

For “division specific”, “region specific”, “plant specific” or “territory specific”, “customer specific” information:-Use “search help I.D” cell as “Customers per

sales group”Fill cells as per requirement, & you can have

“division specific”, “region specific”, “plant specific” or “territory specific”, “customer specific” reports.

FBL5N

With the combination of “Dynamic selection criteria”, “ Search help I.D” & “line item selection”, one can generate any report regarding customers.

GET OWN DOCUMENT NUMERS (FB03)

ENTER RELEVANT FIELDS IN FB03 “DOCUMENT LIST” screen.

Tick “own document only” check box.

You will get list of documents posted from your user I.D.

TO COPY OR TO PASS REVERSE ENTRY

One can copy or pass reverse entry by f-02, or shift+f9 in relevant code.

Enter the document number to be copied or to be reversed.

Enter the relevant fiscal year of document number.

TO COPY OR TO PASS REVERSE ENTRY

Choose relevant option from “flow control” group.

Change document date, posting date & other relevant fields as per requrment.

Save the document.

Thank You for Your attention

Presentation

Documents

Transcript of Presentation