{"id":3,"date":"2019-04-26T18:00:20","date_gmt":"2019-04-26T23:00:20","guid":{"rendered":"http:\/\/www.iqaccountingsolutions.com\/blog\/?p=3"},"modified":"2019-07-24T15:05:47","modified_gmt":"2019-07-24T20:05:47","slug":"unit-of-measure-conversion-sage-50","status":"publish","type":"post","link":"https:\/\/www.iqaccountingsolutions.com\/blog\/unit-of-measure-conversion-sage-50\/","title":{"rendered":"UNIT OF MEASURE CONVERSIONS"},"content":{"rendered":"<p>Unit of measure conversions solve a huge problem for businesses that buy and sell their products in different units. For example, if your supplier only sells widgets in cases of 100, and you need 200 widgets, your purchase order needs to show a quantity of 2, not 200.\u00a0 But when you sell them, you want to sell them individually. So you need a quantity of 1 on your sales invoice to represent 1 widget, not one case of widgets. Fortunately, the unit of measure conversion feature (also referred to as multi-packs some places within Sage 50) does exactly that. This feature is available in Sage 50 Premium and Quantum, but not Pro.<\/p>\n<p>Here is how it works, for each inventory item, you can tell Sage 50 what you want to use for your stocking unit of measure (UOM), purchasing UOM, and sales UOM.\u00a0 The stocking UOM is important because that is the UOM that will be used for inventory reporting, and the purchasing and sales UOMs will both be expressed as multiples of the stocking UOM (thus the alternate term multi-pack). So the stocking UOM is the smallest unit in which you would handle the product. For example, if you only sell pencils by the box, then Box can be your stocking unit of measure. But if you will open those boxes and sell pencils individually, your stocking UOM needs to be Each.<\/p>\n<p>The first step is to tell Sage 50 how many stocking UOMs are in each purchasing or selling UOM. You do this by going to <em>Maintain<\/em> &gt; <em>Units\/Measures<\/em>. Like all other IDs in Sage 50, the <em>U\/M ID<\/em> has to be unique. A very simple example would be to enter BOX here. But since you probably get different size boxes for different products, you would probably use something like BOX-10 or BX-010 for a box of 10. Next enter a description. If you choose to show UOM on your invoices or other forms, the ID will show, not the description. Then enter the number of stocking units that make up one of this UOM. If you entered Box-10 for the ID, then you would enter 10 at <em>Number of Stocking Units<\/em>. Note that you can only enter whole numbers for the number of stocking units. You can set up as many different U\/M IDs as you need.<\/p>\n<p>Next, go to <em>Maintain<\/em> &gt; <em>Inventory Items<\/em>. Choose an item ID or create a new item, go to the Stocking U\/M field and enter a unit of measure.\u00a0 This should be the smallest unit in which you handle this item. It is usually not one of the IDs you set up in Maintain Units\/Measures.\u00a0 Then click the right arrow button next to Stocking U\/M. Check the box that says \u201cPurchase and sell in different quantities.\u201d Now you can choose which U\/M IDs you want to associate with this item. If you want Sage 50 to automatically use this UOM for purchases or sales, check the <em>Use As Default<\/em> box.\u00a0 If you don\u2019t check that box, Sage 50 will use the stocking UOM on sales and purchases, but the others will be available to choose from a list.<\/p>\n<p>While this is a very useful feature, I do need to point out one serious limitation that it has. In the <em>Maintain Units\/Measures<\/em> screen, when you enter the number of stocking units that make up a particular UOM, <u>you can&#8217;t enter decimals, only whole numbers<\/u>. That works fine for discrete items like pencils, but in real life not everything fits that model. For example, if your supplier sells an item by the meter but you sell it by the foot, there&#8217;s no stocking unit that allows you to define both a meter a foot as a whole number of stocking units. If you would like to see this changed, you can join in on <a href=\"https:\/\/iqaccountingsolutions.us2.list-manage.com\/track\/click?u=0b92990bba1267be26b8ca6db&amp;id=4054ef82be&amp;e=b0476d6293\">this conversation at Sage City<\/a>. The more people Sage hears from, the more likely they are to take action.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Unit of measure conversions allow you to buy, stock, and sell the same product in different units of measure.  So if you need to buy something by the case and sell if buy the each, this is the feature you have been looking for.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,3],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=3"}],"version-history":[{"count":22,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3\/revisions"}],"predecessor-version":[{"id":2416,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3\/revisions\/2416"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=3"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=3"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=3"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}