I am using AX 2009… in Ledger journal Table and trans more than 4000 un wanted records transfer from some integration. Now i need to delete the records. By using Delete query it promp ’ Number Sequence Doesnot exist". how to solve this?
static void Deleteunwanted_payment(Args _args)
LedgerJournalTable LedgerJournalTable ;
LedgerJournalTrans LedgerJournalTrans ;
delete_from LedgerJournalTable where LedgerJournalTable .Name == ‘xxxxx’ && LedgerJournalTable .posted == NoYes::No;
delete_from LedgerJournalTrans where LedgerJournalTrans .Txt == ‘xxxxxxxxxx’ ;