Manage Invoice Update Upload

This integration allows further invoicing on closed workers and SOWs. This tool is often used by program offices to allow late invoices to be processed after the worker or SOW is closed.

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 – Manage Invoice Update Upload.

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

Predecessors

Invoices

Misc Invoices

Credit Debit Memos

SOW Invoices

SOW Credit Debit Memos

Related Connectors

Standard Supplier Invoice Download

Standard Paid Invoice Upload

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

Manage Invoice Update Upload

Send Notification?

No

Determines if notifications related to the closing of workers will be sent to users.

Valid values are:

  • True: Notifications will be sent to users per the SAP Fieldglass Messaging Configuration within the application. Any notification configured to be sent during the normal closing of workers and/or approval process will be sent.

  • False: Notifications will not be sent.

If this field is not included in header, the value will default to 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)

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

Object ID

Text

16

Yes

Valid values are:

  • Valid SAP Fieldglass worker ID

  • Valid SAP Fieldglass SOW ID

SAP Fieldglass Worker ID/SOW ID representing the object that will allow further invoicing.

Examples are:

  • xxxxWK00000010

  • xxxxTQ00000011

Allow Further Invoicing

Text

3

Yes

Valid values are:

  • Yes

  • No

Indicates if further invoicing can be allowed for Closed worker/SOW.

See the Configuration Considerations section for more information.

Comments

Text

2000

No

Any comments to provide in the audit trail as to why further invoicing allowed.

Configuration Considerations

#

Item

Notes

1

Allow Further Invoicing flag

When the Unused spend is allocated back to the project company configuration is enabled and the Allow further Invoicing flag set to No, the funds are allocated back to the Project. Once the funds are allocated back to the Project, the SOW cannot be reopened. No further invoicing can be done for the associated SOWs.

Assumptions/Tips

  • If one record in upload file errors out, rest of records will continue processing.

  • Both closed workers and closed SOWs can be entered in same upload.