GRNs template

The following table lists the fields in the GRNs template. All values input to the template are case sensitive. The maximum file size allowed is 20 MB.

Field display name	Required?	Description	Field data type	Level	Value display names
Invoice number	No	The number of the invoice	String	Line
Item code	No	Code of the line item received	String	Line
Item description	No	Description of the line item received	String	Line
Item units	No	Units of measurement for the line item received (e.g., kilograms, pounds, etc.)	String	Line
Line External ID	No	An identifier for the GRN line. Must be unique within a single grn.	String	Line
Line notes	No	Notes about the line item (provided by the receipt creator)	String	Line
Notes	No	Description of the receipt (provided by the receipt creator)	String	Header
Payee external ID	Yes	Unique payee identifier	String	Header
Payer entity	Yes	Payer entity linked to this receipt	String	Header
PO line ID	Yes	An identifier for the purchase order line. Must be unique within a single purchase order.	String	Line
Purchase order number	Yes	An identifier for the purchase order associated with this receipt	String	Header
Quantity shipped	Yes	Quantity of the line item received	Decimal	Line
Receipt by	No	Name of the person who created the receipt	String	Header
Receipt date	Yes	Date and time the receipt was created	Date	Header
Receipt number	Yes	A unique External identifier of the receipt	String	Header
Shipment date	No	Date and time the goods were shipped	Date	Header
Status	No	Status of the receipt	List	Header	Pending approval Partially billed Deleted Closed Active