Receipts worksheet
Lot Management
•
Article
•
7/2/2025
•
2 min
On the Receipts worksheet of the exported Excel document, you can view all inbound transactions in the following fields:
| Field | Description |
|---|---|
| Lot No. | Specifies the lot number associated with the item. |
| Vendor Lot No. | Specifies the vendor lot number associated with the item. |
| Quantity | Specifies the total quantity of the item in this lot. |
| Unit of Measure | Specifies the unit used to measure the item. |
| Item Description | Specifies the description of the item. |
| Item Category Description | Specifies the description of the associated item category. |
| Previous Source Name | Specifies the name associated with the source vendor. This value is derived from the buy-from details of the posted purchase document. |
| Previous Source Phone No. | Specifies the phone number associated with the source vendor. This value is derived from the buy-from details of the posted purchase document. |
| Previous Source Address | Specifies the address associated with the source vendor. This value is derived from the buy-from details of the posted purchase document. |
| Previous Source City | Specifies the city associated with the source vendor. This value is derived from the buy-from details of the posted purchase document. |
| Previous County/State/Region | Specifies the county, state, or region associated with the source vendor. This value is derived from the buy-from details of the posted purchase document. |
| Previous Source Zip/Postal | Specifies the zip or postal code associated with the source vendor. This value is derived from the buy-from details of the posted purchase document. |
| Previous Source Country | Specifies the country associated with the source vendor. This value is derived from the buy-from details of the posted purchase document. |
| Receipt Source Location Name | Specifies the location associated with the ship-to details of the location. |
| Receipt Source Phone No. | Specifies the phone number associated with the ship-to details of the location. |
| Receipt Source Address | Specifies the address associated with the ship-to details of the location. |
| Receipt Source City | Specifies the city associated with the ship-to details of the location. |
| Receipt County/State/Region | Specifies the county, state, or region associated with the ship-to details of the location. |
| Receipt Source Zip/Postal | Specifies the zip or postal code associated with the ship-to details of the location. |
| Receipt Source Country | Specifies the country associated with the ship-to details of the location. |
| Receipt Date | Specifies the posting date of receipt derived from item ledger entries. |
| Traceability Source Reference | Specifies the traceability information of the source, such as an address, URL, GLN, or phone number. This value is derived from the lot origin details. |
| Reference Document Type | Specifies the type of source document the lot originated from. |
| Reference Document No. | Specifies the number of the source document. |
| Reference Document Type 2 | Specifies the type of document the lot is posted in. |
| Reference Document No. 2 | Specifies the number of the posted document. |