Inventory Transactions (Receipts) Import

Last updated
Save as PDF

Overview

The inventory transactions (receipts)import process read files from the ./Incoming/Receipts/ SFTP folder. These files will be moved to the archive folder located at ./Incoming/Archive/Receipts/ before being processed in alphanumeric order.

Unique Keys/Validations

One of the following five sets of columns are required:

ID
Order Line ID and Order Line PO Number
Order Line Number and Order Line PO ID
Order Line ID
Order Line PO Number and Order Line Number

Inventory transaction columns

Column Name	Description	Req'd	Unique	Type	Allowable Values
ID	Coupa Unique Inventory Transaction ID	TRUE*	TRUE	int(11)	any
Barcode	Barcode	FALSE	FALSE	string(255)	any
Currency	Transaction Currency Code	FALSE	FALSE	string(100)	any
Price	Transaction Price	FALSE	FALSE	decimal(30,6)	any
Quantity	Quantity Received in UOM	FALSE	FALSE	decimal(30,6)	any
RFID Tag	RFID Tag	FALSE	TRUE	string(255)	any
Type	Transaction Type	TRUE	FALSE	string(255)	Valid Transaction Type List
Order Line Id	Order Line Coupa Id Number	TRUE*	FALSE	int(11)	any
Order Line Number	Order Line Number	TRUE*	FALSE	string(255)	any
Order Line PO Id	Order Line PO Coupa Id Number	TRUE*	FALSE	int(11)	any
ASN Line Id	ASN Line Coupa Id	FALSE	FALSE	int(11)	any
ASN Line Number	ASN Line Coupa Number	FALSE	FALSE	string(255)	any
ASN Header Id	ASN Header Coupa Id	FALSE	FALSE	int(11)	any
ASN Header Number	ASN Header Coupa Number	FALSE	FALSE	string(40)	any
UOM Code	Unit of Measure Code	FALSE	FALSE	string(6)	any
Status	The status of the transaction. Default is created.	FALSE	FALSE	string(255)	any
Match Reference	Three-way match attribute to connect with Receipt and Invoice Header	FALSE	FALSE	string(255)	any
External Id	This is a custom field that Coupa creates to accommodate the ERP Id. See note below.	FALSE	FALSE	string(255)	any
Transaction Reference	ID of original transaction	FALSE	FALSE	integer	any
Reason Insight	Reason Insight Code	FALSE	FALSE		any

*One of the following five sets of columns are required:

ID
Order Line ID
Order Line ID and Order Line PO Number
Order Line Number and Order Line PO ID
Order Line Number and Order Line PO Number
Order Line PO Number and Order Line Number

If a Receipt is to be voided using integration, External ID field should be populated with Coupa or ERP PO Number during creation of receipt via integration and should be part during voiding of receipt.

Valid Transaction Type List

InventoryReceipt, ReceivingConsumption, ReceivingAmountConsumption, ReceivingQuantityConsumption ReceivingReturnToSupplier, ReceivingAmountReturnToSupplier, ReceivingQuantityReturnToSupplier, ReceivingDisposal, ReceivingAmountDisposal, ReceivingQuantityDisposal