Clear Pending Orders

slmaluwa

Hello

We have 1000s of pending orders left in Orders form. All has pending orders (parially shipped and invoiced).

We are planning to clear them on a date range basis without reinvoicing the balance periodically.

is it possible to automate this task and if possible, bit of code example will be very much appreciated!

TIA

Bodhi

Alex_Chow

Here's what you need to do:
1. Create a process only report that loops through the sales header with filter on Order
2. On the sales header after get record, call the codeunit to reopen the order
3. Delete(TRUE) the order

Be sure to let the user specify the Order Date range.

slmaluwa

Thank you for the idea Alex

Hope this will NOT delete any other data, like Posted Invoices etc?
We just wanted to delete the pending orders

Regards

DenSter

Posted Invoices (and any other posted documents) are not in the Sales Header/Line tables, so provided your sales header table has not been modified, you should be safe there.