Search results

No he doesn't rattle off part numbers in that way... Think of the part number as the same as job name. They are umbrellas for the whole group of line items. the line item is each joint of pipe. So when the customer calls he will say "I am sending you 1,000 joints, part number 10002121" I...

Customer calls us to sort through pipe, itemize, inspect, tally, and store the equipment. We unload the pipe lay it out and record the information in my spreadsheet. we inspect each joint and record the tally, once completed we move the joints to a rack location for storage. I then send a...

Thank you all for your responses. Below is a sample of information from 2 jobs on an excel type spread sheet. each line represents 1 joint. So for this example, I have got 2 jobs Shell ex, and Exxon W1 2 part numbers 129001, and 10221. 10 total joints of pipe. The combination of joint heat lot...

I need to create an inventory database that will track customer owned inventory as it is received stored serviced and sent back to my customer. I am in the oil and gas industry and store large amounts of customer owned pipe. many joints will have the same part number but each joint is one of a...