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.

Connector Overview

Component

Detail

Company Type

Buyer

MSP Partners

Version Type

API-A-V1.0

Format

CSV

Prerequisites

Company plug-ins must be turned on for Integration – Invoice Response Upload.

User role permission must be turned on for Upload Data and Download Data.

Predecessors

Invoices

Misc Invoices

Credit Debit Memos

SOW Invoices

Related Connectors

Invoice Buyer Download

Invoice Buyer Download without Status Change

Invoice Supplier Download

Paid Invoice Upload

Consolidated Invoice Upload

Invoice Status Change Upload

File Formatting

Header

Component

Required?

Definition/Use

Notes

Value

Type Yes Upload file type

If you have a custom connector name for a standard connector, you may use the exact same custom name for the Type header; otherwise, you must use the standard name shown in the Value field.

Invoice Response Upload

Send Notification?

No

Determines whether normal messaging workflow should be followed.

This flag is used to control sending notifications to users. If the value is set to True, an email will be sent. If the value is set to False, an email will not be sent.

The valid values are:

True

False

If this field is not included in the header the default value will be True.

Language No Determines the language to be used for values in the file, such as drop-down lists and radio buttons. Column headers will always default to the upload user's preferred language.

The valid language values are:

Arabic (Standard Arabic)
Chinese (Simplified)
Chinese (Traditional)
Dutch (Netherlands)
English (United Kingdom)
English (United States)
French (Canada)
French (France)
German (Germany)
Hebrew (Israel)
Hungarian (Hungary)
Italian (Italy)
Japanese (Japan)
Korean (Korea)
Mongolian (Mongolia)
Polish (Poland)
Portuguese (Brazil)
Portuguese (European)
Russian (Russia)
Spanish (Mexico)
Swedish (Sweden)

 
Date Format No Determines the date format to be used in the file.

The valid values are:

MM/DD/YYYY

DD/MM/YYYY

YYYY-MM-DD

If this field is not included in the header, the default value will be the format determined by the Locale value.

 
Number Format No Determines the Number Format to be used in the file.

The valid values are:

“#,##9.99 (Example: 1,234,567.99)”

“#.##9,99 (Example: 1.234.567,99)”

“#'##9.99 (Example: 1'234'567.99)”

“# ##9,99 (Example: 1 234 567,99)”

The quotes are required even if the value does not have a comma in it. If this field is not included in the header, the default value will be determined by the Locale value.

 

Manage Approved Invoice

No

Determines whether the status of Invoice, SOW Invoice, Miscellaneous Invoice, Credit Debit Memo, or SOW Credit Debit Memo can be changed to Rejected or Resubmit for Approval for Approved, Payment Pending or Paid invoices / CRDB memos / Miscellaneous Invoices.

Valid values are:

True

False

If this field is not included in the header, the default value will be False.

Separate Processing for Invoices

No

Determines whether SAP Fieldglass will wait for a response/upload for BOTH invoices (reversed and revised) before updating the status of the invoice in SAP Fieldglass.

Valid values are:

True

False

If left blank, the default value is False.

Comments No Upload Comments This is a comment field containing notes about the upload file.  

Immediately following the Header section of the upload is one blank line.

Detail

Field Header Name

Data Type

Length

Required?

Value(s)/Format

Description/Use/Field Rules

Invoice ID Text 16 Yes

Valid values are:

Valid SAP Fieldglass Invoice ID

Valid SAP Fieldglass Miscellaneous Invoice ID

Valid SAP Fieldglass SOW Invoice ID

Valid SAP Fieldglass Credit Debit Memo ID

Valid SAP Fieldglass SOW Credit Debit Memo ID

SAP Fieldglass Invoice ID / Misc Invoice ID / SOW Invoice ID / Credit Debit Memo ID / SOW Credit Debit Memo ID representing the Invoice for which the Status is to be updated.

Examples are:

xxxxIN00000010

xxxxMI00000011

xxxxPI00000012

xxxxCD00000013

xxxxPC00000014

xxxxCI00000092

Invoice Code

Text

100

No

SAP Fieldglass Invoice Code. May match the Invoice ID or be a value supplied by the supplier at the time of invoice creation.

Value is not required.

Status

Text

100

Yes

Valid values are:

Approved

Paid

Payment Pending

Pending Consolidation

Rejected

Resubmit for Approval

Submitted

Value for which to update the Invoice Status.

Module

Text

100

Conditional

Valid values are:

Consolidated Invoice

Credit/Debit Memo

Invoice

Miscellaneous Invoice

SOW Credit/Debit Memo

SOW Invoice

SAP Fieldglass Invoice Module affected by response.

Required if Status = ‘Rejected’ or ‘Approved’.

Approver’s Username

Text

100

Conditional

SAP Fieldglass user’s username

Indicates username who approved this change to invoice status.

Required if Status = ‘Rejected’ or ‘Approved’.

Comments

Text

2000 for Paid, Payment Pending, Pending Consolidation, or Resubmit for Approval

1000 for Approved or Rejected

No

Any comments to provide in the audit trail as to why status was altered.

If no comments are entered, the audit trail will still display a comment noting the time, date, user, and a text stating that the status was updated via the upload tool.

Please note that even if no comments are entered in the file, the ‘Comments’ column header is still required in the upload file.

[rvcom] Comments Text 1000 No   When creating a revised invoice using this upload and if the comments field needs a different value on the reversed invoice, a column needs to be added to the connector. The column name is ‘[rvcom] Comments’. When this is uploaded, the application identifies that the column’s value belongs to the reversed invoice record.

Reject Reason

Text

200

Conditional

Valid SAP Fieldglass reason code

Indicates reason for rejecting invoice.

Required if Status = ‘Rejected’.

Paid Amount

Decimal

Conditional

Example:

255.23

Indicates paid amount for invoice.

Required if Status = ‘Paid’.

Check Number

Text

10

No

Indicates check number for paid invoice.

Date Paid

Date

No

Indicates date invoice was paid.

[c] Custom Field 1

Dependent on custom field configuration

Yes, if the custom field is mandatory without a default value and is not a linked custom field.

Dependent on custom field configuration

Any custom field associated with the invoice. The custom field name should be prefixed with ‘[c]’. For example, custom field name: ‘Invoice Custom Field 1’ should be ‘[c] Invoice Custom Field 1’.

Valid values of the custom field are configured during the setup of the Fieldglass application.

When Custom Field Type = Segmented Pick List and the 'Autopopulate Segment' rule on the Pick List = Yes, if a segment value is left blank on the upload, the value is auto populated on the document if there is only one possible value based on the previous segment values. If there is more than one possible value, an error message displays.

If the SOW Invoice belongs to a statement of work that uses a Contract, the value will default from the statement of work when the upload value is blank.

Do not include this field if not in use.

[rvc] Custom Field 1

Dependent on custom field configuration

Dependent on custom field configuration

Dependent on custom field configuration

When creating a revised invoice using this upload and there are invoice custom fields that are either required or if the custom field needs a different value on the reversed invoice, a column needs to be added to the connector. The column name is the name of the custom field preceded by ‘[rvc]’. When this is uploaded, the application identifies that the column’s value belongs to the reversed invoice record.

If the SOW Invoice belongs to a statement of work that uses a Contract, the SOW Invoice's current value will default when the upload value is blank.

If the custom field is being picked up by the revision, the value will default from the statement of work.

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:

Possible Errors and Resolutions

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.