Inventory Assemblies

Previous  Top  Next

 

Menu Navigation

 

Lists ... Inventory ... Manufacturing ... Inventory Assemblies

 

 

About Assemblies

 

Inventory Assemblies are physical inventory items which are produced (assembled) from other items.  A Bill of Materials (BOM) is specified, denoting the quantity and standard costs of the raw materials and labor, which is used to produce the assembled item.  You can even specify the amount of scrap material which will be left over after assembly.  Assemblies can represent finished goods, ready for sale, or sub-assemblies which are used to produce other items.  Inventory assemblies contain similar settings as those contained in regular inventory items.

 

infoA distinction should be made between Inventory Assemblies and Kits.  Although both are made up of other inventory items, Assemblies are physical items which are actually recorded as manufactured via Work Receipts, and Kits are virtual items which represent the component items as a group for selling purposes only.

 

This feature requires activation in Setup Manufacturing.  Please note that this feature may not be included in your software license.

 

 

In this Topic

 

 

Related Topics

 

 

 

Field by Field Help - Inventory Assembly screen

 

View Activity Log

Click this button to view the activity log for this customer record, which denotes any changes made to any field in the record.

 

Attach documents to this record

Click this button to view or attach documents to this record in the Intellifile Explorer.

 

Statistics

Displays statistics for this item, maintained by the program.  Some of these values can be edited.

 

Recurring Item

If checked the item will be posted with start and end dates when a recurring transaction is generated for this item.  These values are used to compute unearned revenue.

 

Discontinued Item

If checked, this item will no longer be available for new transactions, and will be excluded from most lists.  The item, however, can still be used in transactions.

 

Automatically discontinue item when zero on hand

If checked, the program will automatically place the item on "discontinued" status when the quantity on hand reaches zero.  This is especially useful for items which will no longer be sold, but for which a quantity remains in stock.

 

Item on Hold

If checked, this item will temporarily not be available for new transactions.

 

bulbSuppose you have an item that is being recalled.  You can select "Item on Hold" to stop any and all transactions from involving that item.

 

 

Automatically duplicate this SKU for all other active locations

If checked, the program will automatically enter a duplicate of the new item being added for every active location in your company.  This allows for quicker data entry with less errors.

 

Stock Status

 

These fields contain the quantities of inventory for this SKU.

 

infoThe number of decimal places displayed in the stock status fields is determined by the quantity precision setting in Setup Inventory.

 

 

Quantity Available

Displays the current quantity that is available for sale.  It is found by subtracting the quantity held and quantity committed (S.O.) from the quantity on hand.

 

Quantity On Hand

Displays the on hand count of this item.

 

Quantity Held

If return processing is used, displays the current quantity held in return processing, items that have been returned but have not been processed.

 

Quantity Transfer Pending

Displays the total quantity awaiting transfer into the location denoted above.

 

Quantity Transfer Out

Displays the total quantity transferred out of the location denoted above, that has yet to be received by the receiving location.

 

Quantity Pending (P.O.)

Displays the total quantity of this item that is currently unreceived in open purchase orders.

 

Quantity Committed (W.O/S.O.)

Displays the total quantity of this item awaiting sales order fulfillment or work order fulfillment.

 

Reorder Point Quantity

Enter the quantity at which this item should be reordered.  This value is used on reports and for the AutoFill feature.

 

Minimum Quantity Level

Enter the lowest quantity of this item for this location.  This value is used on reports.

 

Maximum Quantity Level

Enter the highest quantity of this item for this location.  This value is used on reports and for the AutoFill feature.

 

BOM (Bill of Materials)

 

SKU Item

Enter or select (using the SKU Search button) the item to be included in this inventory assembly.

 

Description

Displays the long description of the item in supertrack inventory.

 

Quantity

Enter the quantity of this item used in this inventory assembly.

 

UM

Displays the inventory unit of measure for the selected item.

 

Cost

Displays the cost from the item's supertrack inventory record.

 

Scrap

Enter the percentage of scrap material left over after the product has been fully used to create the inventory assembly.

 

Start Date/Stop Date

Enter the dates upon which the item is included in the bill of materials.  Leave these fields blank if the item is always to be in the bill of materials for this inventory assembly.

 

Insert Item

Click this button to insert a new item into the bill of materials.

 

Delete Item

