When customizing an Advanced PDF/HTML template for a Bill of Materials (BOM) or Work Order, users may notice that the field ${record.startdate} does not display any value, even though other fields like ${record.trandate} work properly. This can be frustrating when trying to print important fields like Production Start Date on the BOM form.
This is a known limitation in NetSuite. The ability to print Production Start and End Dates directly on the BOM via the Advanced PDF/HTML Template is not currently supported.
- Enhancement #162284
Summary: Work Order: Customize - Ability to Add Printing Fields on the Form
Step A: Create Custom Body Fields
A1. Custom Production Start Date
- Navigate to:
Customization > Lists, Records & Fields > Transaction Body Fields
2. Click New.
3. Set the following:
- Label: Custom Production Start Date or anything you want.
- Type: Date
- Under Applies To tab:
- Check Work Order and/or Assembly Build
- Check Print on BOM
4. Click Save.
A2. Custom Production End Date
Repeat the steps above with a different label: Custom Production End Date.
Step B: Populate and Print the BOM
- Create a new Work Order.
- Manually fill in the Custom Production Start and End Dates.
- Complete required fields and Save the record.
- Click Print BOM – the custom date fields should now appear on your template.
Step C (Optional): Automate Using Workflow
To automatically populate the custom fields based on existing values:
- Create a Workflow on the Work Order record type.
- Set the trigger to After Record Submit or on Field Change (depending on your preference).
- Add actions to Set Field Value from the system Production Start and End Dates (if accessible via script or SuiteFlow).
- Update your Advanced PDF/HTML Template to reference the custom fields:
- Example:
${record.custbody_custom_production_start}
While printing the native Production Start Date in a BOM is not currently supported, creating custom fields and optionally automating with a workflow provides a practical workaround. This ensures your Advanced PDF/HTML templates show the correct production dates until the enhancement is delivered.