Add Column to See Sales Order Status on Work Order Print Bills of Materials

It is possible to customize the Print Bills of Materials page found under Print Checks and Forms to add or remove columns for reviewing. However, the Status field of the related Sales Order is not available for this selection when a Work Order is created from the Sales Order.

To achieve this, a custom transaction body field that joins the related information shall be created. This field can be added as a column on the Print Bills of Materials page.

Solution
  1. Create Custom Transaction Body Field 
  2. Navigate to Customization > Lists Records & Fields > Transaction Body Fields > New
  3. Label: Enter Label
  4. Example: SO Status
  5. ID: Enter _wo_sosta
  6. Type: Select Free-Form Text
  7. Store Value: Remove Checkmark
  8. Click Applies To
  9. Work Order / Assembly Build: Enter Checkmark
  10. Click Validation & Defaulting
  11. Default Value: Enter {createdfrom.status}
  12. Formula: Enter Checkmark
  13. Click Save
  14.  
  15. Customize Print Bills of Materials
  16. Navigate to Transactions > Management > Print Cheques and Forms
  17. Click Bills of Materials
  18. Click Customize
  19. Click Additional Columns
  20. SO Status:
  • Include: Enter Checkmark
  1. Click Save

Leave a comment

Your email address will not be published. Required fields are marked *