ap - config guide

44
Accounts Payables Setup - India Localization Set Up Steps Install or upgrade Payables Create application user sign-ons and passwords Define your Chart of Accounts Define your Accounting Period Types and Accounting Calendar Periods Enable Currencies that you plan to use Define a Set of Books Assign your Set of Books to a Responsibility Choose a Primary Set of Books Define Payment Terms Setup ŒInvoices ŒPayment Terms Define Your Purchase Order Matching Tolerances Define Invoice Approval Codes Define Distribution Sets Define Purchasing Lookups (Required With Default) Enter Locations Enter Employees Define Financials options Define Payables options Define Payment Programs Define any additional Payment Formats Define Bank Accounts Open Your Accounting Periods Define Request Sets Set up Print Styles and Drivers for the Supplier Mailing Labels Report Define special calendars for key indicators, and recurring invoices Implement Budgetary Control in General Ledger Implement Sequential Voucher Numbering Define Descriptive Flexfields To enter foreign currency transactions, define additional Rate Types, and enter your Daily Rates Use the Application Developer responsibility to set the GL Set of Books ID profile option to Updateable Use the System Administrator responsibility to set the GL Set of Books Name profile option. If you are performing a single set of books installation, set the option for the Oracle Payables application. If you are performing a multiple set of books installation, set the option for each unique If you want to use Automatic Interest Calculation, define Payment Interest If you want to use Payables to enter employee expense reports, create templates for entering expense reports If you use Payables to enter employees in your organization, enter employee If or Oracle Purchasing is installed, you must define at least one Inventory Organization before defining Financials Options Update country and territory information and assign flexible address formats Define the format for the Expense Distribution Detail Report, and define the format for the Invoice Aging Report

Upload: rkvenki

Post on 22-Nov-2014

114 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: AP - Config Guide

Accounts Payables Setup - India LocalizationSet Up Steps

Install or upgrade Payables Create application user sign-ons and passwords Define your Chart of Accounts Define your Accounting Period Types and Accounting Calendar Periods Enable Currencies that you plan to use Define a Set of Books Assign your Set of Books to a Responsibility

Choose a Primary Set of Books

Define Payment Terms Setup ŒInvoices ŒPayment TermsDefine Your Purchase Order Matching Tolerances Define Invoice Approval Codes Define Distribution Sets Define Purchasing Lookups (Required With Default)If you want to use Automatic Interest Calculation, define Payment Interest Rates

If you use Payables to enter employees in your organization, enter employee QuickCodes Enter Locations Enter Employees

Define Financials options Define Payables options Define Payment Programs Define any additional Payment Formats Update country and territory information and assign flexible address formats Define Bank Accounts Open Your Accounting Periods Define Request Sets

Set up Print Styles and Drivers for the Supplier Mailing Labels Report Define special calendars for key indicators, and recurring invoices Implement Budgetary Control in General Ledger Implement Sequential Voucher Numbering Define Descriptive Flexfields

To enter foreign currency transactions, define additional Rate Types, and enter your Daily Rates

Use the Application Developer responsibility to set the GL Set of Books ID profile option to Updateable

Use the System Administrator responsibility to set the GL Set of Books Name profile option. If you are performing a single set of books installation, set the option for the Oracle Payables application. If you are performing a multiple set of books installation, set the option for each unique combination of organization and responsibility

If you want to use Payables to enter employee expense reports, create templates for entering expense reports

If or Oracle Purchasing is installed, you must define at least one Inventory Organization before defining Financials Options

Define the format for the Expense Distribution Detail Report, and define the format for the Invoice Aging Report

Page 2: AP - Config Guide

RRRRORR

OR

R

RRRORDORDO

OORCR

CRRRRDOORRO

OOOOOO

Required / Optional

Page 3: AP - Config Guide

Supplementary Data Set Up Control Instance

Pay Group aPayment Terms aDistribution Set aAdditional Supplier Info aBank Details aTax Stuctures aPurchase Lookups(TDS) aExpense Report Template aSpecial Calenders aAging Periods aProfile Options aPayables and Financial Options aTDS Year aBOE Agent aSet UpsFolders From User

Payment Formats aThru Bank aSIDBI aFuture Focus

PrepaymentsPay on ReceiptsLC PaymentResponsibilitiesFunction SecurityCustom Reports For FutureScheduling

Page 4: AP - Config Guide

Knowledge Transfers

TARS So Far

DELIVERABLES AsIs, ToBe, GAP, Configuration Guide, Funcional Spec,

TROUBLE SHOOTING GUIDE Invoice Processing, Payment Processing

