Description | | How To |
---|
Create Inventory UOM | | Go to Inventory > Inventory UOM |
| | Click New toolbar button to add inventory UOM. |
| | Add Stock UOM. Example: pound - Enter Unit Measure, Symbol and Unit Type.
- Click Save.
![](/download/attachments/20316665/image2015-6-10%2017%3A37%3A44.png?version=1&modificationDate=1433929099377&api=v2)
Note: Stock UOM is the basis of conversion to other UOMs. |
| | Click New toolbar button to add another inventory UOM. |
| | Add Other UOM - 5-lb bag - Enter Unit Measure, Symbol.
- Select Packed in the Unit Type field.
- In the Other UOM field select the Stock UOM, in our example pound.
- In the Conversion To field enter how many pounds in a 5-lb bag.
- Click Save.
![](/download/attachments/20316665/image2015-6-10%2017%3A44%3A9.png?version=1&modificationDate=1433929484737&api=v2)
|
| | Click New toolbar button to add another inventory UOM. |
| | Add Other UOM - 10-lb bag - Enter Unit Measure and Symbol.
- Select Packed in the Unit Type field.
- In the Other UOM field select the Stock UOM, in our example pound.
- In the Conversion To field enter how many pounds in a 5-lb bag.
![](/download/attachments/20316665/image2015-6-10%2017%3A48%3A40.png?version=1&modificationDate=1433929755170&api=v2)
|
Create Pricing Level | | Go to Common Info > Company Locations |
| | In a selected Company Location go to Pricing tab. |
| | Add Pricing. - In the Name field enter a name for the pricing.
- As soon as Name is added, Level field will automatically be filled with a number.
![](/download/attachments/20316665/image2015-6-11%2011%3A20%3A56.png?version=1&modificationDate=1433992890370&api=v2)
|
Create Sub Location | | Go to Common Info > Company Locations |
| | In a selected Company Location go to Sub Location tab. |
| | Add Sub Location. ![](/download/attachments/20316665/image2015-6-10%2017%3A58%3A28.png?version=1&modificationDate=1433930343550&api=v2)
|
Create Storage Unit | | Go to Inventory > Storage Unit Types |
| | Click New toolbar button to add Storage Unit. |
| | Add a Storage Unit Type. - Enter the Name and Description.
- In the Internal Code field select what this bin is for.
- Select the Capacity UOM.
- Enter Max Weight for the storage unit type.
- Fill in other information you feel necessary.
- Click Save and Close.
![](/download/attachments/20316665/image2015-6-10%2017%3A50%3A9.png?version=1&modificationDate=1433929844807&api=v2)
|
Create Storage Locations | | Go to Inventory > Storage Locations |
| | Click New toolbar button to add Storage Location. |
| | Add Storage Location. - Enter Name and Description.
- Select Storage Unit Type.
- Select Location.
- Select Sub Location
- Fill in other information you feel necessary.
- Click Save and close.
![](/download/attachments/20316665/image2015-6-10%2019%3A2%3A36.png?version=1&modificationDate=1433934191397&api=v2)
|
Create item | Item is lot tracked - yes - serial number | Go to Inventory > Items |
| | Click New toolbar button to add Item. |
| | Add new item. - Enter Item No and Description.
- In the Type field select the item type. In this example, let's use Inventory.
- In the Lot Tracking field select Yes - Serial Number
Add Unit of Measure for the item. - Click Insert button.
- Select the Stock UOM, in this example: pound, and check the Stock Unit checkbox.
- Select Other UOMs.
Notice that as you add other UOMs, the Unit Qty is automatically updated with the converted qty. That is why it is recommended that you setup your Inventory UOMs properly so that when you add it to your item, the system will calculate/convert it for you. This will save you extra step with entering/converting the qty per uom added. ![](/download/attachments/20316665/image2015-6-11%2010%3A46%3A26.png?version=1&modificationDate=1433990819977&api=v2)
|
| | Add Location/s for the item. - Locations are where the items are physically stored.
- Go to Setup tab > Location tab.
- Click Insert button.
![](/download/attachments/20316665/image2015-6-11%2010%3A45%3A30.png?version=1&modificationDate=1433990764613&api=v2)
- Select the location.
- In the Costing Method field select the costing method for the item.
- Select the Sub Location.
- Select the Storage Location.
- In the Issue UOM field select the default UOM for the item when creating Sales Order, Quote, Invoice and Inventory Shipment.
- In the Receive UOM select the default UOM for the item when creating Purchase Order, Bill and Inventory Receipt.
- Fill in all other information you feel necessary.
- Click Save and Close.
![](/download/attachments/20316665/image2015-6-11%2010%3A44%3A43.png?version=1&modificationDate=1433990716797&api=v2)
|
| | Add GL Account defaults for the item. - GL Account defaults are accounts defined to automatically assign Account Ids to a transaction then is being used when posting transactions to the General Ledger Detail.
- Go to Setup tab > GL Accounts tab.
- Click Insert button.
- Select Account Category and assign Account Id for that category.
Note: The following Account Categories are required based on transaction you create.- Inventory Receipt
- Inventory account category
- AP Clearing account category
- Inventory Shipment
- Inventory In-Transit account category
- Inventory account category
- Invoice
- Cost of Goods Sold account category
- Inventory In-Transit account category
- Sales account category
![](/download/attachments/20316665/image2015-6-11%2010%3A47%3A37.png?version=1&modificationDate=1433990890787&api=v2)
Also, for the Account Id to be selected, you will have to assign the Account Category to the Account ID. ![](/download/attachments/20316665/image2015-6-11%2010%3A57%3A4.png?version=1&modificationDate=1433991458500&api=v2)
|
| | Add Pricing for the item. - Pricing may vary by location that is why pricing information can be setup per location.
- Go to Pricing tab.
- Select a Location
- Enter Last Cost. If this is a new item entry, then it is recommended to enter a value the same with Standard Cost. This field will be updated by the cost of the item when received.
- Enter Standard Cost.
- Select a Pricing Method.
- Enter Amount/Percent based on selected Pricing Method.
- Retail Price will then be updated with a price based on Standard/Last Cost, Pricing Method and Amount/Percent.
- Enter MSRP.
Image Added
|
| | Add Pricing Level for the item. - Pricing Level is used to setup Pricing for the item that is off by a certain percentage/amount of the Retail Price. This is a pricing scheme to attract customers from purchasing items in volume/bulk. The more they purchase, the more they get a bigger discount.
- Go to Pricing tab > Pricing Level.
- Select Location.
- Select Price Level.
- Select UOM.
- Enter Min and Max qty.
- Select Pricing Method.
- Enter Amount/Percent based on selected Pricing Method.
- Unit Price will then be updated with a price based on Retail Price (if UOM selected is not Stock UOM, then Retail Price is converted on that Other UOM), Pricing Method and Amount/Percent.
- In the Commission On field select where to base the commission.
- In the Comm Amount/Percent enter the commission amount or percentage.
- Click Save and Close.
![](/download/attachments/20316665/image2015-6-11%2011%3A32%3A41.png?version=1&modificationDate=1433993595350&api=v2)
|
Use Item in a transaction | | |
Create Inventory Receipt | | |
| Create Inventory Receipt directly | Go to Inventory > Inventory Receipts |
| | Click New toolbar button to add Inventory Receipt. |
| | Add Inventory Receipt. - In the Receipt Type select Direct.
- In the Vendor ID field select a vendor.
- Select a Location.
- Fill in other information you feel necessary.
- In the grid select item/s.
- In the Item No. field select the item.
- The Receipt UOM field will be defaulted to the UOM set in the Item Location > Receive UOM. Change this as necessary.
- Enter Qty to Receive.
- Select Lot Wgt UOM.
- The Cost field will show the Last Cost entered for the item.
- Select a Sub Location to where the item will be placed when received.
- Highlight the item. The Lot Tracking grid will be shown.
- Leave Lot Number field blank. Lot Number will be automatically generated for item that is Lot Tracked - Yes-Serial Number.
- Select Lot UOM.
- In the Quantity field enter the Quantity to be received and press enter.
- Enter Tare value if there is. The Net will automatically be computed.
- Enter Expiry Date.
- Select Storage Location.
- Click Receive toolbar button to receive the items.
Notice that Lot Numbers are assigned for each line item in the Lot Tracking grid. Image Added
The Lot Number generated is from Starting Numbers screen setup. Image Added
|
| Create PO and Process it to Inventory Receipt | Go to Purchasing > Purchase Orders |
| | Click New toolbar button to add Purchase Order. |
| | Add Purchase Order - In the Vendor ID field select a vendor.
- Select a Location.
- In the Ship To field select a Location where to receive the item.
- Fill in other information you feel necessary.
- In the grid select the item to order.
- In the Item No. field select the item.
- The UOM field will be defaulted to the UOM set in the Item Location > Receive UOM. Change this as necessary.
- The Cost field will show the Last Cost entered for the item.
Image Added
- Click Process toolbar button to process the Purchase Order to Inventory Receipt.
- In the Inventory Receipt screen > Item grid
- Enter Qty to Receive.
- Select Lot Wgt UOM.
- Select a Sub Location to where the item will be placed when received.
- Highlight the item. The Lot Tracking grid will be shown.
- Select Lot UOM.
- In the Quantity field enter the Quantity to be received and press enter.
- Enter Tare value if there is. The Net will automatically be computed.
- Enter Expiry Date.
- Select Storage Location.
- Click Receive toolbar button to receive the items.
Notice that Lot Numbers are assigned for each line item in the Lot Tracking grid. Image Added
|
| Create Purchase Receipt and pull it from Inventory Receipt | Go to Purchasing > Purchase Orders |
| | Click New toolbar button to add Purchase Order. |
| | Add Purchase Order - In the Receipt Type select Purchase Order.
- In the Vendor ID field select a vendor.
- Select a Location.
- In the Ship To field select a Location where to receive the item.
- Fill in other information you feel necessary.
- In the grid select the item.
- In the Item No. field select the item.
- The UOM field will be defaulted to the UOM set in the Item Location > Receive UOM. Change this as necessary.
- The Cost field will show the Last Cost entered for the item.
- Click Save and Close.
Image Added
|
| | Go to Inventory > Inventory Receipts |
| | Click New toolbar button to add Inventory Receipt. |
| | Add Inventory Receipt. - In the Receipt Type select Purchase Order.
- In the Vendor ID field select a vendor.
- Select a Location.
- Fill in other information you feel necessary.
- In the grid select item/s.
- In the Order Number field select the Purchase Order created.
- In the Item No. field select the item.
- The Receipt UOM field will be defaulted to the UOM set in the Item Location > Receive UOM. Change this as necessary.
- Enter Qty to Receive.
- Select Lot Wgt UOM.
- The Cost field will show the Last Cost entered for the item.
- Select a Sub Location to where the item will be placed when received.
- Highlight the item. The Lot Tracking grid will be shown.
- Leave Lot Number field blank. Lot Number will be automatically generated for item that is Lot Tracked - Yes-Serial Number.
- Select Lot UOM.
- In the Quantity field enter the Quantity to be received and press enter.
- Enter Tare value if there is. The Net will automatically be computed.
- Enter Expiry Date.
- Select Storage Location.
- Click Receive toolbar button to receive the items.
Click Process toolbar button to process the Purchase Order to Inventory Receipt. - In the Inventory Receipt screen > Item grid
- Enter Qty to Receive.
- Select Lot Wgt UOM.
- Select a Sub Location to where the item will be placed when received.
- Highlight the item. The Lot Tracking grid will be shown.
- Select Lot UOM.
- In the Quantity field enter the Quantity to be received and press enter.
- Enter Tare value if there is. The Net will automatically be computed.
- Enter Expiry Date.
- Select Storage Location.
- Click Receive toolbar button to receive the items.
Notice that Lot Numbers are assigned for each line item in the Lot Tracking grid. Image Added
|
| | |