Item Sync and Field Management System

This application manages the synchronization and display of item data between a local database and NetSuite. It leverages a data grid interface to display, add, and edit item information based on selected locations and item types. Users can filter items, search specific columns, and manage required fields for items. The application includes functionality for syncing columns from NetSuite and updating the local database, handling custom fields, and providing AI-generated prompts for specific fields. It also supports password-protected synchronization of item data from NetSuite, with real-time progress tracking.

Real-Time Inventory and Stock Adjustment System

This application provides real-time synchronization and display of inventory data between the WAERStock database and NetSuite. It utilizes a DataGridView to present item quantities, stock adjustments, and value differences across both systems. Discrepancies, such as mismatches in available quantities and values, are highlighted with color-coded cells for easy identification. Users can filter, search, and view stock details for each item. The application includes an automatic data refresh through a timer, ensuring up-to-date inventory information. A background worker optimizes data loading and updates, while tab controls categorize inventory and transactions for easy access. This application helps maintain data accuracy and provides a clear, real-time overview of stock and discrepancies.

NetSuite Schema Synchronization and Bulk Data Management

This application enables seamless synchronization between NetSuite and a SQL Server database by automatically syncing table schemas and columns. It connects to NetSuite via SuiteAnalyticsConnect to retrieve table and column information and updates local tables accordingly. New tables are dynamically created if they do not exist, with primary keys managed and custom fields filtered. The application supports SQL bulk inserts, allowing large volumes of data to be efficiently loaded into the synced tables. A background worker manages real-time updates, with progress displayed in the UI. Customizable data grids display synchronized tables and columns, while schema changes are logged to ensure the database remains aligned with NetSuite.

Customer Price List Generation and Export

This application retrieves customer data and item price lists from NetSuite using SuiteAnalyticsConnect, displaying the information in a user-friendly grid for both customer and item prices. It retrieves customer details such as company name, email, currency, price levels, and regional data, with dynamic retrieval of associated item prices. The application supports exporting price lists to CSV or Excel formats, with options to autofit columns and freeze panes in Excel for easier navigation. Additionally, it includes report generation capabilities, outputting the price list in an Excel report that includes customer-specific pricing and discount information. The application also supports drag-and-drop file imports and detailed price-level filtering.

Dynamic Data Template Management and Excel Integration

Developed a data template management system integrated with NetSuite, leveraging Excel Interop to dynamically generate spreadsheets with placeholder formulas based on predefined structures. The system manages template configurations, including column mappings, custom fields, and data validations, using a SQLite-backed model. Data from NetSuite is retrieved via OpenAccessConnection and synchronized with local databases. The Excel export functionality automatically generates formulas and validations, including dynamic field mappings, conditional logic, and lookup lists based on NetSuite data. The system also supports importing from CSV/Excel files, allowing seamless data synchronization and automation.

Item Demand Plan Management and File Import

This application allows users to import item demand plans from external files, such as Excel or CSV, into a system for planning and forecasting. It integrates with NetSuite via SuiteAnalyticsConnect to retrieve item data, including projection intervals and methods, and supports drag-and-drop file uploads. The imported data is validated and mapped into demand planning columns, with flexible handling of different file types. Additionally, the application enables bulk updates of item demand plans for future months, automatically calculating demand quantities and start dates based on user input. It also provides secure SQL connections for data retrieval and integration with the NetSuite API.