Inconsistency error in G/L entry Table (Excise Settlement)

jay_sadhu

Hi All

While doining settlement of excise duty payable amount with RG 23 A Part II Amount (Cenvat Cr, Rcvble Account), RG 23 C Part II Amount (Cenvat Cr. Rcvble Capital Goods (50%)), Service Tax Rcvble Amount and PLA Amount I’m facing a problem. “Inconsistency error in G/L entry Table” while posting. I’m using Nav 4.0 Sp3.

For the financial year 08-09 I have adjusted the above four accounts successfully. It seems it creates the problem with ST amount as I tested in demo DB without taking ST amount and taking excess amount from RG 23 A Part II. System didn’t throw any error messages.

At first I ran Service Tax as Excise credit report and select those lines I want to avail credit.

In Gen Journal Line I provide Posting Date, (Date when amount has been deposited in PLA Account), Account Type payment, Account Code: payable Account, ECC Code,ST Reg. Code. From Functions-payment-Excise I fill up the form with appropriate value in respective cells.

Before posting the Gen Journal line shows

Amount (Payable) 1030/-
[
BED Amount 1000/-
Ecess Amount 20/-
SHE Cess Amount 10/-
]

RG 23 A BED Amount 300/-
RG 23 A Ecess Amount 6/-
RG 23 A SHE Cess Amount 3/-


RG 23 C BED Amount 200/-
RG 23 C Ecess Amount 4/-
RG 23 C SHE Cess Amount 2/-

ST BED Amount 100/-
ST 23 C Ecess Amount 2/-
ST 23 C SHE Cess Amount 1/-


PLA BED Amount 400/-
PLA 23 C Ecess Amount 8/-
PLA 23 C SHE Cess Amount 4/-

In G/L set up there is no rounding precision has been used for those accounts. Actual figures are in decimal.

I can’t find how system shows inconsistency error in G/L entry table. Please help what are other things I have to check.

With Thanks
Jayanta

Karenh

There is an excellent tip here viewtopic.php?f=5&t=22748

I used it recently and it was very helpful.

ssingla

I have replicated your scenario in the standard Cronus database and the transaction was posted without any error. Zoom the gen. Jnl. line and check the values else try re calculate and post the transaction.

jay_sadhu

Sir

What I found later is that if Posting No. series has been defined for the Journal Batch then error appears but if I use only no. series in the batch and leave Posting No series blank then posting done successfully. I tried it several times and found the same. Is it right or any other things are missed out?

Regards
Jayanta

ssingla

If posting happens than everything is fine though the bug is there if we use posting number series. You can log it with MS or if you cannot then I can test and can submit the same.

rranjanerp

Thanks