beckket
Member
Looking for guidance on setting up Inventory for a Cable company.
1. The Cable company buys inventory in Reels, which consists of a certain number of Feet:
1 Reel = 150FT
2. When they install the cable, they install a certain number of Drops which could be of any Footage,
depending on where the Drop is to be made:
1 Drop = 50 FT, another time 1 Drop = 25 FT, another time 1 Drop = 300 FT
3. Need to setup Advance Sales Pricing which is based on the Number of Drops and the Footage.
At the time a Sales Order is placed, the Number of Drops is known, but the Footage is unknown.
If 1 Drop is made, up to 150FT, the price charged is $200
If 1 Drop is made, up to 225FT, the price charged is $190
If 2 - 15 Drops are made, up to 150FT, the price charged is $175
If 2 - 15 Drops are made, up to 225FT, the price charged is $155
In setting up Advance Pricing, are Drops the Quantity Break or is it Footage? If Drops are the Quantity Break, where is the Footage taken into consideration? Is the Footage component best handled through a User Defined Field, e.g. Line of Business, End Use, Price Code 1, 2, or 3, which is part of an Order Detail group.
4. What are the Priamry, Purchasing, and Pricing UOM?
Any assistance would be greatly appreciated.
1. The Cable company buys inventory in Reels, which consists of a certain number of Feet:
1 Reel = 150FT
2. When they install the cable, they install a certain number of Drops which could be of any Footage,
depending on where the Drop is to be made:
1 Drop = 50 FT, another time 1 Drop = 25 FT, another time 1 Drop = 300 FT
3. Need to setup Advance Sales Pricing which is based on the Number of Drops and the Footage.
At the time a Sales Order is placed, the Number of Drops is known, but the Footage is unknown.
If 1 Drop is made, up to 150FT, the price charged is $200
If 1 Drop is made, up to 225FT, the price charged is $190
If 2 - 15 Drops are made, up to 150FT, the price charged is $175
If 2 - 15 Drops are made, up to 225FT, the price charged is $155
In setting up Advance Pricing, are Drops the Quantity Break or is it Footage? If Drops are the Quantity Break, where is the Footage taken into consideration? Is the Footage component best handled through a User Defined Field, e.g. Line of Business, End Use, Price Code 1, 2, or 3, which is part of an Order Detail group.
4. What are the Priamry, Purchasing, and Pricing UOM?
Any assistance would be greatly appreciated.