Hi,

Can you attach the error message and I can look at it and get back to you with some suggestions.

If it's urgent you can also enter a support ticket using the customer portal.

Thanks,

Hi Joel Singam,

i cant attached the screen shoot can you  give me any solution for balance difference.

please find the attached screen shot.

Hi Srinivas,

Thank you for the screenshot.

Can you run the following in SQL:  

select * from folder name.GACCENTRYD WHERE CURLED_0='ledger currency' AND CUR_0='transaction currency' AND FIY_0 = 2 AND PER_0 = 12

* Copy the results into Excel

* Sort by NUM_0

* Insert a column which multiples the sign (SNS) times the AMTLED so the debits and credits can be netted (I called the results column DB OR -CR).

* Subtotal by NUM_0 on the DB OR -CR column.

* Check for subtotals for NUM_0 that aren't equal to 0

Once you identify the out of balance journal you need to manually adjust it.

In order to do that you need to change the status (GACCENTRY table STA field) of the journal to 'Temporary' using the table maintenance.

Modify the journal and run the journal and account balance resynchronizations.

Please test it in a TEST environment.

Thanks,

Joel

Hi Srinivas,

Thank you for the screenshot.

Can you run the following in SQL:  

select * from folder name.GACCENTRYD WHERE CURLED_0='ledger currency' AND CUR_0='transaction currency' AND FIY_0 = 2 AND PER_0 = 12

* Copy the results into Excel

* Sort by NUM_0

* Insert a column which multiples the sign (SNS) times the AMTLED so the debits and credits can be netted (I called the results column DB OR -CR).

* Subtotal by NUM_0 on the DB OR -CR column.

* Check for subtotals for NUM_0 that aren't equal to 0

Once you identify the out of balance journal you need to manually adjust it.

In order to do that you need to change the status (GACCENTRY table STA field) of the journal to 'Temporary' using the table maintenance.

Modify the journal and run the journal and account balance resynchronizations.

Please test it in a TEST environment.

Thanks,

Joel

Thanks for you suggestion..

i will and let you know the result.

Thanks,

Srinivas

Hi Joel Singam,

Thanks for your help, i got the solution from your post.

Thanks,

Srinivas