I think the best practice in resolving this issue is only by reversing the voucher in the GL Module.
With your question, if there are many tables to consider in AX. The answer is - hundreds of tables you have to logically traced in each classes for you to be able to identify all the tables. Just the thought of doing it one by by. You can agree with me that it is exhausting to identify all the tables in AOT. Which in fact the voucher doesnt only posted in those main tables. The main tables itself commits to several subsidiary tables in AOT. Those Subsidiary tables appears when there are relevant scenario to consider in posting. Let say if the transactions contains GST, therefore Subsidiary table of GST will now be invited as a subsidiary table of the main table which is LedgerTrans table. I guess it not safe and very risky to do the manual deletion of entries in the AX. Poor me, I havent meet a brave guy who can work to find/delete posted transactions.. And logically there is a existing "Reversal of entries", you can make use of it. ________________________________ From: cristinacarcelen <[email protected]> To: [email protected] Sent: Thursday, November 12, 2009 1:33:47 Subject: [Axapta-Knowledge-Village] Re: GL posted voucher cleaning from database Hi Ali, Try running this process: Recalculate period balances. Regards, Cristina --- In Axapta-Knowledge- vill...@yahoogro ups.com, "Ali Jawad" <alijaw...@. ..> wrote: > > Hi, > > > > There was wrongly posted voucher through GL journal. > > I deleted it from following tables > > . Ledgerjournaltable > > . Ledgerjournaltrans > > . Ledgertrans > > > > Now when I print ledger statement, its ok. But when I print trial balance, > the same old amounts are populated. Is there any other tables also that need > to be cleaned for a particular GL posted voucher. > > > > > > Thanks in advance! > > > > Ali >