MASTER SET UP DATA So Far

WHITE PAPERS & TIPS

INTELLIGENCE MODULE & OFA

Dos & Donts

Page 5: AP - Config Guide

EventsSupplier Listing from LegacyNull Site Level UsageTax Payer ID For Netting CustomersClasification -> Type Reporting PurposeClassification -> Minority Owned Limited / Other Companies

Site Level Name / AddressGeneral Tab Site Uses

Supplier Notification DetailsAccounting Distribution Set

GL AccountsControl Invoice Amount Limit

Invoice Match Option Payment Terms

PayGroupInvoice Currency Payment CurrrencyPayment PriorityRemittance E-MailTerms Date BasisPay Date BasisPayment MethodAlways Take Discount

Bank AccountsEDI Invoice TaxTax ReportingPurchasing Payment On Receipt

Ship To LocationBill To LocationShip ViaFOBFreight TermsCountry Of Origin

Page 6: AP - Config Guide

Values

Pay Purchasing Primarye-Mail

PO/Receipt

Invoice/SystemDue / DiscountCheckEnable/ Disbale

Pay On Alternate SiteInvoice Summary LevelCreate Debit Memo For RTS Transaction Enable/Disable

Page 7: AP - Config Guide

Code MeaningADVANCE PAYMENT SUPPLIERS ADVANCE PAYMENT SUPPLIERSBANK TRANSFER BANK TRANSFERCASH DISCOUNT SUPPLIERS CASH DISCOUNT SUPPLIERSCASH PARTIES CASH PARTIESCIVIL CONTRACT PARTIES CIVIL CONTRACT PARTIESCOURIER COURIERCREDIT CARD PAYMENTS CREDIT CARD PAYMENTSDEBIT NOTES DEBIT NOTESDIRECTORS DIRECTORSEMPLOYEES EMPLOYEESFOREIGN SUPPLIERS FOREIGN SUPPLIERSFREIGHT PARTIES FREIGHT PARTIESGROUP COMPANY GROUP COMPANYLITIGATION PARTIES LITIGATION PARTIESOPENING BALANCES OPENING BALANCESOTHERS OTHERSRAW MATERIAL SUPPLIERS RAW MATERIAL SUPPLIERSRECURRING PAYMENT PARTIES RECURRING PAYMENT PARTIESRETENTION AMOUNT RETENTION AMOUNTSALARY BANKS SALARY BANKSSALES COMMISSION SALES COMMISSIONSIDBI SUPPLIERS SIDBI SUPPLIERSSTATUTORY AUTHORITIES STATUTORY AUTHORITIESSUB CONTRACT SUB CONTRACTSUB CONTRACT - FETTLING SUB CONTRACT - FETTLINGTHROUGH BANK SUPPLIERS THROUGH BANK SUPPLIERS

Page 8: AP - Config Guide

DescriptionADVANCE PAYMENT SUPPLIERSBANK TRANSFERCASH DISCOUNT SUPPLIERSCASH PARTIESCIVIL CONTRACT PARTIESCOURIERCREDIT CARD PAYMENTSDEBIT NOTESDIRECTORSEMPLOYEESFOREIGN SUPPLIERSFREIGHT PARTIESGROUP COMPANYLITIGATION PARTIESOPENING BALANCESOTHERSRAW MATERIAL SUPPLIERSRECURRING PAYMENT PARTIESRETENTION AMOUNTSALARY BANKSSALES COMMISSIONSIDBI SUPPLIERSSTATUTORY AUTHORITIESSUB CONTRACTSUB CONTRACT - FETTLINGTHROUGH BANK SUPPLIERS

Page 9: AP - Config Guide

NAMEDIRECT 7 DAYS - 1.5% CDDIRECT 15 DAYS - 1% CDDIRECT 15 DAYS - 1.5% CDDIRECT 30 DAYS - 1.5% CD100% - ADVANCE PAYMENT100% - AGAINST PROFORMA INVOICEDIRECT - 15 DAYS - 2%CDDIRECT - 30 DAYS - 2%CDADVANCE PAYMENT AT 110%BANK AT SIGHT - 100%BANK HUNDI - 120 DAYSBANK HUNDI - 30 DAYSBANK HUNDI - 45 DAYSBANK HUNDI - 60 DAYSBANK HUNDI - 75 DAYSBANK HUNDI - 90 DAYSCAD - 30 DAYSCAD - CASH AGAINST DOCUMENTCAD - USUANCE AT 180 DAYSCAD - USUANCE AT 90 DAYSCOD - CASH ON DELIVERYCONFIRMED - LCDIRECT - 15 DAYSDIRECT - 30 DAYSDIRECT - 45 DAYSDIRECT - 60 DAYSDIRECT - 7 DAYSIMMEDIATELC - AT SIGHTLC - USUANCE AT 180 DAYSLC - USUANCE AT 45 DAYSLC - USUANCE AT 60 DAYSLC - USUANCE AT 90 DAYSNON CONFIRMED - LCORG - ON RECEIPT OF GOODSPAYMENT IN ADVANCETDS TERMS

