Coal India LIMITED

Standard Operating Procedure cum

End User Manual

SAP
Module-II

Version Issue Date

1.0 31st January 2023
 MESSAGE

Corporate Accounts Team, NCL HQ and SME of FICO Module under the
guidance of General Manager (Finance) Shri Dipen Mehra has come out
with a booklet (Version-1) by compiling the Standard operating procedures
and step by step guide to various task performed by finance team at NCL.
This booklet accurately and concisely summarises all the steps to be taken
by finance team during daily operations with help of various screenshots
and images. This booklet does not relate to any specific subject of the
finance department rather it contains various procedures undertaken by all
finance departments.

Shri Dipen Mehra and team have put their sincere efforts and hard work to
bring out this booklet which is surely going to benefit not only the NCL
Finance team but also the entire coal industry.

I am sure this booklet will become a milestone to solve various difficulties

felt by SAP users in Coal India and widen user’s perspective towards the
ways in which they are going to interact with the various SAP modules.

I once again congratulate Shri Dipen Mehra and team for their sincere
efforts.

Rajneesh Narain
Director (Finance)
Northern Coalfields Limited
 FOREWARD

It gives me immense pleasure and great pride to announce that Corporate Accounts
Team, NCL HQ with the help of SME of FICO Module has brought out a systematic
and well explained volume for Standard operating procedure of various SAP module
being used by Finance department like Financial Accounting and Controlling (FICO),
Material Management (MM), Sales Distribution (SD), Human Capital Management
(HCM) etc.

Firstly, I sincerely want to thank our beloved and highly esteemed Director (Finance)
Shri Rajneesh Narain Sir who has guided and encouraged the team towards the
preparation of such a handbook. It was his idea to prepare a book which contains all
the SAP transaction codes with the process that is to be followed. It was not possible
for the team to prepare this booklet without his support and assistance.

Shri Om Prakash Jangid and his team has put in tremendous efforts to prepare the
first edition of this booklet (Vers. 1). It is a sheer delight to note that team will come
up with subsequent versions as per the necessary amendments and requirements.

I am sure that this book will go a long way in disseminating knowledge and provide
support to resolve various issues felt by users during daily operations.

I once again thank Shri Om Prakash Jangid and team who have come up with this
useful handbook on SAP, which will help the finance team of entire coal India a lot.

Dipen Mehra
General Manager (Finance)
Northern Coalfields Limited
 PREFACE

I with my whole team am really thankful to Hon’ble Director Finance Shri

Rajneesh Narain Sir for guiding and motivating us to prepare this booklet
(Vers. 1). He gave us a basic idea of the booklet and shared his experience
from time to time basis, which has helped us a lot.

I sincerely want to thank respected General Manager Finance Shri Dipen

Mehra Sir for assigning his valuable time and providing valuable suggestions
in preparation of this booklet.

I have always been a supporter of the thought that one should not keep his
knowledge only to himself/herself rather he/she should share such knowledge
with all his colleagues. The idea behind preparing this book was to help the
entire NCL team to resolve all their issues relating to SAP on their own.

I acknowledge my corporate accounts team members Shri Amar Nath Rawat,

Shri Vijay Malpani, Shri Sailen Dutta, Ms. Priyanka Choudhary and SME of
FICO module Shri Manoj Kumar for their sincere efforts and full co-operation
in compilation of this book.

I hope that this book will help users to resolve all their confusions and
issues relating to SAP and thereby saving their time and efforts.

Om Prakash Jangid
Manager (Finance)
Northern Coalfields Limited
 Prepared By

- CA Om Prakash Jangid, Manager (Fin.), NCL

- CA Amar Nath Rawat, Dy. Manager (Fin.), NCL

- CMA Manoj Kumar, Dy. Manager (Fin.), NCL

- CA Vijay Malpani, Assistant Manager (Fin.), NCL

- Shri Sailen Dutta, Sr. Officer (Fin.), NCL

- CA Priyanka Choudhary, Accountant, NCL

 SOP – SAP FICO Module –
Cum End User Manual
(Version – I)

Module – II
- Trial and Ledger Scrutiny
- Cost & Budget
- Establishment
- Cash
- Bill Passing
- Print
- Taxation
- Sales

Module-II 1
Trial and Ledger Scrutiny................................................................................ 6
F.08 – Trial Balance .................................................................................................................. 6
F.01 – Financial Statement ........................................................................................................ 9
FAGLL03 – G/L Account Line Item Display G/L View ................................................................. 10
FBL1N – Vendor line item display ............................................................................................ 13
FBL1N – Customer line item display ........................................................................................ 14
FS10N – Month wise G/L balance display ................................................................................ 15
FK10N – Month wise Vendor balance display .......................................................................... 15
FD10N – Month wise Customer balance display ...................................................................... 15
S_pl0_86000028 – Project wise GL / Trial balance ................................................................... 16
S_pl0_86000030 –G/L Account - balance ................................................................................. 18
zfi_trialbalance – Trial balance in columnar format ................................................................. 19
ZFIZBC – Zero Balance Clearing GL Report ............................................................................... 20

Customer and Vendor .................................................................................. 21

FK01 – Create Vendor ............................................................................................................. 21
FK02/XK02 –Change Vendor ................................................................................................... 21
For updating bank account sequence ........................................................................................... 21
For updating Withholding tax ....................................................................................................... 22
FK03/XK03 –Display Vendor ................................................................................................... 24
FD01 – Create Customer ......................................................................................................... 24
FD02 –Change Customer ......................................................................................................... 24
FD03/XD03 –Display Customer ............................................................................................... 24
FK02/FB02 - Maintaining part bank in already posted document ............................................. 25
First Run FK02 ............................................................................................................................... 25
Now Run FB02 ............................................................................................................................... 26

Cost & Budget Section ................................................................................. 29

