Goods purchased/sold by linear foot with serial number management?

[Former Member]

Client purchases rolls of goods, cuts them down, and sells the pieces. Rolls have same width, but can be of varying length. Pricing is by linear foot.

Consider rolls of cloth. Say roll is always 3 feet wide, but can be any length. Roll purchase price and selling price is based on linear feet.

Purchase 1 roll, 3 feet wide by 20 feet long @$1.00/linear foot, $20.00

Sell roll in cut pieces to different customers. Pieces are cut 3 feet wide by x feet long @ $2.00/linear foot till roll is gone.

If I create an item, 'Roll1', based on a linear foot unit of measure, and manage it with serial numbers, then when I receive my 20 foot roll, I need 20 serial numbers. I want one serial number for per roll.

If I create an item 'Roll2', with roll as the basic unit of measure, and manage it with serial numbers, I can't cut it down and sell it in pieces.

Is there a way to take advange of serial number mangement to track the rolls, maybe using bills of material? Is there an addon that does this?

TIA

[Former Member]

Neither Batch nor serial number may help you in the case you present. You could probably use an UDF to record the identified roll numbers on each lines on the marketing document and use query to get the inventory status of the rolls.

Thanks,

Gordon

[Former Member]

Hi

Instead of serial No. why don't you try with BATCH wise.

hope it helps

Ashish Gupte

[Former Member]

I played with batches and it gives the same results as serial. 20 linear feet received, sold, etc. need 20 batch numbers.

My error.

If I add the right quantity to the batch, I think batching gets me most of what i want.

Edited by: Cindy Lange on Jul 21, 2009 1:48 PM

[former_member204969]

The natural solution is using batches.

A roll can be a batch, the quantity is its length.