REQUIREMENTS
- Knot & Co. seeks to implement an automatic generation feature for the item Name/Number on the item record when creating new records. This functionality will streamline the process by automatically generating a unique and appropriate item Name/Number for each new record.
- Knot & Co. requires the automatic population of attribute values based on the selected Design number within the item record. This feature will streamline the process by populating the relevant attributes corresponding to the Design number chosen by the user.
- Knot & Co. intends to develop a Price Calculation that should display the cost of rugs based on their design and size and other variants in the item record.
DELIVERABLES
- We will auto-generate the item numbers in a sequential order while creating the item record.
- To add/ Adjust the Design number, we will establish the custom record and will proceed by creating essential dropdown fields within this record, including Collection, Design, Country, Quality, Pile/Content, Background color, Border color, and more.
- To streamline the process, we will implement customization that automatically populates the design number attributes based on the selected Design number on the item record. Additionally, we will establish the item’s display name/code to be identical to the design number for consistency and clarity.
- In order to maintain a comprehensive price list for both standard and custom sizes, we will create a custom record that will store the dataset. This dataset will be organized based on the designs collection.
- The price calculation will be based on the cost per square foot, the total square footage entered, and, if the selected color is custom or other variants are selected, the corresponding cost per square foot.
- We will add fields on the item record that will allow users to select the size and design of the item. Following the saving of the record, the system will automatically perform the calculations to determine the square feet and cost per piece.
- We will provide the option for choosing the customer on the item record as a dropdown. This will enable the user to choose the customer in case of custom size.
- The price will be calculated based on the customer tier.
- We will incorporate a dropdown field to allow the selection of available rug sizes. The ‘Square Feet’ price will then be determined by the chosen value and the customer tier selected.
- We will consider multiple variants to calculate additional prices for custom rugs, including considerations such as custom designs, color, latex etc.
- We will provide the option to list specific collections applicable to respective customers.
- We will import and create all the price list details into NetSuite by creating custom record.
ASSUMPTION
- At the time of the item record creation the Item number/ name field will not show the number. After record saving the item number will populate.
- Currently, the system does not consider the context of item deletion. For instance, let’s say the most recently created item is automatically assigned the item number 10. If this item is deleted or inactivated, the next created item will be assigned the number 11 instead of reusing the number 10.
- This is only applicable for the inventory items.
- The dropdwown list of the display name attributes (Collection, Design, Country, Quality, Pile/Content, Background color, Border color, etc) will provide by the Knot&co.
- Knot&Co. Should have to share the price tier list for each design and size.
- Knot&Co. Should have to share the Customer-Tier list.
- We will not consider quantity pricing in this scope.
- For custom sizes, we assume that the customer will always be selected.
- We assume that the user will enter the size accurately, ensuring that the actual size entered will always fall within the selected size range.