A fast and secure browser that's designed for Windows 10
is it possible to change the name of an already posted journal?
Hi Khosla, why would you want to do that?
Somebody in finance accidentally posted with the wrong name - but anyways, can we change it? Do you have any idea... I don't think so.
There would be no benefit in changing the name only because is has been posted already. You could reverse the posted journal and then create a new journal with the correct journal name.
Unfortunately not, it can only be renamed if it is still "Open".
It is only possible to change it in SQL directly or write a job with x++ statements and use the doUpdate() command to bypass the update validation checks.
On the user forms there is indeed no option to change it.
how to write a job to update the posted journal.
As per Anton Venter Advise you can reverse the Wrong entries which was posted by your Financial team posted wrongly and you can post the correct journal entries.
If you want to rename the journal it is a long time taking process.
Here is the code format of solution:
public static updateRoutejb(Args args)
ProdRoute ProdRoute ;
while select forupdate ProdRoute
if (ProdRoute .QtyGood > 0)
ProdRoute.OprFinished = true;
If you haven't found a solution yet, please raise a new question on the forum. I don't think the code suggestion from Goutham is helping you as this is a script to update production routes; not journal names/descriptions.
just update it from SQL direct, it is very easy and no change on business logic
Please use the following job to update journalName for the posted journal, provided
journaltype should be the same.
static void LedgerJournalTable(Args _args)
select * from ledgerJournalTable
where ledgerJournalTable.JournalNum =="XYZ"
&& ledgerJournalTable.JournalType == LedgerJournalType::Daily;
select * from ledgerJournalName
where ledgerJournalName.JournalName == "NewName"
&& ledgerJournalName.JournalType == ledgerJournalTable.JournalType;
ledgerJournalTable.JournalName = ledgerJournalName.JournalName;