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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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
|
|
|
Contract ID |
Text |
Alphanumeric, 16 characters |
Six-letter company code, then CT, and numerical string. Example:
|
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.