Paid Invoice Buyer Download

This integration downloads invoices, credit debit memos, and miscellaneous invoices in Paid status. This download differs from the Invoice Buyer without Status Change Download in that only invoices with a Paid status are downloaded.

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 – Paid Invoice Buyer Download.

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

Predecessors

Invoices

Credit/Debit Memos

Miscellaneous Invoices

Related Connectors

Invoice Buyer Download

Invoice Supplier Download

Triggering Events

The status should be Paid. The invoice revision time (when invoice is marked as Paid) should be between the last run date and the run date.

File Formatting

Header

The Paid Invoice Buyer Download connector does not contain any Header data.

Detail

Column Header Name

Data Type

Length

Enabled by Default?

Value(s)/Format

Description/Use/Field Rules

Company Code

Text

6

Yes

Valid SAP Fieldglass supplier code associated to buyer.

Supplier Code for buyer.

Company Name

Text

100

Yes

Supplier Name.

Consolidated Invoice ID

Text

16

No

Example:

  • XXXXCI00000001

SAP Fieldglass Consolidated Invoice ID associated to the invoice.

If the invoice has not been Consolidated, the field will be blank.

SAP Fieldglass Invoice ID

Text

16

Yes

Example:

  • XXXXIN00000001

  • XXXXCD00000001

  • XXXXMI00000001

Invoice ID, Credit/Debit Memo ID or Miscellaneous Invoice ID

Underlying Invoice ID

Text

16

Yes

Invoice ID that has been corrected if the Invoice is a Credit Debit Memo.

If not a Credit Debit Memo, then the Invoice ID and Underlying Invoice ID will have the same value.

Supplier Invoice Code

Text

100

Yes

Invoice Code, as supplied by the suppler when the invoice was submitted.

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

Invoice Type

Text

2

Yes

Valid values are:

  • IN

  • CD

  • PC

  • PI

  • MI

The type of SAP Fieldglass Invoice:

IN = Time Sheet / Expense Sheet Invoice

CD = Credit Debit Memo

PC = SOW Credit Debit Memo

PI = SOW Invoice

MI = Misc Invoice

Invoice Line Item

Text

2

Yes

Valid values are:

  • TS

  • ES

  • PE

  • PS

  • MI

  • TU

The type of source document the invoice was generated from:

TS = Time Sheet

ES = Expense Sheet

PE = SOW Event

PS = SOW Schedule

MI = Misc Invoice

TU = Payment Term Fee

Invoice Submit Date

Date

Yes

Examples:

  • MM/DD/YYYY

  • DD/MM/YYYY

  • YYYY-MM-DD

The date the invoice was submitted by the supplier.

If Auto Invoicing is enabled, then it is the date of the documents final approval.

Site Code

Text

100

Yes

Valid SAP Fieldglass Site Code

Site Code related to the source document being invoiced.

Remit to Address

Text

100

No

Supplier’s Remit to Address.

PO Number

Text

100

No

Optional purchase order number from the work order related to the invoice.

Gross Invoice Amount

Decimal

Yes

Example:

2400.00

Total invoice amount exclusive of any adjustments.

This value will repeat for each line of the invoice that appears in this download.

Net Invoice Amount

Decimal

Yes

Example:

2145.78

Total invoice amount inclusive of all line items and adjustments.

This value will repeat for each line of the invoice that appears in this download.

Invoice Adjustment Amount

Decimal

Yes

Example:

10.00

Adjustments to the base invoice amount. A common invoice adjustment is tax.

Currency

Text

100

Yes

Example values:

  • USD

  • CAD

  • GBP

  • EUR

Currency in which the Invoice Gross Amount is to be paid.

Worker First Name

Text

200

No

Example:

John

Worker’s First Name.

Blank on SOW Invoices.

Worker Last Name

Text

200

No

Example:

Smith

Worker’s Last Name.

Blank on SOW Invoices.

Person ID

Text

24

No

Worker’s Person ID.

Blank on SOW Invoices.

Job Seeker ID

Text

16

No

Example:

XXXXJS00000001

