Accounting Seed uses the salesforce product object as the product master. All the fields and objects needed to manage products are either on the product object itself or can be seen as a related list on the product.
Setting Up an Inventoried Product
The following fields should be completed if the product is used on Accounting Seed Order Management:
Revenue GL Account - The revenue GL account for the product will automatically populate on the billing line if it is set on the salesforce product.
General Ledger Account Variables 1-4 - If populated on the Product record, they will automatically flow through to the Billing Line, Sales Order Line, Purchase Order Line, and Account Payable Line. These values can then be edited if necessary on the specific line items. This provides a consistent, easy way to achieve your accounting for your products.
Expense GL Account - The expense GL account is only used if product costing is enabled on the accounting settings tab. If product costing is enabled then expense GL account is debited when the product is sold via the posting of a billing. For more information on the debits and credits behind product transactions, please see the Debits and Credits knowledge article.
Inventory GL Account - The inventory GL account is used in the accounting of all inventory movements in Accounting Seed ERP. If product costing is enabled on the accounting settings tab, then the inventory GL account is credited when the product is sold via the posting of a billing. For more information on the debits and credits behind product transactions please see the Debits and Credits knowledge article.
Inventory Product - Inventory product means that this product can be stocked in a warehouse and warehouse location. This field must be checked to in order to allocate the product from inventory stock or receive the product into inventory stock.
Inventory Type - The following values are available for selection of inventory type:
Purchased - If the inventory type is set as purchased for a product, then the product will be available to use in the Sales Order to Purchase Order function. When a billing line with a purchased product is posted, the standard cost of the purchase product will be recognized.
Manufactured - If an item is marked as manufactured, it will not be available to purchase via the "purchase order fulfill" function on the sales order list view. When a billing line with a manufactured product is posted, the standard cost will be recognized of the manufactured product.
Kit - Kits are simply a way to group products for purposes of selling them as a single unit in an opportunity or billing. A product can be sold by itself or bundled together in a kit. When creating a sales order from an opportunity with a kit as one of the opportunity products, the product parts of the kit will each be passed as separate line items to the sales order. Product parts will be passed into the sales order from the opportunity with a unit price of zero. The kit product itself will be passed into the sales order, with the price entered on the opportunity product line. When a kit is billed, the cost of its product parts at standard cost will be recognized when the billing transaction is posted. Please see the product parts section below for setting up kit components as product parts.
Raw Material - Raw materials should not be used on the opportunity product or sales order line. The way to exclude raw materials from the opportunity is to not list them in any price books. Raw materials should only be a part of a bill of material for a manufactured product. Raw materials can be purchased through the purchase order fulfillment process from the list view of the project object.
Product Parts - Product parts should show as a related list on the product object page layout. If the product parts list is absent from the page layout simply add it by adjusting the page layout. Product parts are kit components if the inventory type is "Kit," they are the bill of materials if the inventory type is marked "manufacturing." To create a new product part click the "New Product Part" button on the product part related list. Select the product, which is a component to the kit or manufacturing bill of material as well as the quantity per one kit or manufactured product.
Default Vendor - Default vendor is used in the purchase order fulfillment process. When you generate purchase orders from sales orders, the default vendor listed on the product will default in the create draft purchase order screen.
Serialized - If the product is checked true for serialized, an individual record will be inserted for each inventory movement. This allows the user to record an individual serial number for each inventory movement and inventory movements are also required to be entered as whole numbers.
If a product is not checked true for serialized, then a single inventory record is inserted for movements regardless of the quantity of inventory moved.
Sales Order Exclude - To prevent a kit or the product part of a kit from passing into the sales order as a line, check the "Sales Order Exclude" option on the product. This will prevent the kit or any part of a kit from passing to the sales order.
- For example, if you have sold a customer Kit ABC which contains products A, B and C, and you want only products A, B and C to pass to the sales order, then check the sales order exclude option on the kit and do not check the "Sales Order Exclude" options on products A, B and C.
- A second example would be if you have a non-inventoried part such as a warranty shipping charge, or installation service that is sold as part of a kit but has no physical inventory fulfillment, you may want to exclude it from the sales order. You can do so by clicking the "Sales Order Exclude" option on the product part.
Inventory Asset - If a product is checked true for inventory asset, an asset record will be inserted when the serial number is updated on the sales order inventory movement for that particular sales order line. The asset record can be found under the account object as a native salesforce object.
Lead time - Lead time is the amount of time in days it takes for a product to arrive at the distribution/manufacturing site. It is used in the purchase order fulfillment process as a metric to assist in procurement timing.
Manufacturing Order Template - The manufacturing order template is the project template used for a manufacturing work order. It also contains the bill of labor for a manufactured product. The "manufacturing order template" field needs to be completed for each product that is marked as a manufactured product. More information is available in the manufacturing section of the help guide.
Unit Cost - Unit cost is the standard cost for a purchased or manufactured product. It is important to make sure any Unit Cost value is entered in the base currency of your organization. Unit cost should not be changed without considering the effect on inventory movements in process, or the value of inventory on the balance sheet. Please see the inventory revaluation section of the help guide before changing the value of unit cost on an inventory asset.
Minimum Order Quantity - Minimum order quantity is the least amount of units that can be ordered in a single order from a vendor. It is used as a reference field in the purchase order fulfillment process for both purchase products and raw materials.
Safety Stock Quantity - Safety stock quantity is the minimum amount of inventory that you would like to keep on hand. It can be freight purchased, raw materials, or manufactured product. It is used in the purchase order fulfillment process for both purchase products and raw materials.