From a customer:
Q: On the Miscellaneous tab I put the following, thinking I would get twelve 1" diameter 21’ pieces of pipe...
Quantity: 12
PN: 00004DB110 (the part number for 1" schedule 40 domestic pipe)
Description: 1” diameter Dom Blk Sch 40 Pipe
...Thinking I would get 12-21’ pieces of pipe. However, the processed list only listed 12 FT of 1” pipe. Did I input this wrong or is this a glitch in the program?
A: The units for that item is set to 'FT' (for feet) in the Part Number (P/N) table. So, all quantities entered are assumed to be length based. If you need a count of items, then you need to set the units for the parts to 'EA' (for each).
Note: If you are pricing material with HydraLIST, the cost is based on the units. With the units set at FT the price is based on a foot of pipe. With the units set at EA, the price is based on the stock length of pipe (21', 24', 25', etc). The default database has both unit length and stock length part numbers created.
Furthermore, if the part number is used as a pipe type option for mains or lines then the units are required to be 'FT'. Many of our customers carry pipe in 21’ 24’ and 25’ lengths. When the mains and lines are entered, the appropriate pipe type is selected based on the pipe description which includes a stock length. Our default units are setup based on this use.
Below is an example where I first listed Schedule 40 Domestic pipe in the traditional Lines and Mains tabs, and also added pipe in Miscellaneous where the units were the default of 'FT'.
I then changed the units of the parts in my database to EA for the stock lengths of the pipe part numbers and processed the report again:
Before:
After:
Note that the last five items now report the units of EA as opposed to the default of FT.
How to change the units? Here is how:
1. In HydraLIST, pick the General Data button:
2. Put in the first few characters of the Part Number into the Search PN Mask field and pick Find. This will help you find the exact parts easier. In the example below, I put in 00004DB.
In this view you can see both the per unit length and stock length parts
3. In the Units field, simply double-click on the FT and type in EA. I did that on three diameters of pipe, below:
4. Pick the Save SpreadSheet button, then pick the Project Data button and your changes will be saved. Note that this means you will use a different part number for the stock (Miscellaneous) lengths as opposed to the by length pipes (Lines and Mains)
Comments