Error in J1iex

[Former Member]

Hi all,

When i make the J1IEX part2, eror appears as

"Balance in Transaction Currency. Message in F5702"

Regards

[kunal_ingale · Accepted solution]

Hi,

In J1IEX, when you "Simulate" the Excise Invoice,

It should give the following Accounting Entry;

CENVAT Receivable - BED - Dr

CENVAT Receivable - ECS - Dr

CENVAT Receivable - SECess - Dr

CENVAT Clearing A/c - Cr

If It is coming as above then check the total of Cr and Dr, and check whether there as any difference of x amount

If not then check the Account Determination configuration in SPRO > Logistics - General > Tax on Goods Movements > India > Account Determination > Specify Excise Accounts per Excise Transaction > Here check following should exist

GRPO CR CLEAR

GRPO DR RG23AT1

GRPO DR RG23BED

GRPO DR RG23ECS

GRPO IP CR CLEAR

GRPO IP DR RG23AT1

GRPO IP DR RG23BED

GRPO IP DR RG23ECS

Then check in SPRO > Logistics - General > Tax on Goods Movements > India > Account Determination > Specify G/L Accounts per Excise Transaction > Here assign GL Accounts for ETT "GRPO" against the columns of RG23ABED, RG23AECS, RG23AAT1 and MODVAT Clearing, with Subtransaction Type "IP" and w/o also.

Then check in J1IEX.

Please check the following threads which are frequently asked

Also check the following note

Note 763141 - Error: Balance in transaction currency - J1IEX

Regards,

kunal

[Former Member · Accepted solution]

>

> Hi,
> In J1IEX, when you "Simulate" the Excise Invoice,
> 
> It should give the following Accounting Entry;
> 
> CENVAT Receivable - BED - Dr
> CENVAT Receivable - ECS - Dr
> CENVAT Receivable - SECess - Dr
> CENVAT Clearing A/c - Cr
> 
> If It is coming as above then check the total of Cr and Dr, and check whether there as any difference of x amount
> 
> If not then check the Account Determination configuration in SPRO > Logistics - General > Tax on Goods Movements > India > Account Determination > Specify Excise Accounts per Excise Transaction > Here check following should exist
> 
> GRPO CR CLEAR
> GRPO DR RG23AT1
> GRPO DR RG23BED
> GRPO DR RG23ECS
> GRPO IP CR CLEAR
> GRPO IP DR RG23AT1
> GRPO IP DR RG23BED
> GRPO IP DR RG23ECS
> 
> Then check in SPRO > Logistics - General > Tax on Goods Movements > India > Account Determination > Specify G/L Accounts per Excise Transaction > Here assign GL Accounts for ETT "GRPO" against the columns of RG23ABED, RG23AECS, RG23AAT1 and MODVAT Clearing, with Subtransaction Type "IP" and w/o also.
> 
> Then check in J1IEX.
> 
> Please check the following threads which are frequently asked
> 
> 
> 
> 
> Also check the following note
> Note 763141 - Error: Balance in transaction currency - J1IEX
> 
> Regards,
> 
> kunal

Hi Kunal,

As you told before,

When i simulate the J1iex part2, by manual calculation i could see the difference of 0.01 INR .

The error also says

Balance in transaction currency

Message no. F5702

Diagnosis

A balance has occurred in transaction currency 'INR' with the fol

details:

Exchange rate '00', amount ' 0.01-' and currency key

The data in the transaction currency were transferred from the ca

application.

System Response

Your data cannot be processed in FI.

-

---

How this can be fixed?

Regards

[Former Member]

Hai,

Which process ur doing.i.e excise transaction type. check for that ETT that all the duties debit and credit is displaying in simulate tab, if any thing is missing maintain the same in SPRO/Tax/India/A.c Determination/Specify exicse a/cs for ET.

If still u have queries let me know.

Regards,

BSK

[Former Member]

Hi,

Settings are checked and found OK in Quality server

When i post J1iex part 2 ,error appears as Accounting document not generated.

How to go with this?

Regards

[kunal_ingale]

Go to SPRO > Logistics - General > Tax on Goods Movements > India > Account Determination > Specify G/L Accounts per Excise Transaction, here do account determination for Excise transaction type "GRPO"

plz check ur entries for IP subtransaction for GRPO

Accounting Entry should be;

CENVAT Input - BED Dr

CENVAT Input - ECS Dr

CENVAT Input - SECess Dr

CENVAT Clearing A/c Cr

regards

kunal

[Former Member]

Hi Kunal,

I have checked the GL accounts and Excise transactions and appears to be OK.

I have captured part1 when i do MIGO.

When i do J1IEX for part2 for ASSET and when i click SAVE , the following error appears

'Accounting doc not generated'

I have simulated also but erro appears when i save.

Please help.

Regards

[Former Member]

Hi

We use GRPO and found settings to be correct for GL accounts and Excise accounts per excise transactions

Regards

[Former Member]

Hi Kunal,

Getting the error message

'Accounting document not generated'

Message no.F4186

Regards

[Former Member]

Check the ETT of CAPE GL s are defined or not...

[Former Member]

Hi

I have solved the Accounting Doc error.

Kindly provide solution for the error which i get during J1IEX part2 entry Post for ASSET.

Balance in transaction currency

Message no. F5702

Diagnosis

A balance has occurred in transaction currency 'INR' with the following

details:

Exchange rate '00', amount ' 0.01-' and currency key 'INR'.

The data in the transaction currency were transferred from the calling

application.

System Response

Your data cannot be processed in FI.

Procedure

The error is probably in the calling application.

Regards

[Former Member]

In the excise amount field enter the amount which would be closest to that in invoice and should be divisable by 2 as the amount is divided into 50 % for current and 50 % for next year.

e.g. if ur bed amount is 101.3 enter it as 101.2 or 101

if helpful

[Former Member]

Hai,

kindly ensure the following Accounting Entry;

CENVAT Receivable - BED - Dr

CENVAT Receivable - ECS - Dr

CENVAT Receivable u2013 SE Cess - Dr

CENVAT Clearing A/c - Cr

then It is coming as above then check the total of Cr and Dr.

If not then check the Account Determination configuration in SPRO > Logistics - General > Tax on Goods Movements > India > Account Determination > Specify Excise Accounts per Excise Transaction > the following should exist

GRPO CR CLEAR

GRPO DR RG23AT1

GRPO DR RG23BED

GRPO DR RG23ECS

GRPO IP CR CLEAR

GRPO IP DR RG23AT1

GRPO IP DR RG23BED

GRPO IP DR RG23ECS

Then check in SPRO > Logistics - General > Tax on Goods Movements > India > Account Determination > Specify G/L Accounts per Excise Transaction > Here assign GL Accounts for ETT "GRPO" against the columns of RG23ABED, RG23AECS, RG23AAT1 and MODVAT Clearing, with Sub transaction Type "IP" and w/o also.

regards,

venkat