5/5/2014 how to modify J_2IACCBAL table opening balances | SCN

https://scn.sap.com/thread/1037866 1/4

Getting Started Newsletters Store

Products Services & Support About SCN Downloads

Industries Training & Education Partnership Developer Center

Lines of Business University Alliances Events & Webinars Innovation

Login RegisterWelcome, Guest Search the Community

Activity Communications Actions

Brow se

Tweet0

7 Replies Latest reply: 19-Sep-2008 08:10 by chinmaya b

778 View s

Average User Rating

(0 ratings)

how to modify J_2IACCBAL table openingbalancesThis question has been Answered.

sir

i have updated wrong data in excise teble and after that i have posted some tresanction in this year

after go live in 1 april kindly is there any way to change those balances in that table

or how to change last year closing balances of 31st march2008

regd

chinmaya

chinmaya b 09-Sep-2008 13:31

Correct Answer

by goutham p on Sep 10, 2008 9:12 AM

Hi,

In the J2I9 extraction, the program is not considered J_2IACCBAL table and its considered the

following table -

Tables

TABLES j_1ipart1.

TABLES j_1ipart2.

TABLES j_1iexchdr.

TABLES j_1iexcdtl.

TABLES j_1imovend.

TABLES j_1iexgrps.

TABLES j_1iwrkcus.

TABLES lfa1.

Please check the Excise user and ask is it possible to adjust the values in this financial year, if

yes then

do the adjstment through J1IH.

Table updation is not a good practice and it give problems in future

Regards

Goutham

Re: how to modify J_2IACCBAL table opening balances

Hi,

This can be done through following ways -

1. Debit the excess amount or credit the shortage amount in this year through J1IH adjustment.

or

goutham p 09-Sep-2008 13:39 (in response to chinmaya b)

5/5/2014 how to modify J_2IACCBAL table opening balances | SCN

https://scn.sap.com/thread/1037866 2/4

2. Table updation but this will only at table level but not effect the financial entries but it effect in

registers

go to transaction SE16N and enter the table name and selection data. In the top write &SAP_EDIT

and press enter then execute the transaction. then table now be in editable and in that you can add or

delete the values

Rewards if it helps

Regards

Goutham

Like (0)

Re: how to modify J_2IACCBAL table opening balances

sir i want to change it in the way that will affect the 54f4 abbstracts in j2i9 ,or is there any way to

adjust opening balance in this financial year

rega

Like (0)

chinmaya b 10-Sep-2008 08:59 (in response to goutham p)

Re: how to modify J_2IACCBAL table opening balances

Hi,

In the J2I9 extraction, the program is not considered J_2IACCBAL table and its considered

the following table -

Tables

TABLES j_1ipart1.

TABLES j_1ipart2.

TABLES j_1iexchdr.

TABLES j_1iexcdtl.

TABLES j_1imovend.

TABLES j_1iexgrps.

TABLES j_1iwrkcus.

TABLES lfa1.

Please check the Excise user and ask is it possible to adjust the values in this financial

year, if yes then

do the adjstment through J1IH.

Table updation is not a good practice and it give problems in future

Regards

Goutham

Like (0)

Correct Answer

goutham p 10-Sep-2008 09:12 (in response to chinmaya b)

Re: how to modify J_2IACCBAL table opening balances

i am sending data kindly explain me jv i have to post

40 22000580 4745799.57 Cenvat Credit RG23A Part II

11 31.03.2008 BA11

40 22000590 429999.82 Edu Cess Credit RG23A Part II

11 31.03.2008 BA11

40 22000600 51291.91 Higher Edu Cess Credit RG23A Part II

11 31.03.2008 BA11

40 22000610 2027888.90 RG23C on capital goods-

BED 31.03.2008 BA11

50 22000620 9538.00 CENVAT on capital goods-ECS 31.03.2008 BA11

40 22000550 3681983.00 BED payable EG 11 31.03.2008 BA11

40 22000560 73632.00 Edu cess payabl EG11 31.03.2008 BA11

40 22000570 36839.00 Higher Edu Cess Payable RG23A Part II

11 31.03.2008 BA11

50 22000540 5100000.00 PLA on hold Excise group

11 31.03.2008 BA11

chinmaya b 10-Sep-2008 14:54 (in response to goutham p)

5/5/2014 how to modify J_2IACCBAL table opening balances | SCN

https://scn.sap.com/thread/1037866 3/4

40 22000551 1228640.51 PLA for BED 31.03.2008 BA11

40 22000553 3738.44 PLA- for CESS 31.03.2008 BA11

40 22000554 48418.12 PLA-SED 31.03.2008 BA11

50 22000561 2109392.16 PLA for BED12 31.03.2008 BA12

40 22000563 1598597.60 PLA- for CESS 12 31.03.2008 BA12

40 22000564 151410.13 PLA-SED12 31.03.2008 BA12

40 23000610 28138764.97 CENVAT on capital goods-

BED12 31.03.2008 BA12

40 23000620 533838.97 CENVAT on capital goods-ECS

12 31.03.2008 BA12

40 23000630 173962.33 CENVAT on capital goods-SEC

12 31.03.2008 BA12

50 22000640 84712.77 CENVAT on hold 31.03.2008 BA12

40 23000580 8743067.48 Cenvat Credit RG23A Part II

12 31.03.2008 BA12

