No problem setiajiJ Anyways, If you can see that invoice in open transaction editing window then its mean , its available for settlement . In short you either have not yet settled it against any payment journal or settled but not posted. If you could see "Red hand" icon against that invoice then its mean you have settled it in some journal but have not yet posted that journal. Hence you will have to search for the journal against which this transaction has been settled to unsettle it.
There is no need to peek inside the tables , there are many inquiry windows from where you can drill down to the transaction origin. Regards, faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of setiaji Sent: Friday, July 06, 2007 12:06 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] How to unsettle the journal ? Thanks again Faiqa for your amazing quick anwer. Its not me who did the posting with settlement. I only have an order to unsettle that journal. So i began check the voucher and invoice number to get the journal number from open transaction editing. Next i search in ledgerjournaltrans table to get the journal number. Right now, i already have journal number,voucher,invoice and recid. Then i follow your instruction.But the voucher or invoice is not there. Is there something happened with posting journal proses? Its really great help for me Faiqa - setiaji - Faiqa Khushi wrote: > > > > Please tell me the exact steps you have performed to settle the invoice > against which journal? > > If you have settled the invoice in payment journal and did payment against > that invoice and posted , then you can view the settled invoice from > closed editing transaction . But you can just reverse the settlement and > then that invoice will again get available for settlement against other > payment journal . For the wrong payment you will have to enter reversal > transaction through journal. > > Sorry, If I could not get your query correctly. > > Regards, > > faiqa > [Non-text portions of this message have been removed]