MenusSQL > Parts/Raw Materials
Entry window for fabrics, zippers, buttons, expenses, anything that contributes to the manufacture of the product
The Raw Materials Code fields allow entry of any upper case characters or numbers, but no spaces.
Do not use spaces, dashes or slashes.
The dash is reserved to separate the color code.
We recommend you use the following structure. Build the code from General to specific.
Part Style
1. Start all fabrics with F, zippers with Z, Buttons with B, Labels with L, etc.
When FINDING a part code you will be able to quickly list all fabrics by finding on “F”.
2. Second character, or second and more, will be more specific. Such as FK for Fabric, Knit, or FD for Fabric, Denim.
3. As the code moves to the right, get more specific.
Part Color
4. Example: RED, BLU, WHT, BLK
Fabric, Knit, Red = FK-RED
Fabric, Knit, Blue = FK-BLU
12″ White Zippers = Z12-WHT
Option to setup Color Codes to provide consistency: Inventory > Color Codes
The decision of the coding should be based on the ease of FINDING a code during data entry.
Modified by AG, 6-3-26