{"id":16239,"date":"2022-09-15T13:16:09","date_gmt":"2022-09-15T17:16:09","guid":{"rendered":"https:\/\/certek.com\/kb4\/?p=16239"},"modified":"2023-06-16T11:33:34","modified_gmt":"2023-06-16T15:33:34","slug":"item-trend-report","status":"publish","type":"ht_kb","link":"https:\/\/certek.com\/kb4\/knowledge-base\/item-trend-report\/","title":{"rendered":"Item Trend Report"},"content":{"rendered":"\n

The Item Trend report shows how items have performed within a year. This is especially helpful when identifying which months sold the most items, and what items sold specifically.\u00a0<\/p>\n

\n

Accessing the Report<\/h3>\n

There are two ways you can access this report.\u00a0<\/p>\n

Click on \u201cReports<\/strong>,\u201d \u201cMerchandising Reports<\/strong>,\u201d and \u201cItem Trend Report<\/strong>\u201d from the toolbar.<\/p>\n

\"\"<\/a><\/p>\n

Or, click on the \u201cReports<\/strong>\u201d button on the \u201cMain Menu<\/strong>.\u201d<\/p>\n

\"\"<\/a><\/p>\n

Next, click on \u201cMerchandising Reports<\/strong>.\u201d<\/p>\n

\"\"<\/a><\/p>\n

Then, select \u201cItem Trend Report.<\/b>\u201d<\/p>\n

\"\"<\/a><\/p>\n

Either way, you\u2019ll end up at the following screen. This screen will default to preset fields, and the date range will automatically default to your current month and day.<\/p>\n

\"\"<\/a><\/p>\n

However, you may adjust the fields as necessary. You can also save these adjustments and set them to automatically appear the next time you open the report by selecting \u201cSave as Defaults for this Report (except dates).\u201d<\/strong><\/p>\n

\"\"<\/a><\/p>\n

This report might be multiple pages depending on the size of your inventory. Keep this in mind if you are going to print the report.<\/p>\n

\n

Setting Up Your Report<\/h3>\n

Show Subtotals Only:\u00a0<\/strong>Selecting \u201cYes<\/strong>\u201d will only include units sold in your current date range and your current QOH.<\/p>\n

Group By:\u00a0<\/strong>This controls how Artisan will sort your report. For example, if you choose Category Tree, Artisan will sort each section alphabetically by category.\u00a0<\/p>\n

2nd Group By:\u00a0<\/strong>If you want to further filter how Artisan organizes this report, select either by Category Tree or Vendor Code.<\/p>\n

Sort By:\u00a0<\/strong>Determine how you want individual items listed (ex. Item Code).\u00a0<\/p>\n

Selected Sales Date Range:\u00a0<\/strong>Enter the range you want data pulled from for this report.<\/p>\n

You may further filter this report to include only specific items, descriptions, vendors, vendor purchase numbers, item keywords, and categories. Simply type in the item code, description, vendor code, etc or use the magnifying glass to locate them.<\/p>\n

There are other fields to the right of this section to include and exclude other items by discontinued, variants, consignment, non-inventory, out-of-stock, and other options.<\/p>\n

Price Range:\u00a0<\/strong>Leave as-is to use the default amounts or enter a specific price range.<\/p>\n

Unit Cost Range:\u00a0<\/strong>Leave as-is to use the default amounts or enter a specific Unit Cost Range.<\/p>\n

\n

Example Report<\/h3>\n

\"\"<\/a><\/p>\n

Click image to enlarge<\/em><\/p>\n

RCV: This row represents the quantity received into Artisan within the specified date range. For example, in January 2021, we received two butterfly paintings.\u00a0<\/p>\n

SAL: This row represents the quantity sold of each item within the specified date range. For example, in January 2021, we sold three butterfly paintings.<\/p>\n

Due: If any items are currently on order, the quantity will show here.<\/p>\n

QOH: The current amount of this item you have in stock.<\/p>\n","protected":false},"excerpt":{"rendered":"

The Item Trend report shows how items have performed within a year. This is especially helpful when identifying which months sold the most items, and what items sold specifically.\u00a0 Accessing the Report There are two ways you can access this report.\u00a0 Click on \u201cReports,\u201d \u201cMerchandising Reports,\u201d and \u201cItem Trend Report\u201d…<\/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":[334],"ht-kb-tag":[],"class_list":["post-16239","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-merchandising-reports"],"_links":{"self":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16239","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=16239"}],"version-history":[{"count":11,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16239\/revisions"}],"predecessor-version":[{"id":19908,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb\/16239\/revisions\/19908"}],"wp:attachment":[{"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/media?parent=16239"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-category?post=16239"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/certek.com\/kb4\/wp-json\/wp\/v2\/ht-kb-tag?post=16239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}