Skip to main content

Hi Everyone,

One of the customers is using staged billing when processing customer orders. They are facing the following issue when trying to Undo Customer Order Delivery.

 

Test Plan

Create a CO with Sales Qty as 1

 

Stage billing in two stages

 

Released the CO

Open Staged Billing Profile then Approve and Create Invoice for Stage 1

 

 

Open the created invoice and Print. Here I have only invoiced qty 0.3 as first stage of Staged Billing is 30%

 

 

Process the customer order till Picked.

 

Go to Deliver Customer Order With Differences and deliver 0.7 qty (out of 1)

 

Again, go to Deliver Customer Order With Differences and deliver the remaining 0.3 qty

Now the CO is fully Delivered. But only qty 0.3 has been invoiced. The remaining qty 0.7 is not invoiced.

The requirement is to Undo Delivery 0.7 which is not yet invoiced. But the system does not allow to do this through Undo Customer Order Delivery due to the following error.

 

 

Is there another way to accomplish this?

 

Thanks in Advance!!

Hello @EntDhanaP 

 

Do you know if some postings are created when approving the staged billing line on CO ? (like when milestone is approved on PO for ex) 

Thanks

Tanya

Normally I would expect an error to appear stating that invoice lines already exist, this stopping you from executing the undo process.

The logic for this error you are seeing is as follows,

 IF tot_qty_shipped_ IS NULL OR tot_qty_shipped_ > qty_shipped_ THEN
            Error_SYS.Record_General(lu_name_, 'UNDOMULTIDELIV: Customer order delivery has not been undone since there are a multiple deliveries and matching the reservation to the delivery is not possible when using shipment inventory.');
         END IF;

If you could execute the following to retrieve the data it is validating,

SELECT Customer_Order_Delivery_API.Get_Qty_Shipped('ENTER DEL NOTE NO'),
             Customer_Order_Reservation_API.Get_Qty_Shipped('ENTER DEL NOTE NO')
        FROM DUAL;

 

Customer_Order_Delivery_API.Get_Qty_Shipped - this retrieves the value for qty_shipped_

Customer_Order_Reservation_API.Get_Qty_Shipped - this retrieves the value for tot_qty_shipped_

Once you retrieve this data, validate if the numbers make sense,

 

Just had this error message appear where somehow the user has unpegged after the PO has been delivered and then cancelled the PO - so now we can not cancel the delivery and then the customer order.

Joy to the world!

Reply


Terms & ConditionsCookie settings