Enter the Receipt Details into the Sheet
Key fields to create a 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 |
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. |
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.