Dynamics Community Forum Thread Details

Changing posting date of an inventory counting journal

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

Quick Links