Upload Blanket Order Invoices Using a CSV

  • Updated

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 Unimarket_ORG Y

The Organization Code, the Blanket order sits within.

Tip: To locate the Organization Code designated to the blanket order, go to the order (in Unimarket) > click on organization unit hyperlink. 

You will be routed to the Organization Unit screen. The code (e.g. Unimarket_ORG) listed next to Hierarchy is the Organization Code. 
Bill To Code 123 Y
  • Listed on the order, on the Bill-to tab (e.g. [B10]). 
  • Insert the value, excluding the brackets.
  • 255 character limit.
Ship To Code 456 Y
  • Listed on the order, on the Ship-to tab (e.g. [UM103]). 
  • Insert the value, excluding the brackets.
  • 255 character limit.
Community Supplier ID UM0000598 Y Listed in the supplier's profile.
Supplier ID S4534 Y

Your supplier (vendor) ID for your ERP.

Note: If the supplier (vendor) ID is not applicable, insert the Community Supplier ID.
Blanket Order 5665756765 Y
  • Blanket order number.
  • 255 character limit.
Invoice Number INV45333 Y 255 character limit.
Invoice Date 1/10/23 Y  
Invoice Subtotal 100 Y  
Invoice Total 110 Y Enter the value listed on the Release Order (excluding dollar symbol).
Invoice Tax 10 Y Enter the value listed on the Release Order (excluding dollar symbol).
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
  • The value entered under the Line column, on the Release Order.
  • If there are multiple (splits) distributions, insert the value under the Line column on the Release Order.
Product Code   N
  • Can be blank.
  • 255 character limit.
Description Stainless Bolts Y 1024 character limit.
Quantity 1 Y  
UOM EA Y Enter UOM listed on Release Order.
Unit Price 100 Y Enter exact Unit Price, listed on Release Order (excluding dollar symbol).
Line Amount 100 Y Enter exact Subtotal, listed on Release Order (excluding dollar symbol).
Line Tax 10 Y

Enter exact Line Tax, listed on Release Order (excluding dollar symbol).

If no, Line Tax enter 0.
Distribution% 100 N Required if you have multiple distributions for one Invoice Line. If not applicable, leave blank.
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.