Microsoft Great Plains itself in our case should be considered as a platform for light customization and modification. We\u0092ll describe industry requirements and the way them to be implemented in Great PlainsVariable Length Rolls. Usually, when you place and order through your supplier \u0096 there is no way to know exact length of the roll or bolt. It might have 75 yards or 80 yards \u0096 you typically know the average length, say 77 yards and this is why you know what to expect in yards if you purchase 10 boltsInventory in Yards. When you receive the roll \u0096 you need to place it into inventory in exact yards. Typical method is to assign lot number to the bolt and then associate the exact initial length in yards with this unique lot number. This is Great Plains Dexterity customization, which provides parallel unit of measure, associated with the lot numberLight Assembly. Bill of Materials would be probably too complex for cutting the fabric. This is why we suggest to deploy automatic inventory decrease and increase adjustments \u0096 you decrease number of yards in the roll and mattress woven fabric increase your finished good in the number of units assembledMeter \/ Yard challenge. If you purchase from the supplier in China, Mexico, South East Asia or Europe \u0096 they measure their rolls in meters, not yards \u0096 so you need to implement automatic unit of measure translation and conversion. You resolve this on the level of your EDI \u0096 electronic document interchangeCut-beds tracking to original roll. If you are assembling\/cutting something like billiard table beds \u0096 you would like them to be tracked to the original roll in the case of customer complaint. This means that you will have to assign the same or modified lot number to the cut-bedInventory Count. You need to track what is the current length of the bolt\/roll. This is realized via custom Dexterity table, having Item Number, Lot Number, Initial Length in Yards, Current Length in YardsCustomization Tools: Great Plains Dexterity \u0096 this is Great Plains Dynamics programming language and development environment; Modifier with VBA \u0096 will allow your modify Great Plains forms and attach VBA scripts to your custom buttons; SQL scripts and stored procedures \u0096 low level database programming, excellent for the professional with profound GP tables structure and data flow knowledge.Good luck with implementation, customization and integration and if you have issues or concerns \u0096 we are here to help!