Identifying the Printout Fields

The printout contains various fields that depend on the transaction record you print. To learn more about these printout fields, refer to the following tables.

• Purchase Order Printout Fields

• Sales Order Printout Fields

• Invoice Printout Fields

• Picking Ticket Printout Fields

• Packing Slip Printout Fields

Purchase Order Printout Fields

Section	Field Name	Field ID	Description
Header	Company Logo	companyinformation.logoUrl	Company logo on the Company Information record
	Record Title	record@title	Purchase Order
	Company Name	companyinformation.companyname	Company name on the Company Information record
	Company Address	companyinformation.addresstext	Company address on the Company Information record
	Date	record.trandate	Date field value on the transaction record
	PO #	record.tranid	Transaction ID field value on the transaction record
	Receive By	record.duedate	Receive By field value on the transaction record
	Terms	record.terms	Terms field value on the Billing subtab of the transaction record
	Incoterm	record.incoterm	Incoterm field value on the Billing subtab of the transaction record
Vendor Information	Vendor:	record.billaddress	Vendor Address field value on the Billing subtab of the transaction record
Shipping Information	Ship To:	record.shipaddress	Company address on the Company Information record For drop-ship purchase orders, this field contains the shipping address on the Shipping subtab of the transaction record. For special order purchase orders created from a sales order, this field contains the shipping address on the related Sales Order record.
Grid Table	Grid Table Name	Any of the following: item.custcol_gridoe_hidden_parentdispname (parent item's display name) item.custcol_gridoe_hidden_parentname (parent item's item name) gridData.name (item's grid template)	For grid matrix templates, if the parent item's Display Name/Code field value is available, this value becomes the grid table name. Otherwise, the parent item's Item Name/Number field value becomes the grid table name. For grid item templates, the Grid Template field value on the transaction record becomes the grid table name.
	Quantity	-	Calculated sum of quantities for each row attribute
	Total Quantity	-	Calculated total of grid table quantities This value is located at the bottom of the Quantity column on the grid table.
	Row Attribute Values	gridData.grid.data[n].rowattribute	Row attributes on the grid template
	Column Attributes Header Label	gridData.grid.header[n].name	Column attributes on the grid template
	Column Attributes Item Quantity	item.quantity	Item quantity for each column attribute
	Column Attributes Total Quantity	-	Calculated total of column attribute quantities This value is located at the bottom of each column attribute on the grid table, which appears only on single grid tables.
	Rate	item.rate	Rate of each item
	Amount	item.amount	Calculated sum of amounts for each row attribute Ideally, this value is equivalent to the aggregate total of each item quantity multiplied by the respective rate. When you override the price of any item in the amount column on the transaction record, the Amount field value in the printout also changes, causing amount discrepancies.
	Total Amount	-	Calculated total amount This value is located at the bottom of the Amount column on the grid table.
Item List	Quantity	item.quantity	Quantity of each item on the item list
	Total Quantity	-	Calculated total of item list quantities This value is located at the bottom of the Quantity column on the item list.
	Item	item.item	Item name on the transaction record
	Name	Any of the following: item.vendorname (item's vendor name) item.custcol_gridoe_hidden_displayname (item's display name) item.item (item name)	The label for the name depends on the following conditions: If the item’s Vendor Name/Code field value is available, this value becomes the name. If the item’s Vendor Name/Code field value is blank, the item's Display Name/Code becomes the name. If both Vendor Name/Code and Display Name/Code are blank, the Item Name/Number becomes the name.
	Rate	item.rate	Rate of each item
	Amount	item.amount	Amount of each item Ideally, this value is equivalent to the aggregate total of each item quantity multiplied by the respective rate. When you override the price of any item in the amount column on the transaction record, the Amount field value in the printout also changes, causing amount discrepancies.
	Total Amount	-	Calculated total amount This value is located at the bottom of the Amount column on the item list.
Summary	Subtotal	-	Calculated sum of all grid table total amounts and item list total amounts
	Discounts	item.amount (Discount)	Calculated sum of all line-item and transaction discounts on the transaction record For more information on discount items, see Discount Items on the Help Center.
	Markups	item.amount (Markup)	Calculated sum of all markup items on the item sublist of the transaction record For more information on markup items, see Markup Items on the Help Center.
	Tax Total	record.taxtotal	Tax Total field value in the Summary section of the transaction record
	GST/HST	record.taxtotal	(For Canadian subsidiaries only) GST/HST field value in the Summary section of the transaction record
	PST	record.tax2total	(For Canadian subsidiaries only) PST field value in the Summary section of the transaction record
	Grand Total Quantity	-	Calculated sum of all item quantities on the transaction record
	Grand Total Amount	record.total	Total field value in the Summary section of the transaction record Important: The grand total amount may be different from the aggregate sum of amounts on the transaction, especially in cases where you use line item discounts and custom price levels.
Footer	Bar Code	-	Transaction bar code
	Page Number	-	Current page number

For more information about the fields and field IDs that you can use in customizing the grid print template for purchase order, see Standard Purchase PDF/HTML Template.

Sales Order Printout Fields

Section	Field Name	Field ID	Description
Header	Company Logo	companyinformation.logoUrl	Company logo on the Company Information record
	Record Title	record@title	Sales Order
	Company Name	companyinformation.companyname	Company name on the Company Information record
	Company Address	companyinformation.addresstext	Company address on the Company Information record
	Date	record.trandate	Date field value on the transaction record
	Order #	record.tranid	Transaction ID field value on the transaction record
	Terms	record.terms	Terms field value on the Billing subtab of the transaction record
	PO #	record.otherrefnum	PO # field value on the transaction record
	Shipping Method	record.shipmethod	Shipping Method field value on the Shipping subtab of the transaction record
Billing Information	Bill To:	record.billaddress	Billing Address field value on the Billing subtab of the transaction record
Shipping Information	Ship To:	record.shipaddress	Shipping Address field value on the Shipping subtab of the transaction record When the Multiple Shipping Routes feature is enabled, the Enable Item Line Shipping box is shown on the Item subtab of the sales order. This feature allows you to add different shipping addresses for each item in the Item sublist. If there are multiple shipping addresses available in the transaction, the Ship To field in the printout becomes hidden.
Grid Table	Grid Table Name	Any of the following: item.custcol_gridoe_hidden_parentdispname (parent item's display name) item.custcol_gridoe_hidden_parentname (parent item's item name) gridData.name (item's grid template)	For grid matrix templates, if the parent item's Display Name/Code field value is available, this value becomes the grid table name. Otherwise, the parent item's Item Name/Number field value becomes the grid table name. For grid item templates, the Grid Template field value on the transaction record becomes the grid table name.
	Quantity	-	Calculated sum of quantities for each row attribute
	Total Quantity	-	Calculated total of grid table quantities This value is located at the bottom of the Quantity column on the grid table.
	Row Attribute Values	gridData.grid.data[n].rowattribute	Row attributes on the grid template
	Column Attributes Header Label	gridData.grid.header[n].name	Column attributes on the grid template
	Column Attributes Item Quantity	item.quantity	Item quantity for each column attribute
	Column Attributes Total Quantity	-	Calculated total of column attribute quantities This value is located at the bottom of each column attribute on the grid table, which appears only on single grid tables.
	Rate	item.rate	Rate of each item
	Amount	item.amount	Calculated sum of amounts for each row attribute Ideally, this value is equivalent to the aggregate total of each item quantity multiplied by the respective rate. When you override the price of any item in the amount column on the transaction record, the Amount field value in the printout also changes, causing amount discrepancies.
	Total Amount	-	Calculated total amount This value is located at the bottom of the Amount column on the grid table.
Item List	Quantity	item.quantity	Quantity of each item on the item list
	Total Quantity	-	Calculated total of item list quantities This value is located at the bottom of the Quantity column on the item list.
	Item	item.item	Item name on the transaction record
	Name	Any of the following: item.custcol_gridoe_hidden_displayname (item's display name) item.item (item name)	If the item's Display Name/Code field value is available, this value becomes the name. Otherwise, the item's Item Name/Number field value becomes the name.
	Rate	item.rate	Rate of each item
	Amount	item.amount	Amount of each item Ideally, this value is equivalent to the aggregate total of each item quantity multiplied by the respective rate. When you override the price of any item in the amount column on the transaction record, the Amount field value in the printout also changes, causing amount discrepancies.
	Total Amount	-	Calculated total amount This value is located at the bottom of the Amount column on the item list.
Summary	Subtotal	-	Calculated sum of all grid table total amounts and item list total amounts
	Discounts	item.amount (Discount)	Calculated sum of all line-item and transaction discounts on the transaction record For more information on discount items, see Discount Items on the Help Center.
	Markups	item.amount (Markup)	Calculated sum of all markup items on the item sublist of the transaction record For more information on markup items, see Markup Items on the Help Center.
	Tax Total	record.taxtotal	Tax Total field value in the Summary section of the transaction record
	GST/HST	record.taxtotal	(For Canadian subsidiaries only) GST/HST field value in the Summary section of the transaction record
	PST	record.tax2total	(For Canadian subsidiaries only) PST field value in the Summary section of the transaction record
	Shipping Total	record.altshippingcost + record.althandlingcost	Calculated sum of Shipping Cost and Handling Cost field values in the Summary section of the transaction record
	Gift Certificate	record.giftcertapplied	Gift Certificate field value in the Summary section on the transaction record
	Grand Total Quantity	-	Calculated sum of all item quantities on the transaction record
	Grand Total Amount	record.total	Total field value in the Summary section of the transaction record Important: The grand total amount may be different from the aggregate sum of amounts on the transaction, especially in cases where you use line item discounts and custom price levels.
Footer	Bar Code	-	Transaction bar code
	Page Number	-	Current page number

For more information about the fields and field IDs that you can use in customizing the grid print template for sales order, see Standard Sales Order PDF/HTML Template.

Invoice Printout Fields

Section	Field Name	Field ID	Description
Header	Company Logo	companyinformation.logoUrl	Company logo on the Company Information record
	Record Title	record@title	Invoice
	Company Name	companyinformation.companyname	Company name on the Company Information record
	Company Address	companyinformation.addresstext	Company address on the Company Information record
	Date	record.trandate	Date field value on the transaction record
	Invoice #	record.tranid	Transaction ID field value on the transaction record
	Due Date	record.duedate	Due Date field value on the transaction record
	Terms	record.terms	Terms field value on the Billing subtab of the transaction record
	PO #	record.otherrefnum	PO # field value on the transaction record
	Shipping Method	record.shipmethod	Shipping Method field value on the Shipping subtab of the transaction record
Billing Information	Bill To:	record.billaddress	Billing Address field value on the Billing subtab of the transaction record
Shipping Information	Ship To:	record.shipaddress	Shipping Address field value on the Shipping subtab of the transaction record
Grid Table	Grid Table Name	Any of the following: item.custcol_gridoe_hidden_parentdispname (parent item's display name) item.custcol_gridoe_hidden_parentname (parent item's item name)	For grid matrix templates, if the parent item's Display Name/Code field value is available, this value becomes the grid table name. Otherwise, the parent item's Item Name/Number field value becomes the grid table name. Items using grid item templates are shown on the item list.
	Quantity	-	Calculated sum of quantities for each row attribute
	Total Quantity	-	Calculated total of grid table quantities This value is located at the bottom of the Quantity column on the grid table.
	Row Attribute Values	gridData.grid.data[n].rowattribute	Row attributes on the grid template
	Column Attributes Header Label	gridData.grid.header[n].name	Column attributes on the grid template
	Column Attributes Item Quantity	item.quantity	Item quantity for each column attribute
	Column Attributes Total Quantity	-	Calculated total of column attribute quantities This value is located at the bottom of each column attribute on the grid table, which appears only on single grid tables.
	Rate	item.rate	Rate of each item
	Amount	item.amount	Calculated sum of amounts for each row attribute Ideally, this value is equivalent to the aggregate total of each item quantity multiplied by the respective rate. When you override the price of any item in the amount column on the transaction record, the Amount field value in the printout also changes, causing amount discrepancies.
	Total Amount	-	Calculated total amountThis value is located at the bottom of the Amount column on the grid table.
Item List	Quantity	item.quantity	Quantity of each item on the item list
	Total Quantity	-	Calculated total of item list quantities This value is located at the bottom of the Quantity column on the item list.
	Item	item.item	Item name on the transaction record
	Name	Any of the following: item.custcol_gridoe_hidden_displayname (item's display name) item.item (item name)	If the item's Display Name/Code field value is available, this value becomes the name. Otherwise, the item's Item Name/Number field value becomes the name.
	Rate	item.rate	Rate of each item
	Amount	item.amount	Amount of each item Ideally, this value is equivalent to the aggregate total of each item quantity multiplied by the respective rate. When you override the price of any item in the amount column on the transaction record, the Amount field value in the printout also changes, causing amount discrepancies.
	Total Amount	-	Calculated total amount This value is located at the bottom of the Amount column on the item list.
Summary	Subtotal	-	Calculated sum of all grid table total amounts and item list total amounts
	Discounts	item.amount (Discount)	Calculated sum of all line-item and transaction discounts on the transaction record For more information on discount items, see Discount Items on the Help Center.
	Markups	item.amount (Markup)	Calculated sum of all markup items on the item sublist of the transaction record For more information on markup items, see Markup Items on the Help Center.
	Tax Total	record.taxtotal	Tax Total field value in the Summary section of the transaction record
	GST/HST	record.taxtotal	(For Canadian subsidiaries only) GST/HST field value in the Summary section of the transaction record
	PST	record.tax2total	(For Canadian subsidiaries only) PST field value in the Summary section of the transaction record
	Shipping Total	record.altshippingcost + record.althandlingcost	Calculated sum of Shipping Cost and Handling Cost field values in the Summary section of the transaction record
	Gift Certificate	record.giftcertapplied	Gift Certificate field value in the Summary section on the transaction record
	Grand Total Quantity	-	Calculated sum of all item quantities on the transaction record
	Grand Total Amount	record.total	Total field value in the Summary section of the transaction record Important: The grand total amount may be different from the aggregate sum of amounts on the transaction, especially in cases where you use line item discounts and custom price levels.
Footer	Bar Code	-	Transaction bar code
	Page Number	-	Current page number

For more information about the fields and field IDs that you can use in customizing the grid print template for invoice, see Standard Invoice PDF/HTML Template.

Picking Ticket Printout Fields

Section	Field Name	Field ID	Description
Header	Company Logo	companyinformation.logoUrl	Company logo on the Company Information record
	Record Title	record@title	Picking Ticket
	Company Name	companyinformation.companyname	Company name on the Company Information record
	Company Address	companyinformation.addresstext	Company address on the Company Information record
	Date	record.trandate	Date field value on the related Sales Order or Transfer Order record
	Order #	record.tranid	Transaction ID field value on the related Sales Order or Transfer Order record
	Shipping Method	record.shipmethod	Shipping Method field value on the Shipping subtab of the related Sales Order or Transfer Order record
Shipping Information	Ship To:	record.shipaddress	Shipping Address field value on the Shipping subtab of the related Sales Order or Transfer Order record When the Multiple Shipping Routes feature is enabled, the Enable Item Line Shipping box is shown on the Item subtab of the sales order. This feature allows you to add different shipping addresses for each item in the Item sublist. If there are multiple shipping addresses available in the transaction, the Ship To field in the printout becomes hidden.
Grid Table	Grid Table Name	Any of the following: item.custcol_gridoe_hidden_parentdispname (parent item's display name) item.custcol_gridoe_hidden_parentname (parent item's item name)	For grid matrix templates, if the parent item's Display Name/Code field value is available, this value becomes the grid table name. Otherwise, the parent item's Item Name/Number field value becomes the grid table name. Items using grid item templates are shown on the item list.
	Quantity	-	Calculated sum of quantities for each row attribute
	Total Quantity	-	Calculated total of grid table quantities This value is located at the bottom of the Quantity column on the grid table.
	Row Attribute Values	gridData.grid.data[i].rowattribute	Row attributes on the grid template
	Column Attributes Header Label	gridData.grid.header[i].name	Column attributes on the grid template
	Column Attributes Item Quantity	item.quantity	Item quantity for each column attribute This value is derived from the Quantity column of the related Sales Order or Transfer Order record.
	Column Attributes Total Quantity	-	Calculated total of column attribute quantities This value is located at the bottom of each column attribute on the grid table, which appears only on single grid tables.
Item List	Quantity	item.quantity	Quantity of each item on the item list
	Total Quantity	-	Calculated total of item list quantities This value is located at the bottom of the Quantity column on the item list.
	Item	item.item	Item name on the related Sales Order or Transfer Order record
	Name	Any of the following: item.custcol_gridoe_hidden_displayname (item's display name) item.item (item name)	If the item's Display Name/Code field value is available, this value becomes the name. Otherwise, the item's Item Name/Number field value becomes the name.
Footer	Bar Code	-	Transaction bar code
	Page Number	-	Current page number

For more information about the fields and field IDs that you can use in customizing the grid print template for picking ticket, see Standard Picking Ticket PDF/HTML Template.

Packing Slip Printout Fields

Section	Field Name	Field ID	Description
Header	Company Logo	companyinformation.logoUrl	Company logo on the Company Information record
	Record Title	record@title	Packing Slip
	Company Name	companyinformation.companyname	Company name on the Company Information record
	Company Address	companyinformation.addresstext	Company address on the Company Information record
	Date	salesorder.trandate	Date field value on the related Sales Order or Transfer Order record
	Order #	salesorder.tranid	Order # field value on the related Sales Order or Transfer Order record
	Ship Date	salesorder.shipdate	Ship Date field value on the Shipping subtab of the related Sales Order or Transfer Order record
	Tracking #	salesorder.linkedtrackingnumbers	Tracking # field value on the Shipping subtab of the related Sales Order or Transfer Order record This field contains the Package Tracking Number field value on the Packages subtab of the Item Fulfillment record. For more information, see Tracking Numbers.
	Shipping Method	record.shipmethod	Shipping Method field value on the Shipping subtab of the Item Fulfillment record
Shipping Information	Address	record.shipaddress	Shipping Address field value on the Shipping subtab of the Item Fulfillment record
Grid Table	Grid Table Name	Any of the following: item.custcol_gridoe_hidden_parentdispname (parent item's display name) item.custcol_gridoe_hidden_parentname (parent item's item name)	For grid matrix templates, if the parent item's Display Name/Code field value is available, this value becomes the grid table name. Otherwise, the parent item's Item Name/Number field value becomes the grid table name. Items using grid item templates are shown on the item list.
	Ordered	-	Calculated sum of ordered quantities for each row attribute This value is derived from the Quantity column of the related Sales Order or Transfer Order record.
	Total Ordered	-	Calculated total ordered quantity This value is located at the bottom of the Ordered column on the grid table.
	Row Attribute Values	gridData.grid.data[i].rowattribute	Row attributes on the grid template
	Column Attributes Header Label	gridData.grid.header[i].name	Column attributes on the grid template
	Column Attributes Item Quantity	item.quantity	Fulfilled item quantity for each column attribute This value is derived from the Quantity column of the Item Fulfillment record.
	Column Attributes Total Item Quantity	-	Calculated total of fulfilled item quantities for each column attribute This value is located at the bottom of each column attribute on the grid table, which appears only on single grid tables.
	Back Ordered	-	Calculated sum of back-ordered quantities for each row attribute This value is derived from the Back Ordered column of the related Sales Order or Transfer Order record.
	Total Back Ordered	-	Calculated total back-ordered quantity This value is located at the bottom of the Back Ordered column on the grid table.
	Shipped	-	Calculated sum of quantities for each item on the Item Fulfillment record
	Total Shipped	-	Calculated total shipped quantity This value is located at the bottom of the Shipped column on the grid table.
Item List	Ordered	salesorder.item.quantity	Calculated sum of ordered quantities for each item on the item list This value is derived from the Quantity column of the related Sales Order or Transfer Order record.
	Total Ordered	-	Calculated total ordered quantity This value is located at the bottom of the Ordered column on the item list.
	Item	item.item	Item name on the transaction record
	Name	Any of the following: item.custcol_gridoe_hidden_displayname (item's display name) item.item (item name)	If the item's Display Name/Code field value is available, this value becomes the name. Otherwise, the item's Item Name/Number field value becomes the name.
	Back Ordered	-	Calculated sum of back-ordered quantities for each row attribute This value is derived from the Back Ordered column of the related Sales Order or Transfer Order record.
	Total Back Ordered	-	Calculated total back-ordered quantity This value is located at the bottom of the Back Ordered column on the item list.
	Shipped	item.quantity	Quantity of each item on the Item Fulfillment record
	Total Shipped	-	Calculated total shipped quantity This value is located at the bottom of the Shipped column on the item list.
Customer Return Form	Company Name	companyinformation.companyname	Company name on the Company Information record
	Return Address	companyInformation.returnaddress_text	Return address on the Company Information record
	Order #	salesorder.tranid	Order # field value on the related Sales Order or Transfer Order record
	R.A.#	-	Blank field where you can input the return authorization number
Footer	Bar Code	-	Transaction bar code
	Page Number	-	Current page number

For more information about the fields and field IDs that you can use in customizing the grid print template for packing slip, see Standard Packing Slip PDF/HTML Template.

Related Topics

• Customizing the Grid Print Templates
• Identifying the Grid Print Template Elements

General Notices