{"id":6479,"date":"2020-04-23T14:37:24","date_gmt":"2020-04-23T13:37:24","guid":{"rendered":"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/?p=6479"},"modified":"2024-05-13T11:36:59","modified_gmt":"2024-05-13T11:36:59","slug":"product-query-setup","status":"publish","type":"post","link":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=6479","title":{"rendered":"Product Query Setup"},"content":{"rendered":"<p>A new facility has been added to Season 2020 to create and manage product queries. The program can be located within the General Setups pull down menu in product setup.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-6480\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2020\/04\/2304-6-300x187.jpg\" alt=\"\" width=\"300\" height=\"187\" \/><\/p>\n<h3><strong>Setup a new product query<\/strong><\/h3>\n<p>In the example below I have created a query of all products that are apart of the Beef Product groups. To do this enter a <strong>Code\u00a0<\/strong>(will need to be unique) and then populate details for <strong>Description, Query Type, Report Type and Query Value.<\/strong>\u00a0 By default the query will be dynamically managed by the system. If not, then the operator will tick the entry <strong>Manual Query<\/strong>. On entry of details click the<strong> Load Data <\/strong>button to list products that fulfil the query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-49096\" src=\"http:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2020\/04\/kNOWLEDGE-BASE-IMAGE.jpg\" alt=\"\" width=\"719\" height=\"393\" srcset=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2020\/04\/kNOWLEDGE-BASE-IMAGE.jpg 930w, https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2020\/04\/kNOWLEDGE-BASE-IMAGE-300x164.jpg 300w, https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2020\/04\/kNOWLEDGE-BASE-IMAGE-768x420.jpg 768w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><\/p>\n<h3>Query Type List<\/h3>\n<p>The following is the list of query filters that can be applied to products. The &#8220;default&#8221; option will filter on code, name and advanced search.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6482\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2020\/04\/2304-8.jpg\" alt=\"\" width=\"165\" height=\"145\" \/><\/p>\n<h3><strong>Report Type List<\/strong><\/h3>\n<p>The following is a list of available report types that a query could apply to. For example, the gross margin report would be categorized as &#8220;Performance&#8221; and the aged debt report would be categorized as &#8220;Performance&#8221;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-6477\" src=\"http:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2020\/04\/2304-5.jpg\" alt=\"\" width=\"131\" height=\"105\" \/><\/p>\n<h3><strong>Product query utilities<\/strong><\/h3>\n<p>The utilities button will allow a user to delete and refresh selected query, or refresh all queries. Please note only dynamic queries can be refreshed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-49097\" src=\"http:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2020\/04\/Utilities.jpg\" alt=\"\" width=\"969\" height=\"511\" srcset=\"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2020\/04\/Utilities.jpg 969w, https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2020\/04\/Utilities-300x158.jpg 300w, https:\/\/vger.datos.co.uk\/Clientknowledgebase\/wp-content\/uploads\/2020\/04\/Utilities-768x405.jpg 768w\" sizes=\"auto, (max-width: 969px) 100vw, 969px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A new facility has been added to Season 2020 to create and manage product queries. The program can be located within the General Setups pull down menu in product setup. Setup a new product query In the example below I have created a query of all products that are apart of the Beef Product groups. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,20],"tags":[],"class_list":["post-6479","post","type-post","status-publish","format-standard","hentry","category-howtoguides","category-howtooffice"],"_links":{"self":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/6479","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6479"}],"version-history":[{"count":2,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/6479\/revisions"}],"predecessor-version":[{"id":49098,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/6479\/revisions\/49098"}],"wp:attachment":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}