Creating New Inventory Fields Explained
Main Area
1.Buy
Items or services you want to include on an item purchase order.
This includes items that are not for resale, such as items for office use only. It can also include raw materials you use as components to build other inventory items.
2.Sell
Items or services you want to include on an item invoice.
3.Inventoried
Items user buys or sells and whose quantity and values user wants to track. It can also include intermediate goods used in the productions process, such as parts used to manufacture finished goods.
Maintaining an accurate record of on-hand levels of these items requires user to do regular maintenance tasks. For example, user needs to record inventory adjustments to write-off damaged items or to record a stock-take.
Rule 1: If user ticks Buy check-box, the purchase information section will be enabled, if user un-ticks buy check-box the purchase information will be disabled.
Rule 2: if user ticks Sell check-box, the sales information section will be enabled, if user un-ticks sell check-box the sales information will disabled.
Rule 3: if user ticks Inventoried check-box, the Inventory and Purchase check-box section will be enabled, if user un-ticks Inventoried check-box, the inventory section will be disabled.
Rule 4: If user tries to edit item after it has been created, such as un-tick the Buy or Sell or Inventory check-box, system will check whether there is any transaction connected with this item or not. If yes, then a pop up reminder of “This Item has linked with Transactions, you cannot change Item type.” will appear and changes will not be saved. If there is no transaction connected, then edit is allowed to be saved.
If the item has invoices associated with it, the system will not allow you to change the ‘Is Inventoried’ status.
Rule 5: A reminder list will pop up if the user misses a mandatory field after clicking Save button.
4.Inventory Name/Number: this is the item name shown in all transaction and list.
5.Category of: user can choose which category this inventory is belonged to. It is a mandatory field before save.
6.Supplier Part Number: This will record supplier’s part number if it’s needed.
Buying Information
7.Description field will auto load in the purchase transactions if the user is creating any transactions connected with this inventory.
8.Purchase Price is the standard cost as the default price on purchases.
9.Default is 2 decimal places, but user can input maximum 6 decimal place numbers. This amount is default as tax inclusive.
10.Expense Account/COGS Account is the account “Enter the account to use for tracking the costs of producing or purchasing this item. (Required option *)
Only Expense Account, Other Expense Account and Cost of Sales account will show up on the account list. If the user didn't tick the Inventory check-box, then the Expense Account will be display as an Expense Account, otherwise, it shows up as a COGS Account.
11.Tax code is the tax code user assigned to purchase transaction (required option *). It will only pop up purchase type tax code.
12.Primary Supplier: User can choose primary supplier for each item, which is an optional field, not mandatory.
13.Min Qty for Restocking:
Selling information
13.Description on Sales Transaction: this will show in the sales transactions, which will auto load when the user selects the stock item.
14.Sales Price by default is set to display 2 decimal places, but the user can input a maximum 6 decimal place numbers. Sales price could be auto loaded when the user selects an item in sales, and the amount is excluding tax by default. Multi-inventory price level has been introduced in Q6, which has been explained in detail in this link
15.Income account: select the account to be used for recording income from the sale of this item.
16.Only Income Account, Other Income Account will show in the pop up account list.
17.Tax code is the tax code user selected to be auto load in any sales transaction (required option *). It will only pop up sales type tax code.
Inventory information
18.Inventory Account: select an account to be used for recording the on-hand value of this item. Only Asset Account type (Bank card, Current Asset, Non-Current Asset)
19.Liability Account Type (Current Liability, Non-Current Liability) and Equity Account Type will show up in this account list.
20.Quantity on Hand is the total number of inventory-keeping units that are physically located in the warehouse location at the current time. This includes items that are already allocated to fulfilling production needs or sales orders. So, this number may differ from the quantity available total. (This is a read-only label)
21.Current Value is the subtotal amount (excluding tax) of this inventory in Purchase Open and Close Bill plus the value of adjusted inventory, minus any value on Debit notes and Sales Invoices, and minus Return Stock value on Credit Notes and value on quantity requested in Build Inventory.
22.Average cost = Current Value / Quantity on Hand. (This is a read-only label)
22.Committed = Sum of sales order (order status) (This is a read-only label)
23.On Purchase Order = Sum of Purchase Order (order status) (This is a read-only label)
24.Available is the total quantity of inventory-keeping units that are currently available for use in filling a new order internally or externally for purposes such as production or distribution. This quantity does not include inventories that are already allocated to other orders or inventories that are in transit from a supplier. (This is a read-only label)
Please keep in mind, the amount in above six fields should be calculated automatically through the transaction saved, instead of modifying manually, which will only be calculated for inventory item.
|