Worker’s Job Seeker ID

Blank on SOW Invoices

Worker ID

Text

16

No

Example:

XXXXWK00000001

Worker’s Worker ID.

Blank on SOW Invoices.

Week Ending Date

Date

Yes

Examples:

  • MM/DD/YYYY

  • DD/MM/YYYY

  • YYYY-MM-DD

Week Ending Date of the time sheet for time sheet invoices.

For Expense Sheets, MI, Credit/Debit Memo, and SOW Fee/Event, the date Submitted is shown.

For SOW Schedule, the schedule date is shown.

Business Unit Code

Text

100

Yes

Valid SAP Fieldglass Business Unit Code

Business Unit Code related to the invoice.

Business Unit Name

Text

100

Yes

Valid SAP Fieldglass Business Unit Name

Name associated to the Business Unit Code above.

Cost Center Code

Text

200

Yes

Valid SAP Fieldglass Cost Center Code

Cost Center Code related to the Invoice

Cost Center Name

Text

200

Yes

Valid SAP Fieldglass Cost Center Name

Name associated to the Cost Center Code above.

Task Code

Text

100

No

Valid SAP Fieldglass Task Code

Task/Expense Code associated to the Invoice

Task Name

Text

100

No

Valid SAP Fieldglass Task Name

Name associated to Task/Expense Code above.

General Ledger Account Code

Text

100

No

Valid SAP Fieldglass General Ledger Account Code

General Ledger Account Code associated to the Task Code above.

Amount

Decimal

Yes

Example:

21.56

Invoice Line Item Amount.

Hours

Decimal

No

Example:

8.5

Invoice Line Item Hours if applicable.

Rate

Decimal

No

Example:

22.57

Invoice Line Item Rate if applicable.

Rate Code

Text

100

No

Invoice Line Item Rate Category if applicable.

Unit of Measure

Text

12

No

Valid values are:

  • Hr

  • Day

  • Month

Invoice Line Item Unit of Measure if applicable.

Additional Invoice Adjustment Currency

Text

3

No

Valid Fieldglass buyer currencies.

Indicates if buyer is able to add additional invoice adjustment currencies.

The flag Allow Additional Invoice Adjustment Currency must be enabled on the related Job Posting Template/SOW Template/SOW Type Template. Otherwise it will default to ‘No’.

Additional Invoice Adjustment Currency Conversion Factor

Decimal

No

Indicates the valid rate at the time of Submit by the Supplier for Invoice/Misc Invoice/SOW Invoice/Credit Debit Memo/Revised TimeSheet/Consolidated Transaction Invoice (both Real-time conversion and Buyer defined conversion will be supported), and will be stored in the database.

The flag Allow Additional Invoice Adjustment Currency'must be enabled on the related Job Posting Template/SOW Template/SOW Type Template. Otherwise it will default to ‘No’.

Additional Currency Supplier Invoice Adjustment Amount

Decimal

No

Indicates value for the related Supplier Amount of Adjustments in Additional Currency in this download (if this column was optionally added to the download).

The flag Allow Additional Invoice Adjustment Currency must be enabled on the related Job Posting Template/SOW Template/SOW Type Template. Otherwise it will default to ‘No’.

Additional Currency MSP Invoice Adjustment Amount

Decimal

No

Indicates value for the related MSP Amount of Adjustments in Additional Currency in this download (if this column was optionally added to the download).

The flag Allow Additional Invoice Adjustment Currency must be enabled on the related Job Posting Template/SOW Template/SOW Type Template. Otherwise it will default to ‘No’.

Additional Currency Invoice Adjustment Amount

Decimal

No

Indicates value for the related Amount of Adjustments in Additional Currency in this download (if this column was optionally added to the download).

The flag Allow Additional Invoice Adjustment Currency must be enabled on the related Job Posting Template/SOW Template/SOW Type Template. Otherwise it will default to ‘No’.

Additional Currency Net Invoice Amount

Decimal

Conditional

Example:

2400.00

Total invoice amount inclusive of all line items and adjustments.