By Irrevocable LOC in Your FavourBy Irrevocable and Confirmed LOC in Your FavourBy LOC in Your Favour Payable days sightOn Cash Against Document BasisPayment in Advance-By DD/TT/SWIFTOn Receipt of Goods-By DD/TT/SWIFT

25%ADVANCE - BALANCE THROUGH BANKAGAINST DELIVERY

Page 10: AP - Config Guide

DESCRIPTIONDIRECT 7 DAYS - 1.5% CDDIRECT 15 DAYS - 1% CDDIRECT 15 DAYS - 1.5% CDDIRECT 30 DAYS - 1.5% CD100% - ADVANCE PAYMENT100% - AGAINST PROFORMA INVOICEDIRECT - 15 DAYS - 2%CDDIRECT - 30 DAYS - 2%CDADVANCE PAYMENT AT 110%BANK AT SIGHT - 100%BANK HUNDI - 120 DAYSBANK HUNDI - 30 DAYSBANK HUNDI - 45 DAYSBANK HUNDI - 60 DAYSBANK HUNDI - 75 DAYSBANK HUNDI - 90 DAYSCAD - 30 DAYSCAD - CASH AGAINST DOCUMENTCAD - USUANCE AT 180 DAYSCAD - USUANCE AT 90 DAYSCOD - CASH ON DELIVERYCONFIRMED - LCDIRECT - 15 DAYSDIRECT - 30 DAYSDIRECT - 45 DAYSDIRECT - 60 DAYSDIRECT - 7 DAYSIMMEDIATELC - AT SIGHTLC - USUANCE AT 180 DAYSLC - USUANCE AT 45 DAYSLC - USUANCE AT 60 DAYSLC - USUANCE AT 90 DAYSNON CONFIRMED - LCORG - ON RECEIPT OF GOODSPAYMENT IN ADVANCETDS TERMS

By Irrevocable LOC in Your FavourBy Irrevocable and Confirmed LOC in Your FavourBy LOC in Your Favour Payable days sightOn Cash Against Document BasisPayment in Advance-By DD/TT/SWIFTOn Receipt of Goods-By DD/TT/SWIFT

25%ADVANCE - BALANCE THROUGH BANKAGAINST DELIVERY

Page 11: AP - Config Guide

Report Name DescriptionSupplier ReportsSupplier Reports

Supplier Balance Revaluation Report Identifies Suppliers with credit balancesSupplier Paid Invoice History Report

Invoice ReportsBatch Control Report

Invoice Aging Report

Invoice History Report

Invoice Hold Report

Recurring Invoices Report

Prepayment Status Report

Unrealized Gain/Loss Report

PaymentsCash Requirement Report

Final Payment Register

Payment Batch Control Report

Payment Gain/Loss Report

Stopped Payments Report Reports all stopped paymentsDiscounts Available Report

Posting ReportsAccounts Payable Journal Entry Audit Report

Accounts Payable Journal Entry Exception Report

of invoices or payments to your general ledger.

Accounts Payable Trial Balance Report

Transaction Reconciliation Report

Automatic Reports

Detailed Imformation about Supplier and Supplier Sites

Details payment history, discounts taken and frequency of partial payments.

Batch Control reports is used to review invoice batches.Provides information about invoice payments due within four time periodsQuickly identifies and review a detailed list of all activities pertaining to a specific invoice

Provides detailed information on Invoices on Hold.Reviews recurring invoice templates defined during a specific time period.Reviews the unapplied prepayments and unpaid or partially paid invoices for a supplier.

Review unrealized gains and losses on foreign currency invoices.

Report to forecast cash needs for invoice payments.Lists each payment created for a payment batch.Review detailed information about the payments printed in one or more payment batches.

Reports currency exchange rate gain and loss included in the payment.

Identifies payments where advantageous discounts can be taken.

Accounts Payable Journal Entry Audit Report to review invoices and payments that you transferred to your general ledger.

Identifies and resolve all exceptions that occurred when you initiated the transfer

Verifies that total accounts payable liabilities in Payables equal those in the general ledger.

