Product Record ID
Name
A unique name for the product.
Description
A description of the product.
Product tab
Product
Allocated
If this checkbox is marked, the amount from the purchase of this product is allocated to any non-allocated product purchases in the same shipment for a purchase order. Allocation occurs during the invoice process.
If you need to allocate an amount to some, but not all, non-allocated products in a shipment, isolate the products you do not want to allocate to in a separate shipment.
Generic
If this checkbox is marked, the product represents a product type rather than a specific product. Currently, this setting is for informational purposes only; it does not affect the functioning of ActivityHD Purchasing.
Purchase Unrestricted
If this checkbox is marked, the product can be purchased from any vendor in any unit of measure. If you do not mark this checkbox, the product can only be purchased in the vendor/unit of measure combinations defined in the Detail table.
Receipt Required
The point at which to require a receipt for the product. Valid options are:
- Close Order. Require a receipt before the product order can be closed.
- Merge Invoice. Require a receipt before the invoice for the product can be merged.
- Never. Never require a receipt. This option is appropriate for "products" such as sales tax and freight.
APCodes
The APCode(s) to apply to the purchase of this product when the purchase is invoiced. In particular, if the product is subject to 1099 reporting, be sure to designate a payment reporting-type APCode which specifies the appropriate 1099 type and also ensure that the appropriate rows in the Detail table are flagged for reporting.
If you enter multiple APCodes, separate them with commas.
Note
The Ctrl and Shift selection features are available in the Find dialog box so you can select multiple APCodes. ActivityHD automatically separates your selections by commas.
Example
If the purchase is subject to use tax, select the APCode for the applicable use tax.
Press F2 to open a dialog box where you can add and remove selections for this field.
Press F3 to look up the item.
GL Account Masks
Expense
The account mask to use to derive the GL expense account number for purchases of this product. This field is disabled if the Allocated checkbox is marked.Press F2 to open the Account Expand dialog box where you can look up an account number, find an account number by its alias, build the account number by segment, or view setup and setup sources.
Press F3 to look up the account.
If an account is already selected, you can press F4 to open the record in the Account window.
Inventory
The account mask to use to derive the GL inventory account number for purchases of this product. This field is disabled if the Allocated checkbox is marked.Press F2 to open the Account Expand dialog box where you can look up an account number, find an account number by its alias, build the account number by segment, or view setup and setup sources.
Press F3 to look up the account.
If an account is already selected, you can press F4 to open the record in the Account window.
Detail table
Use this table to define the allowable vendor/unit of measure combinations for the product. If the Product Unrestricted checkbox is not marked, only the combinations entered in the table (that are not flagged as obsolete) are allowed for the product. If you can purchase the product from multiple vendors, you need at least one line per vendor. If you can purchase the product from a particular vendor in multiple units of measure, you need one line per vendor/unit of measure combination.
Example
Suppose you can purchase printer toner from two vendors. From Toner Depot, you can order single toner cartridges and you can order by the case. You can only buy toner from Toner Max by the case. Setup for this example would require three detail lines:
Enter the following information for each vendor/unit of measure combination:
Vendor
The vendor that supplies the product. Leave this field blank if the product can be purchased from any vendor.Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
UOM
The unit of measure in which the product can be purchased from the vendor on this row.Press F3 to look up the value.
If a value is already selected, you can press F4 to open the record in its native editor.
Description
A description of the vendor/unit of measure combination.
Part Number
The vendor's part number for the vendor/unit of measure combination of the product.
Default
If this checkbox is marked, the unit of measure should be used as the default whenever this product is entered on a purchase line for the vendor. This option applies whenever there are multiple units of measure for the product for the same vendor. If there is only one vendor/unit of measure combination for a vendor, it is automatically considered the default. Only one default can be specified per vendor per product.
Reporting
If this checkbox is marked, the vendor/unit of measure combination should be included in the basis for payment reporting-type APCodes on purchasing invoices. To ensure that PO invoices with the vendor/unit of measure combination are flagged as subject to 1099, mark the checkbox and ensure that a payment reporting-type APCode which specifies the appropriate 1099 type is designated in the APCodes field.
Example
Suppose you have a "software consulting" product and that product can be provided by either your software provider or by an independent consultant. You would want to flag the vendor/unit of measure combination that represents the independent consultant for reporting so that any amounts paid to the consultant can be reported on a 1099-NEC. In this case, a payment reporting-type APCode for non-employee compensation would be assigned to the product.
Withholding
If this checkbox is marked, the vendor/unit of measure combination should be included in the basis for payment withholding-type APCodes on purchasing invoices.
Obsolete
If this checkbox is marked, the vendor/unit of measure combination is flagged as obsolete and not eligible for future purchases.
Note
If this checkbox is marked and the Purchase Unrestricted flag is not marked, the vendor/unit of measure combination cannot be used on purchase lines.
Memo
Any additional notes about the vendor/unit of measure combination. For instance, you could enter the reason a vendor/unit of measure combination was flagged as obsolete.
Cost table
Use this table to enter cost information for each vendor/unit of measure combination. This table works in conjunction with the Detail table. Select a vendor/unit of measure combination in the Detail table, then enter the following information in the Cost table:
Effective DateThe date the cost on this row takes effect for the selected vendor/unit of measure combination. You can enter multiple cost detail lines to indicate changes in cost over time for the selected vendor/unit of measure combination.Unit CostThe cost per unit of the product as of the specified effective date. This is the default cost of the product for the vendor/unit of measure combination during the effective date range. The default cost can be overridden when a purchase is entered.MemoAdditional notes about the cost entry.
Custom tab
This tab is visible if custom fields exist for the entity. At a minimum, if there are custom fields, a Fields subtab will be present. One or more additional categories of subtabs may also be visible.
Fields subtab
This tab prompts for values for any custom fields set up for entity records of this entity type. Respond to the prompts as appropriate.
References subtab
This tab is visible if other records reference the current record.
Reference
From the drop-down list, select the custom field to view references for. Reference custom fields have the following format: PackageName.EntityName.CustomFieldName.
Example
Suppose a custom field exists on PRCodes that references an ARCode. On the ARCode record, on the Custom > References subtab, you can view all the PRCodes which reference that ARCode.
Exchange Folder subtab
This tab is visible only if you set up a custom field with a data type of "Exchange Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified Exchange folder.
File subtab
This tab is visible only if you set up a custom field with a data type of "File". The label on the tab is the name assigned to the custom field.
This tab renders the contents of the specified file according to its file type.
Internet Address subtab
This tab is visible only if you set up a custom field with a data type of "Internet Address". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified web page.
Network Folder subtab
This tab is visible only if you set up a custom field with a data type of "Network Folder". The label on this tab is the name assigned to the custom field.
This tab shows the contents of the specified network folder.
Purchases tab
The Purchases pane shows the Purchases HD view filtered to show all purchases of the selected product.
Double-click a row in the pane to drill down to its record in the Purchase window.
The Attachments tab is visible if any record for a given entity has an attachment. If the Attachments tab is not visible, this implies that no record of the entity type has an attachment on it; however, once an attachment is added to any record of the entity type, the Attachments tab will become available.
Attachments
The list box shows the files which are attached to the current record. Highlight a file name to preview the file in the adjacent pane. Double-click a file name to open the file in its native editor.
Preview pane
If a file name is highlighted in the Attachments list box, this pane shows a preview of the file contents. Some file types cannot be previewed but can be double-clicked to open in their native editor.
Change Logs tab
This tab is visible if the user has "Change Logs" access to the associated data folder resource.
The Change Logs pane shows the Change Logs HD view filtered to show all change logs for the selected entity record.
Double-click a row in the pane to drill down to its record in the Change Log window.
Other tab
Memo tab
To include additional information about this record not collected elsewhere, enter it in this text box. This area supports common keyboard shortcuts such as Ctrl+C to copy and Ctrl+V to paste.
Timestamps tab
This tab shows the user who created this record and the date and time of creation as well as the user, date, and time of the latest modification to the record.
Developer tab
This tab is visible only when developer features are enabled.
Automation subtab
This subtab shows field names and values for the current data record. Use the information in the subtab to assist when creating automation objects such as bots and import files. The field names and field values can be copied from the text box and pasted directly into your code or application. To copy content from the text box, highlight the content to copy and press Ctrl+C or right-click your selection and select Copy from the context menu.
Export (XML | JSON) subtab
This subtab shows the XML syntax for exporting the selected data record. The syntax can be copied from the text box as an exemplar for creating your own automation objects for bots, import files, ActivWebAPI, etc. To copy content from the text box, highlight the content to copy and press Ctrl+C or right-click your selection and select Copy from the context menu.
Import (XML | JSON) subtab
This subtab allows you to select a file for import and shows the XML syntax for importing data records. Use the subtab to explore the XML syntax for importing data records. In particular, you can investigate the syntax which results when using Data.Import and ActivWebAPI data POST and DELETE routes.
Change Log (XML | JSON) subtab
This subtab is visible only when the Enable Change Logs option is marked in System Options or Company Options (depending on whether the feature applies at the system or the company level). This is the default setting when developer features are enabled.
This subtab allows you to investigate changes to the current data record. The syntax can be copied for use in bots, dashboards, ActivWebAPI, and other automation. To copy content from the text box, highlight the content to copy and press Ctrl+C or right-click your selection and select Copy from the context menu.
Select Statement (SQL) subtab
This subtab allows you to investigate the SQL select statement used to retrieve the current data record. The syntax can be copied as an exemplar for data sources and other automation. To copy content from the text box, highlight the content to copy and press Ctrl+C or right-click your selection and select Copy from the context menu.