Sap Fico Complete End User Manual Realtime Project
Sap Fico Complete End User Manual Realtime Project
Sap Fico Complete End User Manual Realtime Project
FICO TEAM
2009
G r e a v e s Co t t o n L i m i t e d Page 2
2009
Table of Contents:
CHAPTER 1 .................................................................................................................................................... 1
GLOSSARY .......................................................................................................................................................................................................... 1
Features .................................................................................................................................... 1
Company ................................................................................................................................... 1
Company Code .......................................................................................................................... 1
Chart of Accounts....................................................................................................................... 1
Account Groups ......................................................................................................................... 1
Parallel Accounting .................................................................................................................... 2
Integration of Legal and Management Reporting........................................................................ 2
Segment Reporting .................................................................................................................. 2
Controlling area ......................................................................................................................... 2
Fiscal Year .............................................................................................................................................. 2
Special Periods .......................................................................................................................... 3
Cost Centre................................................................................................................................ 3
Profit Centre .............................................................................................................................. 3
Profit Center Group .................................................................................................................... 6
Cost Centre................................................................................................................................ 7
Cost Centre Group ..................................................................................................................... 9
Posting Keys ............................................................................................................................ 10
Document Type........................................................................................................................ 12
CHAPTER 2 ..................................................................................................................................................15
MASTERS .................................................................................................................................................15
General Ledger Account Codes ................................................................................................ 15
Creation of Account Codes (FS00)............................................................................................ 16
Extending GL accounts (FS15) ................................................................................................. 18
Creation of Primary Cost Element (KA01) ................................................................................. 18
Maintaining Cost and Activity Type(KP26) ................................................................................ 20
Allocation Cost Element ........................................................................................................... 22
Creation of Secondary Cost Element (KA06)............................................................................. 22
Creation of Vendor Master Codes (FK01) ................................................................................. 23
Creation of Customer Master Codes (FD01) ............................................................................. 28
Creation of Internal Order Master (KO01).................................................................................. 34
Creation of Asset Master Codes (AS01) .................................................................................... 36
Creation of Asset Sub-number Codes (AS11) ........................................................................... 39
Display of Asset Master Codes (AW01N) .................................................................................. 40
Creation of Bank Key Masters (FI01) ........................................................................................ 42
Creation of House bank (FI12) .................................................................................................. 42
Maintaining Cheque Lots for Each Banks (FCHI) ....................................................................... 47
CHAPTER -3 ............................................................................................................................................... 49
TRANSACTIONS ................................................................................................................................................................................................ 49
Booking a Journal Voucher (F-02)/ (FB50) ................................................................................ 49
Display of Journal Voucher (FB03)............................................................................................ 52
G r e a v e s Co t t o n L i m i t e d Page 3
2009
G r e a v e s Co t t o n L i m i t e d Page 4
2009
G r e a v e s Co t t o n L i m i t e d Page 5
2009
CHAPTER 10 ............................................................................................................................................269
SALES & DISTRIBUTION ........................................................................................................................................................ 269
Process ................................................................................................................................. 269
For Comparison of Master Data from Sales & Distribution to Finance Accounting (OV50) ............ 269
Display Sales Order ( FV03) ................................................................................................... 270
Display the billing document (VF03)........................................................................................ 271
Creation of excise invoice (J1IIN)............................................................................................ 272
Customer Analysis (FD11) ..................................................................................................... 274
CHAPTER 11 ............................................................................................................................................276
REVERSALS & EDITING DOCUMENTS ......................................................................................................................................................276
G r e a v e s Co t t o n L i m i t e d Page 6
2009
CHAPTER 13 ............................................................................................................................................291
DUNNING PROCESS ......................................................................................................................................................................................291
Correspondence (FB12 & F.64) ............................................................................................. 291
Interest Calculation on MSMED .............................................................................................. 295
Calculate Interest on Arrears without Postings (F.4C) .............................................................. 295
Interest Rate Maintaining (OB83)............................................................................................ 298
CHAPTER -14 ............................................................................................................................... 301
CONTROLLING & COSTING ..................................................................................................................................................................... 301
Display BOM ( CS03)/ Multilevel BOM ( CS11) ........................................................................ 301
Display Routing ( CA03) ......................................................................................................... 302
View cost of Final Product ( CK11N) ....................................................................................... 302
Display Production Order ( CS03) ........................................................................................... 303
Production Order Confirmation ( CO11N)................................................................................ 304
View Material Document (MB03) ............................................................................................ 305
To Get Actual Cost of Production Order Settlement (KO88) ..................................................... 305
Overheads Assessment Cycle (KSU5) ...............................................................................................306
Executing Assessment Cycle ................................................................................................. 309
Month end process WIP Calculation ( KKAO)........................................................................ 311
Settlement of orders which are in WIP (CO88/KO88) ............................................................... 314
Changing the Cut-off Period(KKA0 ......................................................................................... 315
CHAPTER -15 ............................................................................................................................... 317
G r e a v e s Co t t o n L i m i t e d Page 7
2009
CHAPTER-20..............................................................................................................................................341
TIPS & TRICKS FOR EFFECTIVE USAGE OF SAP ..............................................................................................341
Copy & Paste Data of SAP Screen......................................................................................................341
Table Settings ........................................................................................................................ 341
Creating your Own Favourite menu ........................................................................................ 342
Reduction of Repetitive work .................................................................................................. 343
Changing Layout of a Report ................................................................................................. 344
Setting up the Printer for Each User ID .................................................................................... 345
Sending Mail from the SAP System......................................................................................... 346
CHAPTER-21..............................................................................................................................................350
G r e a v e s Co t t o n L i m i t e d Page 8
2008
CHAPTER 1
Glossary
Features
The Financial Accounting application component comprises the following sub-components:
Company
The smallest organizational unit for which individual financial statements are created according to the relevant legal
requirements. A company can include one or more company codes. A company s financial statements also form the basis
of consolidated financial statements.
All of the company codes within a company must use the same chart of accounts and fiscal year. However, each company
code can have a different local currency.
Company Code
Smallest organizational unit of external accounting for which a complete, self-contained set of accounts can be created.
This includes the entry of all transactions that must be posted and the creation of all items for legal individual financial
statements, such as the balance sheet and the profit and loss statement.
Chart of Accounts
The chart of accounts list is a directory of all charts of accounts that can be used in a client and must assign one chart of
accounts to each company code. Therefore need at least one chart of accounts for a group company in the system. The
chart of accounts is shared by Financial Accounting as well as cost/revenue accounting. The items in a chart of accounts can
be both expense or revenue accounts in Financial Accounting and cost or revenue elements in cost/ revenue accounting.
We can define the length of the G/ L account numbers. The maximum length is ten characters. Internally, the system keeps
the account numbers with a ten character length. The system pads purely numeric account numbers with zeroes from the
left, and alphanumeric account numbers from the right.
Account Groups
The account group is a summary of accounts based on criteria that effects how master records are created.
The account group determines:
The number interval from which the account number is selected when a G/L account is created.
The screen layout for creating G/L accounts in the company code-specific area
Parallel Accounting
General Ledger Accounting allows us to perform parallel accounting by managing several parallel ledgers for
different accounting principles.
Segment Reporting
General Ledger Accounting supports the segment reports required by the accounting principles IFRS(International
Financial Reporting Standards) and USGAAP (Generally Accepted Accounting Principles). For this purpose, General
Ledger Accounting contains the segment dimension.
Controlling area
The Controlling Area is an entity in Controlling. All the CO transactions in R/ 3 system would be entered with respect to the
controlling area. There will be one controlling area (1000 Greaves Controlling Area) to which all the company codes will
be assigned. All Company codes shall use same Chart of Accounts and Fiscal Year Variant.
Fiscal Year
Usually a period of twelve months for which a company regularly creates financial statements and checks inventories
The fiscal year may correspond exactly to the calendar year, but this is not obligatory.
In Greaves Cotton Limited And Premium Energy Transmission Limited we will be having to Fiscal Year
1. 0L- Fiscal Year From April to March. It will be leading Ledger .
2. SL- Fiscal Year From July to June. It will be Secondary Ledger .
We have to enter the documents in any one ledger and the entry will be posted in other ledger accordingly.
Posting Period and Counting
Page 2
2009
Special Periods
Special posting periods that subdivide the last regular posting period for closing operations.
Irrespective of how we have defined our fiscal year, we can also use special periods. Special periods subdivide the year-end
closing period. They therefore merely divide the last posting period into several closing periods. This enables us to create
several supplementary financial Statements
A fiscal year usually has 12 posting periods. In General Ledger Accounting, we have defined four special periods so out total
accounting periods will be 16 for Greaves Cotton Limited and Premium Energy Transmission Limited.
Cost Centre
An organizational unit within a controlling area that represents a defined location of cost incurrence. The requirement at
Greaves is to capture the costs Department wise. Cost centers would be divided into main groupings: Example:
1) Production
2) Service
3) Administration Cost Centers
4) Selling & Distribution Cost Centers
Profit Centre
Create KE51
Change- KE52
Display:-KE53
A profit center is an organizational unit in accounting that reflects a management-oriented structure of the organization for
the purpose of internal control.
We can analyze operating results for profit centers using either the cost-of-sales or the period accounting approach. By
calculating the fixed capital as well, we can use our profit centers as investment centers.
Page 3
2009
If we have to copy for the existing profit center, we can give that Profit center
The below screen will appear, enter the Profit center details.
Page 4
2009
Page 5
2009
Then Click the Save button on the top row of the screen. The profit center will be created.
Create - KCH1
Change: KCH2
Display: KCH3
A profit center group is a hierachical structure of profit centers.
We can use profit center groups to group profit centers together according to company-specific criteria.
Use
Profit center groups are used for reporting, allocations or in various planning functions, where it does not make sense to
enter or display data at the lowest level (with a high level of detail).
The standard hierarchy is a special type of profit center group. It has to contain all profit centers belonging to the
controlling area and reflect the organizational structure of Profit Center Accounting.
We can collect cost centers according to various criteria into groups. This enables us to use cost centers to depict the
structure of the organization in the SAP System.
Page 6
2009
Cost Centre
Create - KS01
Change: KS02,
Display: KS03
A cost center is an organizational unit that represents a defined location of cost incurrence. To create Cost Center
follow the below path:
Page 7
2009
Page 8
2009
Provide the necessary details and press enter the Description for the data fed will be shown as shown above screen.
Create - KSH1,
Display: KSH3
We can collect cost centres according to various criteria into groups. This enables we to use cost centers to depict the
structure of the organization in the SAP System.
We can use the groups to build cost centre hierarchies, which summarize the decision -making, responsibility, and
control areas according to the particular requirements of the organization. The individual cost centres form the
lowest hierarchical level.
Page 9
2009
Posting Keys
Definition
Two-character numerical key that controls the entry of line items. The posting key determines:
Account type
Debit/credit posting
Layout of entry screens
Use
When we enter a posting, enter a posting key for each item. This key determines how the item is posted. Posting keys are
defined at client level and therefore apply to all company codes. The posting key determines:
Posting keys are differentiated by customer, vendor and G/L accounts. Apart from the General Ledger Accounting (FI-GL)
and Accounts Receivable and Payable (FI-AR/AP) components, there are also posting keys for asset and material accounts.
Page 10
2009
SAP delivers predefined posting keys with the standard system. The following table lists some of the posting keys in the
standard system.
Integration
The document type specifies which account types we can post to. The posting key specifies which account types we can
post to. A posting key can only be entered for an account type which is permitted for that document type.
Page 11
2009
Debit Customer
Credit Customer
Debit Vendor
Credit Vendor
General Ledger
Document Type
Document types are valid for all clients. We specify a number range key for each document type. We create the desired
number range intervals for each number range key based on the company code. This means that we can specify intervals
of different sizes for the same number range.
Page 12
2009
o Accounts receivable
o Accounts payable
o Asset accounting
o Consolidation
o Invoicing
Document Reverse
Description Type DocumentType Account types
Asset Posting AA ADKMS
Accounting Document AB AB ADKMS
Depreciation Pstngs AF AF AS
Customer Document DA DA DS
Customer Credit Memo DG DA DS
Customer Invoice DR DA ADMS
Customer Payment DZ DA DS
Vendor Document KA KA AKMS
Vendor Credit Memo KG KA AKMS
Vendor Invoice KR KA AKMS
Vendor Payment KZ KA AKS
Invoice - Gross RE RE AKMS
Invoice - Net RN RN AKMS
Billing Doc.Transfer RV AB ADS
G/L Account Document SA SA ADKMS
G/L Account Posting SB AB S
Cash Document SK AB S
Adjustment Document SU SU S
Data Transfer UE ADKMS
Goods Issue WA AMS
Goods Receipt WE AMS
Inventory Document WI AMS
Goods Issue/Delivery WL AMS
Page 13
2009
Page 14
2009
CHAPTER 2
MASTERS
General Ledger Account Codes
A G/ L account number identifies the account code in a Chart of accounts and has to be defined for each Company Code
before any postings can be made to the same.
In case of Greaves Cotton Limited and Premium Energy Transmission Limited , the GL account has been defined as a 6 digit
numerical code having a series as displayed in the slide herein below.
Page 15
2009
Listed below are the steps that need to be followed for creating a new GL account.
Enter the number of the account code and the corresponding Company Code in which it is to be created.
Specify whether the account is of the type Balance Sheet or P & L type.
Page 16
2009
Before opening a new GL account, execute tcode F.10 and ascertain the next free number available in a Account group.
Goto the tab for Control Data and specify the following
Specify the currency. This normally gets defaulted from the Company Code currency.
Incase if an account is a Reconciliation account, indicate the same in the field provided.
Select the check box for Open item management & Line item Display . In case of P&L items, the Recon
account and Open item management field is
Note that a Reconciliation account will be used for Vendor and Customer sub-ledgers and cannot be posted to directly.
Based on the value entered in the Sort Key, the Assignment field in the GL account gets populated.
Specify the Field Status Group (FSG). A FSGhelps in identifying the fields that are to be entered while booking an
entry to the GL account.
Incase of Cash and Liquidity related GL accounts, indicator for Planning Level and Relevant for Cash Flow needs
to be populated. Such GL accounts are then displayed in the Cash Management reports.
Page 17
2009
Remove the tick for field check file only check box
Page 18
2009
Page 19
2009
Controlling area
Planner Profile
Page 20
2009
There are various layouts available for maintaining Activity Prices. We have to select 1-201 Activity Types with Price:
Standard
Version should be 0
Fill in the
Unit i.e H for hours ( used for all the hour based rate)
Page 21
2009
Allocation Cost Element- Provide the Secondary Cost Element which should start from 943***
The allocation cost element is a secondary cost element, under which the activity type or business process is allocated.
The allocation cost element is the central characteristic used in all CO postings. It is therefore also an important criterion
for reporting - for example, many reports are structured according to the posted cost elements.
The allocation cost element must have been created in the cost element master data as a secondary cost element of
category 43 "Allocate activities/processes".
If we want to maintain activity price for more than one period then click on following
screen appears
Page 22
2009
Provide the Name and the Description and Cost element Category as 43 Internal Activity Allocation
Page 23
2009
Specify the Company Code and the Account group using which the Vendor code needs to be created. Based on
the Account group selected, the number range gets decided and it may be a External or Internal numbering
sequence.
Click on Enter and in the displayed screen enter the Address details of the vendor. Note that the address as
entered here gets printed on the TDS Certificates and other external correspondences with the Vendor.
Click on the Tab for CIN Details and specify the PAN and Service Tax numbers of the Vendor wherever available
Page 24
2009
Coming back to the main screen will display the following tab wherein a link can be established if Vendor is also a
Customer.
Due to this linkage the combined balance of the Vendor/Customer can be available in a single line item display report.
In the next tab, the bank details of the Vendor can be maintained. An important indicator in this tab is the check box for
Individual Payee .
Selecting this activates a special screen during document entry wherein the description of the Vendor can be entered.
A cheque printed for such a document will then be in the name as maintained in the document and not as per the Vendor
Master record.
Page 25
2009
In the tab for Payment transactions the details like Reconciliation account and Sort key needs to be specified.
The Cash Mgmt Group field is mandatory and a appropriate value needs to be entered therein. This again will be help in
displaying the Vendor
In the tab for Payment transactions , the Payment terms and Payment methods can be entered. These serve as default
values at the document entry level
Page 26
2009
The check box for Chk double invoicing also needs to be selected.
In the tab for Correspondences specify a value in the field for Account statement . This helps in generating Account
Statement correspondences
To the Vendor.
Page 27
2009
These codes then appear as a default during Document entry and can be changed while booking a transaction.
Note that only when a TDSCode is maintained in the Vendor master will the same get defaulted at document entry level
else no TDS will get deducted.
CO indicates the status of the Vendor eg. Company or Others. The checkbox for Liable needs to be selected in order that
TDS may get deducted.
the number range gets decided and it may be a External or Internal numbering sequence.
Page 28
2009
Click on Enter and in the displayed screen enter the Address details of the Customer.
Click on the Tab for CIN Details and specify the PAN and Service Tax numbers of the Customer wherever available
Page 29
2009
Coming back to the main screen will display the following tab wherein a link can be established if Vendor is also a
Customer. Due to this linkage the combined balance of the Vendor/ Customer can be available in a single line item display
report.
In the next tab, the bank details of the Customer can be maintained. An important indicator in this tab is the check box for
Individual Payee .
Selecting this activates a special screen during document entry wherein the description of the Customer can be entered.
A cheque printed for such a document will then be in the name as maintained in the document and not as per the
Customer Master record.
Page 30
2009
In the tab for Payment transactions the details like Reconciliation account and Sort key needs to be specified.
The Cash Mgmt Group field is mandatory and a appropriate value needs to be entered therein. This again will be help in
displaying the Customer
In the tab for Payment transactions , the Payment terms and Payment methods can be entered. These serve as default
values at the document entry level
Page 31
2009
In the tab for Correspondences specify a value in the field for Account statement . This helps in generating Account
Statement correspondences To the Customer.
Page 32
2009
In the tab for WITHOLDING TAX specify the TDS Section under which tax is to be deducted from the Customer
Invoice/Payments.
These codes then appear as a default during Document entry and can be changed while booking a transaction.
Page 33
2009
Page 34
2009
Currently the System Status is shown as CRTD ( which means that created status)
Page 35
2009
Select statistical order check box (if we select this check box values in the internal order can be viewed but not allow to
allocating the cost to some other cost object (Eg: cost center, internal order)
(If order is in CRTD (create) status we can maintain only plan values
REL (release) status system will allow plan and actual values
TECO (technically complete) status system will allow only actual values
Specify the Asset Class under which an Asset is to be created as also the Company code of creation.
Page 36
2009
Enter details relating to the asset like description, serial number, Inventory number etc. in the field provided.
Enter the Cost Center and the Location where the asset is situated. Incase if the cost center or location changes then the
same can be
Modified in the asset master by choosing the option of More Intervals . Incase if shift depreciation is to be activated then
the field Multiple Shift can be activated and along with the Variable portion field in Depreciation areas the required
rate can be manipulated.
Page 37
2009
The Group Asset field has been mandatory for input and is basically used for tracking Depreciation as per the Income Tax
Act.
Specify the appropriate Block of Assets to which the individual asset pertains to.
The field Scrap Value or Scrap % needs to be entered incase if the asset is expected to have a residual value at the end of
useful life of the asset.
Page 38
2009
An Asset sub-number is normally created when a material and significant extension is made to the main asset which has its
own depreciation terms and useful life as distinct from the main asset.
Enter the main asset number for which a sub-number needs to be created and click on enter. By default all the asset details
as provided in the main asset gets copied onto the asset sub-number.
Page 39
2009
The Asset master display can be had through AW01N and is as shown below. In the tabs for Planned Values the
capitalization details are available.
In the Posted Values, the month wise depreciation figures can be know whereas the tab for Comparisons the year-wise
depreciation details can be had.
Page 40
2009
Page 41
2009
Page 42
2009
Provide the company code as shown above and press enter. bellow screen click on new entries
Click on Create button. Following screen appears. Provide all the information and save .
Page 43
2009
If we have are doing reconciliation for the BANK we have to maintain three (3) Bank A/cs for the Each Bank viz.
All the credit transaction should go to Receipt A/c and all the Debit entries should go to Payment A/c
Note : No entries should be passed manually in the system in the BANK MANIN A/C . System will transfer the entries at
the time of Bank Reconciliation from Inflow & Outflow to Main A/c
Page 44
2009
Please take care that in the main Bank A/c Only line items to be selected . For inflow and outflow accounts we need to
select open item management check box in control data tab
For Main Bank A/c go to FI12 (House Bank Create Screen) and mention the Main Bank A/c Code in front of GL
Page 45
2009
Select the Desired Company and Click on Bank Accounts following screen appears (OBVCU)
Click on New Entries Tab and enter the Bank Payment A/c and Save.
Page 46
2009
No need to do any individual banks . As per the configuration the system automatically takes the account codes ending
from 0 and adds 1to that number and treats as Inflow A/c .
Page 47
2009
Mention the various check lot to be used for Automatic and manual Payments
Page 48
2009
Chapter -3
Transactions
Booking a Journal Voucher (F-02)/ (FB50)
Navigation Path
The document entry screen comprises of Header and Line item details to be filled in while booking a transaction.
Details entered in the Header are relevant for the whole document. There can be a maximum of 999 lines in a single
document.
Enter details like Date, company code text etc in the Header area of the screen.
Enter Line item details like Posting Key and the corresponding Account code and specify the amount per line item. Incase
of expense accounts
It is mandatory to enter a Cost Object like Cost Center, Internal Order or Profitability Segment against it. The Assignment
field can be used for the purpose
Page 49
2009
Entering + and clicking on Enter will automatically copy the text as entered in the earlier line items
Once all the line items have been entered, simulate the entry. This will display the accounting entries that will be passed on
saving the transaction.
In case of unbalanced entries, system will not allow the posting of the document. Check that the Dr and Cr amounts are
equal for posting.
Page 50
2009
It is preferable to go with T.Code FB50 as in this mode we need not to remember Posting Keys for Debits and Credits . We
can pass entries with Debit and Credits and in the single screen.
Page 51
2009
Note- On the left hand side of the screen there we see some signal type indicator . We cannot post the transaction until
it turns to Green colour .
As the Total Debits and Total Credits amount are equal the signal turns green and we are able to post the transaction.
Provide the values as shown above and click on simulate button. System will generate the following screen
Simulation means the display of entry before posting it finally. We should always simulate the transaction to check the
accuracy of the transaction. As we simulate we can view the following details of the transaction.
If the Transaction is correct we can Click on save button else we can modify the transaction. As we save the transaction a
document number is generated at the bottom line of the screen.
In case we are not sure about the correctness or we don t want to post the transaction immediately, we can Park the
transaction by clicking on button. The system will neither move this document to Financial Books nor it will
generate the Document number for the transaction.
After we are confirm about the transaction we can Save the transaction from the Park mode to Post Mode
Page 52
2009
Provide the values as shown above. We can search the document on the various criteria.
Click on execute button. As we click on the
Page 53
2009
Page 54
2009
Page 55
2009
Page 56
2009
Page 57
2009
Page 58
2009
Provide the document number and others which shown in the above screen
Press enter
Change the Document TYPE as required and press enter continuously until the following screen appears
Page 59
2009
A template can be maintained for entries that are frequently passed each month. Such entries are referred to as Recurring
Entries .
As a onetime activity the entry can be maintained and the same recalled each month and the entry posted.
Page 60
2009
Enter details like First run, interval, Document type etc. in the Header. In the line items enter the accounts that need to be
posted to.
First Run On: - Date from which the first recurring entry is to be carried out.
Last Run On: Date up until which the final recurring entry is to be carried out.
Interval: Date up until which the final recurring entry is to be carried out.
Run Date: Calendar day on which the recurring entry is to be carried out. If we do not specify a day, then the calendar day
which we entered in the "First run on" field is used.
Document Type : Mention the desired document Type
Page 61
2009
Enter Line item details like Posting Key and the corresponding Account code and specify the amount per line item. Incase
of expense accounts
It is mandatory to enter a Cost Object like Cost Center, Internal Order or Profitability Segment against it. The Assignment
field can be used for the purpose Of sorting of line items.
Click on simulate to check the entry and then save the entry and after saving the following lines appears in the
bottom of the screen.
We can go to Documents and click on display to see the previous entry passed.
Page 62
2009
Enter the document number and the period for which the recurring entry needs to be generated. The session
name can be entered manually for
Easy identification. Executing the transaction now will generate a Batch input session.
Page 63
2009
A batch input sessions gets created that needs to be further processed either in the foreground, background or
errors only mode. If processed
In the foreground mode, each line item screen will come up and it is possible to change the values during
posting.
Page 64
2009
Select the respective session and click on process button . System popup following screen
The system processes the recurring entries showing following screens go on pressing Enter till the document is
posted
Page 65
2009
Chapter 4
Accounts Payable
Decide on the Company code in which the Invoice needs to be posted and the currency involved. One can also specify the
currency conversion rate that needs to be adopted for the transaction. In the reference field enter the Invoice number of
the Vendor Invoice and the corresponding text.
By default, the above screen for TDS deduction comes up. TDS is applicable on Invoicing or Payment whichever is earlier.
Remove the TDScodes against PAYMENT( CP) line as this indicates TDSdeduction at the time of payment. Incase if
Page 66
2009
The light next to the tabs reflects the balance in the document currency:
We can define how we want the debit/credit indicator to appear in Editing Options
Simulate: A document overview appears in which we can select various options for data preparation.
If the entry is ok then Save the entry the Document number will be generated.
Note : We can use FB60 or F-43 for the voucher entry in FB60 we have debit credit screen and in T.Code F-43 we have
to use posting keys to do the transactions .
The procedure for booking of Vendor Invoices remains the same except that a special screen for inputting the Vendor
name and address details comes up. Note that the cheque will get printed as per the name specified in the name field. This
Page 67
2009
Only we have to select the transaction type as credit memo in FB60 / F-43 or we can use FB65/F-41 for creating credit
memos for accounts payable.
Page 68
2009
Page 69
2009
Click on process open item button .. system will open the following screen
Page 70
2009
Remove the value put the * in the amount field click on button
Not assigned field need to always 0. Simulate and post the document
Page 71
2009
Advance payment to vendors are identified in SAP through the use of Special GL indicators. Incase of Greaves Cotton
Limited and Premium Energy Transmission Limited , the indicators that can be used are . Note that
the postings through these indicators get routed through the advance account and not the normal Reconciliation account
Page 72
2009
Specify the Company code, Vendor Code, bank account number and the amount that is to be paid as an Advance and click
on Enter.
The above screen for TDS gets defaulted. Incase if no TDS is to be deducted then the TDS codes needs to be manually
deleted from the above screen.
Page 73
2009
Page 74
2009
If System Displays the Invoice Number in the Primary Screen remove the Invoice and click on
Note : - Provide the Narration in the Text field else the system will not allow to save the document.
Select the Transfer Posting and provide the amount we want to match with the invoice and
simulate the transaction.
Page 75
2009
Now we can clear the invoice with the advance amount (F-44 Clear)
Now we can select process open items and clear the bills
Page 76
2009
Import process
Purchase order:
In the purchase order item data views click on conditions tab select the custom duty conditions for view and change the
custom vendor if required.
Page 77
2009
Page 78
2009
For clearing forwarding sake we are using ZIF1 condition do the same thing for providing vendor.
Page 79
2009
Then provide the purchase order number in purchase order field as shown bellow
Select the planned delivery costs in the above screen and press enter
Page 80
2009
Copy the values from net PO value field and past in the amount column and put quantity as 1 in each column as
shown bellow
Page 81
2009
Put the value in the amount field as shown in the above screen and simulate and save
Page 82
2009
Go with MIGO
Press enter
Page 83
2009
System will propose above screen provide the miro document number and year press enter
Select item on check box in the above screen fill all the mandatory fields and click on post button
Then release the goods from block stock select A05 document type as shown bellow in MIGO transaction provide
the purchase order number system will propouse you bellow screen again provide the MIRO document number
Page 84
2009
Fill the excise invoice number and date, provide the storage location in the above screen select item ok check box and click
on post button. GR fi entry
Excise entry
Page 85
2009
In the above screen you need to select 3 goods/services items + planned delivery costs
Page 86
2009
Now system will show you all the lines deselect the line which not relevant for import vendor as shown bellow Eg: I have
deselected 11 number in the bellow screen
Page 87
2009
Press enter
Page 88
2009
Chapter 5
Accounts Receivable
Click on Simulate and we will get the following entry if it is correct we can save the same
Page 89
2009
We can view the General ledger View how it is posted in Journal Ledger .
Note that the values entered in the Text field will get printed on the Sales Invoice generated. Enter the Income account in
the next line item and click on Enter
Page 90
2009
Page 91
2009
Page 92
2009
Provide the
Bank GL Code
Company Code
Document Type
Date
Execute the report we get the following output
Page 93
2009
Mention the Special GL Indicator as 2 then only system will accept the transactions.
Page 94
2009
Simulate
Page 95
2009
Click on simulation
Page 96
2009
fill the missing values in the TEXT field (Narration) and save the document
Page 97
2009
Page 98
2009
Page 99
2009
The Jounal Entry passed in the system for clearing the transaction will be as follows
Page 100
2009
Page 101
2009
Note: When we post and clear documents, the system uses the exchange rates defined for rate type M to translatethe
currencies. There must be an entry in the system for this rate type.
The exchange rates apply for all company codes it is on the client code level.
All the existing exchange rates appear in a table in the Change View Currency ExchangeRates : Overview screen.
To change an existing value, we simply overwrite it.
To delete an entry, select it and choose Delete.
Page 102
2009
Click on DISPLAY CURRENCY to view the exchange gain loss on the payment transaction.
Page 103
2009
Use
All open items in foreign currency are valuated as part of the foreign currency valuation:
The individual open items of an account in foreign currency form the basis of the valuation, that is, every open item of
an account in foreign currency is valuated individually.
The total difference from all the open items in an account is posted to a financial statement adjustment account. The
account therefore retains its original balance.
The exchange rate profit or loss from the valuation is posted to a separate expense or revenue account for exchange
rate differences as an offsetting posting.
Features
Unrealized exchange rate differences
When we valuate open items in foreign currency, the exchange rate difference determined is posted as an unrealized
exchange rate difference.
Realized exchange rate differences
For an incoming payment, that is, when we are clearing the open items, the current exchange rate is determined. Since the
exchange differences that were not realized are reversed, the full exchange rate difference is posted as realized.
Page 104
2009
Page 105
2009
Now system will crate the batch for execute the batch go with T.Code: SM35
Page 106
2009
Page 107
2009
The balance, that is, the foreign currency balance of the G/L account managed in the foreign currency, forms the
basis of the valuation for each foreign currency and foreign currency balance sheet account.
The result of the valuation is posted to the valuated account or to a adjustment account.
The exchange rate profit or loss from the valuation is posted to a separate expense or revenue account for
exchange rate differences as an offsetting posting.
BILL OF EXCHANGE
Page 108
2009
If the bill of exchange is used for refinancing and is passed on to a bank, then the bill of exchange usage must be posted.
The bill of exchange liability (liability to recourse) that we now have is recorded on special accounts in the system until it
has expired.
Once the due date of the bill of exchange has elapsed, including any country-specific period for the bill of exchange
protest, we can cancel the bill of exchange receivable for our customer and the bill of exchange liability.
Navigation
Page 109
2009
Page 110
2009
Page 111
2009
Page 112
2009
Page 113
2009
Page 114
2009
Enter + in the entry field for which we want to reverse the transaction. And save the transaction.
Page 115
2009
Page 116
2009
c) Discounting F-33
40 Bank Inflow Dr 24500
40 Bank Charges Dr 500
50 To Bill Discounting 25000 Normal GL Credit
Page 117
2009
These can be used for recording Bank Guarantee or any other entries which we don t want to post in the customer Account
and the general ledger A/c. It will be working as single sided entry.
These entries will have no effect on the Financial Books. We use them only for the record purpose and after the purpose is
over we can reverse the same
Fill in the Bank Guarantee Due Dates so that on the Maturity Date we can reverse the same.
Page 118
2009
This will be single screen entry and simulation is not there as it doesn t affect the finance Books.
For viewing the noted items we have to go to Line Item Display FBL5N - Display/ Change Line Items
Select the Noted Items for viewing only noted Items or select Normal Items and Noted Items for all the items.
We can view the noted Items in the Line item Display here it forms the part of the Customer Balance and effects the
balance of the Customer. If we want to see only Noted Items Click on Noted Items only and we can get the List of noted
Item.
Note : We can get the total listing for the Guarantees Received and Given / Taken.
Page 119
2009
On the other hand if we see the Customer Ledger Balance it does not incorporate these Noted Items / Memorandum
Entries
Hence it does not affect our financial Books by using Noted Entries.
Page 120
2009
If we click on cumulative balance we can get the detail line item wise entry without noted items.
Page 121
2009
As normal documents are reversed we can same way reverse the Noted Entries by using FB08
Provide the Noted Item Document Number, Company Codes, Fiscal Year and Reversal Reason
Page 122
2009
Chapter 6
Click on execute button, following screen appears showing details of all the cheques issued /cancelled .
Page 123
2009
Page 124
2009
Click on the Spool Number and we can get the following report
Page 125
2009
Fill the values as shown above (provide the cheque number which wer are going to issue)
Page 126
2009
Note: In the case of deletion system delete the cheque number. We can use the same cheque number for another
document.
Page 127
2009
Enter the Company code, Bank and cheques that need to be voided. Note that a range of cheques can also be voided
through this transaction. Specify a void reason code and click on the icon for Void
Incase if cheques that have been already issued need to voided, the t code FCH9 can be used to void the same.
Enter the Company code, Bank and the cheque that need to be voided. Specify a void reason code and click on the icon for
Cancel Payment
Page 128
2009
Enter the Company code, Bank and the cheque that need to be voided. Specify a void reason code and click on the icon for
Cancel Payment
The cheque gets voided and a reversal document gets posted in the system. Resultantly, the Vendor Invoice that had been
paid off gets a status as Open from Cleared
Page 129
2009
Press enter
Page 130
2009
Reprinting of Cheques-FCH7
Incase if sue to some reasons, a cheque needs to be reprinted the same can be done through tcode FCH7. Enter the
Company code, Bank and the cheque number that needs to be reprinted.
A spool request for printing the cheque also gets created that can be used for generating the cheque. Here there is an
option to print the same cheque or void the previous cheque and print a nee one in its place.
Page 131
2009
We have to mention Pay methods as C as cheque payments . This indicates that method selected will grouped at the
time of Automatic Payment Program.
In case of bulk printing of cheques, T. code F110 is to be used for the same. Enter the Run date and a unique Identification
for the same. The initial status is No parameters entered.
Page 132
2009
Next payment date should be the next date of run date any future date
Page 133
2009
As we save the Screen shows the following Screen. Parameters Have been Created .
Page 134
2009
Keep on press enter till we get the message Payment proposal has been created
Page 135
2009
If we want to block the respective document provide the A in payment block field
If we want to pay the amount which against document which is previously blocked click on reallocate button in the above
screen
As we select reallocate button another screen appears asking for house bank from which we want to make payments and
the payment method.
Once we select particular line item the colour turns blue and it is ready for the payment
Page 136
2009
Variant parameters
Page 137
2009
Page 138
2009
Keep on press enter till we get the message Posting orders: 1 generated, 1 completed
Page 139
2009
Page 140
2009
Incase if a Cash payment needs to be entered, goto the tab for Cash payments and select a business transaction for
Expenses or vendor payments.
Enter the amount of receipt and the GL account to which Debit posting has to be made. Incase of expenses, ensure that the
relevant Cost Center has been specified in the line item. Specify a text or narration wherever applicable and Post the entry.
An accounting document gets generated and the Cash balance now gets updated by the amount of payment entered.
Incase if multiple line items need to be entered in a single cash payment the icon for Split needsto be selected and
details entered therein.
Page 141
2009
In case if a Receipt needs to be entered, go to the tab for Cash receipts and select a business transaction for Receipt.
Enter the amount of receipt and the GL account to which Credit posting has to be made. Specify a text or narration
wherever applicable and Post the entry. An accounting document gets generated and the Cash balance now gets updated
by the amount of receipt entered
Daily Balances of Cash A/c can be known from the side screen
Click on
Page 142
2009
In case we want to have more than one line in single cash vouchers we can have split option. If we use another line in the
main screen it will create another document with separate Document Number. Split option will only generate one
document.
Create a Transaction
Page 143
2009
Provide all the Details Like GL account Payment Amount, Cost Centre, Profit Centre, Click on copy
The Original Screen comes back and post the transaction click on
Once the Document is posted we can see the accounting entry posted click on
If we require to print the Cash Payment / Receipt Voucher we can click on give the printer name
Page 144
2009
As we can Pay Cash / Receive Cash for the General Ledger Accounts we van also receive/Pay cash to
Vendors and Customers
Page 145
2009
Dont mention general ledger Account Code. Select Business Transaction type and Mention only Vendor / Customer Code.
If the Advance Payments are there the system will automatically take the special GL indicators and post to the Advance
Accounts.
Page 146
2009
If any mistake has happened or we need to reverse any transaction select the line item and click on delete button at the
and a new tab for Rason for Reversal Appears Give the reason and select the
Page 147
2009
Bank Reconciliation
Integration
The graphic below gives an overview of the process for entering bank statements manually.
Procedure
To process the bank statement, proceed as follows:
Company Code
-- House Bank
Page 148
2009
3. Confirm the entries. On the next screen, we can process the bank statement data.
4. We have to select Transaction Type, Value Date, Amount Profit Centre, and Customer.
5. Note that Amount Entered and Bank Statement Amount at the Bottom should match, then only the system will
allow us to save .
Page 149
2009
Click
The system displays the screen with the basic data again.
Page 150
2009
When we have the error system will show transaction will red indicator
For posting the transaction select the respective line item, select in the menu statement items - post
Page 151
2009
Note: In general we have to upload the Data in Excel Sheet as per the required Format and then do the Reconciliation
Process. We will not be entering the entry by entry in the system.
Page 152
2009
Being a customised application we have to go through T.Code. ( ZFF67). There is no navigation menu.
Select the Excel sheet where you have saved the Bank statement in the prescribed format
And Click on the Execute Button and the system will process the excel file and upload in the system.
compa house account statem statement opening closing transac value date amount custo bank profit allocati
ny bank id ent date balance balance tion mer reference center on
code number type
1000 HDFC1 HDFC1 77 16.12.2008 11013253.00 11033253.00 C002 13.12.2008 10000 refer 1102001 allow
Page 153
2009
To customer 10000
Page 154
2009
Bank reco at HO
Page 155
2009
Chapter 7
FIXED ASSETS
Asset procurement process:
Page 156
2009
Page 157
2009
Page 158
2009
Press enter
Page 159
2009
Page 160
2009
Save.
Page 161
2009
System creates internally one CWIP asset for view the asset master go with T.Code:KO03
Page 162
2009
Page 163
2009
Page 164
2009
we have to select accounting category as F because we are using Internal order for Assets
Procurement.
Page 165
2009
Page 166
2009
Now the Purchase Order is released to the Vendor . We can receive the material so we can go for GR.
Page 167
2009
Page 168
2009
Page 169
2009
Page 170
2009
Page 171
2009
Execute
Page 172
2009
Page 173
2009
Take the asset class 3000 company code 1000 press enter
Page 174
2009
Double click on book depreciation line item for filling variable dep portion (this is required only for plant and
machinery)
Page 175
2009
Page 176
2009
Page 177
2009
Page 178
2009
Execute the above tcode for posting the monthly depreciation for a Company code. Incase if a display is
required prior to posting the actual Depreciation, select the option of Test run and execute. Normally, the
radio button for Planned posting run will be used. However, if any changes Have been made to the
depreciation terms and depreciation needs to be recalculated then the option of Repeat run needs to be
selected. Due to this the Differential amount of depreciation now gets posted.
Page 179
2009
Incase of no errors in the Depreciation run, the message for successful completion of the test run will be given as shown
above.
An update run for actual posting must always be executed as a Background job. The accounting entry then gets generated
else the batch input
After we are satisfied with the Results we can run in the Final Mode and Final Mode can only be run in the Background
Page 180
2009
After click on save button .For view the job go with T.Code: SM37 or we can select in the following way
Page 181
2009
Depreciation document
Ledger level
Page 182
2009
Now we can go to AW01N - Asset Explorer and view the depreciation and other details
Page 183
2009
Use posting key 50 and 390000 asset clearing account and transaction type 210 press enter
Enter the amount and the relevant Cost center to which the disposed asset belongs to. Next click on the small checkbox for
Asset retirement and click on enter.
Press enter
Page 184
2009
The adjacent screen comes up wherein details of the asset that is to be disposed off needs to be entered. Click on the
option of Complete retirement if the whole asset is being disposed off. Else Partial retirements, the amount or qty fields
can be specified.
Simulate the document and Post. Correct the highlighted lines before posting.
Select Rev. From NBV radio button and put the value 01 and click on save button.
Page 185
2009
Display of AW01N for the asset now shows the retirement entries.
Page 186
2009
Sales of Assets
Place the cursor on the Gain and Loss item and click on Additional account assignment . Enter the Cost center and save
the transaction.
Display of AW01N for the asset now shows the disposal entries.
Click on Simulate and check the entry and if OK we can save the Entry.
Page 187
2009
Provide the existing asset number Provide the dates Select new asset Radio button Click on master data
Provide the values as shown above and click on additional data button in the above screen Provide the required values and
Come back from the above screen And click on save button
Page 188
2009
Provide the asset number which we want to revaluate provide the dates and Trasaction type R90.
Press enter
Page 189
2009
Page 190
2009
Use transaction type 650 for current year acquisition and 640 for previous year acquisition
Provide the asset number which we want to revaluate and put the document date and posting date
and transaction type.
Press enter
Page 191
2009
Provide the depreciation value as shown above and save. System will post document in asset
accounting only
For updating in FI
Page 192
2009
Page 193
2009
Chapter 8
GL
with holding tax types at the time of invoice min.amount account
AI INV - SEC 194A - INT OTH THAN SECURITIES 150001
CI INV - SEC 194C - PAYMENT TO CONTRACTORS 150002
HI INV - SEC 194H - COMMISSION OR BROKERAGE 150003
II INV - SEC 194I - RENT 120000 150004
JI INV - SEC 194J PROF/TECHNICAL SERVICES 150005
FI INV - SEC 195 FOREIGN TRANSACTIONS 150006
WI INV - WCT
GI GTA - Service tax 150110
GE GTA - Cess 150120
GH GTA- Ecess 150130
T1 INV - Sec 206C TCS IT 150050
T2 INV - Sec 206C TCS SC 150051
T3 INV - Sec 206C TCS EC 150052
WITH
TYPE WITH CODE DISCRIPTION TAX RATE
AI A1 INV - Sec 194A -Non Corporate < 10 lac 10.3
AI A2 INV - Sec 194A -Non Corporate > 10 lac 11.33
AI A3 INV - Sec 194A - Companies <1 Crores 20.6
AI A4 INV - Sec 194A - Companies >1 Crores 22.66
Page 194
2009
GI G1 GTA 3.00%
GE G1 GTA-Surcharge .06%
GH G1 GTA-Cess .03%
Page 195
2009
Page 196
2009
In the above screen Business Place and Section Code fields need to be filled. As the TDS Reports are based on the Business
Place. Business Place has been defined based on the TAN Number.
Press enter
Press enter
Page 197
2009
At the time of invoice booking system will provide information relation to advance user need to reduce the advance
amount out of invoice value and need to put that amount and user need to remove the withholding tax type at time of
payment as shown bellow screen.
Page 198
2009
All line items that have been posted to the TDS Payable account will get displayed. Select all and go to Document overview.
Page 199
2009
Page 200
2009
Page 201
2009
Save.
Tip: - In general the TDS line items will be in the non selected mode as we have to select many line items for making the
TDSpayments we can go for Accounting Editing Options - T.Code: FB00
Click on open items tab as shown below, and select check box Select Item Initially Inactive as shown below
And save
As we save it all the line in the TDS Payments will be in the selected mode (Blue Colour) and in case we want to deselect
any line item by double clicking on it we can de-select the particular line.
Specify the Recipient type i.e Corporate and Non Corporate , we cannot run both at the same time. This session again
needs to be executed separately for Companies and Others.
Page 202
2009
Page 203
2009
Following navigation
Page 204
2009
Provide the values as shown above. click on execute button. System propose following screen
Page 205
2009
Page 206
2009
TDS REPORTS
Execute transaction code J1INMIS with the details as shown in the adjacent screen. Normally the date should be for a
quarter for which TDS returns need to be filed. Executing the session will give a display of all Invoices covered under the
entered section code. Select All and Execute again.
Page 207
2009
We have to go to Vendor Master ( FK02/XK02) select the withholding TAB and go to the screen as follows
Example: -
Suppose the TDS rate is 10%
He has got the concession Certificate of 2%
Hence he has got the rebate of 80% from the original Rate of TDS
So mention the 80% in the Rate % Column ( Note :- Don t Put Concessional Rate of TDSi.e 2%)
Now do the Normal Invoicing or the Payment the system will deduct the TDS and the reduced rates
Page 208
2009
Service Tax
Press enter provide the values as shown bellow ( V for input tax, A for out put tax)
A Tax Code KJ has been created. The nature of Tax Type is V as it is Input Tax . As Service Tax has a concept of
movement of Amount of from Interim A/c to Final A/c .
SO we have defined for Example Purpose KJ as Interim Account and KK as Final Account.
Page 209
2009
Press enter
No need to maintain any thing in the above screen, click on save button.
Page 210
2009
For maintain the %rates for each component of tax need to go with T.Code: FV11 , for service tax we have to use JSRT
condition type and SMX1 for service tax Base ..
Press enter
Page 211
2009
In Expenses General Ledger Account need to put ( ) sign and (+ ) sign for income GL. Or put * capturing both tax codes.
Following are the Various Material Tax Codes are created in SAP System
Page 212
2009
JMX JMO JEX JEC JHX JSE JSR JEC JSE JMX JMI JEX JEC JHX JSE JVR
Tax code Description 1 P 1 1 1 1 JVRD SMX1 T 3 3 2 P 2 2 2 2 N JIPC
A/P IN:
IN: IN: Ece A/P A/P
A/P IN: A/P ss SEC SEC A/P BED A/P A/P A/P A/P
BED BED ECS for es ess Servic servi BED inve ECS ECS SCS SCS
setof setoff seto Seto setof Seto e Tax ce eces inve ntor inve Inve inve Inve VAT
f % ff ff f ff VAT base tax cess s ntor y% nt. nt. nt. nt. INV CST
ED CENVATABLE + CST
INVENTORISED
1A ED(10+2+1)CST-INV(2) 100 10 100 2 100 1 2
1B ED(10+2+1)CST-INV(1) 100 10 100 2 100 1 1
1C ED(10+2+1)CST-INV(0) 100 10 100 2 100 1
1D ED(4+2+1)CST-INV(2) 100 4 100 2 100 1 2
1E ED(4+2+1)CST-INV(1) 100 4 100 2 100 1 1
1F ED(4+2+1)CST-INV(0) 100 4 100 2 100 1
1G ED(0)CST-INV(2) 2
1H ED(0)CST-INV(1) 1
1I ED(0)CST-INV(0)
1J ED(INCL)CST-INV(2) 100 0 100 2 100 1 2
1K ED(INCL)CST-INV(1) 100 0 100 2 100 1 1
ED CENVATABLE + VAT
INVENTORISED
2A ED(10+2+1)VAT-INV(4) 100 10 100 2 100 1 4
2B ED(10+2+1)VAT-INV(8) 100 10 100 2 100 1 8
2C ED(10+2+1)VAT-INV(12.50) 100 10 100 2 100 1 12.5
2D ED(4+2+1)VAT-INV(4) 100 4 100 2 100 1 4
2E ED(4+2+1)VAT-INV(8) 100 4 100 2 100 1 8
2F ED(4+2+1)VAT-INV(12.50) 100 4 100 2 100 1 12.5
2G ED(0)VAT-INV(4) 4
2H ED(0)VAT-INV(8) 8
2I ED(0)VAT-INV(12.50) 12.5
ED CENVATABLE + VAT
2009
G r e a v e s Co t t o n L i m i t e d Page 214
2009
5G ED-INV(0)VAT-INV(4) 4
5H ED-INV(0)VAT-INV(8) 8
5I ED-INV(0)VAT-INV(12.50) 12.5
5J ED-INV(INCL)VAT-INV(4) 100 0 100 2 100 1 4
5K ED-INV(INCL)VAT-INV(8) 100 0 100 2 100 1 8
ED-INV(INCL)VAT-
5L INV(12.50) 100 0 100 2 100 1 12.5
ED-INV(INCL)VAT- 21.4
5M INV(21.43) 100 0 100 2 100 1 3
G r e a v e s Co t t o n L i m i t e d Page 215
2009
23 1440-SER(12+2+1)-INT 100 12 2 1
24 1440-SER(12+2+1)-FIN 100 12 2 1
25 2110-SER(12+2+1)-INT 100 12 2 1
26 2110-SER(12+2+1)-FIN 100 12 2 1
27 2120-SER(12+2+1)-INT 100 12 2 1
28 2120-SER(12+2+1)-FIN 100 12 2 1
29 2130-SER(12+2+1)-INT 100 12 2 1
30 2130-SER(12+2+1)-FIN 100 12 2 1
31 2140-SER(12+2+1)-INT 100 12 2 1
32 2140-SER(12+2+1)-FIN 100 12 2 1
33 2160-SER(12+2+1)-INT 100 12 2 1
34 2160-SER(12+2+1)-FIN 100 12 2 1
35 2161-SER(12+2+1)-INT 100 12 2 1
36 2161-SER(12+2+1)-FIN 100 12 2 1
37 HO-SER(12+2+1)-INT 100 12 2 1
38 HO-SER(12+2+1)-FIN 100 12 2 1
39 WR-SER(12+2+1)-INT 100 12 2 1
40 WR-SER(12+2+1)-FIN 100 12 2 1
41 ER-SER(12+2+1)-INT 100 12 2 1
42 ER-SER(12+2+1)-FIN 100 12 2 1
43 SR-SER(12+2+1)-INT 100 12 2 1
44 SR-SER(12+2+1)-FIN 100 12 2 1
45 NR-SER(12+2+1)-INT 100 12 2 1
46 NR-SER(12+2+1)-FIN 100 12 2 1
GTA SERVICE TAX
9A 1110-SER-GTA(12+2+1) 25 12 2 1
9B 1120-SER-GTA(12+2+1) 25 12 2 1
9C 1210-SER-GTA(12+2+1) 25 12 2 1
9D 1310-SER-GTA(12+2+1) 25 12 2 1
9E 1320-SER-GTA(12+2+1) 25 12 2 1
9F 1330-SER-GTA(12+2+1) 25 12 2 1
G r e a v e s Co t t o n L i m i t e d Page 216
2009
9G 1340-SER-GTA(12+2+1) 25 12 2 1
9H 1350-SER-GTA(12+2+1) 25 12 2 1
9I 1410-SER-GTA(12+2+1) 25 12 2 1
9J 1420-SER-GTA(12+2+1) 25 12 2 1
9K 1430-SER-GTA(12+2+1) 25 12 2 1
9L 1440-SER-GTA(12+2+1) 25 12 2 1
9M 2110-SER-GTA(12+2+1) 25 12 2 1
9N 2120-SER-GTA(12+2+1) 25 12 2 1
9O 2130-SER-GTA(12+2+1) 25 12 2 1
9P 2140-SER-GTA(12+2+1) 25 12 2 1
9Q 2160-SER-GTA(12+2+1) 25 12 2 1
9R 2161-SER-GTA(12+2+1) 25 12 2 1
9S HO-SER-GTA(12+2+1) 25 12 2 1
9T WR-SER-GTA(12+2+1) 25 12 2 1
9U ER-SER-GTA(12+2+1) 25 12 2 1
9V SR-SER-GTA(12+2+1) 25 12 2 1
9W NR-SER-GTA(12+2+1) 25 12 2 1
G r e a v e s Co t t o n L i m i t e d Page 217
2009
Note: While entering the Invoice the Gross Amount ( Including Service Tax )
Initially the service tax amount is posted in the Interim A/c ( Modvat Service Tax to be claimed ) and only after the payment
to the Vendor is made it can be transferred to the Final Service Tax Modvat Account
Check the payment is made before the Service Tax Credit is taken and adjusted with the Excise.
For Transferring Interim Service Tax Amount to Final Service Tax Amount ZST01( or we can go to SE38 and provide the
table RFUMSV50
Note:- by default the screen shows Do Not Update change the radio button to Update Document :Update Run
2009
Go on pressing enter till all the entries are posted and the system comes to main screen .
2009
Excise Duty
Go for the T.Code J1ILN the SAP menu appears as follows
2009
Excise JV (J1IH)
Use the following Navigation path
MB1A
Use
We can follow this procedure if we have scrapped a material and want to reverse the excise duty debited to our
CENVAT account.
Procedure
1. From the SAP Easy Access screen, choose Indirect Taxes Excise JV Create Matl write-off.
2009
o Document number
Enter the number of the document that you used to scrap the material.
3. Choose .
o Manually
o By assigning the line item to an excise invoice
MB1A
2009
Press enter
2009
Use
We follow this procedure if we have not used a material in the production process and want to reverse the excise
duty debited to our CENVAT account.
Procedure
1. From the SAP Easy Access screen, choose Indirect Taxes Excise JV Create Matl non-prod.
2. Enter data as required, including:
o Document number
Enter the number of the material document that the adjustment posting is to refer to.
3. Choose .
o Manually
2009
Use
We follow this procedure if a vendor has increased the amount of excise duty that it originally charged we and
we want to debit the difference to your CENVAT account.
Procedure
1. From the SAP Easy Access screen, choose Indirect Taxes Excise JV Create Additional excise.
2. Enter data as required.
In the Document number field, enter then number of the document sent to you by the vendor.
2009
3. Choose .
4. Adjust the posting date as necessary.
5. Enter the amount of excise duty in either of the following ways:
o To enter line items for different materials and the excise duty accordingly, choose and
enter the line items in the table.
o To enter the excise duty only, choose and enter the excise duty in the totals fields at the
foot of the screen.
For inventory adjustment use T.Code MB1A and rest same as above
2009
Use
We follow this procedure to make an adjustment posting when we transfer money to your personal ledger
account (PLA).
Prerequisites
We have already transferred the money to our PLA at the bank, using a TR6 challan, and have posted the
corresponding accounting document.
Procedure
1. From the SAP Easy Access screen, choose Indirect Taxes Excise JV Create TR6 challan.
We can enter either the challan number or the number of the accounting document.
3. Choose .
If we entered the accounting document number, the system displays the information from it.
Use
We follow this procedure in order to cancel an outgoing excise invoice. It reverses any excise duty accounted
for.
Procedure
1. From the SAP Easy Access screen, choose Indirect Taxes Excise JV Create Cancel exc. inv.
or Indirect Taxes Sales and Outbound Movements Excise Invoice Create/Change/Display .
2. Enter the number, year, and series group of the excise invoice that you want to cancel.
3. Choose Yes.
4. Save the adjustment posting.
2009
Use
We follow this procedure if we want to make an adjustment posting that does not fall into any of the other
categories of adjustment offered by this function. we can only use an external document as our reference
document.
Procedure
1. From the SAP Easy Access screen, choose Indirect Taxes Excise JV Create Other adj.
2. Enter data as required, including:
o Document number
Enter the number of the external document that you want to refer to.
Specify which account is affected by the adjustment posting is for. If the posting does not have
to be remitted immediately, select Fortnightly payment.
3. Choose .
o To enter line items for different materials and the excise duty accordingly, choose and
enter the line items in the table.
o To enter the excise duty only, choose and enter the excise duty in the totals fields at the
foot of the screen.
Provide the company code , Excise Group of which we want to take the Cenvat Register . Provide the Date range for which
we want to limit the report.
We can take the detail and Abstract for Input Materials and Capital Materials and execute the report.
Sort in Export to
Total
Detail ascending Excel Local ABC Analysis
order
Display File