Invoices for blanket orders can be uploaded in a CSV file format. Using the sFTP File Automation process, which streamlines the entry of invoice lines. Once loaded against a blanket order, these invoices are placed in the Pending Acceptance state and must be reviewed by the blanket order owner(s) before matching and payment.
Requirements and Supported Scenarios
Submission Method: Invoices can be submitted via the sFTP File Automation process or directly via the Invoices screen (by a user with the Create Invoices role).
Batching: The CSV template supports uploading multiple invoices at once.
Order Type: All invoices in the file must relate to a blanket order.
Supported Scenarios within a Single CSV File:
Multiple blanket orders for the same supplier and/or different suppliers.
Multiple invoices for a single blanket order.
Both invoices and credit invoices are supported, but they must be unique (see below).
Not Permitted:
A single invoice (e.g., INV123) that references more than one blanket order.
A single invoice reference containing both a positive and negative amount (i.e., mixed lines against a single invoice).
Credit/Debit Note Handling: If an invoice (e.g., Inv-123) has a credit line and a positive amount line, it must be separated into two different uploads.
CSV Template Details
All columns in the template are required, though some values can be left blank (indicated by "N" in the Required column).
| Field | Example | Required | Notes |
|---|---|---|---|
| Organization | 1020 | Y | Organization Code - must be the organization the Blanket order sits within. |
| Bill To Code | 123 | Y | . |
| Ship To Code | 456 | Y | . |
| Community Supplier ID | UM0000598 | Y | Unimarket's unique ID for the supplier. Note: Either this OR Supplier ID is required. |
| Supplier ID | S4534 | Y | Your supplier (vendor) ID for your ERP. Note: Either this OR Community Supplier ID is required. |
| Blanket Order | 5665756765 | Y | Blanket order number. |
| Invoice Number | INV45333 | Y | . |
| Invoice Date | 13/10/23 | Y | . |
| Invoice Subtotal | 100 | Y | . |
| Invoice Total | 110 | Y | . |
| Invoice Tax | 10 | Y | . |
| Invoice Shipping | 0 | Y | Can be set to 0. |
| Shipping Tax | 0 | Y | Can be set to 0. |
| Invoice Discount | 0 | Y | Can be set to 0. |
| Invoice Line | 1 | Y | Repeat the line number if there are multiple distributions (splits). |
| Product Code | N | Can be blank. | |
| Description | Stainless Bolts | Y | . |
| Quantity | 1 | Y | . |
| UOM | EA | Y | Accepts any valid UOM. |
| Unit Price | 100 | Y | . |
| Line Amount | 100 | Y | . |
| Line Tax | 10 | Y | . |
| Distribution% | 100 | N | Required if you have multiple distributions for one Invoice Line. |
| AcctFormat | GLN | N | Account code format CODE. Must match a format in your community. Note: If left blank, default accounting from the blanket order will be used.. |
| AcctPart1 - AcctPart4 | 1, 1, 100, 18312 | N | Account code parts. Must match values loaded in your community. |