Cancel Customer ORder Invoice API Package

Hi ​@IFSRUNINNOVAL 

Projection methods are for the use of REST APIs and not to be used within server side coding or migration jobs (or sql event actions) since the projection is a kind of a wrapper for the server APIs. Instead of using the SVC package method, check for the implementation of the method you are trying to execute and use the server method.

Ex: CancelDebitInvoice method uses this server method for actual execution.

 Invoice_Customer_Order_API.Cancel_Prelim_Debit_Invoice(company_, identity_, invoice_id_, cancel_reason_);

Hope it helps!

Damith

Thank you ​@dsj i’ll try it.

​@dsj unfortunatly it didn’t work : 

We have chcecked, we do have value in company

hi ​@IFSRUNINNOVAL 
 

• Use the Correct API Method

  • Instead of CancelDebitInvoice, use Invoice_Customer_Order_API.Cancel_Prelim_Debit_Invoice.
  • Ensure all required parameters (company_, identity_, invoice_id_, cancel_reason_) are correctly set.

• Check User Permissions

  • Verify that the user has the necessary execution rights for Invoice_Customer_Order_API.
  • Ensure proper role configurations in IFS security settings.

• Validate Invoice Status

  • Confirm the invoice is in Preliminary Status before attempting cancellation.
  • Check for dependencies like linked payments or accounting rules.

• Execution Context & Data Integrity

  • Ensure that the migration job runs with the correct execution permissions.
  • Validate that the IFS background job processor can execute the cancellation.

• Enable Debugging & Logs

  • Use IFS SQL Trace and logging mechanisms to identify argument failures.
  • Run a manual test in PL/SQL before integrating into the migration job.