Bug 621
| Summary: | Database Error Occurs When Updating Product Selling Price with a Large Numeric Value | ||
|---|---|---|---|
| Product: | Smartwas | Reporter: | Raghul (Raghul) |
| Component: | Master Data | Assignee: | Arun (Arun) |
| Status: | OPEN --- | ||
| Severity: | Medium | ||
| Priority: | Normal | ||
| Version: | unspecified | ||
| Hardware: | PC | ||
| OS: | Windows | ||
| Associated Test Case ID: | Triaged By: | --- | |
| Root Cause Analysis (RCA): | Resolution Summary / Fix Details: | ||
| Impact Area: | |||
| Attachments: | Database Error Occurs When Updating Product Selling Price with a Large Numeric Value | ||
Created attachment 460 [details] Database Error Occurs When Updating Product Selling Price with a Large Numeric Value In Master Data → Product, when the user opens an existing product and attempts to update the selling price with an excessively large numeric value, the application fails to save the price and displays a database error: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'selling_price' at row 1. The application does not validate the maximum permitted selling price before submitting the data.