Skip to main content

ORA-20105: Invoice. ACCERROR1: Error (Field[ORDER_NO] is a mandatory for Customer Order Charge and requires a value. 


 

 

Any help would be greatly appreciated. 
 

Thank You! 

@Agcd123 could you please provide more details about this? Is this an Instant Invoice? Or perhaps a Customer Order Invoice?

Some screenshots with the invoice would be more than welcomed in order for anyone to be able to assist.


@Agcd123 could you please provide more details about this? Is this an Instant Invoice? Or perhaps a Customer Order Invoice?

Some screenshots with the invoice would be more than welcomed in order for anyone to be able to assist.

I wanted to walk you through everything I have dug through and learned so far on this issue. I spoke with the user that actually created this invoice, She informed me that she created this instant invoice from the Customer Order heard>RMB>Instant invoice>takes you straight to Instant invoice overview>creates a new record>fills in all mandatory fields with corresponding details from the customer order. She informed me that when she created the Instant Invoice it did not CONNECT to the Customer Order. From there I took a closer look to see why the connection was not made between the Instant Invoice and the Customer order she seemingly did not put the ‘Creator Reference’ which is the Customer Order number that is how I understand the connection is made between the Instant Invoice and the Customer Order. So with that being said there is no connection between the two. I’m very lightly assuming that is what is causing the issue with on the Customer Invoice Posting Analysis not letting it go past there. The Error message reads (Field ORDER_NUMBER] is mandatory for Customer Order Charge and requires a value. I went through Customer Order Charges and for this Customer and the Customer Order number, there is not a charge for this Instant Invoice listed on the overview. I do believe since the Instant invoice was created using the RMB in the Customer Order header even though there is no solid connection between the two it is still pulling like the two are connected some type of way.  Thank you again please see screenshot of the posting analysis and the instant invoice. 

 


@Agcd123 it’s the 1st time I hear that it’s possible to create Instant Invoices from Customer Order Header. This makes me think most probably you have a CRIM (customization) implemented to allow you somehow to create an Instant Invoice from CO Header.

In the standard functionality, normally you need to deliver the CO (or at least 1 line) and then the Customer Invoice (CUSTORDDEB and never INSTINV) can be created.

Can you see in the Customer Invoice Postings Analysis which Posting Control triggered this? M28? M30?


The posting type is ‘Manual’ there is no posting control associated with that posting type in our system. 


Reply