SAP AR Config

download SAP AR Config

of 29

Transcript of SAP AR Config

  • 8/18/2019 SAP AR Config

    1/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    1

    ACCOUNTS RECIVABLES TOPICS

    1. Basic Settings in IMG2. Basic settings in Easy Access3. Posting of customer Invoices4. Clearing of Open Items5. Treatment of Advance Received from customer6. Bills of Exchange7. Dunning8. Party Statement of Accounts9. Credit Notes to Customer10. Discount allowed to Customer11. Computation of Sales Tax

    12. Integration between FICO & SD Modules13. MIS for Accounts Receivables

    Configuration Steps:

    1: BASIC SETTINGS IN IMG

    Step1: Define Account Groups with Screen Layout [Customer]T.Code: OBD2

    PATH: Financial Accounting (New) Accounts Receivable and Accounts Payable

    Customer Accounts Master Data Preparations for Creating Customer Master Data Define Account Groups with Screen Layout (Customers)

    Click on New Entries(a). Create Account Group

    Account group: NBDC:General Data:

    Name: DOMESTIC CUSTOMER GRP FOR NBFAField Status:Double click on General Data Double click on Address Select Name 1/last name as

    Required Entry Go Back for 2 timesDouble click on co. code data Double click on Account Management SelectReconciliation account as Required Entry come back for 2 times

    Save It

    (b). Create Account Group NBFC for FOREIGN Customer Group

  • 8/18/2019 SAP AR Config

    2/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    2

    Account group: NBFCGeneral Data:

    Name: FOREIGN Customer Group -NBFAField Status:

    Double click on General Data Double click on Address Select Name 1/last name asRequired Entry Go Back for 2 timesDouble click on co. code data Double click on Account Management SelectReconciliation account as Required Entry come back for 2 times

    Save It

    Step2: Create Number Ranges for Customer AccountsT.Code: XDN1

    PATH: Financial Accounting (New) Accounts Receivable and Accounts Payable Customer Accounts Master Data Preparations for Creating Customer Master Data

    Create Number Ranges for Customer Accounts

    Click on Change Intervals Again Click on Insert Interval New Interval: No From No. To No. Current No.01 500101 500200

    Note: Drill down the numbers & select which one is AvailablePress Enter Again click on Insert Interval

    New Interval: No From No. To No. Current No.02 500201 500300

    Press Enter Save It

    Step3: Assign Number Ranges to Customer A/c GroupsT.Code: OBAR

    PATH: Financial Accounting (New) Accounts Receivable and Accounts Payable Customer Accounts Master Data Preparations for Creating Customer Master Data Assign Number Ranges to Customer Account GroupsGroup Name Number Ranges

    NBDC DOMESTIC CUSTOMER GRP-NBFA 01 NBFC FOREIGN CUSTOMER -NBFA 02Save It

    Step4: Define Document Types and No. Ranges for Account Receivable documents.T.Code: OBA7

    Note: We need not use any new document types. Use the document types which are provided by the SAP.PATH: Financial Accounting (New) Financial Accounting Global Settings (New) Document Document Types Define Document Types for Entry View

  • 8/18/2019 SAP AR Config

    3/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    3

    Double click on DR-Customer InvoiceJust observe that No. Range is given by SAP is 18 don’t changeClick on Number Range Information Enter Company code: NBFA Click on ChangeIntervals Click on Insert Intervals

    New interval:No Year From No. To No. Current No.18 2011 18,00,001 19,00,000Press Enter Save It Come back for 3 times.

    Double click on DZ-Customer PaymentProperties:

    Number range: 14 Click on Number Range Information Company code: NBFA Click on Change Interval Click on Insert IntervalNew interval:

    No Year From No. To No. Current No.14 2011 14,00,001 15,00,000Press Enter Save It Come back for 3 times.

    Double click on DG-Customer Credit MemoProperties:

    Number range: 16 Click on Number Range Information Company code: NBFA Click on Change Interval Click on Insert IntervalNew interval:No Year From No. To No. Current No.16 2011 16,00,001 17,00,000Press Enter Save It Come back for 3 times.

    CUSTOMER RELATED DOCUMENTSNO RANGE NITERVAL

    DOCTYPE DISCRIPTION NO YR FROM TO

    DGCustomer creditmemo 16 2012 1600001 1700000

    DR Customer invoice 18 2012 1800001 1900000DZ Customer payment 14 2012 1400001 1500000

    Step5: Define Tolerance Group for CustomersT.Code: OBA3

    PATH: Financial Accounting (New) Accounts Receivable and Accounts Payable Business Transactions Incoming Payments Manual Incoming Payments DefineTolerances (Customers)

    Click on New EntriesGive Company code: NBFATolerance Group: SA01 Tolerances for Customer-NBFA

  • 8/18/2019 SAP AR Config

    4/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    4

    Grace days due date: 3Press enter Save It

    2: BASIC SETTINGS IN EASY ACCESS

    Step1: Define G/L Accounts for(a). Sundry Debtors-For DOMESTIC SALES(b). Sundry Debtors-FOREIGN CUSTOMERS(c). Sales account- FERRO ALLOY

    Go To FS00-Centrally (a). G/L Account: 200301

    Comp.code: NBFAAccount Group: Sundry Debtors

    Select the Radio Button Balance Sheet A/cShort Text: S.Drs for Main productG/L Acct Long Text: Sundry debtors for main salesControl Data:Recon.account for acct.type: D--customersCheck the box Line Item DisplaySort Key: 031 ---Customer NoCreate/Bank/Interest:Field status Group: G067 — Reconciliation AccountsSave It

    (b). G/L Account: 200302Comp. code: NBFA

    Click on With TemplateG/L Acct: 200301Company code: NBFAChange the TextShort Text: S.Drs-Misc.salesG/L Acct Long text: S.Drs-Miscellaneous salesSave It

    (c). G/L Account: 300001Comp.code: NBFAAccount Group: SalesSelect the Radio Button P&L statement A/cShort Text: Sales CementG/L Acct Long Text: Sales CementControl Data:Check the box Line Item Display

  • 8/18/2019 SAP AR Config

    5/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    5

    Sort Key: 001 ---Posting DateCreate/Bank/Interest:Field status Group: G001 — General [with text allocation]Save It

    (d). G/L Account: 300002Comp. code: NBFA

    Click on With TemplateG/L Acct: 300001Company code: NBFAChange the TextShort Text: Sales white CementG/L Acct Long text: Sales white CementSave It

    Step2: Create Customer Master RecordsT.Code: FD01

    PATH: Accounting Financial Accounting Accounts Receivable Master Records FD01 – Create

    1. Select the Account Group: NBDC-DOMESTIC CUSTOMER GRP Press Enter

    Title: Company Name: SUN Cement DealersSearch term ½: SUNStreet/House No: KukatpallyClick on Company code dataAcc. Management:Recon. Acct: 200301 sort key: 031Payment Transactions:Terms of payment: 0001 Tolerance group: GR01Save It

    2. Select the Account Group: NBDC-DOMESTIC CUSTOMER GRP -NBFA PressEnterTitle: Company

    Name: MOON Cement DealersSearch term ½: MOONStreet/House No: AmeerpetClick on Company code dataAcc. Management:Recon. Acct: 200301 sort key: 031Payment Transactions:Terms of payment: 0001 Tolerance group: SA01

  • 8/18/2019 SAP AR Config

    6/29

  • 8/18/2019 SAP AR Config

    7/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    7

    Click on General Ledger View

    ● To view the Customer account T. code: FD10N PATH: Accounting Financial Accounting Accounts Receivable Accounts

    FD10N Display BalancesEnter the Customer No:

    Company code:Fiscal year:

    Click on Execute or (F8)

    4. CLEARING OF OPEN ITEMS:(a). Complete Clearing(b). Partial Clearing

    (a). Complete Clearing: In case of Complete Clearing the amount received is equal to

    invoice. The amount received is linked up with invoice amount & can be cleared. In thegiven scenario the invoice amount is 1, 25, 000/-. The incoming payment is receivedfrom customer is Rs. 1, 25, 000/- and clear the Open Item.● Post the entry for incoming payment:PATH: Accounting Financial Accounting Accounts Receivable DocumentEntry F-28 - Incoming Payments

    Do. Date: 16.11.2011Po. Date: 16.11.2011Bank Data:Account: 200410

    Amount: 1, 25, 000/-Text: Complete clearingOpen Item Selection:Account: 6201After completing this Click on Process Open Item TabDeactivate other line items & keep the invoice to which payments has been received inActive mode.After deactivating the other line items you can observe that amount entered & amountassigned will be equal.

    Save It

    Go to FD10N & View the Customer A/c

    (b). Partial Clearing:Scenario amount outstanding: 1, 33, 000/-1St payment – 60, 000/-2nd payment – 40, 000/-3rd payment – 33, 000/-

  • 8/18/2019 SAP AR Config

    8/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    8

    Go to F-28- Incoming PaymentsDo. Date: 16.11.2011Po. Date: 16.11.2011Clearing Text: Partial Clearing

    Bank Data:Account: 200410Amount: 60, 000/-Text: Partial Payment ReceivedOpen Item Selection:Account: 6201Click on Process Open Item TabClick on Partial Payment TabKeep the curser in the payment amount column & double click. Then the amount enteredwill appear and below amount entered & amount assigned will be equal.

    Save It

    ● To View the open item T. Code: FBL5N PATH: Accounting Financial Accounting Accounts Receivable Accounts FBL5N- Display/Change Line Items

    Enter the Customer Account: 6201Company code: NBFA

    Status:Select the Radio button Open Item Click on Execute Button

    Post the incoming entry for 40, 000/- in T. Code: F-28Do. Date: 16.11.2011Po. Date: 16.11.2011Clearing Text: Partial ClearingBank Data:Account: 200410Amount: 40, 000/-Text: Partial Payment ReceivedOpen Item Selection:Account: 6201Click on Process Open Item Tab

    Click on Partial Payment TabKeep the curser in the payment amount column & double click.

    Save It

    Again Post the incoming entry for 33, 000/- in T. Code: F-28Do. Date: 16.11.2011Po. Date: 16.11.2011

  • 8/18/2019 SAP AR Config

    9/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    9

    Clearing Text: Partial ClearingBank Data:Account: 200410Amount: 33, 000/-

    Text: Partial Payment ReceivedOpen Item Selection:Account: 6201Click on Process Open Item TabSince this is the final payment amount entered & amount assigned will be equal.

    Save It

    Go to T. Code: FBL5N Select the Radio Button Cleared Items Execute

    ● MANNUAL CLEARING

    In case open items are not cleared at the time of receiving the payment we can clearthe same manually.

    PATH: Accounting Financial Accounting Accounts Receivable Accounts F-32(clear)

    Enter the account no: 6201Click on Process Open Item

    In this case invoice is 1, 00, 000/- & payment received are 70, 000/- & 30, 000/- just save

    the document. Once we save, System generates a document without any line items.

    5. TREATMENT OF ADVANCE RECEVIED FROM CUSTOMER

    Normal entry when sale is madeCustomer a/c dr ( S. Drs )

    To SalesWhen payment is recd

    Bank A/c DrTo Customer A/c (S. Drs A/c)

    Accounting Entries for Advance Scenario:

    1. When advance is received from customer

    Bank a/c Dr ‘A’ SPL GL INDICATOR

  • 8/18/2019 SAP AR Config

    10/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    10

    To Customer a/c (Advance from Customer a/c)Spl GL a/c, Recon A/c

    2. when sale is made AGAINST ADVANCE

    Customer a/c Dr (S. Drs)To Sales a/c

    3. Transfer balance from special G/L to normal G/Li.e. Transfer of balance from advance from customer a/c to sundry debtors a/c

    Customer a/c Dr (Advance from Customer)To Customer a/c ( S.Drs)

    4. Clear the open Items manually

    Configuration Steps:

    Step1: Define G/L account for Advance from CustomerGo to T. code: FS00 & create G/L account for advance from customer account.

    G/L account: 100801A/c Group: advances from customerSelect the Radio button Balance sheet accountShort text: Advance from customerG/l acct long text: Advance from customerCheck the box Line item display

    Recon acct.: CustomerSort key: 001Field status group: G067

    Save It

    Step2: Establish a link between sundry debtors & advance from customer account

    PATH: IMG Financial Accounting (New) Business Transactions Down PaymentReceived Define Reconciliation Accounts for Customer Down Payments

    T. code: OBXR

    Double click on A --- Down paymentEnter Chart of account: SACAPress enterRecon. Acct: 200301 Special G/L acct: 100801

    Save It

  • 8/18/2019 SAP AR Config

    11/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    11

    Step3: Business Process Steps(A). Post an entry for receipt of advance.Path: Accounting Financial Accounting Accounts Receivable DocumentEntry Down Payment F-29 - Down Payment

    Do. Date: 17.11.2011 Type: DZPo. Date: 17.11.2011 Period: 08Customer: 6201 special G/l ind: ABank:Account: 200410Amount: 1, 55, 000/-Value Dt: 17.11.2011Text: Advance from customer receivedPress enterAmount: 1, 55, 000/-Over view & Save It

    (B). Post an entry for sale of goods against advancePost in F-22 - (Invoice General)

    Do. Date: 17.11.2011Po. Date: 17.11.2011

    First Line Item:Ps. Ky: 01 A/c: 100801Press EnterAmount: 1, 55, 000

    B. Area: NBHYB. Line Date: 17.11.2011Text: Sale of Goods against Advance

    Next Line Item:Ps. Ky: 50 A/c: 300001Press EnterAmount: 1, 55, 000B. Area: NBHYText: Sale of Goods against AdvanceClick on overview

    Save It

    (C). Transfer the balance from special G/l to normal G/lPath: Accounting Financial Accounting Accounts Receivable DocumentEntry Down Payment F-39- Clearing

    Do. Date: 17.11.2011Po. Date: 17.11.2011

  • 8/18/2019 SAP AR Config

    12/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    12

    Account: 6206Text: Transfer the balance from special G/l to Normal g/lClick on Process down pmnts TabKeep the curser in the Transfer posting column Double click

    Save It

    To view the DocumentGo to Document display Click on G/l acct. view

    (D). Clear the OPEN ITEMS manuallyGo to F-32- clearAcct: 6206 Press EnterSave It

    6. BILLS OF EXCHANGE

    Accounting entries:1. When sale is made

    Customer a/c Dr (S. Drs) 100To Sales a/c 100

    2. When bills of exchange is received from customer

    Customer a/c Dr (Bills of exchange a/c) SPL GL A/C 100 ‘W’ To Customer a/c (S. Drs) NORMAL GL 100

    3. When bills of exchange is Discounted with bankBank a/c Dr 98Discount charges a/c Dr 2

    To Bank Bills Discounting a/c 100

    4. On due date when bill is honored reverse the contingent liability.

    Bank bills discounting a/c DrTo Customer a/c (Bills of exchange)

    Configuration Steps:

    Step1: Create G/L accounts for(a). Bills of exchange a/c(b). Discount charges on bills a/c(c). Bank bills Discounting a/c

    NOTE: Bills of exchange is a current asset, Sundry debtors is also current asset. So in thegroup of Sundry debtors we create Bills of exchange a/c.

    Go to FS00 Create

  • 8/18/2019 SAP AR Config

    13/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    13

    (i). Bills of Exchange A/cG/l Acct: 200305Co. code: NBFA Click on Create TabAccount group: Sundry Debtors

    Select the Radio button Balance sheet acctText: Bills of ExchangeControl data:Recon. a/c type: CustomersCheck the box Line Item DisplaySort Key: 031Create/Bank/Interest:Field status group: G067Save It

    (ii). Discount charges on Bills a/c

    G/l Acct: 400501Co. code: NBFA Click on Create TabAccount group: Financial chargesSelect the Radio button Profit & loss acctText: Discount charges on Bills a/cControl data:Check the box Line Item DisplaySort Key: 001Create/Bank/Interest:Field status group: G001Save It

    (iii). Bank Bills Discounting a/cG/l Acct: 100501Co. code: NBFA Click on Create TabAccount group: Current LiabilitiesSelect the Radio button Balance sheet acctText: Bank Bills Discounting a/cControl data:Check the box’s Open item management & Line Item DisplaySort Key: 001[Open item management means all the open items will be managed by the system

    automatically by checking the open item management check box.]Create/Bank/Interest:Field status group: G005Check the box Post automatically onlySave It

    Step2: Establish link between sundry debtors a/c and Bills of exchange a/cT. code: OBYN

  • 8/18/2019 SAP AR Config

    14/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    14

    PATH: IMG Financial Accounting Bank Accounting Business Transactions bills of Exchange Transactions Bills of Exchange Receivables Post Bills ofExchange Receivables Define Alternative Reconcile Acct for Bills/Exch Receivable

    Double click on W – Bills of Exchange ReceivableEnter the Chart of accounts: SACARecon.a/c Special G/l a/c200301 200305Save It

    Step3: Define alternative a/c for Bills of Exchange TransactionsT. code: OBYH

    PATH: IMG Financial Accounting Bank Accounting Business Transactions bills of Exchange Transactions Bills of Exchange Receivables Post Bills ofExchange Receivables Define Alternative Reconcile Acct for Bills/Exch Receivable

    This step is for recording of Bank discounting charges automatically

    Double click on Bank Discount Charges — BDSEnter the Chart of accounts: SACAA/c400501Save It

    Step4: Define Bank Sub accountsPATH: Financial Accounting Bank Accounting Business Transactions B/EReceivable Present B/E Receivable at Bank Define Bank sub accounts

    T. code: OBYKClick on New EntriesCh.Ac Bank

    a/cUsage SGL in Customer

    ReconBank sub a/c forliab

    SACA 200410 D Discounting W 200301 100501

    Save It

    Business Scenario1. Post the entry for customer sales.2. For the sale we have received B/E from customer hence post entry for receipt of

    B/E.3. Whatever the bills are we have received, Discount it with bank, hence post entry

    for receipt of cash on discounting the bills.4. Reverse the contingent liability upon honoring the bills by customer.

    Step5: Entries in SAP

  • 8/18/2019 SAP AR Config

    15/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    15

    1. Post invoice to the customer in F-22Do. Date: 17.11.2011Po. Date: 17.11.2011

    First Line Item:Ps. Ky: 01 A/c: 6206Press EnterAmount: 1, 66, 000B. Area: NBHYB. Line Date: 17.11.2011Text: Sale of cement

    Next Line Item:Ps. Ky: 50 A/c: 300001Press Enter

    Amount: 1, 66, 000B. Area: NBHYText: Sale of cementClick on overviewSave It

    2. Post entry for receipt of bills of exchange from customer.PATH: Accounting Financial Accounting Accounts Receivable Document Entry Bills of Exchange F-36 Payment

    Do. Date: 19.11.2011

    Select the Radio button Incoming of PaymentPs ky: 09 A/c: 6206 SGL Ind: W Special G/l DebitPress enterAmount: 1, 66, 000/-Text: bills of Exchange Received Towards PaymentDue on: 31.12.2011Planned Usage: D. DiscountingClick on Choose Open ItemsCompany code: NBFASpecial G/L Ind: WClick on Process Open Items

    Save ItView the Document Display Click on General Ledger viewView the Customer a/c in FD10N (Remember the Doc. No of this entry)

    3. Post the entry for Discounting of the B/E.PATH: Accounting Financial Accounting Accounts Receivable Document Entry Bills of Exchange F-33 Discounting

  • 8/18/2019 SAP AR Config

    16/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    16

    Do. Date: 19.11.2011Usage: D Discounting/ Value date: 19.11.2011Bank a/c: 200410B. Area: NBHY

    Amount: 1, 60, 000/-Bank charges: 6, 000/-Text B/E Discounted with bankClick on Select Bills of ExchangeDoc.No Item Fis.Year1400010 1 2011

    Go to Document & Simulate

    This is the Doc. No three which we have received the B/E (Before entry Doc. No click on bank charges enters the text & save it.)

    Save It

    NOTE: (Because of the entry in step 4 without creation of bank charges G/l accountentry is made)Contingent liability is a liability, which will take a shape on happening or non happeningof an event at a future date.

    4. Reverse the contingent liabilityNote: This entry has to be posted on receiving the communication from the bank, thatthe bill has been honored by the customer on the due date.

    T. code: F-20

    PATH: Accounting Financial Accounting Accounts Receivable DocumentEntry Bills of Exchange F-33 Discounting

    Do. Date: 31.12.2011 — Due date should be enteredPo. Date: 31.12.2011G/l a/c: 200305 – Bills of ExchangeDue by: 31.12.2011Customer: 6206Click on Edit Line Items Read the message & press enter Ignore it

    Save It

    To view the document — DisplayEntry will be reversed

    7. DUNNING

  • 8/18/2019 SAP AR Config

    17/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    17

    Dunning is a German word. “To Dun” means “ to remained ”. In the corporate sector everycompany will generate remainder letters to its customers for the outstanding balances.

    In SAP system allows Dunning process automatically. System duns the openitems that appear in the customer accounts in which the overdue items create a debit

    balance. The dunning program selects the overdue open items and generates a dunningletter. While doing so we can add some charges for generating the dunning letters.

    Configuration Steps:

    Step1: Define Dunning Procedure T. Code: FBMPPATH: Financial accounting (New) Accounts Receivable and Accounts Payable Business Transactions Dunning Dunning Procedure Define Dunning Procedure Click on New ProcedureDunn. Procedure: NBFA

    Name: Dunning procedure for ANAND GroupDunning Interval in days: 10

    No. of dunning level: 4 (around & levels are available)Line item grace periods: 3Check the box Standard transaction dunningRef. dunning procedure for texts: NBFA (take your dunning procedure)Click on Dunning Texts TabMsg: Reference dunning procedure has 0 levels.Ignore the message & Press Enter.Comp. code: NBFASelect the radio button Customer Press Enter

    Click on New Company CodeCompany code: NBFA Press EnterCheck the box separate notice per dunning levelSave It Come Back Save it once again

    (i). Define Dunning Texts

    Click on Dunning Text TabCompany code: NBFASelect the radio button Customer Press enter

    Normal Dunning:

    Procedure From1 F150_DUNN_012 F150_DUNN_013 F150_DUNN_024 F150_DUNN_02[System takes 1 St part of the letter after 3 days (since grace periods) & after it generates2nd part of the letter (after 10 days after 1 st letter i.e 13) both the procedures are not same]

  • 8/18/2019 SAP AR Config

    18/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    18

    Come Back

    (ii). View/Define Dunning Levels:

    Click on Dunning Levels TabDunning Level 1 2 3 4Days in Arrears 3 13 23 33Come back

    (iii). Define Dunning Charges:

    Note: The Company can charge for the dunning letters which includes the clerk expenses& printing and stationery charges.

    Click on Charges TabDunn. Level Dunn. Charge1 252 503 754 100Come back

    (iv). Define minimum amounts if required:

    Click on Minimum amounts TabCurrency: INR Press Enter[We can assign minimum amount to be paid for Ex: Credit card]Come back Save It Ignore the Message Press Enter Come back

    Step2: Assign Dunning Procedure in Customer Master Record: T. Code: FD02

    Change customer masterEnter the Customer No.:Press EnterClick on Company code data TabClick on Correspondence TabDunning Procedure: NBFASave It

    Like this we have to assign dunning procedure to all customers.

    Step3: Execute Dunning Procedure:

  • 8/18/2019 SAP AR Config

    19/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    19

    Note: Before execution of dunning procedure see that overdue items appear as openitems. Post few invoices to the customer accounts check the open items in FBL5N. Postfew invoice entries with old date.Doc. Date: 10.11.2011

    Text: Test for DunningPost an another invoice with same entryClick on Post with referenceReference Doc. No………….. Press EnterChange the amount by double clicking overview Save It[We can also change the customer number. Post total 5 invoices with different amounts]Check the open items through FDL5N.

    ● Execution of Dunning Procedure PATH: Accounting Financial Accounting Accounts Receivable Periodic

    Processing F150-DunningRun on: 21.11.2011Identification: SA01Status: No Parameters maintained

    (i). Define Parameter

    Click on Parameter TabDunning Date: 21.11.2011Doc’s posted up to: 21.11.2011Company code: NBFACustomer: 6201 to 6206Click on Additional Log TabCustomer: 6201 to 6206Click on SaveCome to Status TabParameters are maintained

    (ii).To view the sample printout:

    Click on Individual Dunning notice Tab

    O/p device: LP01Press EnterCompany code: NBFACheck the print previewClick on Sample PrintoutCome back

    (iii). Schedule Dunning Run:

  • 8/18/2019 SAP AR Config

    20/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    20

    Click on Schedule TabO/p device: LP01Start date: 21.11.2011Start time: 00.00.00Check the box Start immediatelyClick on scheduleStatus message: Dun selection is scheduledPress EnterDun selection is completeTo view sample printout click on Sample print out TabO/p device: LP01Press EnterCustomer (From/10)

    6201Click on display

    (iv). Schedule Dunning Notice Printout:

    Click on Dunning Printout TabO/p device: LP01Click on PrintStatus message: Dun printout is scheduledPress EnterStatus message: Dun print out is complete

    (v). To view the Dunning notice it will be available in history & we can take additional printouts also.Click on Dun. History TabAccount type: D — customerCompany code: NBFACustomer: 6201 to 6206Click on Execute or F8

    Keep the cursor on the line item & click on display Dunning Notice Tab.If we want to print click on-- Copy as.

    8. Party Statement of Account

    Note: In case of party statement of accounts we can see the total transactions of the party.Whereas in case of dunning letter we can see only open items.

    Configuration steps:

  • 8/18/2019 SAP AR Config

    21/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    21

    Step1: Assign programs for correspondence types

    PATH: Financial accounting (New) Accounts Receivable and Accounts Payable

    Customers Accounts Line Items Correspondence Make & check settings forCorrespondence Types select SAP06-A/c StatementClick on Copy asCompany code: NBFA(Never disturb the other entries)Press EnterSave It

    Step2: Generation of Party Statement of AccountsT. code: FB12

    (i). Generate Request:

    PATH: Easy Access Accounting Financial Accounting Accounts Receivable Accounts correspondence Fb12- RequestCompany code: NBFADouble click on SAP06Company code: NBFACustomer: 6201Postings form: 01.04.2011Postings to: 30.11.2011Message: Account statement requested for second party also.Press EnterGive the customer number & posting.

    (ii). Generate the party account statement:

    Click on F.64 — MaintainPATH: Easy Access Accounting Financial Accounting Accounts Receivable Accounts correspondence Correspondence: SAP06Company code: NBFAClick on Execute (F8)Double click on customer number & ignore the messagePress EnterO/p device: LP01Press Enter

  • 8/18/2019 SAP AR Config

    22/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    22

    9. Computation of Discount on Sales

    The scenario isRaise the invoice to the customer with payment term 0002. That 0002 is contains

    payment term as follows.1. If payment is received within 14days then 3% cash discount will be given.2. If payment is received within 30days then 2% cash discount will be given.3. If payment is received after 30days & within 45days there is no discount.

    Note: This is the standard payment term provided by SAP.

    ● Computation of Cash Discount Configuration Steps:

    Step1: Define G/L Account for Cash Discount in FS00G/L Acct: 400201Company code: NBFAAcct Group: Trading expensesDescription:Short Text: Cash DiscountG/L Acct long text: Cash DiscountControl Data:Check the box Line Item DisplaySort Key: 001

    Create/Bank/Interest:Field Status Group: G001

    Step2: Define Accounts for Cash Discount granted.T. code: OBXI

    PATH: IMG Financial Accounting (New) Accounts Receivable and AccountsPayable Business Transactions Incoming Payments Incoming Payments GlobalSettings Define Accounts for Cash Discount GrantedEnter Chart of Accounts: SACAPress EnterSave It

    Chart of Accts: SACATransaction: SKTAccount400201Save It

    Note : Add disc percentage in OBA4 for employee tolerance group.

  • 8/18/2019 SAP AR Config

    23/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    23

    Step3: Raise the invoice to the customer with payment term 0002T. code: F-22 Invoice general

    Do.Date: 22.11.2011

    Po.Date: 22.11.2011

    First Line Item:Ps.Ky: 01 A/c: 6201Press EnterAmount: 1, 00, 000B.Area: NBHYPayment Term: 0002Text: Test for Cash Discount

    Next Line Item:

    Ps.Ky: 50 A/c: 300001Press EnterAmount: 1, 00, 000B.Area: NBHYText: Test for Cash DiscountClick on overviewSave It

    Step4: Post the entry for receipt of cash with in 15daysGo to F-28 — Incoming paymentDo. Date: 22.11.2011

    Po. Dtae: 22.11.2011Account: 200410Amount: 97, 000 Business Areas: NBHYAccount: 6201Acct. type: DClick on process open itemGo to Document Simulate See the EntryS.No Psky B. area Account Description Amount001 40 NBHY 200410 Andhra Bank 97, 000002 40 NBHY 400201 Cash dis. a/c 3, 000003 15 NBHY 6201 Sun cement 1, 00, 000Save ItPartial payment of Rs. 50, 000/- is received in 15 days & balance received after 15 days.Do. Date: 22.11.2011Po. Date: 22.11.2011Account: 200410Amount: 50, 000 B. Area: NBHYAccount: 6201

  • 8/18/2019 SAP AR Config

    24/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    24

    Click on Process Open ItemGo to Partial PaymentD-activate all line itemsSave It

    1. Credit Notes to CustomerConfiguration Steps:Step1: Define G/L Account for Quantity Rebate in FS00G/L Acct: 400202Co. code: NBFAClick on With TemplateG/l Acct: 400201Co. code: NBFAPress EnterChange textShort text: Test Quantity RebateG/l acct long text: Test Quantity RebateSave It

    Step2: Assign credit note format to company codePATH: IMG Financial Accounting (New) Accounts Receivable and AccountsPayable Customer Accounts Line Items Correspondence Make and CheckSettings for Correspondence Assign Programs for Correspondence TypesSelect SAP11- Customer Credit MemoClick on Copy as-F6Enter Company code: NBFAPress EnterSave It

    Step3: Post entry for passing on rebate to customerPATH: Easy Access Accounting Financial Accounting Accounts Receivable Document Entry F-27 - Credit Memo – GeneralDo. Date: 22.11.2011Po. Date: 22.11.2011First line item:Ps. Ky: 11 Acct: 6206Press EnterAmount: 1, 00, 000B. Area: NBHYText: Quantity Rebate to CustomerPs. Ky: 40 Acct: 400202Press EnterAmount: 1, 00, 000B. Area: NBHYText: Quantity Rebate to Customer

  • 8/18/2019 SAP AR Config

    25/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    25

    Save ItAfter saving note down the document number

    Step4: Generate the credit notes

    PATH: Accounting Financial Accounting Accounts Receivable Account Correspondence FB12 – RequestEnter Company code NBFAPress EnterDouble Click on SAP11 — Customer credit memoCompany code: NBFADoc. No: ________ [give the doc. No which was noted in the above step]Fiscal year: 2011

    Step5: Printing of Credit notePATH: Accounting Financial Accounting Accounts Receivable Account

    Correspondence F.64 – MaintainCorrespondence: SAP11Company code: NBFAClick on Execute or [f8]Double click on customer numberThen you will get a message & just ignore itO/p device: LP01

    2. Computation of Sales Tax

    Configuration Steps:

    Step1: Define sales tax procedureT. code: OBYZ

    PATH: Financial Accounting (New) Financial Accounting Global Settings (New) Tax on Sales/Purchases Basic Settings Check Calculation ProcedureDouble click on Define Procedure

    Select SATAX — Tax Procedure-NBFA — INDIADouble click on Control DataClick on New EntriesReference Step overviewStep Cou C. type Description From To A/c key100 BASB200 MWAS 100 100 MWS300 MWVS 100 100 VST

  • 8/18/2019 SAP AR Config

    26/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    26

    Press EnterStep Cou C. type Description From To A/c key100 0 BASB Base Amount200 0 MWAS Output Tax 100 100 MWS

    300 0 MWVS Input Tax 100 100 VSTSave It

    Step2: Assign Country to calculation procedureT. code: OBBG

    PATH: Financial Accounting (New) Financial Accounting Global Settings (New) Tax on Sales/Purchases Basic Settings Check Calculation ProcedureDouble click on Define ProcedureCity Name ProcedureIN INDIA SATAXSave It

    Step3: Define Tax Codes for sales & PurchasePATH: Financial Accounting (New) Financial Accounting Global Settings (New) Tax on Sales/Purchases Calculation Define Tax Codes for Sales and PurchasesEnter country: INPress EnterCountry key: INTax code: T1Properties:Tax code: T1--10% Output tax on sales of CementTax type: A — output TaxPress EnterOutput Tax — MWS give 10% & Press EnterKeep the curser on input TaxClick on Deactivate LineIt will give the message (Tax type input tax is not active)Save It

    Next entryCountry key: INTax code: T2Properties:Tax code: T2-- 12% Output tax on sales of White CementTax type: A — output TaxPress EnterOutput Tax — MWS give 12% & Press EnterKeep the curser on input TaxClick on Deactivate LineIt will give the message (Tax type input tax is not active)Save It

  • 8/18/2019 SAP AR Config

    27/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    27

    Step4: Define G/l Account for sales tax liability in FS00G/l acct: 100502Company code: NBFA

    Type/Description:Acct group: Current LiabilityShort text: Liab. For sales taxG/l acct long text: Liability for sales taxControl data:Check the boxes only balance & Local CurrencyAnd line item displaySort key: 001Create/Bank/Interest:Field Status Group: G001

    Step5: define Tax Accounts T. code: OB40PATH: Financial Accounting (New) Financial Accounting Global Settings (New) Tax on Sales/Purchases Posting Define Tax AccountsDouble click on –

    Enter your chart of accounts: SACAPress EnterAccounts are determined based onCheck the box Tax CodeSave ItTax code Account

    T1 100502T2 100502Save It

    Step6: assign the tax code in the sales G/l accountGo to FS00Enter the sales G/l Acct No: 300001Click on changeClick on Control data TabTax category + only output tax allowedSave It

    Read the warningPress Enter

    Step7: Raise the sales invoice along with taxGo to F-22 — invoice generalDo. Date: 24.11.2011Po. Date: 24.11.2011First line item:

    Output tax MWS

  • 8/18/2019 SAP AR Config

    28/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    Sai Anand – CA, FICO Faculty (Onlin e and Class Roo m Trainin g) SAP FI Certif ied.- Mob ile +91 9849129175

    28

    Ps ky: 01 Acct: 6201Press EnterAmount: 1, 00, 000Check the box Calculate Tax

    B. Area: NBHYText: Test for Sales Tax

    Next line item:Ps. Ky: 50 Acct: 300001Press EnterAmount: 1, 00, 000Tax code: T1B. Area: NBHYText: Test for sales TaxClick on overviewGo to Document Simulate

    Entry posted by systemS.No Psky B. area Account Description Amount001 40 NBHY 6201 Sun Cement 1,00,000002 40 NBHY 300001 Sales cement 90090.09003 15 NBHY 100502 Liab. For sales tax 9090.91Save It

    Step8: Hard coding of sales tax code in G/l accountGo to FS00Enter the G/l Acct: 300002Click on change mode

    Go to Control data TabTax category: T2 — 12% output tax on sales of white cementSave It

    Go to F-22Do. Date: 24.11.2011Po. Date: 24.11.2011First line item:Ps ky: 01 Acct: 6201Press EnterAmount: 2, 00, 000

    Check the box Calculate TaxB. Area: NBHYText: Test for Sales Tax

    Next line item:Ps. Ky: 50 Acct: 300002Press EnterAmount: 2, 00, 000Tax code: T2

  • 8/18/2019 SAP AR Config

    29/29

    SAP Acc oun ts Rece ivab lesS tep by s tep Conf igura tion Notes

    B. Area: NBHYText: Test for sales TaxClick on overviewSave it

    Step9: To get the exclusive taxGo to F-22Menu path Setting Editing options check the box — calculate taxes on net amountSave It

    Do. Date: 24.11.2011Po. Date: 24.11.2011First line item:

    Note: 1 st line item should be credit by 50Ps. Ky: 50 Acct: 300002

    Press EnterAmount: 1, 00, 000Tax code: T2Check the box Calculate TaxB. Area: NBHYText: Test for sales Tax

    Next line item:Ps. Ky: 01 Acct: 6201Press EnterAmount: 1, 00, 000B. Area: NBHY

    Text: Test for sales TaxClick on overviewSave it

    INTEGRATION BETWEEN SD AND FI

    Financial Accounting (New) General Ledger Accounting (New) PeriodicProcessing Integration Sales and Distribution Prepare Revenue Account

    Determination : T. CODE VKOA