{"id":12462,"date":"2015-08-27T09:19:22","date_gmt":"2015-08-27T09:19:22","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=12462"},"modified":"2015-08-27T09:19:22","modified_gmt":"2015-08-27T09:19:22","slug":"ic-item-valuation-report-in-sage-300","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/","title":{"rendered":"IC Item Valuation Report in Sage 300"},"content":{"rendered":"

In Sage 300, there are many useful inventory reports that help to manage the inventory efficiently. In our today\u2019s blog we will discuss about the IC Item Valuation Report in Sage 300.<\/strong>
\nIC valuation report is a very important when users want to know quantities on hand, calculated for the items, locations, costs, or optional amounts. IC item valuation report also provides an option to print the report summary wise and detail wise for separate location, Item by location, Consolidate location. User can also find out the costing of the inventory in four different methods so this becomes very important as far as the user is concerned.
\nNew Stuff : <\/em><\/strong>Manage AP Vendor and Vendor group Statistics in Sage 300 ERP<\/a><\/span>
\nTo print the Item Valuation report:
\nOpen Inventory control–> IC stock Control Reports–> Item valuation
\n\"66666666666666666\"<\/a>
\nIn IC valuation report there are basically 2 reports one is \u201cLocation detail costs<\/strong>\u201d to find the costing of the inventory on the basis of different locations and \u201cTransaction Cost\u201d<\/strong> which gives the cost of the inventory in four different costing methods. To print the report first have to select one type of valuation report.
\nLocation Detail Costs:<\/strong>– To print the current value of your inventory using all data stored in costing buckets.
\nTransaction Costs:<\/strong>– To print all transactions and item costs for the period you specify (from receipts, shipments, transfers).
\nThere are different filters available on the UI as follows:
\n\u2022 Select Transactions by Cutoff Date or Fiscal Year\/Period.
\n\u2022 Print Transaction Details
\n\u2022 Include Quantities and Costs- ALL\/Only positive\/ only negative\/only zero \/ non zero
\n\u2022 From and to Account Set
\n\u2022 From and to Location
\n\u2022 Sort by- select from drop down list
\n\u2022 Select up to 4 Costing Methods for Valuation
\nBefore printing the report, the user has to select sub report type option from drop down list, depending on options selected, the report will show the summary or detail wise data. Following are the options in the drop down.
\n1. Print Separate Locations in Detail:<\/strong>– If the user selects this option, the report includes item number, description, and quantity on hand, stocking Unit and selected valuation for costing method.
\n2. Print Separate Locations in Summary:<\/strong>– If the user selects this option, the report include location code and location description and totals for all items at the location Unit and selected valuation for costing method.
\n3. Print Items by Location in Detail<\/strong>:- If the user selects this option, the report include costing method, average unit value, location, totals for all items and Unit and selected valuation for costing method.
\n4. Print Items by Location in Summary:<\/strong>– If the user selects this option, the report includes the totals for all items on the report.
\n5. Print Consolidated Locations in Detail:<\/strong>– If the user selects this option, the report includes the item number, description, and costing method for each item across all locations.
\n6. Print Consolidated Locations in Summary:<\/strong>– If the user selects this option, the report consists of a single line showing the total costs for all inventory items included in the range of items and locations you select.
\n7.Transaction Costs:<\/strong>– If the user selects this option, the report include item number and respective transaction, item\u00a0 description, location code and discretion, stocking Unit and selected valuation for costing method.
\nThus, IC Valuation report will give a detailed information regards to the inventory in term of cost and quantity in detail as well as in summary format.
\nAlso Read:<\/span> <\/em><\/strong>
\n1.Stock summary Report<\/a>
\n2.Stock Status Report in Sage 300 ERP<\/a>
\n3.Raw Material Purchase Report<\/a>
\n4.Customized Stock Transfer<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage 300, there are many useful inventory reports that help to manage the inventory efficiently. In our today\u2019s blog we will discuss about the IC Item Valuation Report in Sage 300. IC valuation report is a very important when users want to know quantities on hand, calculated for the items, locations, costs, or optional\u2026 Read More »<\/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":[1234,1249,1341,2357],"class_list":["post-12462","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-ic-item-valuation-report","tag-ic-reports","tag-inventory-control","tag-sage-300-erp"],"yoast_head":"\nIC Item Valuation Report in Sage 300 - 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\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"IC Item Valuation Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"In Sage 300, there are many useful inventory reports that help to manage the inventory efficiently. In our today\u2019s blog we will discuss about the IC Item Valuation Report in Sage 300. IC valuation report is a very important when users want to know quantities on hand, calculated for the items, locations, costs, or optional\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-27T09:19:22+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/66666666666666666.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\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/\",\"name\":\"IC Item Valuation Report in Sage 300 - 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\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/66666666666666666.png\",\"datePublished\":\"2015-08-27T09:19:22+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/66666666666666666.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/66666666666666666.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"IC Item Valuation Report in Sage 300\"}]},{\"@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":"IC Item Valuation Report in Sage 300 - 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\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/","og_locale":"en_US","og_type":"article","og_title":"IC Item Valuation Report in Sage 300 - Sage 300 ERP \u2013 Tips, Tricks and Components","og_description":"In Sage 300, there are many useful inventory reports that help to manage the inventory efficiently. In our today\u2019s blog we will discuss about the IC Item Valuation Report in Sage 300. IC valuation report is a very important when users want to know quantities on hand, calculated for the items, locations, costs, or optional\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2015-08-27T09:19:22+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/66666666666666666.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\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/","name":"IC Item Valuation Report in Sage 300 - 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\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/66666666666666666.png","datePublished":"2015-08-27T09:19:22+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/66666666666666666.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2015\/08\/66666666666666666.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2015\/08\/27\/ic-item-valuation-report-in-sage-300\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"IC Item Valuation Report in Sage 300"}]},{"@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\/12462","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=12462"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/12462\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=12462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=12462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=12462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}