/
Script to un-age creditor transactions and allocations based on a supplied date
Script to un-age creditor transactions and allocations based on a supplied date
Problem
A period roll-over has been accidentally run and transactions are required to be un-aged for changes to be made to allocations.
Solution
SQL skills are required
Sound knowledge of SQL is required to complete task
The attached script will un-age creditor transactions and associated allocations where the transaction date is on or after a specific date - e.g. 31 May 2016. Edit the date as required.
Related articles
, multiple selections available,
Related content
Changing creditor allocations on aged out transactions
Changing creditor allocations on aged out transactions
More like this
Debtors statements to print un-aged fully allocated transactions
Debtors statements to print un-aged fully allocated transactions
More like this
Change debtor allocations on transactions that have been aged out
Change debtor allocations on transactions that have been aged out
More like this
Ageing of transactions during Period Rollover can apply Period Rollover Date
Ageing of transactions during Period Rollover can apply Period Rollover Date
More like this
Delegation of Debtor Transactions and General Ledger journals on Order Process
Delegation of Debtor Transactions and General Ledger journals on Order Process
More like this