Store quantity and pricing information for Customer Order Lines when an order is Cancelled

We have a checkbox that we use on a Customer Order to indicate that it was cancelled. I want to be able to store what the Customer Order Line item, quantity, and price were when the order is cancelled so that we can use this data to determine how much loosing the order cost us. For example, if a customer cancels an order because we cannot ship it fast enough, we want to know the loss associated with this. My thoughts were to create a new table to store this information in and populate the values when the cancelled checkbox is selected. I am not sure how to loop through each customer line though and populate this. Does anyone have some insight?

Find more posts tagged with

General Discussions

Accepted answers

All comments

unknown

Could you use SLCoitemLogs to get the values before it was canceled? SLCoitemLogs captures the historical changes to the order lines.

avillanueva

You can create an event handler (for an AES event, not form event) that apply to the SLCoitems IDO. If you use the IdoOnItemUpdate event you can check if the property modified is the one bound to the checkbox as the first action. That way you optimize the execution time of the event, and then you insert the data from the payload in your new table (you should generate an IDO for the table or create a SP to insert directly the data).

kwmyers

I don't know if this will work in your situation or not but we just extended SLCoItems and added a "LostSaleQty" column. When we have a cancellation, we set the Qty Ordered to 0, LostSaleQty to the qty cancelled and the line status to "Filled". We don't actually delete or move the line.

Copyright © 2025 Infor. All rights reserved.