{"id":31629,"date":"2025-12-30T13:06:12","date_gmt":"2025-12-30T13:06:12","guid":{"rendered":"https:\/\/www.greytrix.com\/blogs\/sagex3\/?p=31629"},"modified":"2025-12-30T13:06:12","modified_gmt":"2025-12-30T13:06:12","slug":"how-to-update-custom-fields-in-the-work-order-wo-header-table-mfghead-in-sage-x3","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2025\/12\/30\/how-to-update-custom-fields-in-the-work-order-wo-header-table-mfghead-in-sage-x3\/","title":{"rendered":"How to Update Custom Fields in the Work Order (WO) Header Table (MFGHEAD) in Sage X3"},"content":{"rendered":"\n

In many manufacturing setups, businesses often require custom information to flow seamlessly from Sales Orders (SO) into Work Orders (WO). Recently, one of our clients needed an additional alphanumeric field (length 50) on the Sales Order header called \u201cSpecial Notes\u201d<\/strong>, and they wanted this field to automatically carry forward to the Work Order header during WO creation in Sage X3<\/a>.<\/p>\n\n\n\n

While this requirement sounds simple, challenges appeared specifically when Work Orders were created through Multilevel Planning<\/strong>. This blog explains the complete solution covering field creation, screen changes, script logic, and the special handling required for automated planning scenarios.<\/p>\n\n\n\n

Step 1: Adding the Custom Field on the Sales Order<\/strong><\/p>\n\n\n\n

To begin, we added a new custom field ZSPCLNOTE<\/strong> to the SORDER<\/strong> table.
This field was then placed on the Sales Order screen under the Management tab.<\/p>\n\n\n\n

New stuff:<\/strong> Managing Repeated Data and Line Suppression Using Next() & Previous() Functions in Crystal Reports<\/a><\/p>\n\n\n\n

\"fig1<\/a><\/center>\n
fig1 Sales Order screen<\/center><\/font>\n\n\n\n

Step 2: Adding the Field to the Work Order Header<\/strong><\/p>\n\n\n\n

Next, we created the same field ZSPCLNOTE<\/strong> on the MFGHEAD<\/strong> table.
We added this field to the Work Order header screen to ensure visibility for users.<\/p>\n\n\n\n

\"fig2<\/a><\/center>\n
fig2 Work Order screen<\/center><\/font>\n\n\n\n

Step 3: Ensuring Data Flows from SO to WO<\/strong><\/p>\n\n\n\n

To make the \u201cSpecial Notes\u201d value flow from the Sales Order to the Work Order during manual WO creation, we added custom logic in the SPEMFG<\/strong> script under the SETBOUT<\/strong> action.<\/p>\n\n\n\n

This worked perfectly for manually created Work Orders\u2014the data passed correctly and was saved in the MFGHEAD table.<\/p>\n\n\n\n

Issue: Value Not Saved During Multilevel Planning<\/strong><\/p>\n\n\n\n

However, a problem occurred when Work Orders were generated using the Multilevel Planning<\/strong> function available under Sales Order \u2192 Details<\/strong>.<\/p>\n\n\n\n

Although the value flowed from SO to WO during planning, it did not get saved<\/strong> in the MFGHEAD<\/strong> table.<\/p>\n\n\n\n

This happened because Multilevel Planning uses automated processes that do not trigger the same script actions as manual WO creation.<\/p>\n\n\n\n

Step 4: Fix for Multilevel Planning Scenario<\/strong><\/p>\n\n\n\n

To resolve this, we created the entry point MFGAUTLIB<\/strong> and attached a custom script ZMFGDET<\/strong> to it.<\/p>\n\n\n\n

\"fig3<\/a><\/center>\n
fig3 Entry Point<\/center><\/font>\n\n\n\n

Inside this script, we implemented custom logic under the AUTLIBMAJ<\/strong> action.
This ensures that the \u201cSpecial Notes\u201d value is properly written into the MFGHEAD<\/strong> table even when the Work Order is created automatically via Multilevel Planning.<\/p>\n\n\n\n

\"fig4<\/a><\/center>\n
fig4 Multilevel planning option<\/center><\/font>\n\n\n\n

Conclusion:<\/strong>
By leveraging entry points and custom script logic, we ensured that the \u201cSpecial Notes\u201d field flows correctly from the Sales Order to the Work Order\u2014whether the Work Order is created manually or through automated Multilevel Planning.<\/p>\n\n\n\n

This customization ensures consistent data visibility, improved traceability, and enhanced process efficiency across the manufacturing lifecycle.<\/p>\n\n\n[about_us_blog_common]\n","protected":false},"excerpt":{"rendered":"

In many manufacturing setups, businesses often require custom information to flow seamlessly from Sales Orders (SO) into Work Orders (WO). Recently, one of our clients needed an additional alphanumeric field (length 50) on the Sales Order header called \u201cSpecial Notes\u201d, and they wanted this field to automatically carry forward to the Work Order header during\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,13],"tags":[3318,493,1822,1983,2428],"class_list":["post-31629","post","type-post","status-publish","format-standard","hentry","category-sage-erp-x3","category-integration","tag-custom-fields","tag-customization","tag-sage-x3","tag-sales-order","tag-work-order"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31629","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=31629"}],"version-history":[{"count":8,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31629\/revisions"}],"predecessor-version":[{"id":31637,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/31629\/revisions\/31637"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=31629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=31629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=31629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}