40 23000590 437010.89 Edu Cess Credit RG23A Part II

12 31.03.2008 BA12

40 23000600 163824.80 Higher Edu Cess Credit RG23A Part II

12 31.03.2008 BA12

50 22000630 4422.03 CENVAT on capital goods-SEC 31.03.2008 BA12

50 23000550 442976.98 BED payable EG 12 31.03.2008 BA12

50 23000560 8885.03 Edu Cess Payable RG23A Part II

12 31.03.2008 BA12

50 23000570 4445.99 Higher Edu Cess Payable RG23A Part II

12 31.03.2008 BA12

50 22000571 191283.14 PLA for BED13 31.03.2008 BA13

50 22000573 3825.67 PLA- for CESS 13 31.03.2008 BA13

50 22000574 1912.84 PLA-SED13 31.03.2008 BA13

40 24000550 897368.00 BED payable EG 13 31.03.2008 BA13

40 24000560 17955.00 Edu Cess Payable RG23A Part II

13 31.03.2008 BA13

40 24000570 8968.00 Higher Edu Cess Payable RG23A Part II

13 31.03.2008 BA13

40 24000580 20372073.87 Cenvat Credit RG23A Part II

13 31.03.2008 BA13

40 24000590 369851.87 Edu Cess Credit RG23A Part II

13 31.03.2008 BA13

40 24000600 345663.41 Higher Edu Cess Credit RG23A Part II

13 31.03.2008 BA13

50 24000610 1085981.69 CENVAT on capital goods-

BED13 31.03.2008 BA13

50 24000620 24421.62 CENVAT on capital goods-ECS

13 31.03.2008 BA13

40 24000630 19164.77 CENVAT on capital goods-SEC

13 31.03.2008 BA13

40 25000550 3777743.00 BED payable EG 14 31.03.2008 BA14

40 25000560 75556.00 Edu Cess Payable RG23A Part II

14 31.03.2008 BA14

40 25000570 37778.00 Higher Edu Cess Payable RG23A Part II

14 31.03.2008 BA14

50 25000580 2876611.75 Cenvat Credit RG23A Part II

14 31.03.2008 BA14

40 25000590 11164.32 Edu Cess Credit RG23A Part II

14 31.03.2008 BA14

50 25000600 21482.68 Higher Edu Cess Credit RG23A Part II

14 31.03.2008 BA14

50 25000610 1062725.28 CENVAT on capital goods-

BED14 31.03.2008 BA14

50 25000620 18762.71 CENVAT on capital goods-

ECS14 31.03.2008 BA14

50 25000630 18128.05 CENVAT on capital goods-SEC

14 31.03.2008 BA14

40 26000551 96154.00 PLA for BED 16 31.03.2008 BA16

40 26000553 843.00 PLA- for CESS16 31.03.2008 BA16

40 26000554 31311.40 PLA-SED16 31.03.2008 BA16

40 26000610 884320.00 CENVAT on capital goods-

BED16 31.03.2008 BA16

40 26000620 17686.40 CENVAT on capital goods-ECS

16 31.03.2008 BA16

40 26000630 8843.20 CENVAT on capital goods-

SEC16 31.03.2008 BA16

50 22000770 214583.50 Prepaid expenses 31.03.2008 BA12

50 29000100 121686.03 GTA ST Receivable 31.03.2008 BA12

50 29000200 2433.71 GTA ST Cess Receivable 31.03.2008 BA12

5/5/2014 how to modify J_2IACCBAL table opening balances | SCN

https://scn.sap.com/thread/1037866 4/4

Follow SCNSite Index Contact Us SAP Help Portal

Privacy Terms of Use Legal Disclosure Copyright

Tweet0

Re: how to modify J_2IACCBAL table opening balances

sir

i need ferther clarification

about below trasanction and it will affect where,can u provide to find proper t code

regd

chinmaya

Like (0)

chinmaya b 11-Sep-2008 08:39 (in response to chinmaya b)

Re: how to modify J_2IACCBAL table opening balances

it is answared

Like (0)

chinmaya b 19-Sep-2008 08:10 (in response to chinmaya b)

50 29000300 1216.86 GTA STHCess Receivable 31.03.2008 BA12

50 22000650 285597.00 Service tax on hold on

services 31.03.2008 BA12

50 22000660 103060.81 ECS on hold on services 31.03.2008 BA12

50 22000670 51530.36 SEC on hold on services 31.03.2008 BA12

50 22000690 25746183.12 Input VAT credit-Non-capital

goods 31.03.2008 BA12

40 22000790 102132.66 Vat (Receivable) -Cap Goods 12.5% - 2007-

08 31.03.2008 BA12

40 22000800 322118.65 Vat (Receivable) -Cap Goods 12.5% - 2008-

09 31.03.2008 BA12

40 22000810 322119.62 Vat (Receivable) -Cap Goods 12.5% - 2009-

10 31.03.2008 BA12

40 22000820 219988.00 Vat (Receivable) -Cap Goods 12.5% - 2010-

11 31.03.2008 BA12

Like (0)

Re: how to modify J_2IACCBAL table opening balances

Hiii,

Its very difficult to tell here but tell me FI Consultant is availalbe in your project, if please contact

he can guide much

Regards

Goutham

Like (0)

goutham p 11-Sep-2008 08:43 (in response to chinmaya b)