Identifies the General Ledger journal entry lines imported from particular transactions in Payables.

Page 12: AP - Config Guide

Unaccounted Transsaction Sweep ReportPayables Approval ReportPreliminary Purged ListingsFinal Purged ListingsRejected Purged ListingsFinal Purge Statistics ReportSupplier Marge ReportPurchase Order Headers ReportInvoice Import ReportInvoice Import Exception ReportPayables Open Interface ReportsPreliminary Payment RegisterFinal Payment RegisterUpdate Matured Future Payment Status

Customized Reports

Page 13: AP - Config Guide

Bank Name Branch Name Account Name Primary1 AR AP NETTING DUMMY ARAP2 Bank of Baroda CBE Main BOB-CA2663 Cash on Hand U11 Unit-11 Cash-U114 Cash on Hand U12 Unit-12 Cash-U12 5 Cash on Hand U13 Unit-13 Cash-U13 6 Cash on Hand U21 Unit-21 Cash-U21 7 Cash on Hand U31 Unit-31 Cash-U31 8 Citibank Coimbatore CITI-70040039 HDFC Bank Avinashi Road HDFC-330000022

10 ICICI Anywhere Bank Trichy Road AWB-16050053511 ICICI Bank Trichy Road ICICI-160500019512 IDBI Bank Trichy Road IDBI-00610300000036513 Indian Bank CBE Main IB-CC16714 Indian Bank Dollar A/c CBE Main IB-USD-204415 SIDBI SIDBI SIDBI16 State Bank of India PN Palayam SBI-PNP171819202122

E1
Administrator: Possible Values - Yes - No for one payment method and one currency there can be only one primary bank account
Page 14: AP - Config Guide

Cash Receipt Confirmation Remittance 90.00.000.4992.000.00.0090.00.000.2201.000.00.0011.00.000.2290.000.00.0012.00.000.2290.000.00.0013.00.000.2290.000.00.0021.00.000.2290.000.00.0031.00.000.2290.000.00.0090.00.000.2239.000.00.0090.00.000.2217.000.00.0090.00.000.2221.000.00.0090.00.000.2218.000.00.0090.00.000.2207.000.00.00 31.00.000.4995.000.00.00 31.00.000.4996.000.00.0090.00.000.2200.000.00.0090.00.000.2240.000.00.0011.00.000.2255.000.00.0090.00.000.2224.000.00.00

Page 15: AP - Config Guide

Factoring Short Term Debt Bank Charges Unapplied Receipt90.00.000.3310.000.00.0090.00.000.3310.000.00.0011.00.000.3310.000.00.0012.00.000.3310.000.00.0013.00.000.3310.000.00.0021.00.000.3310.000.00.0031.00.000.3310.000.00.0090.00.000.3310.000.00.0090.00.000.3310.000.00.0090.00.000.3310.000.00.0090.00.000.3310.000.00.00

31.00.000.4994.000.00.00 31.00.000.4993.000.00.00 31.00.000.3310.000.00.0090.00.000.3310.000.00.0090.00.000.3310.000.00.0011.00.000.3310.000.00.0090.00.000.3310.000.00.00

Page 16: AP - Config Guide

Unidentified Receipt On Account Receipt Unearned Discount Earned Discount90.00.000.3320.000.00.00 90.00.000.3310.000.00.0090.00.000.3320.000.00.00 90.00.000.3330.000.00.0011.00.000.3320.000.00.00 11.00.000.3310.000.00.0012.00.000.3320.000.00.00 12.00.000.3310.000.00.0013.00.000.3320.000.00.00 13.00.000.3310.000.00.0021.00.000.3320.000.00.00 21.00.000.3310.000.00.0031.00.000.3320.000.00.00 31.00.000.3310.000.00.0090.00.000.3320.000.00.00 90.00.000.3330.000.00.0090.00.000.3320.000.00.00 90.00.000.3330.000.00.0090.00.000.3320.000.00.00 90.00.000.3330.000.00.0090.00.000.3320.000.00.00 90.00.000.3330.000.00.0031.00.000.3320.000.00.00 31.00.000.3201.000.00.0090.00.000.3320.000.00.00 90.00.000.3330.000.00.0090.00.000.3320.000.00.00 90.00.000.3330.000.00.0011.00.000.3320.000.00.00 11.00.000.3310.000.00.0090.00.000.3320.000.00.00 90.00.000.3330.000.00.00

Page 17: AP - Config Guide