Click this button to delete the selected item from the bill of materials.

 

Detail

 

Department ID

Enter or select the department identification code applicable to this item.  Department codes are used to separate your inventory for analysis and reporting.

 

Category ID

Enter or select the category identification code applicable to the item.  Category codes are used to separate your inventory for analysis, reporting, and inventory counts.  This can also be used to copy some of your items from one location to another.

 

Warranty ID

Enter or select the identification code of the warranty applicable to the item.

 

Manufacturer ID

Enter or select the identification code of the manufacturer of the item.  Manufacturer codes are used to identify manufacturer information more quickly and easily as well as filtering items out for use in inventory count, and reporting.

 

Commission ID

Enter or select the identification code of the commission structure to be used for calculating the commission amounts for the sale of this item.

 

Ship Weight

Enter the weight of the item, per unit, for shipping purposes.  The ship weight is used in conjunction with the shipping methods to automatically calculate shipping charges, when applicable.

 

Net Weightgear

Enter the net weight of this item as it pertains to the calculation of tax by volume.

 

Bin Location 1, 2, 3

Enter a value that can be used to indicate an item's physical location, such as aisle number, shelf, or container number.  This is useful when attempting to locate an item for invoicing or inventory counts.  These values are optionally used for sorting inventory count reports.

 

User-Defined Field 1-5

Enter any user defined information in these fields, such as Manufacturer or Model Number.  The descriptions of the fields are dependent upon the template selected, and can be edited in the template record(s).

 

Full Size Image

Enter or select the file that contains a graphic representation of the item, such as a photograph or drawing.  This image can be in GIF, JPG or BMP format.  This value is used by the program to display an image of the item selected.

 

Thumbnail Image

Enter or select the file that contains a graphic representation of the item in thumbnail (miniature) format, similar to the full size image above.  This value is used by the program to display an image of the item selected.

 

Pricing

 

Average Cost

Displays the unit average price paid for the item.  This value is updated automatically as new transactions are made, but may be adjusted manually.  This value is used to record cost of goods sold and inventory reduction for tangible items on invoices entered, if the average costing method is chosen on this item.  This value may optionally be used to calculate price.  This field is not displayed for supertrack kinds of Expense and Supplies.  The number of decimal places displayed in this field is determined by the cost precision setting in Setup Inventory.

 

Unit Last Cost

The last price per unit paid for the item.  This value is updated automatically as new transactions are made, but may be adjusted manually.  This value is used to record cost of goods sold and inventory reduction for tangible items on invoices entered, if the last costing method is chosen on this item.  This value is optionally used to fill new transactions.  This field is displayed only for supertrack kinds of Tangible and Intangible.  The number of decimal places displayed in this field is determined by the cost precision setting in Setup Inventory.

 

Lowest Selling Price

The lowest sale price for this item.  The program can optionally disallow any entered price that is less than this set price.  This field is displayed only for supertrack kinds of Tangible, Intangible, and Kit.

 

Latest Cost

The last price paid for the item.  This value is updated automatically as new transactions are made, but may be adjusted manually. This value is optionally used to fill new transactions.  This field is displayed only for supertrack kinds of Expense and Supplies.  The number of decimal places displayed in this field is determined by the cost precision setting in Setup Inventory.

 

Promotion Plan Id

Enter or select a promotion plan ID to apply to this item.  Based on the value present, a promotional discount will be applied to automatically adjust pricing for this item when entered on a transaction.  This value can be set for multiple items using the global price change feature.

 

Suggested Retail Price

Enter the retail price for this item.  This value is optionally displayed on labels and screens.

 

Web Sale Price

Enter the selling price of the item on the company website.  This value is used for e-commerce functions.

 

Price Calculation

Select the method by which the program should calculate the price of the item.

 

Markup PercentageApplies to standard and price break pricing.  Defined as the profit divided by the cost of the item.  Markup% = 100 × (Sale Price - Latest Cost) / (Latest Cost).  Has no maximum.  Enter the percent or actual value for each standard price.  Enter the percentage for each tier.

 

Margin PercentageApplies to standard and price break pricing.  Defined as the profit divided by the sale price of the item.  Margin% = 100 × (Sale Price - Latest Cost) / (Sale Price).  Has a maximum of 910.99%.  Enter the percent or actual value for each standard price.  Enter the percentage for each tier.

 