FMAVCR01 – How to CHECK budget ........................................................................................ 29
FMBB – Budget upload and budget release ............................................................................. 31
Budget Upload .............................................................................................................................. 31
Budget release .............................................................................................................................. 32
Cost element grouping ........................................................................................................... 33
RECONCILIATION OF COST SHEET IN ERP ................................................................................. 36
Maintain Opening Stock Rate: ...................................................................................................... 36

Module-II 2
 Run the cost sheet by Transaction Code ZFICS ............................................................................. 37
Reconciliation................................................................................................................................ 38

Establishment .............................................................................................. 41
ZHR_SAL_REG– SALARY REGISTER........................................................................................... 41
ZHCM_PAYSLIP_ALL– Payslip for regular payment ................................................................... 42
ZHCM_VV/ZHR_VV– VV statement ......................................................................................... 43
ZHCM_FI – Salary Clearing ...................................................................................................... 44

Reversing Document .................................................................................... 46

FB08 – Reverse Open item document...................................................................................... 46
F.80/fb08 – Mass reversal....................................................................................................... 47
Either through fb08 ....................................................................................................................... 47
Or through F.80 ............................................................................................................................. 47
FBRA – Reverse cleared document .......................................................................................... 48
AB08 - Reversal of Assets Document ....................................................................................... 49
MR8M – Cancel Invoice document .......................................................................................... 50

Cash Section ................................................................................................ 51

“F-51” – Money Receipt.......................................................................................................... 51
F-51 – Posting of Money receipt ................................................................................................... 51
ZFI_MR_PRINT – printing Money receipt .................................................................................... 53
F110/ZFB02 – Automatic payment Transactions ...................................................................... 54
First Run ZFB02 ............................................................................................................................. 54
Now Run F110 ............................................................................................................................... 55
Now Run zfi_eft_ncl for acquaintance roll ................................................................................... 59
ZFI_BRS2 – Bank Reconciliation .............................................................................................. 60
F-53 – Post outgoing payment ................................................................................................ 62
ZFI_BRS2– bank Reconciliation Statement............................................................................... 66
OT81/FRFT_B– bank to Bank Transfer ..................................................................................... 68
Step-1 Enter T code OT81 ............................................................................................................. 68
Step- 2 Use T code – FRFT_B ......................................................................................................... 71

Bill Passing Section ...................................................................................... 76

FV60/FB60 – Create a vendor Invoice ...................................................................................... 76
FBV0– Post park document ..................................................................................................... 79
FV50/FB50– Enter Journal entry ............................................................................................. 80

Module-II 3
 MIR4– MIRO Document Posting.............................................................................................. 81
Check purchase order no. and service entry sheet before posting MIR4..................................... 84
Checking of Purchase order ...................................................................................................... 84
Either by MIR4....................................................................................................................... 84
Or by ME23N ......................................................................................................................... 84
Checking of Service entry sheet ................................................................................................ 85
Either by ME23N ................................................................................................................... 85
Or by ML81N ......................................................................................................................... 85
Checking of FI document at the time of service entry .............................................................. 87
FB03– Attach document ......................................................................................................... 89
Attach document .......................................................................................................................... 89
Edit/delete attached document.................................................................................................... 90
ZFI_BT– Bill Tracking System ................................................................................................... 92
New entry...................................................................................................................................... 92
Track status ................................................................................................................................... 92

PRINT DOCUMENTS ..................................................................................... 93

ZFI_FIJVPRINT– JV Print .......................................................................................................... 93
ZFI_FIPRINT – Invoice Voucher Print ....................................................................................... 94
ZFI_PMTPRINT/ ZFI_PMTPRINT_NCL– Payment Voucher Print ................................................. 95
ZFIASSETINV – Assets Transfer Invoice Printing ....................................................................... 96
ZFI_PRN– Dashboard For Finance............................................................................................ 97
ZSD_CDN_NCL – Credit and Debit Note Print ........................................................................... 98
ZSD_PRINT_NCL – Sales order confirmation print Out ............................................................. 99

TAXATION .................................................................................................. 100

ZFI_GSTNEW –GST report ..................................................................................................... 100
ZFITDS2–Withholding Tax Report.......................................................................................... 101

Sales Accounts ........................................................................................... 102

“F-30”– Post with Clearing .................................................................................................... 102
“F-29”– Customer Down payment......................................................................................... 102
“F-32”– Customer clearing .................................................................................................... 104
VA02– Change sales order .................................................................................................... 106
VA03– Display sales order .................................................................................................... 107
ZFI_PRN– Dashboard For Finance.......................................................................................... 108

Module-II 4
ZSD_CDN_NCL – Credit and Debit Note Print ......................................................................... 109
ZSD_CM_BANK – Update the Bank Details ............................................................................ 110
ZSD_PRINT_NCL – Sales order confirmation print Out ........................................................... 111
ZSD_SO_APR – Sales order and contract work approval......................................................... 112
ZSD012_NCL – Billing report ................................................................................................. 113
ZSD011– Sales order Report.................................................................................................. 114

Module-II 5
 Trial and Ledger Scrutiny
T-Code F.08 – Trial Balance

Field Remarks
Chart of accounts CIL
G/L account If balance required of specific GL code
Company Code NCL
Fiscal Year Relevant Fiscal year
Reporting Period Range of period (April being 1 and march being 12 to 16)

If TB of specific profit center is required than click on dynamic selections. below screen
will open.

Module-II 6
Click on drop down and look for profit center. Fill profit center. And click on execute.

Trial balance is ready to download.

Go to System > List > Save > Local Files

Module-II 7
Click on Text with Tabs. And then click on continue (green button). Below mentioned screen
will pop up –

Click on of directory.

Field Remarks
Save in Path of place where file to be saved
File Name Suitable data
Save as type Change the same to Excel Files (*.xls)

