Query: Update order Status to Change QTY for Refunds/Cancellations

The following documentation is work around to orders that produce an error when there is an attempt to process a refund more than likely due to insufficient quantity from a split order (e.g. back-ordered, change in vendor needs). These errors are caused by a kit product where the quantity of the main product is non-zero, but the child products are zero.

reference tickets:

• https://support.ahima.org/helpdesk/tickets/8979
• https://support.ahima.org/helpdesk/tickets/9279

Overview: You will need to execute query to flip the original order to taken status, remove the batch, update the quantity, save the order, reapply the batch, and then flip the order back to shipped status.

NOTES:

• Not recommended UI because it may trigger onset of various other complications. 
• Recommended: Conduct updates in AptifyTest environment prior to making changes in AptifyProd.
• Updates should have no impact on original order pricing or GLs.

**Before getting started, be sure to take a screenshot of the original order as reference to ensure all other information remains the same (excluding QTY).**

 --Order Statuses : Shipped = 2   /  Taken = 1--

Query 1: Look up the order 

Select * 

from aptify.dbo.OrderState

where ID = #

Query 2: Update order status 

update aptify.dbo.OrderState (or aptify.dbo.OrderStatusID)

set OrderStateID (or set OrderStatusID) = #                      

where ID = # 

Query 3: Look up batch number (to temporarily remove)

select * 

from aptify.dbo.OrderState

where ID =                                     

    --Copy batch number--

Query 4: Update batch to NULL (temporarily) and set order status to Taken (1)

update aptify.dbo.OrderState

set OrderStatusID = 1, BatchID = NULL

where ID = #

and batchID = # 

   --Back in Aptify, Update line item QTY in order record and click save--

--Take screenshots of the original order line items (including subproducts) and GLs-- 

Query 5: Reapply batch number and set order status to Shipped(2) 

update aptify.dbo.OrderState

set OrderStatusID = 2, BatchID = #

where ID = # 

and Batch = NULL

--Validate that there were no changes paid to payment lines, final order total, or GLs--