Tweet
HI
I am trying to trigger the "create consolidated invoice" action from a recurring process. Only problem is my recurring process kicks off but the action is not completing i.e. my invoices are not consolidated. I have also checked the processing logs and cannot see any errors. Is there any known problem in OTM automation invoice consolidation this way?
This is the saved query I am using to retrieve my invoices.
SELECT b.invoice_gid, b.insert_date FROM invoice b JOIN invoice_involved_party ip ON b.invoice_gid = ip.invoice_gid JOIN contact c ON c.contact_gid = involved_party_contact_gid WHERE b.consolidation_type ='STANDARD'AND invoice_type ='I'ANDNOTEXISTS(SELECT1FROM invoice_refnum WHERE b.invoice_gid = invoice_gid AND invoice_refnum_qual_gid ='TOLL.CONSOLIDATED_INVOICE_NUMBER')AND b.servprov_alias_value ='CML.TOLL_REGIONAL_NSW'and b.domain_name ='CML'
I am trying to trigger the "create consolidated invoice" action from a recurring process. Only problem is my recurring process kicks off but the action is not completing i.e. my invoices are not consolidated. I have also checked the processing logs and cannot see any errors. Is there any known problem in OTM automation invoice consolidation this way?
This is the saved query I am using to retrieve my invoices.
SELECT b.invoice_gid, b.insert_date FROM invoice b JOIN invoice_involved_party ip ON b.invoice_gid = ip.invoice_gid JOIN contact c ON c.contact_gid = involved_party_contact_gid WHERE b.consolidation_type ='STANDARD'AND invoice_type ='I'ANDNOTEXISTS(SELECT1FROM invoice_refnum WHERE b.invoice_gid = invoice_gid AND invoice_refnum_qual_gid ='TOLL.CONSOLIDATED_INVOICE_NUMBER')AND b.servprov_alias_value ='CML.TOLL_REGIONAL_NSW'and b.domain_name ='CML'