Invoice Status Download

This integration downloads all invoices in Approved and Payment Pending status.

Connector Overview

Component

Detail

Company Type

Buyer

MSP Partner

Version Type

1.0

Format

CSV

Prerequisites

Company Details Setting must be turned on for Integration – Invoice Status Download.

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

Predecessors

Invoice(s)

Credit Debit Memo(s)

Miscellaneous Invoice(s)

Related Connectors

Invoice Status Change Upload

Triggering Events

Invoice statuses will appear in the download if their status is in Approved or Payment Pending at run time.

File Formatting

Header

Component

Enabled by Default?

Definition/Use

Notes

Value

Type

Yes

Download file type

Procedure

procedure

ProcedureName

Yes

Determines procedure to be run

Procedure name

invoice_status_change_upload

Transaction

No

Transaction type

Transaction type. The valid type names are:

  • True: If any record errors, the entire Download fails.

  • False: Only records that are in error fail. Remaining records are committed successfully.

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

Comments

No

Download Comments

This is a comment field containing notes about the Download file.

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

Detail

Column Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

Invoice ID

Text

16

Yes

Examples:

  • XXXXIN00000001

  • XXXXMI00000001

  • XXXXPI00000001

  • XXXXPC00000001

  • XXXXCD00000001

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

Invoice Code

Text

100

Yes

Invoice code, as supplied by the suppler when the invoice was approved.

If no code was provided by the supplier, the Invoice Code will equal the Invoice ID.

Status

Text

100

Yes

Valid values are:

  • Approved

  • Payment Pending

Value for which to update the Invoice Status.

Comments

Text

2000

No

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

The Detail table lists the standard columns in this download. If your company enables custom fields for the invoice modules, those columns append to the end of each row after all standard columns. For the setup requirement, the modules covered, and the custom-field column-header format, see the Custom Fields section of this topic.

Unique Identifier

  • Invoice ID field

Custom Fields

  • To include custom fields in the download, customers need to change the Post Processing Method to invoiceStatusWithCF. This change ensures that the download file includes custom fields from the following SAP Fieldglass modules:

    • Invoice

    • Misc Invoice

    • Credit Debit Memo

    • Cost Center and Task Code

    • Expense Code

    • Timesheet

    • Expense Sheet

    • Buyer

    • Supplier

    • Work Order

    • Work Order Revision

  • Custom fields that are included will always appear at the end of the column layout after all of the native, either default or optional, Fieldglass fields have been output.

  • Column header format for custom fields will follow the following format:
    • [c]{module}_{custom field name}

    For example, if there is a custom field named Cube Number in the Worker Module, it would appear in the download as follows:
    • [c]worker_Cube Number

Assumptions/Tips

Due to audibility and data integrity requirements, invoices must adhere to certain requirements when having their statuses changed.

  • If an invoice is currently in a status of:

    • Approved, its status may be updated to Rejected, Payment Pending, Pending Consolidation, or Paid.

    • Payment Pending, its status may be updated to Approved or Paid.

  • This download won't change the status of any invoices in Pending SAP Quality Review status.

  • The system includes any inactive cost centers associated with the document.