Custom int field throws "Specified cast is not valid"

Hi @rcreasy 

The error "Specified cast is not valid" is typically thrown when the application attempts to read a value from the database that doesn't match the data type specified in the DAC field. This often happens due to changes in the field's data type after data has been entered.

Here's what you can do to troubleshoot this:

1. Check Database Value: Directly check the value stored in the database for the UsrPDinches field. Ensure that all values in the column are integers. If there's a non-integer value (like a decimal or string), that would be the root cause.

2. History: If you changed the data type of this custom field after it was initially created (for instance, if it was originally a PXDBDecimal and then you changed it to PXDBInt), old data might still be stored in the database in the original format, causing a casting error when trying to retrieve it. You'll need to either clear out or convert old data to the correct type.

3. Database Schema: Also, ensure that the database schema correctly reflects this field as an integer column.

Disabling Field Based on Production Order Status

To disable the field based on the production order status, you'll need to use a RowSelected event on the production order DAC to set the field's Enabled property to false when the order is completed.

Here's an example of how you can achieve this:

Assuming your production order DAC is named ProductionOrder:

protected virtual void _(Events.RowSelected<ProductionOrder> e)
{
    if (e.Row == null)
        return;

    ProductionOrder order = e.Row;

    // Assuming 'Completed' status is represented as "C"
    if (order.Status == "C") 
    {
        PXUIFieldAttribute.SetEnabled<ProductionOrder.usrPDinches>(e.Cache, order, false);
    }
}