{"id":18946,"date":"2018-05-22T06:47:18","date_gmt":"2018-05-22T06:47:18","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/?p=18946"},"modified":"2024-03-27T06:14:53","modified_gmt":"2024-03-27T06:14:53","slug":"18946","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/","title":{"rendered":"Spend &#8211; item Details Report"},"content":{"rendered":"<p>Use the Receipt Entry screen to:<\/p>\n<ul>\n<li>Enter receipts of goods into Purchase Orders\u2014for inventory or non-inventory items. Edit existing receipts.<\/li>\n<li>Enter or change the vendor address information.<\/li>\n<li>Enter additional costs for receipts (from primary or secondary vendors).<\/li>\n<li>Invoice receipts and additional costs.<\/li>\n<li>Identify items as fixed assets for management by Sage Fixed Assets.<\/li>\n<li>Specify drop-ship addresses for receipt details.<\/li>\n<li>Check and edit tax distributions by detail line and for the primary and secondary vendors.<\/li>\n<li>Import and export receipts.<\/li>\n<li>Assign serial numbers to serialized items (if you use Serialized Inventory and Lot Tracking).<\/li>\n<li>Assign lot numbers to lotted items (if you use Serialized Inventory and Lot Tracking).<\/li>\n<\/ul>\n<p><strong>New Stuff:-\u00a0<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/18\/deduction-and-remittance-report-is-now-on-posting-date\/\" target=\"_blank\" rel=\"noopener noreferrer\">Deduction And Remittance Report is now on Posting date<\/a><\/strong><br \/>\nIn this blog, we will discussed how to export PO receipt data with detail level item, Purchase Order number with Receipt created against same and item details<br \/>\nWe have developed a report and user interface to print this report. The data will be display in Excel format (refer below the screen)<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-18947\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.png\" alt=\"\" width=\"400\" height=\"137\" \/><\/a><br \/>\nAfter clicking on the export button, System will generate a report as shown below (refer below screen<br \/>\n<a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/2-3.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"aligncenter wp-image-18948 size-full\" src=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/2-3.png\" alt=\"\" width=\"1119\" height=\"53\" \/><\/a><br \/>\nDate will be display as per selected Receipt date filter<br \/>\n<strong>LOCATION:<\/strong><strong>&#8211;\u00a0<\/strong>PO Receipt detail-level Location code<br \/>\n<strong>ACCOUNT SET:-\u00a0<\/strong>Account set field of selected item<br \/>\n<strong>CATEGORY:-\u00a0<\/strong>CATEGORY field of selected item<br \/>\n<strong>RECEIPT DATE:-\u00a0<\/strong>Receipt date field<br \/>\n<strong>PO NUMBER:-\u00a0<\/strong>Detail level Po number item wise<br \/>\n<strong>PO DATE :-\u00a0<\/strong>Detail level Po number Date<br \/>\n<strong>LEAD TIME:- <\/strong>Difference in PO Date and Receipt date (will be days in number)<br \/>\n<strong>RECEIPT NUMBER:-<\/strong>Receipt number field<br \/>\n<strong>UOM :-\u00a0<\/strong>UOM field<br \/>\n<strong>RECEIPT QTY<\/strong>:-Qty Received field<br \/>\n<strong>RECEIPT COST (SOURCE):-<\/strong>Extended cost field value should be display in Vendor Currency<br \/>\n<strong>RECEIPT COST (FUCT):-<\/strong>Extended cost field value should be display in Functional<br \/>\n<strong>EXTENDED WT:-<\/strong>Extended weight<br \/>\n<strong>PRODUCT CODE:-<\/strong>Item Number field<br \/>\n<strong>PRODUCT NAME:-<\/strong>Item Description field<br \/>\n<strong>UNIT WT:-<\/strong>UNIT weight field<br \/>\n<strong>VENDOR CODE:-<\/strong>Vendor number field<br \/>\n<strong>VENDOR CODE: &#8211;\u00a0<\/strong>Vendor name field<br \/>\n<strong><u>About Us<\/u><\/strong><br \/>\nGreytrix is a one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.<br \/>\n<a href=\"http:\/\/www.greytrix.com\/\">Greytrix<\/a>\u00a0has unique solutions of\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-crm\/gumu-sage-300-erp-integration\">Sage 300 integration with Sage CRM,<\/a>\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-300-erp\/gumu-300-salesforce-integration\">Salesforce.com\u00a0<\/a>and\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/sage-300-erp\/ecommerce-magento-integration\">Magento eCommerce<\/a>. We have the migration expertise of Sage 300 Migration from <a href=\"https:\/\/www.greytrix.com\/Greytrixpdf\/sage-erp-crm-integration-and-migration.pdf\">Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/a>. We work on the latest Sage 300c technologies and offer best-in-class\u00a0<a href=\"http:\/\/www.greytrix.com\/product\/erp-development\/sage-300-erp-development\">Sage 300 | Sage 300c customization and development services<\/a>.\u00a0 This include upgrading old codes, creating new web screens, delivering new reporting tools like Sage Intelligence, PowerBI and SAP BO to Sage business partners, end users and Sage PSG worldwide.<br \/>\nFor more details on Sage 300 | Sage 300c Services, please contact us at\u00a0<a href=\"mailto:accpac@greytrix.com\">accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use the Receipt Entry screen to: Enter receipts of goods into Purchase Orders\u2014for inventory or non-inventory items. Edit existing receipts. Enter or change the vendor address information. Enter additional costs for receipts (from primary or secondary vendors). Invoice receipts and additional costs. Identify items as fixed assets for management by Sage Fixed Assets. Specify drop-ship\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/\">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":[776,1394,1423,2225,2724,2725],"class_list":["post-18946","post","type-post","status-publish","format-standard","hentry","category-sage-accpac","tag-details","tag-item","tag-item-wise","tag-report","tag-spend","tag-spend-report"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Spend - item details report.<\/title>\n<meta name=\"description\" content=\"We will discuss how to export PO receipt data with detail level item, purchase order number with receipt created against it, and item information.\" \/>\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\/2018\/05\/22\/18946\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Spend - item details report.\" \/>\n<meta property=\"og:description\" content=\"We will discuss how to export PO receipt data with detail level item, purchase order number with receipt created against it, and item information.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage 300 ERP \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-22T06:47:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-27T06:14:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.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\/2018\/05\/22\/18946\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/\",\"name\":\"Spend - item details report.\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.png\",\"datePublished\":\"2018-05-22T06:47:18+00:00\",\"dateModified\":\"2024-03-27T06:14:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5\"},\"description\":\"We will discuss how to export PO receipt data with detail level item, purchase order number with receipt created against it, and item information.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#primaryimage\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.png\",\"contentUrl\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Spend &#8211; item Details Report\"}]},{\"@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":"Spend - item details report.","description":"We will discuss how to export PO receipt data with detail level item, purchase order number with receipt created against it, and item information.","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\/2018\/05\/22\/18946\/","og_locale":"en_US","og_type":"article","og_title":"Spend - item details report.","og_description":"We will discuss how to export PO receipt data with detail level item, purchase order number with receipt created against it, and item information.","og_url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/","og_site_name":"Sage 300 ERP \u2013 Tips, Tricks and Components","article_published_time":"2018-05-22T06:47:18+00:00","article_modified_time":"2024-03-27T06:14:53+00:00","og_image":[{"url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.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\/2018\/05\/22\/18946\/","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/","name":"Spend - item details report.","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#primaryimage"},"thumbnailUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.png","datePublished":"2018-05-22T06:47:18+00:00","dateModified":"2024-03-27T06:14:53+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/#\/schema\/person\/1aced4e22c30ccf606960de27c9542f5"},"description":"We will discuss how to export PO receipt data with detail level item, purchase order number with receipt created against it, and item information.","breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#primaryimage","url":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.png","contentUrl":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2018\/05\/1-6.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/2018\/05\/22\/18946\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/"},{"@type":"ListItem","position":2,"name":"Spend &#8211; item Details Report"}]},{"@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\/18946","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=18946"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/18946\/revisions"}],"predecessor-version":[{"id":33988,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/posts\/18946\/revisions\/33988"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/media?parent=18946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/categories?post=18946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-json\/wp\/v2\/tags?post=18946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}