The flag Allow Additional Invoice Currency must be enabled on the related Job Posting Templat e /SOW Template and an Additional Invoice Currency value must be selected on the latest confirmed Work Order/Work Order Revision/SOW/SOW Revision.

The field is optional and must be configured for the download.

Additional Currency Gross Invoice Amount

Decimal

Conditional

Example:

2400.00

Total invoice amount exclusive of any adjustments.

The flag Allow Additional Invoice Currency must be enabled on the related Job Posting Template /SOW Template and an Additional Invoice Currency value must be selected on the latest confirmed Work Order/Work Order Revision/SOW/SOW Revision.

The field is optional and must be configured for the download.

Additional Currency Amount

Decimal

Conditional

Example:

2400.00

Invoice Line Item Amount.

The flag Allow Additional Invoice Currency must be enabled on the related Job Posting Template /SOW Template and an Additional Invoice Currency value must be selected on the latest confirmed Work Order/Work Order Revision/SOW/SOW Revision.

The field is optional and must be configured for the download.

Adjustment Name

Text

100

Conditional. Site configuration Expense Code Adjustment must be enabled for the global site for the buyer.

Expense code adjustment name.

Adjustment %

Decimal

Conditional. Site configuration Expense Code Adjustment must be enabled for the global site for the buyer.

Expense code adjustment percentage.

Expense Amount

Decimal

Conditional. Site configuration Expense Code Adjustment must be enabled for the global site for the buyer.

Also, Calculation Entry Method 'Net Expense Amount' must be selected.

Expense Code Adjustment value without taxes applied.

Expense Total

Decimal

Conditional. Site configuration Expense Code Adjustment must be enabled for the global site for the buyer.

Also, Calculation Entry Method 'Gross Expense Total' must be selected.

Expense code adjustment value with taxes applied.

[c] custom_field name

Dependent on Custom Field

Dependent on Custom Field

Dependent on Custom Field

Any custom fields from available modules which were requested to be added to the download.  Modules include:

Worker
Cost Center
Job Posting
Supplier
Time Sheet
Task Code
Expense Code
Invoice
Business Unit
Buyer
Work Order
Work Order Revision
SOW Worker
Site
Miscellaneous Invoice
Credit/Debit Memo
Expense Sheet
Statement of Work
SOW Credit/Debit Memo
SOW Invoice
Event
SOW Revision
Schedule
Fee
Fee Response

Contract ID

Text

Alphanumeric, 16 characters

Six-letter company code, then CT, and numerical string. Example:

  • CRPACT00000921

When the SOW Invoice is for an SOW that uses a Contract, the Contract ID will output.

External Contract ID

Text

Alphanumeric, 24 characters

When the SOW Invoice is for an SOW that uses a Contract, the External Contract ID will output.

Unique Identifier

  • Invoice ID field

Custom Fields

  • The download file will include custom fields from various modules in SAP Fieldglass. The specific modules are explained in the file format above.

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

  • Custom Field headers will be displayed in the format '[c] Field Name'.

Configuration Considerations

When you add columns for adjustments and their values to invoice downloads, the download will show the buyer adjustment amount. To see the supplier or MSP adjustment amounts, add the optional columns "Supplier Adjustment" or "MSP Adjustment" after the "All Adjustments" column. You will see one column per adjustment with the buyer amount. Following this, there will be another column with the supplier or MSP amount, or both if added, for the same adjustment before moving to the next adjustment columns.

Assumptions/Tips

  • Non-billable items are not included in the download.

  • If All Used Adjustments is set, the download will pull one column per adjustment that is used by at least one invoices on the download. If All Fixed Adjustments is set, it pulls all active adjustments that the buyer has in use, regardless of if they are included on the invoices of that download or not. These fields are mutually exclusive.

  • This download will also pull SOW Line Item revision invoices.

  • This download will also pull Holdback revision invoices.

  • If buyer company has multiple MSPs, when MSP supplier user downloads records, they will see only records for their MSP.

  • This download will also pull the expense sheet revised invoice and its associated reversed invoice.

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