Click on save. And then click on generate.

Module-II 8
 T-Code F.01 – Financial Statement

Field Remarks
Chart of accounts CIL
G/L account If balance of specific GL code is required
Company Code NCL
Financial statement Version FS22
Reporting Year Current period
Reporting Period Range of current period (April being 1 and march being 12 to 16)
Comparison year Previous Year
Comparison Period Range of previous period (April being 1 and march being 12 to 16)
ALV grid control Change layout as per requirement
/BS BALANCE SHEET
/BSNOTE BALANCE SHEET NOTEs
/PL PROFIT AND LOSS
/PLNOTE PROFIT AND LOSS NOTEs
/GRPGL GROUP WISE GL BASED

Click on execute.
Module-II 9
 T-Code FAGLL03 – G/L Account Line Item Display G/L View

Only
one to
be
selected

Field Remarks
G/L account GL account
Company Code NCL
Open Items
Open at Key date To view open items on any particular date
Cleared items
Clearing date To view cleared items on any particular period
Open at key date To view open items at particular date which has cleared today
All items
Posting date To view all items on any particular posting period

Click on execute. Below window will pop up -

Module-II 10
for general ledger view Click on display document . Below screen will open.

Click on call up document overview. and document will be displayed in entry view.

Module-II 11
To view the document in General ledger view, click on general ledger view.

And to view entry passing ID, click on “Display document header” . Below screen will pop up and
all the details of document will be shown.

Module-II 12
 T-Code FBL1N – Vendor line item display

Field Remarks
Vendor Account Vendor Code
Company Code NCL
Open Items
Open at Key date To view open items on any particular date
Cleared items
Clearing date To view cleared items on any particular period
Open at key date To view open items at particular date which has cleared today
All items
Posting date To view all items on any particular posting period
Types
Normal Item To view normal items
Special G/L transactions To view G/L transactions
Noted items To view transactions which have no financial impact (e.g. F-47)
Parked items To view parked items

Click on execute
Module-II 13
 T-Code FBL1N – Customer line item display

Field Remarks
Customer Account Vendor Code
Company Code NCL
Open Items
Open at Key date To view open items on any particular date
Cleared items
Clearing date To view cleared items on any particular period
Open at key date To view open items at particular date which has cleared today
All items
Posting date To view all items on any particular posting period
Types
Normal Item To view normal items
Special G/L transactions To view G/L transactions
Noted items To view transactions which have no financial impact (e.g. F-47)
Parked items To view parked items

Click on execute.

Module-II 14
 T-Code FS10N – Month wise G/L balance display

Field Remarks
Account Number GL code
Company Code NCL
Fiscal year Relevant fiscal year

Execute.

T-Code FK10N – Month wise Vendor balance display

Field Remarks
Vendor Vendor code
Company Code NCL
Fiscal year Relevant fiscal year

Execute.

T-Code FD10N – Month wise Customer balance display

Field Remarks
Vendor Vendor code
Company Code NCL
Fiscal year Relevant fiscal year

Execute.

Module-II 15
T-Code S_pl0_86000028 – Project wise GL / Trial balance

Module-II 16
 Field Remarks
Currency Type 10 (Company code currency)
Company Code NCL
Account Number/cost As per Requirement
center/Profit center
Fin. Statement Vers. ZCIG
Ledger 0L
Reporting year/period As per requirement
from/ period to
Comparison year/period As per requirement
from/ period to
Output type
Classic Drilldown report ProjectWise balance
Object list GL code wise project wise balance

Execute.

Module-II 17
 T-Code S_pl0_86000030 –G/L Account - balance

Field Remarks
Currency Type 10 (Company code currency)
Company Code NCL
Account Number/cost As per Requirement
center/Profit center
Output type
Classic Drilldown report GL code wise balance
Object list GL code wise project wise balance

Execute.

Module-II 18
T-Code zfi_trialbalance – Trial balance in columnar format

Field Remarks
Company Code NCL
Fiscal year As per Requirement
Posting date Period of TB
Profit center
Fill Profit center range or specific profit center by clicking

Execute.

Layout can be change by clicking .

Module-II 19
T-Code ZFIZBC – Zero Balance Clearing GL Report

Field Remarks
GL Account 11000032 (Zero balance clearing)
Financial year Year
Company Code NCL
Profit center Fill Profit center range or specific profit center
Posting date Period of TB

Execute.

Module-II 20
 Customer and Vendor
T-Code FK01 – Create Vendor

T-Code FK02/XK02 –Change Vendor

Only to be used for updating bank account sequence and withholding tax

For updating bank account sequence

(Access is provided on one id at every Project)

Field Remarks
Vendor Vendor code of the vendor
Company code NCL
General Data Tick on Payment Transactions
Company code Data Tick on Payment Transactions

Press enter.

Module-II 21
Maintain part bank type “BnkT”

Field Remarks
Bank Key IFSC code
Bank account Bank Account
Account holder Name
BnkT Maintain part bank type
01 for first account
02 for second account in next row

Click on Save.

For updating Withholding tax

Module-II 22
 Field Remarks
Vendor Vendor code
Company Code NCL
Withholding tax Withholding tax details

Click enter.

Field Remarks
With.t.t Withholding tax type
Liable Ensure tick mark on check box
Withholding tax Withholding tax details

Click on save.

Module-II 23
T-Code FK03/XK03 –Display Vendor

Field Remarks
Vendor Vendor code
Company Code NCL
General data
Address To view address and contact details
Control Other vendor details like PAN/ GSTIN etc.
Payment transactions Bank account details of vendor
Contact Person Contact details of person
Company code data
Accounting info Accounting info like Recon account etc.
Payment transactions Payment tranactions like payment methods, pay terms etc.
Withholding tax Withholding tax details

