Invoice Response Upload
This integration updates the status on multiple invoices to Approved, Paid, Rejected, Payment Pending, or Pending Consolidation status along with any accompanying custom fields and comments. This upload is often used by program offices to either move invoices along in a stalled process or set them back to previous statuses to correct errors or update fields in customer financial system. This upload can also be used to integrate invoices directly with the invoicing system and return the invoice status with additional information to the SAP Fieldglass application.
File Formatting
Assumptions/Tips
Due to auditability and data integrity requirements, invoices must adhere to certain requirements when having their statuses changed. The following scenarios outline the statuses available for an invoice update dependent on the invoice’s current status.
-
This upload won't change the status of any invoices in Pending SAP Quality Review status.
-
If an invoice is currently in a status of:
-
Rejected - Its status may be updated to Paid.
-
Approved - Its status may be updated to Rejected, Payment Pending, Pending Consolidation, or Paid.
-
Pending Consolidation - Its status may be updated to Rejected or Approved.
-
Payment Pending - Its status may be updated to Approved or Paid.
-
Paid - Its status may be updated to Rejected or Approved.
-
Approval Paused - Its status may be updated to Rejected.
-
Pending Approval - Its status may be updated to Approved or Rejected.
-
-
If a Consolidated Transaction Invoice (CTI) is currently in the status of:
-
Pending Approval - Its status may be updated to Approved or Rejected.
-
Payment Pending - Its status may be updated to Approved or Paid.
-
Paid - Its status may be updated to Rejected or Approved.
-
Approval Paused - Its status may be updated to Rejected.
-
Approved - Its status may be updated to Rejected, Payment Pending, or Paid.
-
Rejected - Its status may be updated to Paid.
-
-
If an invoice or consolidated transaction invoice is in any status other than those listed above, it may not be updated via the Invoice Response Upload.
-
As with approval updates, payment status updates are kept on hold until the pairing invoice status is received (then it will be shown on the UI / Downloads). It applies to the following:
Current Status
Updated Status
Rejected
Paid
Approved
Payment Pending
Approved
Paid
Payment Pending
Approved
Payment Pending
Paid
Paid
Approved
Paid
Rejected
-
When a revised invoice is marked as paid with this upload, the reversed invoice will also automatically be marked as paid. When a reversed invoice is marked as paid with this upload, the revised invoice will also automatically be marked as paid.
-
The status of an invoice associated to a revision of an SOW Line Item will be able to be updated to Approved, Paid, Rejected, Payment Pending, or Pending Consolidation status along with any accompanying comments via this connector.
-
The header component 'Separate Processing for Invoices' must be set to 'True' in order to enable reverse and revised status update.
-
This applies to Invoice, SOW Invoice, and Consolidated Transaction Invoice modules that have entered the existing invoice revision workflow.
-
SAP Fieldglass waits for a response/upload for BOTH invoices (reversed and revised) before updating the status of the invoice in SAP Fieldglass.
-
Comments are updated to show custom field change for all intermediate status changes, like after upload for reverse invoice as well as revised invoice.
-
-
The following table defines status scenarios and expected results for the reversed and revised invoice responses:
-
Reversed Invoice
Revised Invoice
Expected Outcome
Approved
Approved
Reversed and Revised invoices move to 'Approved' Status.
Approved
Rejected
Reversed and Revised invoices move to 'Rejected' Status.
Rejected
Approved
Reversed and Revised invoices move to 'Rejected' Status.
Rejected
Rejected
Reversed and Revised invoices move to 'Rejected' Status.
-
If the reversed and revised invoice pair moves to 'Rejected' status as per the expected behavior table above, the invoices are updated as per the existing 'Edit Rejected' workflow and both are resent via integrations when resubmitted.
-
If the Separate Processing for Invoices header field is set to False, [rvc] custom fields are used. However, if the Separate Processing for Invoices header field is set to True, [rvc] custom fields are ignored and only [c] fields are used for revised and reversed invoices.
Errors
The following errors can occur when processing this upload file:
|
Error Message |
Resolution |
|---|---|
|
Approver's Username char length exceeding 1000 |
The value in the Approver's Username column exceeds 1,000 characters. Shorten the value in the Approver's Username column to 1,000 characters or fewer. Applies when Status is Approved or Rejected. |
|
Check Number cannot exceed 10 characters. |
The value in the Check Number column exceeds 10 characters. Shorten the value in the Check Number column to 10 characters or fewer. Applies when Status is Paid. |
|
Comments char length exceeding 1000 |
The value in the Comments column exceeds 1,000 characters. Shorten the value in the Comments column to 1,000 characters or fewer. Applies when Status is Approved or Rejected. |
|
Comments char length exceeding 2000 |
The value in the Comments column exceeds the maximum allowed length of 2000 characters. Shorten the value in the Comments column. Applies when Status is neither Approved nor Rejected. |
|
Invoice is in invalid status to mark as paid. |
The invoice is not in an eligible status for the Paid transition. The invoice must be in Approved, Payment Pending, Rejected, or Submitted status to be marked as Paid. Verify the current status of the invoice and update the Status column accordingly. |
|
Invoice status cannot be updated because of mismatched line items. Verify if all line items of Invoice exists in the System. |
The invoice has line items that do not match what is recorded in the system. Verify that all line items for this invoice exist in SAP Fieldglass before retrying the upload. Applies to Invoice and SOW Invoice module types. |
|
Invalid values for Approver's Username |
The value in the Approver's Username column does not match an active user in the system. Verify that the username exists and is active, then enter a valid value in the Approver's Username column. |
|
Invalid values for Invoice Code |
No invoice was found matching the value in the Invoice Code column. Verify the value in the Invoice Code column matches an existing invoice code in the system. |
|
Invalid values for Invoice ID |
No invoice was found matching the value in the Invoice ID column. Verify the value in the Invoice ID column matches an existing invoice reference in the system. |
|
Invalid values for Manage Approved Invoice |
The file header flag Manage Approved Invoice is set to False, but the Status column contains a value (Rejected or Resubmit for Approval) that requires this flag to be True. Set the Manage Approved Invoice file header to True to allow status changes on Approved, Payment Pending, or Paid invoices. |
|
Invalid values for Module |
The value in the Module column does not match a recognized invoice module. Enter one of the accepted module values (for example: Invoice, SOW Invoice, Credit/Debit Memo) in the Module column. Applies when Status is Approved, Rejected, or Resubmit for Approval. |
|
Invalid values for Paid Amount |
The value in the Paid Amount column is not a valid number. Enter a valid numeric value in the Paid Amount column. Applies when Status is Paid. |
|
Invalid values for Date Paid |
The value in the Date Paid column is not a valid date or does not match the configured date format. Enter a valid date in the Date Paid column using the date format specified in the file header. Applies when Status is Paid. |
|
Invalid values for Reject Reason |
The value in the Reject Reason column does not match a valid rejection reason for this invoice module. Verify the value in the Reject Reason column matches an active rejection reason configured for the invoice module. Applies when Status is Rejected. |
|
Invalid values for Status |
The value in the Status column is not valid for the current state of the invoice. The invoice is in a status that does not allow the requested transition. Verify the current status of the invoice and enter a supported status value (Approved, Rejected, Paid, Payment Pending, Pending Consolidation, or Resubmit for Approval) in the Status column. |
|
Invoice Transaction Failed - Error Code: 403 |
The invoice cannot be updated because the buyer or supplier company has been blocked. Contact your System Administrator to resolve the blocked-access restriction before retrying the upload. |
|
Invoice Transaction Failed - Error Code: 451 |
The invoice cannot be updated because the buyer/supplier company pair is under sanctions review. Contact your System Administrator to resolve the sanction restriction before retrying the upload. |
|
Missing data for Approver's Username |
The Approver's Username column is required when Status is Approved or Rejected. Enter a valid username in the Approver's Username column. |
|
Missing data for Invoice ID |
Both Invoice ID and Invoice Code are blank. Enter a value in the Invoice ID column or the Invoice Code column to identify the invoice. |
|
Missing data for Module |
The Module column is required when Status is Approved, Rejected, or Resubmit for Approval. Enter a valid module name in the Module column. |
|
Missing data for Reject Reason |
The Reject Reason column is required when Status is Rejected. Enter a valid rejection reason in the Reject Reason column. |
|
The Approver: {0} has been closed. |
The user specified in the Approver's Username column has been deactivated. Enter the username of an active user in the Approver's Username column. |
|
This record has been archived. Contact your System Administrator if you believe you should have access to the record. |
The invoice identified in the Invoice ID column has been archived and cannot have its status updated. Remove the row from the upload file, or contact your System Administrator if you believe the record should be accessible. |
|
{0} must be in Approved or Rejected status to move to Payment Pending or Pending Consolidation status. |
The invoice is not in an eligible status for the Payment Pending or Pending Consolidation transition. The invoice must be in Approved or Rejected status before it can be moved to Payment Pending or Pending Consolidation. Verify the current status of the invoice and update the Status column accordingly. |