Inventory Setup

The Inventory Setup page allows you to view and edit information related to the inventoried product. Many of the fields available on this page are part of the new inventoried product creation wizard. The fields that display on this page will depend on the whether the product is an Individual or Standing Order product.

For more information on the fields available on this page, please see the table below.

Page Element	Description
Inventoried	Toggle. This indicates that this is an inventoried product and it is selected by default. A non-inventoried product is when an order entry screen does not validate that available inventory exists for the product (i.e., it is considered always in stock). Non-inventoried products do not have inventory or cost of goods accounts. A non-inventoried product that is not connected to a warehouse will default to preshipped and therefore will not be picked up by the INV620.  If you want the INV620 process to pick up a non-inventoried product, you need to assign it to a bin of a warehouse and then the status will default to not fulfilled instead. For more information on non-inventoried warehouses, please see Inventory Locations.
Allow Back Order	Toggle. This indicates that any order can be placed for an out of stock inventoried product. This checkbox should NOT be selected if the Inventoried checkbox is not selected. If this toggle is set to No, the "Display Out-of-Stock on Web" toggle will be disabled on the eBusiness Control screen. If the product has been set up to display on the web, is out of stock (Available quantity defined on the Inventory screen = 0), the Pre-Order Available date is today or a day in the future, and this toggle is set to Yes, the "PRE-ORDER AVAILABLE" product alert will display on the Product Listing and Product Detail pages on the web for this product. If the web user purchases this product, the system will create a back-order. If the product has been set up to display on the web, is out of stock (Available quantity defined on the Inventory screen = 0), the Pre-Order Available date is not set or set to a date in the past, and this toggle is set to Yes, the "BACKORDER AVAILABLE" product alert will display on the Product Listing and Product Detail pages on the web for this product. If the web user purchases this product, the system will create a back-order. Additionally, the Place Back Order button will display on the product detail page on the web for this product. If the product is out of stock (Available quantity defined on the Inventory screen = 0), this toggle is set to No, and the Display Out-of-Stock on Web toggle is set to Yes on the eBusiness Control screen, the "OUT OF STOCK" product alert will display on the Product Listing and Product Detail pages on the web for this product.
Is a Donation	Toggle. When set to Yes, indicates that when you purchase this inventoried product, it will count as a donation. The amount paid for the product is included in the giving analysis and recognition. When set to No, indicates this product is not related to fundraising or donations. If this toggle is set to Yes, when an order is paid for this product, a record will be created for the customer on the Credit Transactions tab in Donor Central. The amount will be the price of the product minus the Fair Market Value.
Eligible for Free Shipping	Toggle. When set to Yes, indicates that this product is eligible for free shipping. Only order line amounts for products eligible for free shipping will be included when evaluating whether the order qualifies for free shipping. If this toggle is set to Yes and the product has a surcharge, then only the surcharge will be charged. If this toggle is set to No and the product has a surcharge, then both the regular shipping fee and the surcharge shipping fee will be charged. INV900 does NOT give free shipping on standing order lines. Therefore, it is NOT recommended that you check this checkbox for Standing Order products.
Returnable	Toggle. This indicates that customers can return the product.
Unit Weight	Text box. The weight per unit and is optionally used in shipping calculations. This field is a numeric value only and is not specific to any measuring system such as metric.
Unit Measure	Drop-down. The measuring unit used, such as pounds, ounces, etc. This value is for informational purposes only and is not used in any calculation of price or shipping. Values in the drop-down are populated based on the non-fixed codes defined for the ORD "UNIT_OF_MEASURE" system type.
Quantity	Text box. The number of units per product. For example, if the product is a box of pencils containing 10 pencils, the quantity would be 10. This value is for information purposes only and does not affect the number On the Shelf.
ISBN	Text box. This is the International Standard Book Number (ISBN) for the product. It is the unique ten-digit numerical identification assigned to books, pamphlets, educational kits, microforms, CD-ROMs, and braille publications. If the product has been defined to display on the web and a valid ISBN number is entered here, the Google Preview button will display on the product detail page on the web, as shown below. The system will pass this ISBN number to Google's book preview utility to display a preview to the web user. If an invalid ISBN number is entered, the ISBN number will still display on the product detail page, but the Google Preview button will NOT display. Google Books respects the user's local copyright restrictions, and as a result, previews or full views of some books are not available in all locations. For more information, please see https://developers.google.com/books/docs/dynamic-links#terminology.
Cost Method	Drop-down. This indicates how costing of inventory is calculated. Values include: Manual Average Cost The user enters an amount in the Average Unit Cost field and nothing is done on receipt of inventory. If someone enters a price when receipting in inventory, it will not affect the unit cost. If this option is selected, the average cost will NOT be recalculated on inventory adjustment even if the Recalculate Cost on Inventory Adjustment checkbox is selected. Calculated Average Cost When the receipt of inventory is done, the system automatically recalculates average cost based on the amount recorded with the receipt. If this option is selected, the Average Unit Cost field will be disabled and is automatically calculated on receipt of inventory. Formula: [(current quantity on hand * current average cost) + (quantity added  * cost per unit items added) ] / new total quantity = new average cost If this option is selected and the Recalculate Cost on Inventory Adjustment checkbox is NOT selected, the average cost will NOT be calculated on inventory adjustment. Values in the drop-down are populated based on the fixed codes defined for the INV "COST_METHOD" system type.
Average Unit Cost	Text box. The average cost per unit. If this cost is zero and the Cost Method selected is Manual Average Cost, then no cost accounting will be performed in Personify. For example: An association buys 10 hats at $5 each. The total Inventory cost = 10 * $5 = $50. The Average cost = $50 / 10 = $5. Now the association again buys 100 hats at $10 each. The total Inventory cost =100 * $10 = $1000 The Average cost = $1000 / 100 = $10. Scenario 1: Inventory is received in warehouse Total Inv Qty Received = 10 + 100 = 110 Total Inv Cost = $50 + $1000 = $1050 Average Cost = Total Inv Cost/Total Inv Qty = $1050 / 110 = $9.54 Scenario 2: Inventory adjustment, such as damaged inventory Damaged Qty =10 Average Cost = Total Inv Cost/Total Inv Qty = $1050 / (110 - 10)= $10.50
Cost Calc Date	Drop-down. This is the date the cost of the product was last  calculated.
Pre-Order Available	Drop-down. This date indicates when the product is available to be pre-ordered. If the product has been set up to display on the web, is out of stock (Available quantity defined on the Inventory screen = 0), the Pre-Order Available date is today or a day in the future, and the Allow Back Order toggle is set to Yes, the "PRE-ORDER AVAILABLE" product alert will display on the Product Listing and Product Detail pages on the web for this product. This field has no effect on the order fulfillment status. If the web user purchases this product, the system will create a back-order.
Last Sold	Read-only. The last date the product was sold.
YTD Sold Quantity	Read-only. The number of products sold for the year-to-date. This number is automatically updated when orders are created, shipped, cancelled, returned, and deleted.
Total Sold Quantity	Read-only. The number of products sold altogether. This includes all products sold for every year.
Next Inventory Arrival	Drop-down. Select the date the next inventory will arrive. This date will display on the Product Detail page on the web when the inventory is out of stock and the Add to Cart button is not displayed.
Reorder Quantity	Text box. The number that should be reordered when a reorder is required. The Low Inventory notification will be sent out to staff when the number On the Shelf reaches the Reorder Quantity defined here. This field is only enabled when the Product Type is Individual Product.
Reorder Level	Text box. The total number in inventory at which point the product should be included in the INV500 – Product Inventory reorder report. This value is for informational purposes only. You can use this field for a notification to be sent to the inventoried product manager when the inventory reaches the reorder level. This field is only enabled when the Product Type is Individual Product.
Inventory Account	Allows the user to select which account is to be defined as the inventory account. This field is only displayed for inventoried INV Products only.
Cost of Goods Account	Allows the user to select which account will be the expense account for the product. This field is only displayed for inventoried INV Products only.
Preferred Vendor	This field allows you to specify the preferred vendor for the product. This field is displayed for Individual Products only.
Pricing Method	Drop-down. The method used for pricing for Standing Order Products only. This field will NOT be displayed for Individual Products. The values are populated based on the fixed Pricing_Method system type for the ORD subsystem. The available values are: Product Only All pricing and accounting is performed from the standing order product. Component Only All pricing and accounting is performed from each component product. By default, the Order_Detail.ALLOW_PAYMENT_FLAG is set to N when a standing order product is defined to have pricing calculated at the component level. If the "Component Only" option is selected, please note that the system will NOT automatically charge the customer's credit card each time a standing order component becomes available. Therefore, you must send an invoice to collect the credit card payment when the component becomes available.