Press enter.

T-Code FD01 – Create Customer

T-Code FD02 –Change Customer

T-Code FD03/XD03 –Display Customer

Module-II 24
 FK02/FB02 - Maintaining part bank in already posted
T-Code
document

First Run FK02

(access is provided on one id at every Project)

Field Remarks
Vendor Vendor code of the vendor
Company code NCL
General Data Tick on Payment Transactions
Company code Data Tick on Payment Transactions

Press enter.

Module-II 25
Maintain part bank type “BnkT”

Field Remarks
Bank Key IFSC code
Bank account Bank Account
Account holder Name
BnkT Maintain part bank type
01 for first account
02 for second account in next row

Click on Save.

Now Run FB02

Field Remarks
Document no. Document no. for which part bank to be maintained
Company code NCL
Fiscal year Year of document posting

Module-II 26
Press enter. Below screen will open.

Double click on vendor line item (vendor liability). Below screen will open.

Click on additional data.

Module-II 27
Select Part. Bank type (01 or 02)

Save the document.

Module-II 28
 Cost & Budget Section

T-Code FMAVCR01 – How to CHECK budget

Field Remarks
FM area CIL
Fiscal year Current Fiscal year
Fund Input required data
Fund center Input required profit center
Commitment Item Input required commitment item

Module-II 29
Execute. Below screen will appear.

DOUBLE CLICK ON CONSUMED AMOUNT to get consumption report.

Module-II 30
T-Code FMBB – Budget upload and budget release

Budget Upload

Select layout version SAP004. Below screen will appear.

Field Remarks
BCL Value type Budget
Process Enter
Document type CIL1 (Budget Create)
Version 0
Document date As applicable (generally 01.04.20XX)
Fiscal year As applicable
Budget type CIL1 (Initial budget entry)
Fund Fund type
Fund center Profit center
Commitment item Applicable commitment item
Amount Budget amount

Click on save.

Module-II 31
Budget release

Field Remarks
BCL Value type Released
Process Enter
Document type CIL3 (Budget Release)
Version 0
Document date When budget is released
Fiscal year As applicable
Budget type REL
Fund Fund type
Fund center Profit center
Commitment item Applicable commitment item
Amount Budget amount

Click on save.

Released Budget Can Be Seen In FMAVCR01 Report .

Module-II 32
 Cost element grouping
We have two types of cost element grouping:

1. Direct expenses – No allocation. Only direct cost in production cost center is considered
for direct expenses.

2. Indirect expenses – Indirect expenses like production indirect, admin, production overhead,
selling overhead are considered for indirect cost allocation.

Code Particulars Cost Allocation

element Criteria
/group
Material consumed
M (i) Purchase of Coal 40002001
Process Materials/Chemicals :
A_iii_c (i) Timber 40000006 Primary
A_i (ii) Explosives 40000000-02 Direct allocation
based on process
Order Basis

D Utilities 94200039 Assessment Cycle

A_ii Direct employee cost 94200002 Assessment Cycle

Direct Expenses :
A_iii_a (i) POL 94200003 Direct Allocation
A_iii_e (ii) Surface Miner Expenses 94200007 Direct Allocation
A_iii_f (iii) Hiring of Equipments (Coal & OB) 94200008 Direct Allocation
A_iii_g (iv) Transportation within Mines (up to pit 94200009 Direct Allocation
head)
A_iii_h (v) Other Contractual Expenses 94200010 Direct Allocation
A_iii_j (vi) Other Expenses 94200012 Direct Allocation
A_iii_b (vii) Stores & Consumables 94200004 Direct Allocation

A_iii_d Repair & Maintenance 94200006 Assessment Cycle

E Quality Control 94200040 Assessment Cycle

Research & Development Expenses

Technical Know-how Fee or Royalty

A_iii_i Depreciation &Amortisation 94200011 Assessment Cycle

Production Overhead :-
C_i (i) Security Expenses 94200024 Assessment Cycle

Module-II 33
C_ii (ii) Environmental Expenses 94200025 Assessment Cycle
B_i (iii) Process Material (Others) 94200013 Assessment Cycle
B_ii (iv) Salaries & Wages 94200014 Assessment Cycle
B_iii_a (v) POL 94200015 Assessment Cycle
B_iii_c (vi) Repair & maintenance 94200017 Assessment Cycle
B_iii_b (vii) Consumable Stores and spares 94200016 Assessment Cycle
B_iii_f (viii) Depreciation &Amortisation 94200020 Assessment Cycle
B_iii_g (ix) Insurance 94200021 Assessment Cycle
B_iii_e (x) Other Contractual Expenses 94200019 Assessment Cycle
B_iii_d (xi) Hiring of Equipments 94200018 Assessment Cycle
B_iii_h (xii) Hiring Charges Others 94200022 Assessment Cycle
B_iii_i (xiii) Other Expenses net of Income, if any 94200023 Assessment Cycle

Industry specific operating expenses :

F_i (i) Unwinding of Discounts 94200060 Direct -Profit
center basis
(ii) Mine Closure Plan (Prov)
F_ii (iii) Depreciation on Site Restoration Cost 94200041 Assessment Cycle
F_iii (iv) OBR Adjustment 94200061 Direct -Profit
center basis

N Less : Credit for Recoveries

Increase/Decrease in stock of finished goods:
Opening Stock of Finished Goods
Closing Stock of Finished Goods
L Increase/Decrease in stock of finished goods 94200062 Direct -Profit
center basis

I Less: self or Captive consumption 94200063

Other Adjustments

Cost of production or operation of goods or xxxxxxxxx

