Hi All,
A user has posted an inventory count journal with the wrong posting date.
I have written a few scripts to address the various affected dates across an array of tables:
InventJournalTrans
InventTrans
InventTransPosting
SubLedgerVoucherGeneralJournalEntry
GeneralJournalEntry
I am pretty confident all relevant dates have been modified correctly at a transactional level.
However, the related financial voucher that was posted, even though I have updated the accountingDate values, the balances in the ledger accounts are not correctly updated even when a calculate balance function runs.
Is there anything I can do to ensure the new dates and the associated values are reflected in the ledger balances?
This is still only in a test environment but the client needs a live resolution ASAP
I have mentioned using a movement journal to reverse the count on the same posting date then repeat the count again with the correct count values at the correct date, but this is plan B for them.
Can someone please advise how I can get the ledger balances to reflect the changes made?
Thanks
