How to Set Up Wire in Inventory

How to Set Up Wire in Inventory

When setting up Wire as a Part you need to first figure out how it will be purchased (100ft Box, 1000ft Box, etc.) and then if it will be inventoried and issued by the Foot or by the Box.  Once you know that information then you can set up the Part.  

Inventory – Part Setup

Scenario 1 - Wire - Qty Box of 100ft

Purchased in 100ft Box for a total of 250 per box.
Inventoried and Issued per Foot.
Therefore this would be considered a Qty of "100" since it is purchased and sold at different amounts. 

Under the Vendor Tab the Qty would be entered as "100" and the Purchase Cost would be $250. 

Under the Warehouse Tab the Standard Cost would be $2.50 - since the Qty was entered at 100 then the Cost per 1 Foot would be $2.50. 

When creating a PO, you would enter how many boxes of Wire you need - not how many feet.

Example: You need to order 500ft. and it is sold in a box of 100 ft but sold/inventoried per foot.
For the PO you would enter the Qty as 5 which would be received as 500 ft.

When issuing to a job or a ticket, enter how many feet you are selling. Because you entered a qty of 100 per box, the system knows that when you enter a qty on a PO it is by box, and when you enter a qty on a ticket/job it is by feet.

Scenario 2 - Wire Qty 1
Purchased in 100ft Box
Inventoried and Issued as 100ft Box 
Therefore this would be considered a Qty of "1" since it is purchased and sold as the same Qty of "1".

Under the Vendor Tab the Qty would be entered as "1" and the Purchase Cost would be $250.  Purchase Cost is always the amount for the entire purchase of that Part regardless of Qty entered. 

Under the Warehouse Tab the Standard Cost would be $250. 

When creating a PO, you would enter how many boxes of Wire you need - since it is purchased/inventoried/sold as a qty of 1.  Likewise it will be issued by the box on jobs and service tickets.