services sold
Administration Overhead:-
C_iii_a (i) Salaries & Wages 94200026 Allocation Cycle
C_iii_b (ii) POL 94200027 Allocation Cycle
C_iii_c (iii) Utilities (Power) 94200028 Allocation Cycle
C_iii_d (iv) Repair & maintenance 94200029 Allocation Cycle
C_iii_e (v) Consumable Stores and spares 94200030 Allocation Cycle
C_iii_f (vi) Depreciation &Amortisation 94200031 Allocation Cycle
C_iii_g (vii) Insurance 94200032 Allocation Cycle
C_iii_h (viii) Other Contractual Expenses 94200033 Allocation Cycle
C_iii_i (ix) Hiring Charges Others 94200034 Allocation Cycle
C_iii_j (x) Transportation Cost 94200035 Allocation Cycle
C_iii_k (xi) Other Expenses 94200036 Allocation Cycle

Module-II 34
C_iii_l (xii) CSR Expenses 94200037 Allocation Cycle
C_iii_m (xiii) Service Unit Expenses 94200038 Allocation Cycle
C_iii_n (i) Security Expenses 94200067 Allocation Cycle
G (xiv) Administrative Expenditure (HQ and
Apex)

Secondary packing cost

Selling & Distribution:
H_i (i) Salaries & Wages 94200050 Allocation Cycle
H_xi (ii) POL 94200064 Allocation Cycle
H_ii (ii) Utilities (Power) 94200051 Allocation Cycle
H_iii (iii) Repair & maintenance 94200052 Allocation Cycle
H_iv (iv) Consumable Stores and spares 94200053 Allocation Cycle
H_v (v) Depreciation 94200054 Allocation Cycle
H_vi (vi) Insurance 94200055 Allocation Cycle
H_vii (vii) Other Contractual Expenses 94200056 Allocation Cycle
H_viii (viii) Transportation Cost (beyond pithead) 94200057 Allocation Cycle
H_ix (ix) Hiring Charges 94200058 Allocation Cycle
H_xii (i) Security Expenses 94200065 Allocation Cycle
H_x (x) Other Expenses net of income, if any. 94200059 Allocation Cycle

J Interest & Financing Charges 94200066 Direct -Profit

center basis

Cost of Sales of product or activity group

Net sales Realisation
K_i (i) Gross Sales 30000001 Direct -Profit
center basis
K_ii (ii) bonus 94200068 Direct -Profit
center basis
K_iii (iii) Deduction (current year related only) 94200069 Direct -Profit
center basis
Amount of Margin as per cost Accounts

Module-II 35
 RECONCILIATION OF COST SHEET IN ERP
Maintain Opening Stock Rate:
Transaction Code – ZFICS

Click on the Maint. Adjustment

Now click on New Entries

Module-II 36
Here fill the Plant, Fiscal year and period and Coal Rate (means closing rate of coal
stock of preceding month) and then save.

