Prev: command button not opening related fields
Next: Design with no experience
From: Coco111 via AccessMonster.com on 14 Nov 2009 11:24
Thanks, Steve. Im a bit slow, but I try to visualize and try to follow your
step....coco111

Monkey Butler wrote:
>On Nov 12, 8:01 pm, "Coco111 via AccessMonster.com" <u56083(a)uwe>
>wrote:
>> Hi Jeff,
>>
>[quoted text clipped - 33 lines]
>> --
>> Message posted viahttp://www.accessmonster.com
>
>I deal with this as a routine part of our business. We pull hose off a
>large reel and add end fittings and sell it as an assembly, or pull a
>length of saw stock off of a roll and weld it into a band saw blade.
>
>You need to set up a unit of measure table
>
>tblItemUM
>ItemID UM UnitSize BaseUM
>----------------------------------------------------
>Hose1 IN 1 Y
>Hose1 FT 12 N
>Hose1 RL 250 N
>
>All inventory is controlled using the base unit but different
>transaction are processed using other UM's. For instance on hose the
>manufacturer wants us to order by the roll which is approximately 250
>feet long. But when we receive a roll it may be 256 feet long so the
>form for the receiving transaction displays feet which is entered as
>256 but when the RECEIVE command button is clicked we update the
>inventory using code as 256*[UnitSize]) or (256*12) = 3072 in.
>
>To sell the item by the piece which could be any length we do the
>following. First set up an inventory item call something like "Hose1/
>Cut to Length". Set up a table that in essense a bill of materials for
>your cut to lenght pieces.
>
>tblBOM
>ItemID ComponentItemId QtyPerItem ComponentUM
>---------------------------------------------------------------------------------------------------------
>Hose/Cut to Length Hose1 Null
>IN
>GardenHoseCTL Hose1 Null
>FT
>GardenHoseCTL CutCharge 1
>EA
>GardenHoseCTL BrassEndFitting 2 EA
>GardenHoseCTL SprayerNozzle 1 EA
>
>You never purchase or stock the item ABC1/Cut to Length. Say a
>customer wants 2 pieces 12'-6" long. You enter an oder for 2 EA ABC1/
>Cut to Lenght and design you system so that it automatically adds the
>item ABC1 as a seperate line as a component. The quantity per item is
>blank (null) so you enter 150 in. on the order. The price per each cut
>to length piece is a roll up of 150*price per inch. This method is
>very flexible in that it allows you do things like sell a made to
>order hose assembly. When someone adds a GarenHoseCTL to an order 4
>components are automatically added, the hose itself, a cutting charge,
>2 pieces of an end fitting, and 1 Sprayer Nozzle. Our BOM knows the
>each hose has two ends but that only one nox=zzle is required, and we
>get to add a CutCharge for our labor. Once again the hose quantity is
>blank and is filled in at order entry time. this way you can use the
>single BOM to create any number of different length hoses that you
>need.
>
>HTH
>
>Steve P.

--
Message posted via http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2
Prev: command button not opening related fields
Next: Design with no experience