And you are sure your sales order is in the open interface for the operating unit you are running right? What does the auto-invoice report say?
Thanks for the reply.
Yes the Org_id I checked in oe_order_headers_all as well as ra_interface_lines_all.Its same
Yes,but I mean also when running autoinvoice :-). I don't have order management invoices I think, but if you submit autoinvoice can you select the sales order or the transaction number in the LOV? If not, the system does not think it's there right?
What I'm trying to figure out is whether you have a mismatch when running auto-invoice and its looking at other invoice source, organization or type and thus not picking it up (it's a mistake I have made pretty often).
Is it related to the order_type_id in oe_order_headers_all which is for 1111 and in ra_interface_lines_all the transaction_type_id is 2222.?
I am unable to debug why the interface_line_id should populate as NULL .It should throw specified Autoinvoice error in the ra_interface_errors_all ..
Yes, but it only throws errors if it tried to pick it up and failed to process.
Can you copy the output of the autoinvoice program in here? Does the master program submit the detail program or does it stop after the master program?
If you open the LOV on (Low) Sales Order Number, what does it show? Can you add a screenprint?