{"id":7618,"date":"2014-05-27T10:22:05","date_gmt":"2014-05-27T10:22:05","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=7618"},"modified":"2014-05-27T10:22:05","modified_gmt":"2014-05-27T10:22:05","slug":"find-the-ar-items-sales-history","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/","title":{"rendered":"Find the A\/R items sales history"},"content":{"rendered":"<p style=\"text-align: justify\">How much items have we sold in the month of December? How much in February? Have we got any sales<b>\/<\/b>items returned? What are the actual cost and the margin factor after selling all these items? Can we check it monthly and half yearly? What is the last date of sale for an item? I am sure all these questions do come to your mind when you are about to check the items sales report related to accounts receivables. It is very important to your accounts receivables too.<\/p>\n<p style=\"text-align: justify\">What if you get the answers at one place?<\/p>\n<p style=\"text-align: justify\">By using SAGE 300 A\/R module, you will get to know your item sales history related to <b><i>Account Receivables<\/i><\/b>.<\/p>\n<p style=\"text-align: justify\"><span style=\"color: #993300\"><em><strong>The New Stuff\u00a0:<span style=\"color: #000000\"><a title=\"Sage 300 ERP Order Entry \u2013 All in One\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/sage-300-erp-order-entry-all-in-one\/\" target=\"_blank\">Sage 300 ERP Order Entry \u2013 All in One<\/a><br \/>\n<\/span><\/strong><\/em><\/span><\/p>\n<p style=\"text-align: justify\">Let\u2019s see how to get it:<\/p>\n<p style=\"text-align: justify\">Suppose you don\u2019t have any program for maintaining your inventory. You sell items on a continuous basis without entering the stock. You want to create an item and sell it. I know you don\u2019t want to wait but need a fast process to apply. Here comes the SAGE 300. There is a provision in SAGE 300 Accounts receivable module where you can create an item and sell it to your customer.<\/p>\n<p style=\"text-align: justify\">It delivers &#8211; Item Sales History Report<\/p>\n<p style=\"text-align: justify\">In SAGE 300, we can easily get the report list of sales activity for the items in your Accounts Receivable system. A user prints this report when there is a need to check on sales activity such as the most recent date that an item was sold, the quantity sold during a particular period, the number of sales returns or the profit margin for an item or items.<\/p>\n<p style=\"text-align: justify\"><b><i>A\/R \u2013 A\/R transaction reports \u2013 Item sales history.<\/i><\/b><\/p>\n<p style=\"text-align: justify\">Here in the form, you put the values \u201cfrom item no. to item no.\u201d and select the period. Click print to get the report. Wait a minute, before you click the print button; see the check box <b><i>\u201cinclude counts\u201d<\/i><\/b>. If you select \u201cinclude items\u201d, it will display the <b><i>total sales count values<\/i><\/b> of items. E.g. how many times the particular item was sold in that period?<\/p>\n<p style=\"text-align: justify\"><a title=\"Item Sales History Report\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png\" target=\"_blank\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter  wp-image-7619\" alt=\"AR Item Sales History Report\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png\" width=\"491\" height=\"276\" \/><\/a>Here you go, Item sales history for a particular period included total counts.<\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Item-sales-history.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter  wp-image-7631\" alt=\"Item sales history\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Item-sales-history.png\" width=\"491\" height=\"276\" \/><\/a><strong>Without include counts:<\/strong><\/p>\n<p style=\"text-align: justify\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Item-sales-history1.png\" target=\"_blank\"><img decoding=\"async\" class=\"aligncenter  wp-image-7632\" alt=\"Item sales history\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/Item-sales-history1.png\" width=\"491\" height=\"276\" \/><\/a>Let\u2019s take an example; Say we are into consulting of providing labour to customers. We recently provided 3 labours to a customer xyz. We set the cost as 100 USD for a labour and for customer it is 200USD. By doing this we will get actual costs, selling price and margin.<\/p>\n<p><b>\u00a0<\/b><b>What exactly information do you get on this report:<\/b><\/p>\n<ul>\n<li>The Sales Amount column lists the item price, multiplied by the quantity sold.<\/li>\n<\/ul>\n<ul>\n<li>The Sales Returns column lists the item price, multiplied by the quantity returned.<\/li>\n<\/ul>\n<ul>\n<li>The Actual Cost column lists the item cost, multiplied by the quantity sold.<\/li>\n<\/ul>\n<ul>\n<li>The Margin column lists the difference between the sales amount and the actual cost (usually the profit).<\/li>\n<\/ul>\n<ul>\n<li>The Margin Per cent is calculated by dividing the margin amount by the sales amount.<\/li>\n<\/ul>\n<p>So if you are planning to create items and sell it without maintaining a stock inventory and need a regular report for you\u2019re A\/R item sales, go for SAGE 300 A\/R module.<br \/>\n<strong>Also Read:<\/strong><br \/>\n<strong>1.<\/strong>\u00a0<a title=\"Features in Accounts Receivable Module of Sage 300 ERP 2012\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/03\/06\/new-features-in-accounts-receivable-module-of-sage-300-erp-2012\/\" target=\"_blank\">Features in Accounts Receivable Module of Sage 300 ERP 2012<\/a><br \/>\n<strong>2.<\/strong>\u00a0<a title=\"AR Revaluation Process in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/23\/ar-revaluation-process-in-sage-300-erp\/\" target=\"_blank\">AR Revaluation Process in Sage 300 ERP<\/a><br \/>\n<strong>3.<\/strong>\u00a0<a title=\"Payment Follow-up in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/17\/payment-follow-up-in-sage-300-erp\/\">Payment Follow-up in Sage 300 ERP<\/a><br \/>\n<strong>4.<\/strong>\u00a0<a title=\"National Accounts Management in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2012\/11\/14\/national-accounts-management-in-sage-300-erp\/\">National Accounts Management in Sage 300 ERP<\/a><br \/>\n<strong>5<\/strong>.\u00a0<a title=\"Account Receivable Transaction Reports in Sage 300 ERP\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2013\/05\/27\/account-receivable-transaction-reports-in-sage-300-erp\/\" target=\"_blank\">Account Receivable Transaction Reports in Sage 300 ERP<\/a><\/p>\n<p style=\"text-align: justify\">\n","protected":false},"excerpt":{"rendered":"<p>How much items have we sold in the month of December? How much in February? Have we got any sales\/items returned? What are the actual cost and the margin factor after selling all these items? Can we check it monthly and half yearly? What is the last date of sale for an item? I am\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[79,252,1414,2357],"class_list":["post-7618","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-accpac","tag-ar-items","tag-item-sales-history","tag-sage-300-erp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Find the A\/R items sales history - Sage 300 ERP \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Find the A\/R items sales history - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"How much items have we sold in the month of December? How much in February? Have we got any sales\/items returned? What are the actual cost and the margin factor after selling all these items? Can we check it monthly and half yearly? What is the last date of sale for an item? I am\u2026 Read More &raquo;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-27T10:22:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png\" \/>\n<meta name=\"author\" content=\"sage300\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sage300\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/\",\"name\":\"Find the A\/R items sales history - Sage 300 ERP \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png\",\"datePublished\":\"2014-05-27T10:22:05+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Find the A\/R items sales history\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\",\"name\":\"Sage 300 ERP \u2013 Tips, Tricks and Components\",\"description\":\"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! \",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\",\"name\":\"sage300\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"sage300\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Find the A\/R items sales history - Sage 300 ERP \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/","og_locale":"en_US","og_type":"article","og_title":"Find the A\/R items sales history - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"How much items have we sold in the month of December? How much in February? Have we got any sales\/items returned? What are the actual cost and the margin factor after selling all these items? Can we check it monthly and half yearly? What is the last date of sale for an item? I am\u2026 Read More &raquo;","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2014-05-27T10:22:05+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png","type":"","width":"","height":""}],"author":"sage300","twitter_card":"summary_large_image","twitter_misc":{"Written by":"sage300","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/","name":"Find the A\/R items sales history - Sage 300 ERP \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png","datePublished":"2014-05-27T10:22:05+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2014\/05\/AR-Item-Sales-History-Report.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2014\/05\/27\/find-the-ar-items-sales-history\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Find the A\/R items sales history"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/","name":"Sage 300 ERP \u2013 Tips, Tricks and Components","description":"Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We\u2019ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us! ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5","name":"sage300","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"sage300"},"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/author\/sageaccpac\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/7618","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/comments?post=7618"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/7618\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=7618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=7618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=7618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}