Connected Items
Connected items
As of version 6.2 Connected items are an integrated part of AGR. All functionality comes pre-installed and ready to go. The connected items workspace can be found in the top menu under More
By default, only the item no from/to columns and the connected from/to date columns are visible. This can easily be configued in the view settings where a variety of fun columns are available:
There are some smart defaults set for the connected items which can be found under the system settings:
Behind the scenes
The connected items staging elements are enabled by default so it’s ready to go from the time you install the system:
If using connected stock you can view the [inv].[stocks] table where you will see a breakdown of the stock numbers and also a trace in the connected_stock_description column which will tell you from which item id’s the connected stock came:
Similarly, in the [inv].[histories_connected_sale] you will find a trace:
Validation and error tracing
when adding new item connections a validation procedure will be run (in prod - [dbo].[connected_items_validation]). This validation should catch most of the errors but if you are encountering errors during the nightly run you can check out the table [inv].[connected_item_error_list] in the staging database