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.
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.