Fixed PercentageApplies to price break pricing only.  Enter the percentage in decimal format BY which to change the price for each tier (e.g. a 5.00% price decrease is entered as 5.00).

 

Reduction AmountApplies to price break pricing only.  Enter a flat amount BY which to reduce the price for each tier (e.g. a 5.00 price decrease is entered as 5.00).

 

Fixed PriceApplies to price break pricing only.  Enter a flat amount TO which to set the price for each tier.

 

Price Rounding

Select the rounding method to use.

 

Not RoundedDo not adjust the value.

 

to the Nearest AmountAdjust the decimal value of the price to the amount provided.

 

Ending with NumberAdjust the decimal value of the price to end with the number provided.

 

Price Adjustment

Enter the value used with the price rounding calculation.

 

SKU Base Price

Enter the base price for each price level.  This value may be automatically filled based on the markup/margin calculation.

 

Markup/Margin Calculation

If either of these price calculation methods are used, enter or select the percent to use for each price level.

 

Allow price break discount on base price

If checked, will allow the user to enter discounted prices/percentages based on the quantity of an item.

 

Taxes

 

Calculate Invoices for this item with {Tax Type}

If checked, this item will be included in tax calculation for the tax type on sale transactions.

 

Accounting

 

Income GL Account/Expense GL Account

The GL account to be credited for sale transactions and debited for purchase transactions.

 

Cost of Goods GL Account

The GL account to be debited for the cost of sale transactions.

 

Inventory/Expense GL Account

The GL account to be credited for the cost of sale transactions, debited for purchase transactions, and adjusted by inventory transactions.

 

Adjustment GL Account

The GL account to be debited for a decrease adjustment, credited for an increase adjustment.

 

Scrap GL Account

The GL account to be credited for scrap or shrinkage due to use of most of a product but not all (scrap).

 

Variance GL Account

The GL Account to be credited or debited when a difference exists between the expected amount of a product used to manufacture another and the actual amount.

 

Notes

 

Internal Notes

Enter notes about this item that will only be seen by users of the program.

 

Transaction Item Notes

Enter notes about this item that will be printed on transactions directly below the associated item.  This value may be optionally overridden on selected transactions.

 

Web

 

Post SKU to Internet

Check this box to post this item to your shopping cart should you wish to separate uploadable items from those that should not be uploaded.

 

Web Featured Item

Check this box to set this item as a featured item within the Comersus shopping cart software, where it will appear on the front page of your shopping cart website.  It can additionally be used as a query option in other shopping cart software packages as well.

 

Web Sales Information

Enter any notes or text to display on the website about the item.  This text can contain HTML tags.

 

Preview HTML

Click this button to see what the text will look like on the Web, if HTML tags are used.

 

Web Profile

Select or add a new web profile to assign to this inventory item.  This will categorize your item within the shopping cart software you want to use.  You can add or otherwise view a list of web profiles by clicking on the lookup button at the end of the field.

 

Web Keywords

Enter keywords with which you item can be found in a search on your shopping cart website.

 

Web Sale Price

Enter the selling price of the item on the company website.

 

Image

 

Full Size Image

Enter or select the file that contains a graphic representation of the item, such as a photograph or drawing.  This image can be in GIF, JPG or BMP format.  This value is used by the program to display an image of the item selected.

 

Thumbnail Image

Enter or select the file that contains a graphic representation of the item in thumbnail (miniature) format, similar to the full size image above.  This value is used by the program to display an image of the item selected.

 

 

Unit Measure

 

Purchase Units of Measure

Enter or select the unit of measure used on purchase transactions.  The quantity from the unit of measure chosen will be multiplied by the transaction quantity to determine the actual unit effect.

 

Sale Unit of Measure

Enter or select the unit of measure used on sale transactions.  The quantity from the unit of measure chosen will be multiplied by the transaction quantity to determine the actual unit effect.

 

Inventory Unit of Measure

Enter or select the unit of measure used to display the quantity counts on this inventory item.  This unit of measure will be displayed in the appropriate column on inventory transfers and inventory adjustments.

 

 

 

Q & A - Inventory Assemblies

 

Q01.I don't see my question here.  Where else can I get information?


© 2015 - Intellisoft Solutions, Inc. All rights reserved.
Other Related Links
  Business Software | Cellular Software | Pager Software | Business Management Software