Sales Order Line Items Not Showing Due to Blank Aggregated Status

Symptom

Product Configurations (line items) are not visible on a Sales Order in the UI. The Sales Order page loads but the line items section appears empty, even though Product Configuration records exist and are linked to the Sales Order.

This issue does not produce an explicit error message — the line items simply do not render.

Cause

The Aggregated_Status__c field on one or more Product Configuration records linked to the Sales Order is blank (null). A custom filter function in the Sales Order UI uses this field to determine which line items to display. When the field is blank, the filter function breaks silently, causing all line items to be excluded from the rendered view.

Resolution

Step 1: Query Product Configurations linked to the Sales Order

Run the following SOQL query to check the Aggregated_Status__c field on all Product Configurations associated with the Sales Order:

SELECT Id, Name, Aggregated_Status__c
FROM cscfga__Product_Configuration__c
WHERE Sales_Order__c = '<SALES_ORDER_ID>'

Look for records where Aggregated_Status__c is blank or null.

Step 2: Populate the Aggregated_Status__c field

For each Product Configuration with a blank Aggregated_Status__c:

1. Determine the correct status value based on the PC's lifecycle state (e.g., Active, Ready for Activation, or the appropriate status for your implementation)
2. Update the field either:
3. Via the UI: Edit the Product Configuration record and set the status field
4. Via Data Loader / Workbench: Bulk update if multiple records are affected

-- Verify which records need updating
SELECT Id, Name, Aggregated_Status__c, cscfga__Configuration_Status__c
FROM cscfga__Product_Configuration__c
WHERE Sales_Order__c = '<SALES_ORDER_ID>'
  AND Aggregated_Status__c = NULL

Step 3: Verify line items are now visible

After updating the Aggregated_Status__c field, navigate to the Sales Order in the UI and confirm that all line items are now displayed correctly.

Step 4: Investigate root cause

To prevent recurrence, investigate why the Aggregated_Status__c field was not populated:

• Check if the field is set by a trigger, workflow rule, or process builder that may have failed
• Review the order creation flow to ensure the status is always populated during PC creation
• Check if a recent data migration or import left the field blank

Additional Notes

• The Aggregated_Status__c field is critical for the Sales Order UI rendering. Any custom code or processes that create or modify Product Configuration records should ensure this field is always populated.
• If this issue affects multiple Sales Orders, run a broader query to identify all affected records:

SELECT Sales_Order__c, COUNT(Id)
FROM cscfga__Product_Configuration__c
WHERE Aggregated_Status__c = NULL
  AND Sales_Order__c != NULL
GROUP BY Sales_Order__c

• The correct value for Aggregated_Status__c depends on your implementation's status model. Common values include Active, Ready for Activation, Created. Check existing, correctly-functioning Product Configuration records for reference.