Order Return Credit Error

There are times where Finance is trying to process a return (cancel a quantity on an order line) and they receive an error message:

"Line xx is a cancellation line. Quantity must be less than 0"

This is due to the product having a Kit Assembly

In order to get around this you must flip it back to a Standard Product, process the cancellation, and then put it back to a Kit Product.

This must be done quickly and outside of peak sales hours. We run the risk of an order processing while it's not in the kit status. 

Here is the query:

--Validate that item is KitTypeID = 2

select ProductKitTypeID, *

from aptify.dbo.Product

where ID = 66638

-- Run update query to change from 2 to 1

update aptify.dbo.Product

set ProductKitTypeID = 1  --set = 1 (Standard), process the cancellation, then set back to 2 (Kit Product) - this must be done quickly to not affect incoming orders

where ID = 66638

Run your cancellation wizard in Aptify.

Ship the cancellation order.

Then run the above query again to set back to 2

Attachments (2)

68e76f063196....png
200 KB

68e76f063196....png
82.3 KB