Entries shows double in Financial Ledger or Other Reports

Discussion on Installation Issues, Oracle Installation, Database Creation, Trouble Shooting etc.

Entries shows double in Financial Ledger or Other Reports

Postby sunil » Fri Oct 04, 2013 4:04 pm

Dear All,

Sometime due to corruption in Table Structure , our Product display double entries in Financial Ledger or in other reports. Find below solution of this issue.

1. Connect to SQLTalk
2. rename table as
ALTER TABLE PARTYTRN RENAME TO PARTYTRN_1;
DROP ALL INDEXES OF SOURCE TABLE (PARTYTRN)
CREATE TABLE PARTYTRN AS SELECT * FROM PARTYTRN_1
DROP TABLE PARTYTRN_1
CREATE INDEXES OF PARTYTRN
Note : don't forget to run create/update balance from Utilities

I hope , this will help.

Regards.
Shilpi Technical Team.
User avatar
sunil
 
Posts: 216
Joined: Fri May 25, 2012 9:55 am

Re: Entries shows double in Financial Ledger or Other Report

Postby swapnilyarwar » Sat Nov 09, 2013 3:49 pm

Sir ,

We should give some simple process in Utilcap10.exe for this issue , because its not possible to connect SqlTalk at client end because we need password of database and
then , execute syntax one by one.

So we have to give simple option in UtilCap10.exe which client can process it easily .


Regards

Swapnil P. Yarwar
swapnilyarwar
Shilpi Support
 
Posts: 28
Joined: Thu Jul 18, 2013 11:04 pm


Return to Technical / Installation Issues

Who is online

Users browsing this forum: No registered users and 5 guests

cron