{"id":17164,"date":"2022-11-17T19:52:22","date_gmt":"2022-11-18T00:52:22","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=17164"},"modified":"2023-06-15T13:22:36","modified_gmt":"2023-06-15T17:22:36","slug":"on-order-report","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/on-order-report\/","title":{"rendered":"On Order Report"},"content":{"rendered":"\n<p>This report refers to all items on purchase orders within a specific date range (Artisan defaults this date range from your current date to the end of the year. Ex. November 17th, 2022-December 31, 2022). Though you can easily view any of your on order items here, this report is handy to have for your own records, as it shows certain details, like margins for each item.<\/p>\n<hr \/>\n<h2><strong>Accessing the Report<\/strong><\/h2>\n<p>From the toolbar, select &#8220;<strong>Reports<\/strong>,&#8221; &#8220;<strong>Purchasing Reports<\/strong>,&#8221; and &#8220;<strong>On Order Report<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-17179 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_17.png\" alt=\"\" width=\"474\" height=\"332\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_17.png 474w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_17-300x210.png 300w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/a><\/p>\n<p>Or, from the &#8220;<strong>Main Menu<\/strong>,&#8221; click on &#8220;<strong>Reports<\/strong>.&#8221;\u00a0<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_50.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17180 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_50.png\" alt=\"\" width=\"724\" height=\"515\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_50.png 831w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_50-300x213.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h38_50-768x546.png 768w\" sizes=\"auto, (max-width: 724px) 100vw, 724px\" \/><\/a><\/p>\n<p>Select &#8220;<strong>Purchasing Reports<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h39_30.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17181 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h39_30.png\" alt=\"\" width=\"733\" height=\"519\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h39_30.png 832w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h39_30-300x212.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h39_30-768x544.png 768w\" sizes=\"auto, (max-width: 733px) 100vw, 733px\" \/><\/a><\/p>\n<p>Click on &#8220;<strong>On Order Report<\/strong>.&#8221;<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h55_40.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17182 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h55_40.png\" alt=\"\" width=\"747\" height=\"533\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h55_40.png 830w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h55_40-300x214.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h55_40-768x548.png 768w\" sizes=\"auto, (max-width: 747px) 100vw, 747px\" \/><\/a><\/p>\n<p>Either way, you&#8217;ll end up at the On Order report screen.<\/p>\n<hr \/>\n<h2><strong>Report Fields<\/strong><\/h2>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-17_15h34_33.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-17168 aligncenter\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-17_15h34_33.png\" alt=\"\" width=\"757\" height=\"453\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-17_15h34_33.png 844w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-17_15h34_33-300x180.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-17_15h34_33-768x460.png 768w\" sizes=\"auto, (max-width: 757px) 100vw, 757px\" \/><\/a><\/p>\n<p><strong>Group By:\u00a0<\/strong>This determines how your data will be sorted and organized in the report. Grouping by Vendor, for example, will sort by vendor first and include each vendor&#8217;s currently on-order items. Refer to the examples for more information.<\/p>\n<p><span style=\"color: #333333;\"><strong>Purchase Basis: <\/strong>These fields help you narrow down your results. \u00a0<\/span><\/p>\n<p><strong>Start Date:\u00a0<\/strong>The earliest date this purchase order can be received into Artisan.<\/p>\n<p><strong>Expected Date:\u00a0<\/strong>The date the items are expected to arrive at your store.\u00a0<\/p>\n<p><strong>Cancel Date: <\/strong>The last date you can receive these items into Artisan.<\/p>\n<p><strong>Issue Date:\u00a0<\/strong>The date and time the purchase order was created.<\/p>\n<p><strong>Report Date Range:\u00a0<\/strong>Only purchase orders placed between these dates will appear on this report.<\/p>\n<p><strong>Sub-Group By Purchase Order?:\u00a0<\/strong>Selecting &#8220;<strong>yes<\/strong>&#8221; will separate the list to show which items belong to what purchase order. Refer to the examples for more information.<\/p>\n<p><strong>Show Individual Items?:\u00a0<\/strong>Selecting &#8220;<strong>yes<\/strong>&#8221; will list every item currently on order. Otherwise, the report will only show purchase order information by category, vendor, or start date, depending on which grouping you choose.<\/p>\n<p>Like most Artisan reports, there are countless other options to filter your results as you see fit, from only including specific items and vendors, to setting a price range, unit cost range, and more. You may save your changes to load as &#8220;<strong>Defaults<\/strong>&#8221; the next time you run this report. The only thing that won&#8217;t save is the date range.<\/p>\n<hr \/>\n<h3><strong>Report Examples<\/strong><\/h3>\n<p><strong>Group By Category, Start Date Purchase Basis<\/strong><\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h59_21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17183\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h59_21.png\" alt=\"\" width=\"1284\" height=\"835\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h59_21.png 1284w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h59_21-300x195.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h59_21-1024x666.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_10h59_21-768x499.png 768w\" sizes=\"auto, (max-width: 1284px) 100vw, 1284px\" \/><\/a><\/p>\n<p>In this example, we can see the unit, cost, price, and margin total for each category and the individual items on order.\u00a0<\/p>\n<p><strong>Group By Vendor, Start Date Purchase Basis<\/strong><\/p>\n<p>This example sorts by Vendor, including the day the PO was created and when the item(s) are expected to arrive.\u00a0<\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h07_37.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17185\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h07_37.png\" alt=\"\" width=\"1275\" height=\"932\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h07_37.png 1275w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h07_37-300x219.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h07_37-1024x749.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h07_37-768x561.png 768w\" sizes=\"auto, (max-width: 1275px) 100vw, 1275px\" \/><\/a><\/p>\n<p><strong>Group By Start Date, Start Date Purchase Basis<\/strong><\/p>\n<p><a href=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h50_55.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17186\" src=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h50_55.png\" alt=\"\" width=\"1288\" height=\"695\" srcset=\"https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h50_55.png 1288w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h50_55-300x162.png 300w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h50_55-1024x553.png 1024w, https:\/\/certek.com\/kb4\/wp-content\/uploads\/2022\/11\/2022-11-18_11h50_55-768x414.png 768w\" sizes=\"auto, (max-width: 1288px) 100vw, 1288px\" \/><\/a><\/p>\n<p>Here, Artisan sorted the on-order items by the date the purchase orders were created.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This report refers to all items on purchase orders within a specific date range (Artisan defaults this date range from your current date to the end of the year. Ex. November 17th, 2022-December 31, 2022). Though you can easily view any of your on order items here, this report is&#8230;<\/p>\n","protected":false},"author":17,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":"","_monsterinsights_skip_tracking":false,"footnotes":"","_members_access_role":[],"_members_access_error":""},"ht-kb-category":[337],"ht-kb-tag":[],"class_list":["post-17164","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-purchasing-reports"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/17164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/comments?post=17164"}],"version-history":[{"count":5,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/17164\/revisions"}],"predecessor-version":[{"id":17187,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/17164\/revisions\/17187"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=17164"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=17164"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=17164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}