Document SequencesName Application From To TypeLMW S&P Invoices Oracle Payables 4-Mar-03 AutomaticLMW Check Payments Oracle Payables 4-Apr-03 AutomaticLMW Credit&Debit Memos Oracle Payables 4-Apr-03 AutomaticLMW Credit Notes Oracle Payables 4-Apr-03 AutomaticLMW Expense Reports Oracle Payables 4-Apr-03 AutomaticLMW Recurring Invoices Oracle Payables 4-Apr-03 AutomaticLMW Supplier Refunds Oracle Payables 4-Apr-03 AutomaticLMW Clear Payments Oracle Payables 4-Apr-03 Automatic

Document AsignmentsApplication Category Set of Books Method Start DateOracle Payables Check Payments Lakshmi Machine Works Ltd. 5-Apr-03Oracle Payables Clearing Payment Lakshmi Machine Works Ltd. 5-Apr-03Oracle Payables Credit Memo InvoiLakshmi Machine Works Ltd. 5-Apr-03Oracle Payables Debit Memo Invoi Lakshmi Machine Works Ltd. 5-Apr-03Oracle Payables Expense Report InLakshmi Machine Works Ltd. 5-Apr-03Oracle Payables Credit Note Invoic Lakshmi Machine Works Ltd. 5-Apr-03Oracle Payables Prepayment Invoi Lakshmi Machine Works Ltd. 5-Apr-03Oracle Payables Recurring StandarLakshmi Machine Works Ltd. 5-Apr-03Oracle Payables Standard Invoices Lakshmi Machine Works Ltd. 4-Mar-03Oracle Payables Supplier Refund Lakshmi Machine Works Ltd. 5-Apr-03

Convention Used Type / year / Sl.no 1 / 3/ 00001

Type1 - Check Payments2- Standard Invoice & Prepayment Invoices3- Debit / Credit Memos4- Credit Notes5- Expense Reports6 - Recurring Invoices7- Supplier Refunds8- Clear Payments

Page 18: AP - Config Guide

Message Initial Value23000011300001330000143000015300001630000173000018300001

End Date SequenceLMW Check PaymentsLMW Clear PaymentsLMW Credit&Debit MemosLMW Credit&Debit MemosLMW Expense ReportsLMW Credit NotesLMW S&P InvoicesLMW Recurring InvoicesLMW S&P InvoicesLMW Supplier Refunds

Page 19: AP - Config Guide

Payment ProgramsName Type Registered NameLMW Indian Bank Format Payments LMWFINR101LMW Yourselves Indian Bank Format Payments LMWFINR102LMW Ourselves Indian Bank Format Payments LMWFINR103LMW ICICI Bank Format Payments LMWFINR104LMW Yourselves ICICI Bank Format Payments LMWFINR105LMW Ourselves ICICI Bank Format Payments LMWFINR106LMW Bank Of Baroda Format Payments LMWFINR107LMW Yourselves Bank Of Baroda Format Payments LMWFINR108LMW Ourselves Bank Of Baroda Format Payments LMWFINR109LMW ICICI Anywhere Bank Format Payments LMWFINR110LMW Yourselves ICICI Anywhere BankFormat Payments LMWFINR111LMW Ourselves ICICI Anywhere Bank Format Payments LMWFINR112LMW All Other Banks Format Payments LMWFINR113LMW Debit Advice Remittance Advice LMWFINR121LMW Cash Voucher Format Payments LMWFINR116Payment FormatsFormat Name Payment Method Currency Remittance No. Of Invoices Separate RemittanceLMW Indian Bank Check Mulitiple After 50 LMW Debit AdviceLMW Yourselves Indian Bank Check Single/INR After 50 LMW Debit AdviceLMW Ourselves Indian Bank Check Single/INR After 50 LMW Debit AdviceLMW ICICI Bank Check Single/INR After 50 LMW Debit AdviceLMW Yourselves ICICI Bank Check Single/INR After 50 LMW Debit AdviceLMW Ourselves ICICI Bank Check Single/INR After 50 LMW Debit AdviceLMW Bank Of Baroda Check Single/INR After 50 LMW Debit AdviceLMW Yourselves Bank Of Baroda Check Single/INR After 50 LMW Debit AdviceLMW Ourselves Bank Of Baroda Check Single/INR After 50 LMW Debit AdviceLMW ICICI AWB Check Single/INR After 50 LMW Debit AdviceLMW Yourselves ICICI AWB Check Single/INR After 50 LMW Debit AdviceLMW Ourselves ICICI AWB Check Single/INR After 50 LMW Debit AdviceLMW All Other Banks Check Single/INR After 50 LMW Debit AdviceLMW Cash Voucher Check Single/INR After NAPayable DocumentsBank Name Account Number Document Name Payment Format Document Numbers

