Create a Receiving Sheet

Download Sources

There are two download sources:

Receiving Transactions - Use this download for Put Away. It returns transactions that have been received but not yet delivered. Filters: Organization, Procurement BU, Supplier Name, Supplier Number, Document Number (PO), Item, Receipt Number, Due Date/To Due Date.
Manage Receipts - This download returns all receipts. This should be used to action Return or Correction. We recommend filtering the download by Transaction Type - for example, Deliver for Return to Supplier transactions. Filters: Organization, Receipt Number, Document Number, Item, Supplier Name, Transaction Type, Transaction Date From/To.

Tip: Receipt Number or Document Number must be included as a parameter. To search on more than one value, or to return all records, use % as a wildcard e.g. Document Number = US%.

Download Details into the Sheet

Getting your data into your spreadsheets efficiently and accurately is important. The best way to fill your sheet with what you need is to download it right from your system’s. This makes sure you’re always working with the freshest and most accurate data, which cuts down on manual mistakes and keeps things running smoothly.

By downloading directly, you can easily pull out all the details for your receipts and purchase orders. This covers everything like who the supplier is, when you order, what you ordered, how much, unit prices, and when you expect it.

Field Reference

The table below lists the fields on the Receiving Transactions Integrator sheet, and whether each is Required, Optional, Conditional Required, or Not Applicable/Not Supported for each of the three transaction types you can perform with this Integrator: Put Away (Deliver), Return to Supplier, and Correct.

Note: the sheet also includes a number of read-only columns not listed below (for example PO Number, Item, Description, and Supplier). These are provided only to help you identify the correct transaction to action and do not need to be entered.

Table 1. Common fields
Field	Description	Put Away	Return to Supplier	Correct (In a future release)
Section: Lines		—	—	—
Upload Action	Controls what happens on each row upload (Create, Update, or Delete). Refer to the Upload Actions guide. Note: Update and Delete are limited to transactions in the interface table.	Required	Required	Required
Interface Transaction ID	Read-only. Internal reference linking this row to the receiving interface table.	N/A	N/A	N/A
Line Transaction Status Code	Read-only. Internal interface table transaction status.	N/A	N/A	N/A
Current Transaction Type/Code	Read-only. Shows the transaction type the downloaded row is currently eligible to be actioned from.	Receive	Deliver	Receive/Deliver
Action Transaction Type	Enter the action to be performed on this row.	Deliver	Return to supplier	Correct
Transaction Date	This field downloads with the original transaction’s date. Replace it with the new transaction date, or leave it blank to use the current date.	Required*	Required*	Required*
Quantity	Quantity being actioned. All are positive numbers. Put Away / Deliver, enter the quantity to deliver. Return to Supplier, enter the quantity being returned. Correct, enter the corrected total quantity for the transaction (not the delta).	Required	Required	Required
UOM	Unit of measure for the goods. Defaults from the purchase order.	Required*	Required*	Required*
Subinventory	Name of the destination subinventory for the transaction. Required when the Destination Type is Inventory.	Conditional Required	N/A	N/A
Locator	Name of the locator. Required if the destination subinventory is locator-controlled.	Conditional Required	N/A	N/A
Deliver To Location	Abbreviation identifying the deliver-to location. Defaults from the purchase order but can be updated to any valid location for the organization.	Required	N/A	N/A
Deliver to Person	Name of the deliver-to person or requester. If left blank, defaults to the requester on the purchase order distribution.	Optional	Optional	N/A
Transacted By (Name/Number)	Name or employee number of the person who performed the transaction. Will default to user logged in.	Required*	Required*	Required*
Reason	Name of the inventory transaction reason for the transaction.	N/A	Optional	N/A
Line Note	Free text entered by the user when actioning the transaction.	Optional	Optional	N/A
Return for Credit	Indicates whether the return should generate a request for credit from the supplier for the returned quantity.	N/A	Optional	N/A
Create Debit Memo	Indicates whether a debit memo should be automatically created in Payables for the value of the returned quantity. Typically used together with Return for Credit.	N/A	Optional	N/A
RMA	Supplier’s Return Material Authorization number for the returned goods, if one was provided.	N/A	Optional	N/A
Section: Lot Number	For items that are lot-controlled.	—	—	—
Lot	Lot number for the transaction.	Optional	Not Supported	Not Supported
Lot Transaction Quantity	Quantity for this lot. Should match the line quantity; if necessary, the line quantity can be split across multiple lots.	Optional	Not Supported	Not Supported
Expiration Date	Expiration date of the lot corresponding to the receipt line.	Optional	Not Supported	Not Supported
Section: Serial Number	For items that are serial controlled.	—	—	—
Serial Number	Serial number for a single unit receipt, or the starting number of a range.	Optional	Not Supported	Not Supported
To Serial Number	Ending serial number of the range, used when the number of serial numbers provided does not match the quantity being received.	Optional	Not Supported	Not Supported

‘*’ Required field - will default if not entered.

Process Steps

The typical receiving process follows these steps:

Create a sheet and either:
- Download data from the relevant Download Source, or
- Manually enter, or copy and paste, data from another source.
Enter the relevant details into the sheet - for example, quantity and location.
Validate the data and correct any errors.
Upload the validated transactions to the Oracle interface table.
Submit the 'Manage Receiving Transactions' process directly from the Integrator.
Refresh the Integrator to view the import results.
Correct any errors and repeat the process from the beginning, if needed.
Periodically purge processed records from the interface tables.

As this process is the same across Integrators, refer to the Expected Shipments Integrator for full details.