Enter the Receipt Details into the Sheet

Key fields to create a receipt.

Table 1. Common fields for Direct Delivery and Standard Receipt
Field Description Optional/Required

Section: Header

Header Upload Action

Controls what happens on each upload (Create or Update). Refer Upload Actions guide

Required

Procurement BU

Name of the business unit. For a purchase order receipt, this attribute references the procurement business unit of the supplier site

Required

Receipt Date

Date when the receipt header request is interfaced. The default value is the current date. This value cannot be a future date.

Required

Received By

Name of the employee who is creating the receipt. Will default to logged in user

Required

GL Date

Date in the general ledger. Will default to Receipt Date

Required

Supplier Name or Number

Name of the supplier or the Number that identifies the supplier.

Required

Packing slip

Number that identifies the packing slip for a container on the shipment or a receipt.

Optional

Waybill

Number that identifies the waybill or air bill for the shipment or receipt.

Optional

Bill of Lading

Number that identifies the bill of lading for this shipment or receipt.

Optional

Shipping Method

Abbreviation that identifies the method for the shipment. Defaults from PO.

Optional

Notes

Text that the used entered when receiving the item.

Optional

Section: Lines

Transaction Upload Action

Controls what happens on each upload (Create or Update). Refer Upload Action Columns

You should only include an action on the lines required. Eg if you download a PO with 10 lines but you are only receiving the goods on line 5, add an action to line 5 only. The other lines can remain on the sheet but will be ignored.

Conditional required

Quantity

Quantity of goods received

Conditional Required

UOM

UOM of goods receipt. Default from PO

Conditional Required

Amount

Value of the receipt for services

Conditional Required

Table 2. Direct Delivery specific
Field Description Optional/Required

Receiving Location

Name of location receiving the goods/service. Will default from the PO.

Required

Subinventory

Name of the destination subinventory for the receiving transaction. Required for transactions with the Destination Type of Inventory

Conditional Required

Locator

Name of Locator if locator controlled subinventory

Conditional Required

Deliver To Location

Abbreviation that identifies the deliver to location. Defaults from PO but can be updated to any valid location for the Organization.

Required

Deliver to Person

Name of the deliver to person or requester. If this attribute is blank, this will default to the requester specified on the purchase order distribution

Optional

Line Receipt Date

Receipt date. Default from header.

Required

Line Received By

Name of the employee who performed the receiving transaction. Defaults from header

Required

Exception

Value that indicates whether or not the received transaction being created has an exception

Optional

Reason

Name of the inventory transaction reason for the receiving transaction

Optional

Section: Lot Number

For Items that are Lot controlled

Lot

Enter Lot Details

Optional

Lot Transaction Quantity

The quantity for this Lot should match the line quantity. If necessary, the line quantity can be split across multiple Lots

Optional

Expiration Date

Optional

Section: Serial Number

For items that are serial-controlled

Serial Number

The Serial number for a single receipt, or the starting number of a range

Optional

To Serial Number

End Serial number range. The number of serial numbers provided doesn’t match the quantity being received. For example, if you’re receiving 5 units of a serial-controlled item, but only provide 3 serial numbers, or provide 7.

Optional

Currently, we do not support items that are both Lot and Serial controlled.
Table 3. Standard Receipt specific
Field Description Optional/Required

Receiving Location

Name of location receiving the goods/service. Will default from the PO.

Required

Subinventory

Not required. Will form part of putaway transaction

Null

Locator

Not required. Will form part of putaway transaction

Null

Deliver To Location

Not required. Will form part of putaway transaction

Null

Deliver to Person

Not required. Will form part of putaway transaction

Null

Line Receipt Date

Receipt date. Default from header

Required

Line Received By

Name of the employee who performed the receiving transaction. Defaults from header

Required

Exception

Value that indicates whether or not the received transaction being created has an exception

Optional

Reason

Name of the inventory transaction reason for the receiving transaction

Optional

These sections are not required. Will form part of putaway

Section: Lot Number

For Items that are Lot controlled

Section: Serial Number

For items that are serial-controlled

Grouping Lines into a PO Receipt

POs should be grouped by organization and supplier.

When using the Purchase Order Receiving Integrator is that each receipt you create can only be for a single destination organization. Therefore, if you initiate a receipt for 'Organization A,' all subsequent items added to that receipt must also be destined for 'Organization A.' You cannot combine items for 'Organization A' and 'Organization B' on the same receipt.

You must also have only one supplier per receipt.

Split Lines

If you need to split a line into multiple lines, simply insert a new row directly below the line you wish to split. From there, copy all the original line details and any subsequent sections onto this newly created row.

You can then enter the specific quantity for each new line, along with any other relevant details, such as a new "Deliver to" location. Please ensure that the quantities across these new lines add up to either the original ordered quantity or less.