Last Used Last Available

Page 20: AP - Config Guide

Cash On Hand U11 Cash-U11 Cash Voucher LMW Cash Voucher 11300000 11399999Cash On Hand U12 Cash-U12 Cash Voucher LMW Cash Voucher 12300000 12399999Cash On Hand U13 Cash-U13 Cash Voucher LMW Cash Voucher 13300000 13399999Cash On Hand U21 Cash-U21 Cash Voucher LMW Cash Voucher 21300000 21399999Cash On Hand U31 Cash-U31 Cash Voucher LMW Cash Voucher 31300000 31399999

Page 21: AP - Config Guide

Convention Used

Page 22: AP - Config Guide

Unit / Year / Sl.No 11 / 3 / 00001

Page 23: AP - Config Guide

Payables Check DocumentsBank Name Branch Name Bank Accounts Name Bank Account Number

BANK OF BARODA / BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266Bank Of Baroda CBE Main Bank Of Baroda - BOB-CA266 BOB-CA266

ICICI BANK / ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195ICICI Bank Trichy Road ICICI - ICICI-1605000195 ICICI-1605000195

ICICI ANYWHERE BANK / AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535ICICI Anywhere Bank Trichy Road ICICI Anywhere Bank - AWB-1 AWB-160500535

INDIAN BANK / IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167

Page 24: AP - Config Guide

Indian Bank CBE Main Indian Bank - IB-CC167 IB-CC167CITI BANK /CITI-7004003

Citi Bank Coimbatore CitiBank - CITI-7004003 CITI-7004003HDFC BANK / HDFC-330000022

HDFC Bank Avinashi Road HDFC - HDFC-330000022 HDFC-330000022SIDBI

SIDBI SIDBI SIDBI SIDBI

Page 25: AP - Config Guide

Payables Check DocumentsDocument Name Disbursement Type Payment Format Last Used Last Available

BANK OF BARODA / BOB-CA266CombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombined

ICICI BANK / ICICI-1605000195CombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombined

ICICI ANYWHERE BANK / AWB-160500535CombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombined

INDIAN BANK / IB-CC167CombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombinedCombined

Page 26: AP - Config Guide

CombinedCITI BANK /CITI-7004003

CombinedHDFC BANK / HDFC-330000022

CombinedSIDBI

Combined

Page 27: AP - Config Guide

LMW Bank Of Baroda LMW Indian Bank LMW ICICI BankLMW Yourselves Bank Of Baroda LMW Yourselves Indian Bank LMW Yourselves ICICI BankLMW Ourselves Bank Of Baroda LMW Ourselves Indian Bank LMW Ourselves ICICI Bank

Page 28: AP - Config Guide

LMW ICICI AWB LMW All Other BanksLMW Yourselves ICICI AWBLMW Ourselves ICICI AWB

Page 29: AP - Config Guide

Template Name Unit 11 Exp Report TempDescription LMW Unit 11 Expense Report Template - TMD PNP

Expense Item Item Type GL AccountUN1 - Bus/Train/Air Fare Item 11.00.000.8042.000.00.00UN1 - Lodging Expenses Item 11.00.000.8042.000.00.00UN1 - Food & Tiffin Expenses Item 11.00.000.8042.000.00.00UN1 - Travelling & Conveyance Item 11.00.000.8042.000.00.00UN1 - Telephone & Telegrams Item 11.00.000.8042.000.00.00UN1 - Purchase As Per Bill Item 11.00.000.8042.000.00.00

Template Name Unit 12 Exp Report TempDescription LMW Unit 12 Expense Report Template - TMD Kaniyur

Expense Item Item Type GL AccountUN2- Bus/Train/Air Fare Item 12.00.000.8042.000.00.00UN2- Lodging Expenses Item 12.00.000.8042.000.00.00UN2- Food & Tiffin Expenses Item 12.00.000.8042.000.00.00UN2- Travelling & Conveyance Item 12.00.000.8042.000.00.00UN2- Telephone & Telegrams Item 12.00.000.8042.000.00.00UN2- Purchase As Per Bill Item 12.00.000.8042.000.00.00

Template Name Unit 13 Exp Report TempDescription LMW Unit 13 Expense Report Template - TMD S&R

