FI Basic settings
step1: Create company:(ox15):
Path:select->New entries
|
select-give-company(7777)
|
give company name{xxxx(some company name)}
|
give the street-(xxxx)
postal code-(xxxx)
city-(hyd)
country-(In)
language key-(EN)
Currency-(Inr)
|
Select-save
|
Press enter
Step2: Create company code:(ox02):
Path: Select->New entries
|
Company code-(777a)
Company Name-(xxxxxxx)
Street-(xxx)
city-(xxx)
country-(In)
currency-(Inr)
Language-(En)
|
Select-Save
|
press enter
Step3: Define Business area: (ox03):
Path: Spro->Enterprise structure->Definition->Financial Accounting->Define Business
Area
|
[New entries]
|
Business Are Description
| |
777H Hyderabad business area 777A
777B Banglore business ares 777A
|
Save
Step 4): Define functional area: (Fm_function):
|
Fm_function
|
Functional area-[Finance](or)[admin](or)[sales],etc.
|
Select-[Create]
|
Functional area text-[financea area 777a]
|
Save
Step 5): Maintain Consolidated Business area:
Path: Same path
|
[New entries]
|
Cons.B.area Description
| |
7777 Constructions
|
Save
Step 6): Maintain functional area:
Path: Same path
|
[New entries]
|
Fm Area FM area text
77In India 777a
77Us USA 777a
|
Save
Assignments
Step1:Assign comapany code to Company:(ox16):
Path: Select->Position button
|
give the company code-(777a)
|
Press enter
|
Give the company-(777a)
|
Select-Save
|
Press enter
Step2: Assign business consolidation:
Path: Spro->Select-Enterprise structure->Select-Definition->Select-financial
Accounting
|
Select->maintain consolidation business area
|
Select-New entries
|
Select-cons.business area Description
7AP Andhrapradesh 777a
7TS Telangana business 777a
|
Save
|
Press enter
GLOBAL SETTINGS
Step1: Create chart of accounts:(ob13):
Path:Spro->Financial Accounting->Genearl Ledger accounting->G/L accounts->Master
Data->Preparations->Edit Chart of Accounts List
|
Select-[New entries]
|
Chart of A/C's-[777a]
Desciption-[chart of A/c's for Company name]
Maintain.language-[English]
Length of G/L account no-[6]
|
Save
Press Enter
step6: Assign chart of a/c's to company code:(ob62):
Ob62
|
enter
|
Select-[position button]
|
co.code-[777a]
|
Enter
|
give the chart of A/c's-[777a]
|
Save
|
Enter
Step7:Create chart of accounts:(obd4):
|
Select-[New entries]
|
Co.code A/C group Name From A/C To A/C
777a 0001 Liabilities 100000 199999
777a 0002 Assets 200000 299999
777a 0003 Revenues 300000 399999
777a 0004 Expenses 400000 499999
|
SAve
step8: Define retained earnings A/c's:
ob53
|
Enter
|
Chart of A/c's-[777a]
|
Enter
|
P&L Account
xx xxxxxx(100101)
|
Save
Step9:Create fiscal year variant(or) financial Year:(ob29):
Path:Select->(v3)
|
Select-copy as button(f6)
|
Select-give the Fiscal year variant-{like your choice(v7)}
|
Press enter
|
Save
Step10:Assign fiscal year variant to company code:(ob37):
Path: Select-Position button
|
Give the-Company code-(777a)
|
Press enter
|
give the-(fiscal year variant-v7)
|
Save
|
Press enter
step11: Create field status group:(obc4):
Path:Select->1000(ideas group)
|
Select-copy as button(f6)
|
Give the-field status variant-(777a)like company code
Give the-field status name-give the company name
|
Press enter
|
Click on-copy all button
|
again-enter
|
Save
|
Press enter
step12: Assign field status group to company code:(obc5):
Path: Select->Position button
|
Give the company code[777a]
|
Press enter
|
for company code- Give the field status variant-[777a]
|
Save
step13: Create Document splitting:
path: Select->Financial accounting(new)->select-G/L Accounting(new)->select-
Business transactions->Select-document splitting
Select-Classifying G/L A/c's Document splitting
|
chart of accounts-[777a]
|
select-new entries
|
A/c from A/c To Cat. Description
100000 199999 01000 balance sheet
200000 299999 02000 balance sheet
300000 399999 30000 Revenues
400000 499999 20000 Exepenses
|
Press enter
|
Save
step14: Create tolerance group for general ledger:(oba0):
Path: oba0
|
Select-New entries
|
Company code-[777a]
|
tolerence Group-[company name]
|
Tolerence group for G/L Accounts in local currency
Debit- 100/- percentage-5%
Credit- 100/- Percentage-5%
|
Press enter
|
Save
Step15: Create tolerence group for vendor and customer:
Path: Oba3
|
Select-New entries
|
Company code-[777a]
Tolerence group-[Tata auto mobile]
|
Select-Details of Added entries
|
Tolerence group[Tata auto mobile 777a]
|
Specification for Clearing Transactions
Permitted Amount percentage
Gain 100 5%
loss 100 5%
|
Permitted payment Defference for automatic
Amount Percentage
Rvenue - 100/- 5%
Expenses - 100/- 5%
Tolerence group for payment advice
Amount Percentage
out std receive from- 100 5%
out std payable from- 100 5%
|
Save
Press enter
Step16: Create tolerence group for User (or) Employees:(oba4):
Path: oba4
|
Select-New entries
|
Co.code-[777a]
Currency-[Inr]
Amount per document-[9999999999]
Amount per line A/c item-[9999999999]
Cash diiscount per line item-[5% ]
Permitted payment Different
Amount percentage
Revenue - 100 5%
Expenses - 100 5%
|
save
Step17: Create posting periond variant:(obb0):
Path: obb0
|
Select-New entries
|
Variant-[777a]
Company name-[Tata auto mobile]
|
Save
Step18: Assign posting period variant to company code:(obbp):
Path: obbp
|
Select-Position button
|
Give the company code-{777a}-press enter
|
Save
|
press enter
step19: open and close posting period:(ob52):
Path: ob52
|
Select-variant-1000 for 6 line
+ - Valid for all account types
A - Assets
D - customer
K - vendor
M - Materail
S - G/L Accounts
|
Click on [Copy as] button
|
Change variant to 1000 to our company code[777a]
|
Also change year to [2014]
|
Press enter
|
Save
Step20:Create general ledger for share capital under liability:(fs00):
Path: fs00
|
G/L Account-{100000}
Company code-[777a]
|
select-[create button]
|
account group-[Liability]
|
Select-Balance sheet radio button
|
Short text-[Share capital]
|
G/l long text-[share capital]
|
Control data tab
|
Account currency-[Inr]
select-only balance in local currrency check box-[/]
Select-open item management check box-[/]
Select-line item display check box[/]
Short key-[001]
Select-Create/bank/ intrst tab
|
Salect-field status group-{g001}
|
Save
Same as all G/l a/c's will create(assets,exps,rev)
Step21: create controlling area:(okkp):
Path: okkp
|
Select-new entries
|
controlling area-{777a}
|
Click on-controlling area.co.code button
|
Co.code-[777a]
|
enter
|
Co.code->co.area-{controlling area same as company code}
|
Cctr.std.hierarchy[ssch_777a]
|
save
|
Click on-assignment of com.code folder
|
new entries
|
Co.code-[777a]
|
save
|
Click on-[active components/comntrolling area folder]
|
Select-new entries
|
Fiscal year-[2014]
|
Cost centre-[active component]
|
Oder management-[Active]
|
Commit.mgt-[component active]
|
Active based-[Active parllel as calculation]
|
Select-AActivity type check box[/]
|
[/]-profit cnter acctg check box
[/]-projects
[/]-sales order [/]-w.commit.mgt check box
[/]-cost objects
[/]-real estate mgnt
|
save
|
press enter
Step22: Define Document splittings:
Path: Financial accounting (new)->General ledger Accounting (new)->Document-
>Document splitting->Specify the genaeral ledgers
|
Ledgers from Ledger to xxx
100000 199999 01000
200000 299999 01000
300000 399999 30000
400000 499999 20000
|
Enter
|
Save
Step23: Tax procedure(obbg):
|
City-In
Name-india
Procedure-Taxit
|
Save
Step24: create no range:(fbn1)
Path: fbn1
|
co.code-[777a]
|
Click on change interval button
|
Select-interval
|
No year From No To no current no
01 2014 1 9999 0
|
enter
|
save
|
Ignore the warnng msg
|
press enter
Step25:(i).Post share capital receipt entry:(f-02):
f-02
|
Doc.date-xxxx
Postng.date-xxxx
Type-SA
Co.code-777a
Currency-Inr
pst key-[40](debit) Account group-[200500](bank A/C)
|
Enter
|
Amount-{xxxxxx}
Text-[partner A invested as a share capital]
|
Pstg key-[50] Account-[100000]
|
Amount-[*]
|
Text-[+]
|
Select-Document->Simulate
|
Save
(ii) post Rent payment G/L:
f-02
|
Doc.date-[xxxx]
Postng.date-[xxxxx]
Type-[SA]
Co.code-[777a]
Currency-[Inr]
Pstg key-[40] Account-[400501](Rent A/C]
|
Enter
|
Amount-[10000]
|
Text-[Rent paid for feb,2015]
|
Pstg key-[50] Account-[200500]
|
Amount- [ * ]
|
Text-[ + ]
|
Document->Simulate
|
Save
Step26: Display of above posted G/L:
Fbl3n
|
G/L Account-[100000]
Co.code -[777a]
|
Select-[open item management] radio button
|
Select-Excute(f8)
Note: Like above Steps change G/L account number and display all require G/L
postings.
ACCOUNTS RECEIVABLE
In real business senario credit sales (or) common for all companies.That means we
have supplied material to several customers on credit basis.so,we have to listout
and prepare outstanding statement.This is called a Accounts receivable(sundry
debitors)
As per the company law 'N' no.of rules and regulations for accounts receivables.
Ex:1Rank customers should not be given credit more than 100000 and period.
As per sap before posting sales and receipts entries we have follow / configure
the following steps.
Step1:Create customer account group:(obd2):
Path: Obd2
|
Select-[ New entries]
|
Account group-[777a]
|
Name-[customerA/HYD/777a]
|
Enter
|
Save
Note:In real business Senario client can have multiple accounting groups as per
client requirement.
Step2:Create No.rengs:
xdn1
|
Click on-[ change interval button]
|
Select-[interval]
|
NO From No To no
7A 500000 500999
|
Enter
|
Save
Step3: Assigned No range to account groups:
OBAR
|
Enter
|
Select-Group-[777a]
Assign no-[7A]
|
SAve
Step4: Create Account's receivable recon.account:FS00:
path: FS00
|
Enter
|
G/L Account-200700(Asset)
|
Select-[create]
|
Short text-[Accounts receivable]
G/L long text-[Accounts receivable]
|
Select-control dat tab
|
Select-currency-[INR]
Select-recon A/C for A/c type-[Customer]
|
Select-line item display check box-[/]
|
Sort key-[001]
|
select-create/bank/intrst tab
|
field status group-[G067](Reconcilation account)
|
Save
Step5:Create customer masterdata:-
xd01/vd01/fk01
|
Enter
|
Account group-{customer/hyd/777a}
Co.code-[777a]
|
Enter
|
Name-[CustomerA]
|
Adress:-
postal code-[hyderabad]
country-[In]
Region-[01]
|
Select-[companu code tab](ctrl+f2)
|
Recon.A/c-[200700]
Short key-[031]
Cash.mgnt group-[E2]
|
Enter
|
save
Step5: Post sales Invoice:
F-22
|
Enter
|
Doc.date:[xxxx]
Posting date-[xxxx]
Type-[DR] D-customer
{Create no.range18 fbn1}
Co.code-[777a] R-Invoice
Pstgkey-[01] Account-[500000](customer account no)
|
Enter
|
Amount-[100000]
BlineDate-[due date]
Text-[DD]
pstkey-[50] Account-[300000](sales account)
|
Amount-[*]
Text-[+]
|
Simulate
|
Save
Step6: Display customer ledger and sales ledger:
fbl3n
|
Enetr
|
G/L A/C-[300000]
|
Co.code-[777a]
|
Execute(f8)
Step7: Display customer ledger:
fbl5n
|
Enter
|
Customer account-[500000]or(xxxxxx)
Co.code-[777a]
|
Execute(f8)
Step8:Dispaly customer balance monthwise:
Fd10n
|
Enter
|
Customer A/c-[xxxxxxx]
co.code-[777a]
Fiscal year-[2014]
|
Execute(f8)
Step9:Display account's receivable statement:
fbl3n
|
Enter
|
G/L-[200700] {it is standard report}
Co.code-[777a]
|
Execute(f8)
Step10: Post Customer receipt:
F-28
|
Enter
|
Doc.date-[xxxxxx]
Posting data-[System date]
Type-[DZ] {D-customer}
{z-payment}
Co.code-[777a]
posting date-[777a] {create no.range 14
fbn1}
Bankdata:
Account-[200500](bank account no)
Amount- [100000]
Valuedate-[xxxxxxx]
Text-[chequeck from customer]
open item selection:
Account-[500000](Customer)
|
Click on-[open item process] button
|
Save
step11: Post customer receipt to part payment:
f-28
|
Enter
|
Doc.date-[xxxxx]
Posting date-[system date]
Type-[Dz]
bank dat:
|
Account-[200500]
Amount -[50000]
value date-[xxxxx](cheque date)
Text-[part payment of bill]
|
Customer-[500000]
|
Click on-[process open item button]
|
double click on-[100000]
|
Select-[partpayment tab]
|
Change the amount-[50000]
|
Save
Step12: Post customer receipt balance amount:
f-28
|
Enter
|
Bank account-[200500]
Amount-[50000]
Value date-[xxxx]
Text-[balance amount paid]
|
Customer A/c-[500000]
|
Click on-[Process open item button]
|
Click on-{selectAll icon}
|
Select-[Deactivate items] tab
|
Double click on payment amount-[100000]
|
Select-[partial payment] tab
|
Amount-[50000]
|
Save
Step13: Display customer balance:
fbl5n
|
Enter
|
Customer account-[500000]
Co.code-[777a]
|
Execute(f8)
Step14: Post final adjustment between invoice amount and part payment:
F-32
|
Customer account-[500000]
Co.code-[777a]
|
Select-[process open item] button
|
Click on-[Deactive items]
|
Double click on-[100000]
Double click on-[50000]
Double click on-[50000]
|
Save
Customer Downpayment
It's nothing but a advance amount.In Real business senario sometimes some
comapanies are asking advance before supplying the material.
Normally customer data will be under assets/Accounts receivable because our
material is at customer that means we are waiting for customer payment.
But in advance (payment) case we are taking amount before supply the material
.so,now we liabile to customer.So this advance amount should be under Liabilities.
In sap this is called as on Special G/L-A
following steps
Step1: Create downpayment from customer G/L under Liabilities:-
Fs00
|
Enter
|
G/L-[100720]
|
Co.code-[777a]
|
Select-[Create] button
|
Account type-[Liabilites]
|
Select-[control data]tab
|
Local balance currency-[Inr]
|
Recon.Account type-[Customer]
|
Select-[Line item Display check box[/]
|
Sort key-[031]
|
Select-Create/bank/Interest]Tab
|
Field status group-[G067]
|
Save
Step2: Create Spl G/L:-
Obxr
|
Double click on -[D][A]
|
Chart of accounts-[777a]
|
Enter
|
Rec.Account Spl.G/L
200700 100720
|
Save
|
Enter
Work flow of Customer downpayment
Step1: Customer Advance/Downpaymnet:-
f-29
|
Doc.date-[xxxxxx]
Postind date-[xxxxxx]
Type-[DZ]
Co.code-[777a]
Currency-[Inr]
|
Customer Account-[xxxxxx]
|
Spl.G/L-[A]
|
Bank Acccount-[xxxxx]
|
Amount-[xxxxxx]
|
Value date-[XXXX]
|
Text-[XXXXXXXX]
|
Enter
|
Amount-[*]
|
Text-[+]
|
Document
|
Simulate
|
Save
Step2: Post sale invoice:
F-22
|
Enter
|
Doc.date-[xxxx]
Postg date-[xxxx]
|
Pstg key-[01]
Account-[Customer Account]
|
Enter
|
Amount-[xxxxx]
|
Text-[XXXXX]
|
Pstg Key-[50]
|
Account-[XXXXX](sales Account)
|
Amount[*]
|
Value date-[xxxxx]
|
Text-[+]
|
Documant
|
Simulate
|
Save
Step3: Transfer Advance amount to Customer G/L:
F-39
|
Doc.date-[XXXX]
Pstg.date-[xxxx]
|
Customer account-[XXXXXX]
|
Text-[XXXXXXXX]
|
Select-[Process downpaymnt]
|
Select-Line item(Amount)
|
Save
Step4: Final Clearing:f-32
Dunning(16.03.2015)
Step1:Maintain dunning procedure:(fbmp):
fbmp
|
Select-[New procedure]
|
Dunning procedure -[777a]
Name -[Customer <200000]
|
Dunning interval in days-[5]
No.of dunning levels-[3]
|
Select-standard transaction dunning checking box[/]
|
Select-[dunning levels]
|
Days in arrears/interest:
|
Days in arrears -[]-[5]-[10]
calculate interest -[/]-[/]-[/]
|
Print parameters:
|
Always dun? -[/]-[/]-[/]
print all item -[/]-[/]-[/]
|
Select-[Charges] tab(f6)
|
currency-[Inr]
|
Enter
|
Dun.level from dun.amount Dun.charges
1 10000 100
2 20000 200
3 30000 300
|
Select-Minimum amounts
|
Currency-[Inr]
|
Dun.level Minimum amount minimum for interest
1 10000 100
2 20000 200
3 30000 300
|
Select-[Dunning Text]tab
|
Give the Co.code-[777a]
|
Select-[New company code tab]
|
[777a]
|
Enter
|
Select-Dunning area Per dunning level
[/] [/]
|
Save
|
Select-back arrow (1 time)
|
Select-[yes]
|
Again-[dunning text]tab
|
Normal dunning procedure:
1------>Select-[any one form]
2------>select-[any one form]
3------>select-[any one form]
|
Select-back arrow
|
Save
Step2: Create new customer And assign above dunning method:
Xd01
|
Select-Customer group-[customer/vij/777a]
|
Co.code-[777a]
|
Enter
|
city-[Vijaywada]
|
Country-[in]
|
Region-[01]
|
Select-[correspodence]tab
|
Dunning procedure-[777a]
|
save
Step3: Post sale invoice with old date:
F-22
|
Document date-[xxxx]
posting date-[xxxxx]
Type-[DZ]
co.code-[777a]
|
pstng key-[01] account-[select-customer a/c]
|
Amount-[xxxxx]
|
Text-[xxxxx]
|
pstng key[50] Account-[200500](select-bank A/c)
|
Amount-[*]
|
Text-[+]
|
Document
|
Simulate
|
Save
Step4: Run program for Dunning:
f150
|
Run on-[todays date]
|
Identification-[777a]
|
select-[parameters]tab
|
Dunninng date-[any old date](11.03.2015)
|
Duc.date-[28.02.2015
posted date-[28.02.2015]
|
Co.code-[777a]
|
A/c Restrictions:
|
Customer-[500020]
|
Save
|
Select-[back arrow](1 time)
|
Click on-[schedule]button
|
Select-[start immediatly check box][/]
|
Enter
|
3 times enter press
|
Click on-[dunning print out] tab
|
Select-[Print]
|
Enter
|
Select-[Dunning history]tab
|
A/c type-[D](customer)
|
Co.code-[777a]
|
Select-[500020](customer A/c)
|
Execute(f8)
|
Click on-[Cutsor on line item](line amount)
|
Select-[Display dunning notice]
|
Select-[print-preview button]
Accounts payable(Vendor)
step1:Create accounts groups:
Obd3
|
Select-[New entries]
|
A/c group-[777a]
General data:
Name-[vendor/vij/777a]
|
Enter
|
Save
Step2: Create no.ranges:
Xkn1
|
Enter
|
Select-[Changes interval]
|
Select-[Interval]
|
No From no To no
7a xxxxx xxxxxxx
|
Enter
|
Save
|
Ignore the warning msg
|
Enter
Step3:Assign no range to accounting group:
OBas
|
Select-[777a]
|
Give the no.range-[7a]
|
Save
Step4: Create accounts payable G/L:
fs00
|
G/L Accouunt-[100700]
|
Select-[Create] button
|
Account group-Select-[Liabilities]
|
Select-balance sheet account[/]
|
Short text-[accounts payable]
G/L long text-[accounts payable]
|
Control data Tab:
|
Accounts currency-[Inr]
Reconcilation account-Select-[vendor]
Select-line item display radio button
Select-short key-[012]
Create/bank/intrst:
|
Field status group-select-[g067]
|
Save
Step5: Create new vendor master data:
xk01
|
Enter
|
Co.code-[777a]
Accounts group-[777a]
|
Enter
|
Title-selecct-[company]
Name-[VendorA]
|
Street-[main road]
City-[Hyd]
Country-[In]
Region-[01]
|
Enter-(3 times)
|
Select-Recon.A/c-[100800](accounts payable)
|
Short key-[012]
Cash.mgt.group-[A1]
|
Enter
|
Save
Step6:Post purchase invoice:-
f-43
|
Duc.date-[xxxxxxx] {k-vendor}
psting.date-[xxxxxxx] {R-invoice}
Type-[Kr]
Pstng key[31] Account-[select-accountspayable A/c]
|
Amount-[xxxxxxxx]
Blinedate-[xxxxxxx]
Text-[DD]
|
Pstng key-[40] Account-[xxxxx](purchase account)
|
Enter
|
Amount-[*]
|
Text-[+]
|
Document->simulate
|
Save
Step7:Display vendor A/c statement:
fbl1n
|
Vendor-[accounts payable account]
Co.code-[777a]
|
Execute(f8)
Step8: Display vendor statement monthwise:-
fk10n
|
Vendor-[xxxxx](payable account)
Co.code-[777a]
Year-[2014]
|
EXecute(f8)
Step9:Post vendor payment:
F-53
|
Doc.date-[xxxxx] {k-vendor}
Type- [KZ] {z-payment}
Bank data:
|
Account-[200500] (create no.range 15
|
Amount- [xxxxxx] fbn1->enter->co.code-[777a]-
>select-change interval button->
Value date- Select->interval
Text- [payment agisnt purchases]
No year fromNo ToNo
Account-[xxxxx](vendor payable account) 15 2014 xxxxxx
xxxxxx
| |
Click on-[process open item]button Enter
| |
Enter Save
|
Save
step10:Display vendor account statement with open items and cleared item option:
fbl1n
|
Enter
|
VENDOR ACCOUNT-[XXXXXX]
|
CO.CODE-[777A]
|
Execute(f8)
(i)Post vendor payment and adjust with 1 Invoice outoff above two invoice:
(ii)post veendor partpayment two times and adjust with invoice:
(iii)final clear with two partpayments and 1 Invoice:
Vendor Downpaymnet
Step1: Create Dwonpayment G/L under Asset:
Fs00
|
Enter
|
[200800]
|
[Create]
|
Account Group-[Asset]
|
Short text-[Downpayment]
Long Text-[Vendor Downpaymnt]
|
Select-[Control data]
|
Local currency-[Inr]
|
Local balance Curency check box-[/]
|
Recon A/C type-[Vendor]
|
Select-Line item Check box[/]
|
Sort key-[012]
|
Select-[Create/bank/interest]
|
Field status group-[g067]
|
Save
Step2: Create spl G/L:
Obyr
|
Enter
|
Double click on-[D][A]
|
Recon A/C Spl G/L
| |
100700 200800
|
Save
Step3: Create new vendor Master data for Down payment:
Xk01
|
Enter
|
Co.code-[777a]
|
Account group-[777a]
|
Enter
|
Title-Select-[Company]
|
Name- [Vendor down paymnt]
|
Postal City/Code-[Anantapur][515308]
|
Country-[In]
|
Region-[01]
|
Enter(3 times)
|
Recon.A/c-[100700]
|
Sort key-[012]
|
cash mgnt group-[A1]
|
Save
Step4: Post Vendor downpayment:
f-48
|
Enter
|
Doc.date-[xxxxx]
pstng.date-[xxxxx]
Type-[kz]
Co.code-[777a]
|
Vendor Account-[XXXXX]
Spl.G/L-[A]
|
Bank Account-[XXXXX]
|
Amount-[XXXXX]
Value date-[XXXXX]
Text-[XXXXXXXX]
|
Enter
|
Amount-[XXXXX]
Text-[XXXXXXXXXXXXXX]
|
Document
|
Simulate
|
Save
Step5: Post Purchase Invvoice:
F-43
Step6: Transfer advance amount to vendor invoice :
F-54
|
Enter
|
Doc.date-[XXXXXXX]
Pstg,date-[xxxxxx]
|
Vendor A/C-[XXXXXX]
|
Text-[Transfer advance amount]
|
Select-[Process down payment]tab
|
Select-[Line item]
|
Post(Save)
Step7: Display Vendor Down payment:
Fbl1n
|
Enter
|
Select-Vendor No-[XXXXXX]
|
Select-[Open item] Radio button (.)
|
Select-[Spl g/l Transaction]Check box[/]
|
Execute(f8)
|
Select-[Back arrow]
|
Deslect-[Spl G/L Transaction]check box
|
Execute(f8)
Terms of payment
Step1: Create terms of payments:
obb8
|
Select-[New entries]
|
payment terms-[777a]
|
sales Text-[customer<500000hyd]
|
select-[posting date radio button]
|
paymt terms
Term percentage No.of days
1 2% 10
2 1% 20
3 0 30
|
Enter
|
Save
Step2: Create discount given exepenses G/L:
fs00
|
G/L-[400507]
Co.code-[777a]
|
Account group-[Expenses]
|
Select-[P&L A/c rdio button]
short text-[discount given]
G/l long text-[discount given]
|
Control data tab
|
Currency-[inr]
Line item display check box[/]
short key[001]
|
Create/bank/intrst tab
|
Field status group-[g001]
|
Save
Step3: Create automatic acccount assignment for discount given G/L;
obxi
|
Enter
|
chart of accounts-[777a]
|
Enter
|
select-[posting key]tab
|
save
|
Yes
|
again select-[posting key]tab
|
Select-accounts-[400507][discount given]
|
Save
step4:Create new customer master data:
xd01
|
A/c group-[customer/vij/777a]
|
Co.code-[777a]
|
Enter
|
Title-[company]
name-[customer TP]
city-[viajaywada]
country-[In]
Region-[01]
|
Recon.A/c-[200700]{Select-acounts receivable A/C}
Short key-[031]
cash.mgnt group-[E2]
|
payment terms-[777a](select-company code)
|
Save
Step5: Post sales invoice:
Old date entry
f-22
|
Enter
|
Doc.date-[01.12.2014]
posting date-[01.12.2014]
Type-[DR]
|
All are same in header data
|
Pstg key-[01]
Account-[select-customer terms paymnt account]{xxxxxxx}
|
Enter
|
Amount-[xxxxx]
|
Text-[xxxx]
|
pstkey-[50] Account-[sales A/c]
|
amount-[*]
|
Text-[+]
|
Document
|
Simulate
|
Save
Present date
F-22
|
Enter
|
Doc.date-[xxxxxx]
posting date-[xxxxxxx]
Type-[DR]
|
pst key-[01] account-[TermPaymnt account]
|
Enter
|
Amount-[xxxxxx]
|
Text-[xxxx]
|
pst key-[50] account-[sales A/c]
|
Enter
|
Amount-[*]
|
Text-[+]
|
Document
|
Simulate
|
Save
Step6: Post customer receipt payment:
f-28
|
Doc.date-[xxxxxx]
posting date-[xxxx]
Type-[DZ]
|
bank
Account-[200500](select bank account)
|
Amount-[98000]
|
Text-[xxxxxx]
|
customer
|
Account-[xxxxx](select-terms of payment account)
|
Select-[process open item]
|
Select-[Select all]
|
Select-[deactivate item]
select-[present date line item]
|
Save
Step7: Display cash discount G/L:
fbl3n
|
Enter
|
Account-[select discount given A/c]
Co.code-[777a]
|
Execute(f8)
Sales Tax
step1: create condition Type:
obyz
|
Enter
|
select-[condition type]
|
select-[New entries]
|
co.code-[777B](base amount)
|
condition data1:
|
cond.Class-[A]
calc.type- [B]
cond.Category-[K]
|
Enter
|
Save
|
Enter
Again same entry: Access.seq-[mwst]
|
Select-[New entries]
|
[777c]-[cst payble]
|
Cond.class-[D]
calc.type -[A]
Cond.category-[D]
|
Select-[Amount/percent]check box
|
Save
Again-[New entries]
|
cond.type-[777v]{vat payble} Acces.seq-[mwst]
cond.type-[D]
calc.type-[A]
cond.category-[D]
|
Save
Step2: Create tax process:
Obcn
|
Select-[New entries]
|
process-[77c]
general details:
|
Description-[Cst payble]
Tax type-[1]
posting ind-[2]
|
Save
|
Enter
Again-[New entries]
|
process-[77v]
description-[Cst output(777a)]
Taxtype-[1]
posting ind-[2]
|
Save
|
Enter
Sterp3: Create Tax Procedure:
obyz
|
Select-[procedure]
|
Select-[New entries]
|
Procedure Description
777a 777a
|
Save
|
Enter
Step4: Assign above tax procedure to country:
Obbg
|
Enter
|
country Name procedur
In India 777a
|
Save
Step5: Create and assign in procedure-(base amounts to tax conditions):
obyz
|
Select-[procedure]
|
select-[our procedure(777a)]
|
Double click on-[control]
|
Select-[New entries]
Step co ctype Description from To A/c key
10 0 777b base amoount 10
20 0 777c Cst payble 10 10 77c
30 0 777v vat payble 10 10 77v
|
Save
|
ENTER
step6: Create Cst payble G/L under liabilities:
Fs00
|
G/L a/c-[100995]
|
Select-[create button]
|
A/c group-[Liabilities]
balance sheet[.]
|
Short text-[Cst payble]
|
Select-[control data] tab
|
select-only balance in local currency check box[/]
|
select-posting without tax allowed[/](it is optional)
|
Select-line item display check box[/]
|
short key-[001]
|
Select-[create/bank/intrst]tab
|
field status group-[G001]
|
Save
Step7: Assign cst payble G/L for account determination(automatic payment):
ob40
|
Double click on-[77c]
|
Chart of accounts-[777a]
|
Enter
|
Select-[posting key] tab
|
select-[yes]
|
again select-[posting key]
|
debit-[40]
credit-[50]
|
select-[accounts] tab
|
select-[yes]
|
enter
|
Account given the-[100800](cst payble a/c)
|
save
Step8: Create Tax code:
Ftxp
|
country-[In]
|
enter
|
Tax code-[7c]
|
Enter
|
Tax code-[7c][4% vat output 777a]
|
Tax type-[A]
Select-check id check box-[/]
|
Enter
|
Cst payble-[77c][4]
|
Enter
|
Save
Step9: Create sales cst G/L:
Fs00
|
G/L-[300100]
|
Select-[create]button
|
select-Account group-[Revenue]
|
Select-[P&L satetment]radio button
|
Short text-[Sales Cst]
|
Select-[Control data] tab
|
tax category-Select-[7c]
|
Select-posting without tax allowed check box[/]
|
Select-[Line item display check box]
|
short text-[001]
|
Select-[Create/bank/intrst] tab
|
field status group-[G029]
|
Save
Step10: Create new customer for sales tax:
xd01/fd01/vd01
|
Enter
|
Account group-[select-customerA/vij/777a]
|
Enter
|
Title-[company]
Name- [custmer TX]
|
city-[hyderabad]
country-[In]
Region-[01]
|
Select-[company code Data]
|
Recon.account-[select-A/c's receivable a/c]
|
Short key-[031]
cash mgnt group-[E2]
|
Save
Step11: post sale invoice with cst tax code:
f-22
|
enter
|
pstg key-[01] A/c-[select-customertax a/c]
|
Enter
|
Amount-[xxxxx]
|
Select-calculate tax check box[/]
|
Text-[xxxxx]
|
pstg key-[50] A/c-[select-sales cst a/c]
|
enter
|
amount-[*]
|
Text-[+]
|
Document
|
simulate
|
Save
Step12: Display CST payble:
fbl3n
|
G/L a/c-[100995](select-cst a/c)
|
co.code-[777a]
|
execute(f8)
step13: Display customer G/L:
fbl5n
|
G/L a/c-[select-customer account]
co.code-[777a]
|
execute(f8)
Baddebts
It's nothing but a overdue bills.As per the company law under A/C's reeceivable at
the we have to show seperatly before
duedate A/c's receivable and above duedate A/c's receivable.
once we fix a program we run baddebts program for particular period then system
automatically will takeout overdue bills
and it will update A/c's rceivable baddebts.Also it will update bad expenses G/L
and provision for baddebts.
Step1: Create baddebts method:
Ob04
|
Select-[New entries]
|
Provision per Month per1 Month per2 Month Per3 Month
Per4
777a 1 10 2 20 3 30 4
40
|
Enter
|
Save
Step2: create The following ledgers:
Fs00
|
G/L-[200850]
|
Create
|
A/c group-[Asset]
Balance sheet Accountt radio button[.]
|
Short text-[A/c's Receivable for baddebts]
Long text-[A/c's Receivable for baddebts]
|
Select-Control data tab:
|
Currency-[Inr]
|
Recon.A/c-[Select-Customer baddebts G/L]
|
Line item display check box[/]
Short Text-[001]
Create/Bank/Intrst:
Fild status group-[G067]
|
Save
Step3: Create baddebts G/L Under expenses:
Fs00
|
G/L-[400508]
Co.code-[777a]
|
A/C group-[expenses]
P&L Statement radio button[.]
|
Short text-[baddebts expenses]
G/L Long Text-[baddebts expenses]
|
Select-control data tab;
|
currency-[Inr]
|
Select-[Line item display]check box
|
Srt key-[001]
|
Create/Bank/inrst:
|
Select-field status group-[G001]
|
Save
Step4: Create provision for baddebts under liability:
Fs00
|
G/L-[100150]
Co.code-[777a]
|
A/c group-[Liability]
Select-[Balance sheet account radio button]
Short text-[Provision for baddebts]
|
Select-control data tab:
|
Currency-[Inr]
|
Select-[open item management]check box[/]
Select-[Line item Display]check box[/]
sort key-[001]
|
Create/bank/intrst:
|
Select-field status group- [g001]
|
Save
Step4: Create Special G/L:
Fbkp
|
Click on-[spl.g/l]
|
Click on-[D]-[E]
|
C.O.A-[777a]
|
Rec.A/C-[200700](Select-rec.A/c)
|
spl.G/l-[200850](baddebts)
|
save
Step5: Create automatic postings for bad expenses and provision for baddebts:
|
Select-
