Solved

ORA-20111: CustomerOrder.NOTEXIST2: The Customer Order object does not exist.

  • 4 April 2023
  • 3 replies
  • 363 views
R
Rank
Userlevel 5
Badge +9

Hello All,

 

We want to Create a Credit invoice for a Customer invoice.

We do that via the RMB option Create Credit invoice.

The background job that was created gave the following message:
ORA-20111: CustomerOrder.NOTEXIST2: The Customer Order object does not exist.

When I looked for the customer order I found-out that it's gone.

When I spoke to customer they told me that they had done a clean-up action for customer orders.

Due to that action several Customer order are removed from the system.

 

How can you create a Credit Invoice in this case?

 

Kind Regards

Raymond

icon

Best answer by cperdue 4 April 2023, 14:56

View original

3 replies

cperdue
Rank
Userlevel 6
Badge +14

You can create an instant invoice or create a new customer order with a no-part order line to replicate the original order.

Best- Christy
R
Rank
Userlevel 5
Badge +9

Hello Christy,


With the solution you provided, I think I will make another invoice and then credit it.

It is precisely about me crediting the invoice from which the corresponding order has been removed.

I don't think that's happening with the surgestie you're doing now.

Or am I seeing that wrong?

cperdue
Rank
Userlevel 6
Badge +14

I would create a negative value invoice.   If you create a debit and then a credit, it will leave the debit invoice (AR balance) on the system unless you offset with the credit.   This will put you back to where you are currently (a net of zero).

Best- Christy

Reply


Terms & ConditionsCookie settings