Please see if (Note: 413627.1 - AR_INVOICE_API_PUB.CREATE_INVOICE Creates Incomplete Invoices) is applicable.
The note tells that it was issue with a parameter passed. Resolved in later releases by aplication of patch.
But it will not serve our purpose of creation of incomplete on Account CM.
Let me know if you have any reference for it.
We did have the same kind of problem with creating transactions in incomplete state using the open interface. The only solution that we found was to create a custom trigger on RA_CUSTOMER_TRX_ALL to incomplete invoices (:new.COMPLETE_FLAG := 'N').
Hope this help,
I had a similar requirement once...but with invoice creation through Autoinvoice interface tables.
What we ended up doing was to create a wrapper program around AutoInvoice program that will set all successfully imported invoices to incomplete status and kick off a workflow approval process.
Once the invoice got approved through workflow approval, the approved invoice would then be set to complete status.
'Complete' button on the transaction workbench had to be greyed out..to prevent users from completing/incompleting invoices.
You may try this approach..
Edited by: James Kim on Mar 17, 2010 2:28 PM
We have exactly similar requirement, where invoices would be created through AutoInvoice and then sent for approval.
We need to make the Invoices Incomplete before sending for approval and sent them complete once we get the approval.
Can you please elaborate what you did to Complete and Incomplete the Invoices? Is it direct table update of RA_CUSTOMER_TRX_ALL? I didn't find any API to achieve the same.
Appreciate your response.
Has any successfully done this? That is, imported data via autoinvoice and then have the transaction incompleted either via sql updates or an API?
We had a similar problem.
As the solutions were used AR functions:
arp_process_header_updte_cover.update_header_cover (p_form_name => 'ARXTWMAI',
p_form_version => 1,
p_customer_trx_id => l_trx.customer_trx_id,
p_complete_flag => 'N',
The data was taken from RA_CUSTOMER_TRX_PARTIAL_V.