Expense Item Item Type GL AccountS&R- Bus/Train/Air Fare Item 13.00.000.8042.000.00.00S&R- Lodging Expenses Item 13.00.000.8042.000.00.00S&R- Food & Tiffin Expenses Item 13.00.000.8042.000.00.00S&R- Travelling & Conveyance Item 13.00.000.8042.000.00.00S&R- Telephone & Telegrams Item 13.00.000.8042.000.00.00S&R- Purchase As Per Bill Item 13.00.000.8042.000.00.00

Template Name Unit 21 Exp Report TempDescription LMW Unit 21 Expense Report Template - MTD Arasur

Expense Item Item Type GL AccountMTD- Bus/Train/Air Fare Item 21.00.000.8042.000.00.00MTD- Lodging Expenses Item 21.00.000.8042.000.00.00MTD- Food & Tiffin Expenses Item 21.00.000.8042.000.00.00MTD- Travelling & Conveyance Item 21.00.000.8042.000.00.00MTD- Telephone & Telegrams Item 21.00.000.8042.000.00.00MTD- Purchase As Per Bill Item 21.00.000.8042.000.00.00

Enable For Internet Expense

Enable For Internet Expense

Enable For Internet Expense

Enable For Internet Expense

Page 30: AP - Config Guide

Template Name Unit 31 Exp Report TempDescription LMW Unit 31 Expense Report Template - MTD Foundry

Expense Item Item Type GL AccountFDY- Bus/Train/Air Fare Item 31.00.000.8042.000.00.00FDY- Lodging Expenses Item 31.00.000.8042.000.00.00FDY- Food & Tiffin Expenses Item 31.00.000.8042.000.00.00FDY- Travelling & Conveyance Item 31.00.000.8042.000.00.00FDY- Telephone & Telegrams Item 31.00.000.8042.000.00.00FDY- Purchase As Per Bill Item 31.00.000.8042.000.00.00

Template Name Unit 90 Exp Report TempDescription LMW Unit 90 Expense Report Template - CORP

Expense Item Item Type GL AccountCORP- Bus/Train/Air Fare Item 90.00.000.8042.000.00.00CORP- Lodging Expenses Item 90.00.000.8042.000.00.00CORP- Food & Tiffin Expenses Item 90.00.000.8042.000.00.00CORP- Travelling & Conveyance Item 90.00.000.8042.000.00.00CORP- Telephone & Telegrams Item 90.00.000.8042.000.00.00CORP- Purchase As Per Bill Item 90.00.000.8042.000.00.00

Enable For Internet Expense

Enable For Internet Expense

Page 31: AP - Config Guide

Prompt Req.Receipt Above

Hotel Bills To Be EnclosedTo Be Supported By BillsReceipt To Be Submitted For Rs.50 & Above Rs.50

Prompt Req.Receipt Above

Hotel Bills To Be EnclosedTo Be Supported By BillsReceipt To Be Submitted For Rs.50 & Above Rs.50

Prompt Req.Receipt Above

Hotel Bills To Be EnclosedTo Be Supported By BillsReceipt To Be Submitted For Rs.50 & Above Rs.50

Prompt Req.Receipt Above

Hotel Bills To Be EnclosedTo Be Supported By BillsReceipt To Be Submitted For Rs.50 & Above Rs.50

Justification Required

Justification Required

Justification Required

Justification Required

Page 32: AP - Config Guide

Prompt Req.Receipt Above

Hotel Bills To Be EnclosedTo Be Supported By BillsReceipt To Be Submitted For Rs.50 & Above Rs.50

Prompt Req.Receipt Above

Hotel Bills To Be EnclosedTo Be Supported By BillsReceipt To Be Submitted For Rs.50 & Above Rs.50

Justification Required

Justification Required

Page 33: AP - Config Guide

Justification Required

Justification Required

Justification Required

Justification Required

Page 34: AP - Config Guide

Justification Required

Justification Required

Page 35: AP - Config Guide

To-Be Process Maps - Reports - APAccounts Payable - Reports Master Tracking List

As-Is Reports & Formats Oracle Reports Pre-StationeryProcess Bills

Receipt Of Supplier Invoice Not Required NAMIN Printing - MIN Copy Not Required NAPO Verification Work Order Not Required NAPO Verification Supply Not Required NADebit Note For Discrepancy Yes YesRejection Invoice Verfication Not Required NAPayment List ( without Cheque No.) Not Required NADay Book - Purchase, Imports & Rej. Yes NoIT Debit Note Yes NoWarehouse Journal Yes No

Process Debit NoteRejection Invoice(IR/NIR Series) Yes YesDebit Note(DP/NDP Series) Yes YesDebit Note for Sub-Contract Yes YesDay Book(IR/DP) Yes No