Imp Note: (Don’t fill Profit Center

Step 4:

Run the cost sheet by Transaction Code ZFICS

In the above screenshot, there shall not be any figure in Explosive manual posting.
Production, despatch and OB quantity must be matched with Statistics Report (M
Series) of the respective period. If not then manual adjustment can be done as
follows:

Click on the Maint. Adjustment tab

Module-II 37
Here fill the Plant, Profit Centre (MUST FILL), Fiscal year and period and quantity
of differences in coal production quantity, coal despatch quantity and OB quantity
and then save.

Again run the Transaction Code ZFICS.

Step 5:
Reconciliation
(Over/under absorption should be Zero)

Module-II 38
Transaction Code – S_ALR_87013611

Fill the respective fields and execute

Module-II 39
CASE-I Here Over/Under absorption should be zero and is zero.

In some cases difference will be for non-cost items you can ignore the same

CASE-II Here Over/Under absorption should be zero and It is not is zero.

Module-II 40
 Establishment
T-Code ZHR_SAL_REG– SALARY REGISTER

Field Remarks
Payroll area Payroll area
Payroll period Current / other period
Selections As per requirement
Additional selection As per requirement

Execute.

Module-II 41
T-Code ZHCM_PAYSLIP_ALL– Payslip for regular payment

Field Remarks
Period As per requirement
Selections As per requirement
Period for attendance mandatory

Execute

Module-II 42
T-Code ZHCM_VV/ZHR_VV– VV statement

Field Remarks
selection As per requirement
From month/ to month As per requirement
Display as PDF Format If required
Output type ALV output

Module-II 43
T-Code ZHCM_FI – Salary Clearing

Field Remarks
Payroll area Required payroll area
Payroll period Required period
Company code NCL
Posting date Posting date
Test run Test run to be selected first time

Execute. A list will appear.

Compare profit center wise balance of 11000060 posted in salary JV and ZHCM_FI test run result.
Module-II 44
Now go back and execute with selecting “POST” instead of “test run”.

Now Clear 11000060 GL using tcode f-03 or f-04.

NOTE:
1. Once you post any document for a payroll area for a posting date, you cannot repost on
the same date for the same payroll area, even if you have reversed it.

2. If you run the program more than once for same payroll area with same on cycle or off
cycle identification it will post document more than once.

To overcome the above mentioned limitation of custom program, all finance

establishment section of respective Profit Center are requested to check GL 11000060
open item at the end of each month or salary posting date and clear open item.

3. if you found any error in the posted document you may reverse this document using
standard fi transaction FB08.

Module-II 45
 Reversing Document
T-Code FB08 – Reverse Open item document

Field Remarks
Document number Document number to be reversed
Company code NCL
Fiscal year Year of document
Reversal reason 01 – Reversal for rectification
02 – Provision reversal

Click on display before reversal. .

Go back and click on save.

Module-II 46
T-Code F.80/fb08 – Mass reversal
Either through fb08

Click on mass reversal

Or through F.80
Both method will open below screen -

Field Remarks
Company code NCL
Document number Range of documents
Fiscal year Year of document
Reason of reversal 01 – Reversal for rectification
02 – Provision reversal
Posting date Date of posting
Posting period Posting period
Test run click on check box to test run

Execute.

Module-II 47
T-Code FBRA – Reverse cleared document

Field Remarks
Clearing document Cleared Document number to be reversed
Company code NCL
Fiscal year Year of document

Click on post. Then a pop will show. Always select “reset and reverse”.

Module-II 48
T-Code AB08 - Reversal of Assets Document

Fill the Assets Number in which FI posted document is required to be deleted

*Fields same as AB03

Below mention screen open

Select the document which is required to be deleted

Click on reverse.

Field Remarks
Fiscal Year Automatically fetch
Posting date Posting date as per requirement
period Period of posting
Reversal reason 01-Reversal for rectification
02-Provision reversal

Click on continue and save.

Module-II 49
T-Code MR8M – Cancel Invoice document

For reversal of Invoice document posted through MIRO/MIR7.

Field Remarks
Invoice document no. Miro/MIR7 no.
Fiscal Year Year of document
Reversal reason 01-Reversal for rectification
02-Provision reversal
Posting date Date of posting

Module-II 50
 Cash Section
T-Code “F-51” – Money Receipt

F-51 – Posting of Money receipt

Field Remarks
Document date Suitable value
Posting date Suitable value
Company code NCL
Reference Suitable narration
Doc. Header text Suitable narration
Transaction to be processed Incoming payment
First line item
Pstky 15 – Customer
35- Vendor/employee
39- Special GL indicator
Account Customer code/Vendor code/Employee vendor code

Module-II 51
Press enter

Field Remarks
Amount MR amount
Calculate tax Ensure tick mark
Tax code Suitable value
Next line item
Pstky 40
Account Bank Account

Press enter

Module-II 52
 Field Remarks
Amount *
Value date Suitable value

Simulate and post the document.

ZFI_MR_PRINT – printing Money receipt

Field Remarks
Company code NCL
Customer Bill account Document Document number
Fiscal Year Year of document

Execute and document will be downloaded in system.

Module-II 53
T-Code F110/ZFB02 – Automatic payment Transactions
First Run ZFB02

Field Remarks
Choose an option Vendor/ customer as the case may be
Company code NCL
Vendor code Suitable vendor code
Posting date Not mandatory
Profit center Suitable profit center
Document number Not mandatory
GL item selection Normal/special GL as the case may be

Execute. Below screen will pop up

Field Remarks
Check box Click on check box
Pmnt block Leave blank to make payable else fill “B” to block (All “B” items will
be blocked for payment)
Payment method Suitable payment method (preferably T)
House bank Suitable outgoing House bank
Account ID Suitable outgoing Bank Account ID
Baseline date Ensure baseline date should be today or before today

Click on Post.

Module-II 54
Now Run F110

Field Remarks
Run date Today date
Identification Random alpha numeric number

Now click on parameter tab.

Module-II 55
 Field Remarks
Company code NCL
Pmt meths Same as punched in zfb02 (preferably “T”)
Next p/date Any date after today
Vendor
Vendor code range ( click to fill specific multiple vendors)

Click on additional log. Below screen will pop up.

Field Remarks
st nd th
Required logging type Mark tick on 1 , 2 and 4 check box
Account required Vendor code

Click on status Tab.

Click on yes. Now parameter has been created

Module-II 56
Now click on proposal .

Mark tick on start immediately. Press green button.

Now press enter to create the payment proposal.

Module-II 57
 Now click on and ensure LED on type column of line item.

This
represents
error

Now go back and click on payment run.

Click on start immediately and click on green button.

Payment has been processed.

 This SOP is for the payments which are initiated without integration portal. (i.e. check will be
printed manually.) To make integrated payment change the payment method from “T” to

Module-II 58
 “X” ( in case of axis bank) and “I” (in case of ICICI bank). Whole process will be same but
while processing schedule payment below screen will pop up.

Mark tick on create payment medium.

Now Run zfi_eft_ncl for acquaintance roll

Field Remarks
Run date Run Date entered in F110
Identification Run Date entered in F110

Execute the code.

Module-II 59
T-Code ZFI_BRS2 – Bank Reconciliation

Company Code NCL

House Bank Suitable House Bank
Account Details Suitable Account ID
Posting Date Suitable Posting Period
Date Date on which Transaction appeared on Bank
Statement
Mode
Click on “Error Only”

Execute and following screen will open:-

Module-II 60
Tick on those Line items which are cleared in Bank Statement and ensure that “clearing date”
of line item is same as Date of Transaction in Bank Statement. And then click on Post Button.

Module-II 61
T-Code F-53 – Post outgoing payment

Document Date Today Date

Company Code NCL
Currency/INR INR
Reference Suitable Reference
Doc. Header Text Suitable Entry
Clearing Text Suitable Narration
Bank Data
Account Out Bank GL Code
Amount Payable amount (if unknown than enter 1)
Profit Center Respective Profit Center
Open Item Selection
Account Vendor Code
Special G/L Respective G/L (leave blank in case of normal
item)
Additional Selection
Tick on Document Number

Module-II 62
Then click on and enter doc number as indicated below:-

Fill Document no.

Then again press on

Then click on and following screen will open:-

Module-II 63
double click on payment line item and following screen will open:-

Enter “*” in amount column than press enter button from keyboard. System will automatically fetch

payable amount. Then press on and simulate the Document as indicated

below:-

Module-II 64
And click on Post Button

Module-II 65
T-Code ZFI_BRS2– bank Reconciliation Statement

Run ZFI_BRS2

Company Code NCL

House Bank Suitable House Bank
Account Details Suitable Account ID
Posting Date Suitable Posting Period
Date Day of BRS
Mode
Click on “Error Only”

Execute and following screen will open:-

Module-II 66
Tick on those Line items which are cleared in Bank Statement and ensure that “clearing date”
of line item is same as Date of Transaction in Bank Statement. And then click on Post Button.

Module-II 67
T-Code OT81/FRFT_B– bank to Bank Transfer

Step-1 Enter T code OT81

Enter Paying Company code- NCL

House Bank Out Bank account - Search By ERP GL account

Account ID- Out GL account ( Account ID linked with Out Gl account)

Click on Create

New Small Window Pop Up-

Select – Bank

In Next Screen

Enter Details for Sending Bank and Target Bank ,refer below details

Module-II 68
Press Enter and Save

Next Click on Green Flag

And release-

And Save.

Next Click on Groups

Click on New Enteries

And Enter Repetitive Code and its Description

Module-II 69
Press Enter and Save

Next Click on

And Assign Comopany code to Repetitive Code

Save

Module-II 70
Step- 2 Use T code – FRFT_B
Net Entry

Bank To Bank Transfer

In Selection screen Enter Group Code

Press Enter

Bank details will appear

Enter Transfer amount

Next Click on Create Payment Request

Module-II 71
Select the line open Payment Request

Next Click on Release

Once Released
Next Click on Pay

Module-II 72
Below Confirmation will come

Module-II 73
Next Go to F111

Or Click on Environment

Module-II 74
Next to View Document number

Click on

Payment Document display by T code- FB03

Module-II 75
 Bill Passing Section
T-Code FV60/FB60 – Create a vendor Invoice
FV60 and FB60 is same except in FV60 only post option is available and n FB 60 park and post both
options are available.

Field Remarks
Vendor Vendor code
Invoice date Date of invoice
Posting date Date of posting
Amount As per bill (with tax)
Calculate tax Mark tick on tab
Reference Invoice number
Tax code Select suitable tax code
[Link]/Sectn Suitable data
Reason for document 01 – input material
02- input service
03- capital goods
G/L acct GL code
Amount in doc. Curr. Bill amount (with tax)
Tax code (Automatically filled)
Cost center Suitable cost center
HSN code Suitable HSN code

Click on detail tab

Module-II 76
Click on payment tab and select free for payment in Pmnt block column

Select withholding tax.

Module-II 77
Click with/tax amt FC manually. Simulate.

Then Post.

Module-II 78
T-Code FBV0– Post park document

Field Remarks
Company code NCL
Doc. Number Parked document number
Fiscal year Year of document

Press enter and screen of FB60 will pop up.

Module-II 79
T-Code FV50/FB50– Enter Journal entry
FV50 and FB50 is same except in FV50 only post option is available and n FB50 park and post both
options are available.

Field Remarks
Document date Date of document
Posting date Date of posting
reference Suitable reference
Doc header text Additional narration
G/L acct GL code
D/C Debit/Credit
Amount in doc. Curr. amount
Tax code Suitable Tax code
Cost center Suitable cost center (if exp code entered)
Profit center Suitable profit center (if required)
Profitability Click on profitability (if income code used)
Click on simulate.

Click on post.

Module-II 80
T-Code MIR4– MIRO Document Posting

Field Remarks
Invoice Document No. MIRO /MIR7 document no.
Fiscal Year Year of document

Click on display document. Below screen will appear.

Click on Edit > Display/Change. Below screen will appear.

Field Remark
Invoice date Invoice date as per Invoice
Reference Invoice no.
[Link]/sectn Business place- MP23 for MP and UP09 for UP Projects.
Section- plant code

Then click on Payment Tab.

Module-II 81
 Field Remark
[Link] Choose bank Account
Pmnt block Choose free for payment

Click on Tax Tab and check tax code and GST Amount.

Click on Withholding Tax Tab and select applicable TDS Codes.

Now check purchase order no. and service entry sheet (process mentioned in next chapter).

Now simulate document before posting. Below screen will appear.

Module-II 82
Now click on post.

Module-II 83
Check purchase order no. and service entry sheet before posting MIR4

Checking of Purchase order

Either by MIR4

Field Remarks
Invoice Document No. MIRO /MIR7 document no.
Fiscal Year Year of document

Click on display document. Below screen will appear.

Click on Edit > Display/Change. Below screen will appear.

Double Click on Purchase order no.

Or by ME23N

Click on Other purchase order . Then fill Purchase order and press enter.

Below screen will pop up from both the methods-

Module-II 84
Click on Item Overview to view the PO.

Checking of Service entry sheet

Either by ME23N

click on Item . Then click on purchase order history.

Then click on service entry number.

Or by ML81N

Module-II 85
Click on Other Purchase Order. Fill Purchase order no. and press enter. Below screen will appear.

Click on “>” sign. Then click on party.

Both the methods will show below screen of service entry sheet –

Module-II 86
Checking of FI document at the time of service entry
Run code ME23N

Click on Other purchase order . Then fill Purchase order and press enter. Below screen will
pop up .

click on Item . Then click on purchase order history.

Module-II 87
Then click on Goods receipt number. Following window will be displayed

Go to Doc. Info tab

Click on FI Documents. Below screen will open.

Double click on Accounting document and Journal entry screen will appear.

Module-II 88
T-Code FB03– Attach document
Attach document
Run FB03.

Field Remarks
Document Number Document number
Company code NCL
Fiscal year Year of document
Press enter. Below screen will pop up.

Click on side arrow of “Go to service object” >Create > HMS attachment. Below screen
will appear.

Module-II 89
Select the path of file to be attached and click on open. File will be attached.

Edit/delete attached document

Run FB 03

Field Remarks
Document Number Document number
Company code NCL
Fiscal year Year of document
Press enter. Below screen will pop up.
Module-II 90
Click on side arrow of “Go to service object”>attachment list. Below screen will appear -

Select the document and click on edit to edit the document and click on delete to delete
the document. Click on green button to save.

Module-II 91
T-Code ZFI_BT– Bill Tracking System

New entry

Field Remarks
Company code NCL
Vendor Vendor code
Execute.

Click on “New Entries” tab. below screen will pop up.

Field Remarks
Criteria Bills or Letter or Advance/PI as the case may be
Bill Number Bill number
Bill date Date of bill
Physically receipt date Date of receipt of document
Bill Amount Amount of bill
Bill Department Concerned department

Click on save.

Track status
Click on track status. Below screen will appear.

Fill DAK Number and click on “Track Details”. All the details related to such DAK will appear here.

Module-II 92
 PRINT DOCUMENTS
T-Code ZFI_FIJVPRINT– JV Print

Field Remarks
Company code NCL
Fiscal year Year of document
Document Number Document number
Press on execute

Ensure “LP01” is filled in output device and then click on print preview. JV will open.

Module-II 93
T-Code ZFI_FIPRINT – Invoice Voucher Print

Field Remarks
Select radio button Open item/Clear item as per requirement
Company Code NCL
Fiscal year Year of document
Vendor Code *Optional
Document Number Document number

Ensure “LP01” is filled in output device and then click on print preview. Invoice will open.

Module-II 94
T-Code ZFI_PMTPRINT/ ZFI_PMTPRINT_NCL– Payment Voucher Print

Field Remarks
Type of payment Manual or Automatic as the case may be
Company Code NCL
Year Year of document
Profit center Respective profit center
Document Number Document number

Execute. Below screen will appear.

Select the document and click on print PDF.

Ensure “LP01” is filled in output device and then click on print preview. Payment advice will open.

Module-II 95
 T-Code ZFIASSETINV – Assets Transfer Invoice Printing

Field Remarks
Company Code NCL
Customer bill Account Document FI document number
Fiscal year Year of asset transfer

Click on Execute

Ensure “LP01” is filled in output device and then click on print preview. Asset Invoice will open.

Module-II 96
 T-Code ZFI_PRN– Dashboard For Finance

Click on FI Invoice – Customer

Field Remarks
Company code NCL
Customer Bill account document Document no.
Fiscal year 2022

Execute.

Similar process is for Vendor Invoice.

Module-II 97
 T-Code ZSD_CDN_NCL – Credit and Debit Note Print

Enter credit / debit note no. and execute

Ensure LP01 in output device and click on print preview.

Module-II 98
 T-Code ZSD_PRINT_NCL – Sales order confirmation print Out

Field Remarks
Sales doc Number SO number
Selection of Radio Button Suitable data
Selection of Radio Button Suitable data

Execute.

Module-II 99
 TAXATION
T-Code ZFI_GSTNEW –GST report

Field Remarks
Report for Input / Output GST report
Company code NCL
Fiscal year Relevant year
period Relevant period
Profit center Relevant profit center
Tax codes Relevant tax codes

Execute.

Module-II 100
 T-Code ZFITDS2–Withholding Tax Report

Field Remarks
Customer/Vendor As per requirement
Company code NCL
Profit center Relevant profit center
Posting date As per requirement

Execute

Module-II 101
 Sales Accounts
T-Code “F-30”– Post with Clearing
Similar like F-51

T-Code “F-29”– Customer Down payment

Field Remarks
Document date Relevant date
Posting date Relevant date
Reference suitable data
Doc. Header Text suitable data
Vendor
Account Employee vendor code
Special GL ind 3 (Laptop Advance)
Bank
Account Out bank GL code
Amount Advance amount
Value date Suitable date
Profit center Respective profit center

Press enter

Module-II 102
 Field Remarks
Amount Advance amount
Bus./Sectn Suitable data
Profit center Respective profit center

Simulate and post the entry.

Module-II 103
 T-Code “F-32”– Customer clearing

Fill Customer code as per requirement

Field Remarks
Account Vendor Code
Clearing Date Date of clearing
Company Code NCL
Additional Selection As per requirement

Select Additional selection

Press enter

All the document which is to be cleared as per selection criteria are open

Module-II 104
Select the document which is required to be cleared

Document which is not required to be cleared can remove, by double click on

amount and color will be black.

If amount entered and assigned are tallied, then Post the document.

Module-II 105
 T-Code VA02– Change sales order

Enter sales order no. Then press enter. Change details as required.

Module-II 106
 T-Code VA03– Display sales order

Press enter to view sales order.

Module-II 107
 T-Code ZFI_PRN– Dashboard For Finance

Click on FI Invoice – Customer

Field Remarks
Company code NCL
Customer Bill account document Document no.
Fiscal year 2022

Execute.

Similar process is for Vendor Invoice.

Module-II 108
 T-Code ZSD_CDN_NCL – Credit and Debit Note Print

Enter credit / debit note no. and execute

Ensure LP01 in output device and click on print preview.

Module-II 109
 T-Code ZSD_CM_BANK – Update the Bank Details

Click on Customer code and select the suitable option for Update/ edit/ delete/ report and execute.

Module-II 110
 T-Code ZSD_PRINT_NCL – Sales order confirmation print Out

Field Remarks
Sales doc Number SO number
Selection of Radio Button Suitable data
Selection of Radio Button Suitable data

Execute.

Module-II 111
 T-Code ZSD_SO_APR – Sales order and contract work approval

Field Remarks
Selection Options Other subsidiary
Shipping Point Suitable mode of transportation

Execute and approve the data.

Module-II 112
 T-Code ZSD012_NCL – Billing report

Field Remarks
Various input options As per requirement
Sales organization NCL
Select document type As per requirement
Transport mode As per requirement

Execute.

Module-II 113
 T-Code ZSD011– Sales order Report

Field Remarks
Selection Options Other subsidiary
Shipping Point Suitable mode of transportation

Module-II 114