Proposal Summary
This proposal outlines a customized solution aimed at enhancing the item records by incorporating a custom record to display comprehensive information regarding out-of-stock products and their corresponding dates. The solution focuses on incorporating location-specific details to provide a comprehensive overview of stock availability.
Requirement
Currently, do not have a mechanism in place to track the specific date when a product goes out of stock at any location. This lack of visibility hinders the ability to promptly address stock-out situations.
Require a solution that enables to accurately record the stock-out date and location whenever a product becomes unavailable in any of the locations. The solution should include a table integrated into our Inventory Item and Kit records, facilitating easy export of the data in CSV format. The table should provide comprehensive visibility of all stock-out occurrences.
Deliverables
The proposed solution involves implementing a custom record within the item records system. This custom record will serve as a dedicated section to capture and display detailed information about out-of-stock products. The record will be designed to accommodate specific fields, such as the product name, stock-out date, and location. This will allow users to easily identify and track the occurrence of stock-outs for each item based on its associated location.
- Development of Custom Record: The solution involves creating a custom record that will store information about items and their stock status at different locations. This custom record will have separate entries for each item, allowing for accurate tracking and management.
- Custom Record Fields: Each entry in the custom record will contain important fields such as the location of the item and the date when it went out of stock. These fields will help in determining the current stock availability and tracking any changes over time.
- Scheduled Scripts: Two scheduled scripts will be implemented to run every hour. These scripts will perform specific tasks to update the custom record and keep it synchronized with the actual stock status.
- “Out-of-Stock” Script: The first script will focus on identifying items that have gone out of stock. It will check the available quantity for each item at different locations. If the available quantity is zero, it means the item is out of stock.
- Updating Custom Record for Out-of-Stock Items: After filtering the items that are out of stock, the custom record will be updated to reflect the latest stock out date and the corresponding location for each item. This information will help in monitoring stock depletion and making informed decisions.
- “In-Stock” Script: The second script will identify items that have come back in stock during the hour. It will compare the available quantity for each item with the previous records and identify items that were previously out of stock but are now available again.
- Updating Custom Record for In-Stock Items: Like the out-of-stock case, the custom record will be updated for items that have come back in stock. The relevant date and location information will be updated to reflect the latest availability.
- Saved Search and Reporting: A saved search will be created based on the custom record, allowing users to easily retrieve information about items, their locations, and stock status. This search will provide a comprehensive view of the items, facilitating efficient stock management.
- Report Generation: Users will have the ability to download reports based on the details obtained from the saved search. These reports can be customized as per the user’s requirements and will provide valuable insights into the stock availability and movement of items across different locations.
Assumptions
- The search results generated from the custom record will provide accurate and up-to-date information regarding the stock status of items.
- Bin Level Location Availability Excluded: The solution will not consider bin level location availability. Instead, it will focus on the overall location availability of items. This means that the stock dates will be determined based on the total quantity available at each location, without considering specific bins within those locations.
- Custom Record Updates: The custom record will be updated on an hourly basis. This update process will involve checking the availability of items at different locations and reflecting any changes in the custom record accordingly. By updating the custom record regularly, it ensures that the stock date information remains accurate and up to date.
- Permanent Saved Search: A saved search will be created within the NetSuite account. This saved search will persist and will not be deleted automatically.
- Downloading Reports from Saved Search: Users will have the capability to download reports directly from the saved search result views. These reports will provide a comprehensive overview of the item details, including their respective locations and stock availability. Olsa Tools can customize and manipulate the data as needed for their reporting purposes
Risks
Since the accuracy of the data is determined during the customization phase only, there is a risk that the data may become inaccurate over time due to various factors such as changes in stock availability, or manual errors.
Estimated Time
38*hrs