Process Credit NoteCredit Note Copy Yes YesRe-Acceptance Memo Need to Look into the ProcessMIN Printing - MIN Copy Not Required NA

Process PaymentsBank Intimation ( Local & Foreign) Not Required NAAdvance Payment Letter Not Required NAEndorsement Letter Yes YesRetirement Letter to Bank Yes YesRetirement Letter - Foreign Yes YesRetirement Approval - WD Yes YesBank Debit Advice - Local & Imports Need to Look into the Process NAPayment Voucher - Local & Imports Need to Look into the Process YesL.R Covering Letter Yes YesRetirement Register - Local & Imports Not Required NAP.O Verification For Advance Payment Not Required NASIDBI Payment List - Party & Consol.. Yes YesDebit Note for Cash Discount Yes YesCapital Journal - Day Book Yes YesDebit Advice Voucher( Che. Payment) Yes YesPayment List Yes YesCheque Leaf… Yes YesForm 16A Yes YesMisc.. Payment Voucher Yes YesSupplier Statement Of Account Yes YesOutstanding Bills Yes YesPacking Certificates Yes YesForm8 & Form 18 Register Yes Yes

Page 36: AP - Config Guide

Internal/External

NANANANAExternalNANAInternalInternalInternal

ExternalExternalExternalInternal

External

NA

NANAExternalExternalExternalInternalNAExternalExternalNANAExternalExternalInternalExternalInternalExternalExternalExternalExternalInternalExternalExternal

Page 37: AP - Config Guide

Name TDS Section # Form No Type DescriptionSec. 194© 26C Tax Deduction at Source TDS - Advertisements - OthersSec. 194© 26C Tax Deduction at Source TDS - Advertisements - LimitedUNDER DTAA 27 Tax Deduction at Source TDS - RoyaltySec. 194© 26C Tax Deduction at Source TDS - Contractor Payments - OthersSec. 194© 26C Tax Deduction at Source TDS - Contractor Payments - LimitedSec. 194(H) 26I Tax Deduction at Source TDS - Sales CommissionSec. 194(J) 26K Tax Deduction at Source TDS - Professional Charges - OthersSec. 194(J) 26K Tax Deduction at Source TDS - Professional Charges - LimitedSec. 194(I) 26J Tax Deduction at Source TDS - Rent IndividualsSec. 194(A) 26A Tax Deduction at Source TDS - InterestSec. 194(I) 26J Tax Deduction at Source TDS - Rent CompaniesSec.194(H) 26I Tax Deduction at Source TDS - Sales Commission

TDS@1% - [email protected]% - LimitedTDS@10% - RoyaltyTDS@2% - [email protected]% - [email protected]% - Sales CommissionTDS@5% - Professional [email protected]% - Professional ChargesTDS@15% - Rent [email protected]% - [email protected]% - Rent [email protected] - Sales Commission

Page 38: AP - Config Guide

Account Vendor Name90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.8170.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER90.00.000.3214.000.00.00 INCOME TAX OFFICER

Page 39: AP - Config Guide

Code Meaning DescriptionSec. 194(A) TDS Section 194(A)-IND TDS Section 194(A)Sec. 194(C) TDS Section 194(C)-IND TDS Section 194(C)Sec. 194(I) TDS Section 194(I)-IND TDS Section 194(I)Sec. 194(J) TDS Section 194(J)-IND TDS Section 194(J)Sec. 194 TDS Section 194-IND TDS Section 194Sec. 195 TDS Section 195-IND TDS Section 195Sec. 194(H) TDS Section 194(H)-IND TDS Section 194(H)EXEMPT Exempt ExemptUNDER DTAA Under DTAA Under DTAA

192 Salary193 Interest On Securities

FutureFutureFutureFutureFutureFutureFutureFutureFutureFuture

Page 40: AP - Config Guide

Code Meaning DescriptionForm A Form A-IND Form AForm B Form B-IND Form BForm C Form C-IND Form CForm D Form D-IND Form DFORM H Form H-IND Form HFORM 17 Form 17-IND Form 17FORM 26A Form 26A-IND Form 26AFORM 26C Form 26C-IND Form 26CFORM 26I Form 26I-IND Form 26IFORM 26J Form 26J-IND Form 26JFORM 26K Form 26K-IND Form 26KFORM 27 Form 27-IND Form 27

FutureFutureFutureFutureFutureFutureFutureFutureFutureFutureFORM 24FORM 25FORM 26

Page 41: AP - Config Guide

Code Meaning DescriptionLIMITED LIMITED LIMITEDOTHERS OTHERS OTHERS