{"id":21478,"date":"2020-12-29T13:57:22","date_gmt":"2020-12-29T13:57:22","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=21478"},"modified":"2020-12-29T13:58:09","modified_gmt":"2020-12-29T13:58:09","slug":"purchase-receipt-quantity-not-flowing-to-purchase-invoice-screen-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2020\/12\/29\/purchase-receipt-quantity-not-flowing-to-purchase-invoice-screen-in-sage-x3\/","title":{"rendered":"Purchase Receipt quantity not flowing to Purchase Invoice screen in Sage X3"},"content":{"rendered":"\n

In Sage X3<\/a>, we faced an issue for the Quantity not getting flown from Purchase Receipt to Purchase Invoice screen on the selection from the left list. As per the standard process, we create a Purchase order, and further we create a Purchase receipt using the same Purchase Order. Further, while creating the Purchase Invoice we select the respective Receipt which eventually flow the detail line data of the Receipt to Invoice screen which includes Product Code, Product description, UOM, Quantity, Gross price, etc. But here the quantity is not getting flowed from Receipt to Invoice screen.<\/p>\n\n\n\n

New Stuff:<\/strong> How to \u2018Close PO\u2019 programmatically using 4GL Script<\/a><\/p>\n\n\n\n

\"[Purchase<\/a><\/center>\n
[Purchase Receipt]<\/center><\/font>\n\n\n\n

As shown in above screenshot, we have created the Purchase receipt with quantity 10 for \u201cSASA001 \u2013 Test Supplier\u201d.<\/p>\n\n\n\n

\"[Purchase<\/a><\/center>\n
[Purchase Invoice \u2013 Quantity not flowing in Invoice screen]<\/center><\/font>\n\n\n\n

Now we will be creating a Purchase Invoice using the same supplier code and select the respective Receipt from the left list. As you can see in above screenshot, all the details are flowing properly in Purchase Invoice detail line except the quantity which did not flow on Invoice screen.<\/p>\n\n\n\n

Let\u2019s check the steps to solve above the issue.<\/p>\n\n\n\n

Navigate to Setup -> General Parameters -> Parameter Values. In Parameter values, expand the ACH Purchase field from the left list and select the folder. Here in the grid there is an option of INV \u2013 Invoicing rules. Click on the action button and select Details which will open the pop-up box as shown in below screenshot.<\/p>\n\n\n\n

\"[Parameter<\/a><\/center>\n
[Parameter Values]<\/center><\/font>\n\n\n\n

As you can see, the value for billable quantity is \u201cQty A\u201d. So this means only those Receipt quantities will be flowing in Invoice detail line whose Status is \u201cA\u201d. But as you can see in the first screenshot (Purchase Receipt), the status is \u201cQ\u201d in detail line so that is the reason the quantity did not flow in the Invoice screen. Here we will select from the finder which Invoice Quantity we need to select so that quantity will flow in the Invoice screen. Here there are three options, A (Allocate), Q (Quality) and R (Reject). As per the clients requirement we will select the Products whose status is either Allocated (A) or in Quality (Q) i.e. (Qty A+Q).<\/p>\n\n\n\n

\"[Selection<\/a><\/center>\n
[Selection of Quantity Status \u2013 A, Q, R]<\/center><\/font>\n\n\n\n

Now we will create the Purchase Invoice from the Receipt using same supplier code and now we will check the whether the quantity will flow in the Invoice or not.<\/p>\n\n\n\n

\"[Purchase<\/a><\/center>\n
[Purchase Invoice \u2013 Quantity flowing in Invoice screen]<\/center><\/font>\n\n\n\n

As you can see in the above screenshot, here the quantity 10 is flowing properly now in the Purchase Invoice detail line as it we changed the setting as per the requirement. So now here the Quantity is flowing properly from the Purchase Receipt screen to Purchase Invoice.<\/p>\n\n\n\n

About Us<\/strong><\/h2>\n\n\n\n

Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

Greytrix has some unique integration solutions developed for Sage CRM<\/a> with Sage ERPs namely Sage X3<\/a>, Sage Intacct<\/a>, Sage 100<\/a>, Sage 500<\/a>, and Sage 300<\/a>. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.<\/p>\n\n\n\n

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 \u2013 Sage CRM integration listed on Sage Marketplace<\/a> and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace<\/a>. The GUMU™ Cloud framework<\/a> by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n

For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

In Sage X3, we faced an issue for the Quantity not getting flown from Purchase Receipt to Purchase Invoice screen on the selection from the left list. As per the standard process, we create a Purchase order, and further we create a Purchase receipt using the same Purchase Order. Further, while creating the Purchase Invoice\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,8],"tags":[1145,1424,1564,1573,1590],"class_list":["post-21478","post","type-post","status-publish","format-standard","hentry","category-integration","category-sage-erp-x3","tag-left-list","tag-parameter-values","tag-purchase-invoice","tag-purchase-receipt","tag-quantity"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=21478"}],"version-history":[{"count":11,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21478\/revisions"}],"predecessor-version":[{"id":21504,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/21478\/revisions\/21504"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=21478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=21478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=21478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}