{"id":1001,"date":"2026-11-02T08:30:00","date_gmt":"2026-11-02T13:30:00","guid":{"rendered":"https:\/\/www.dataflowsoln.com\/blog\/?p=1001"},"modified":"2026-11-02T08:30:00","modified_gmt":"2026-11-02T13:30:00","slug":"your-custom-fields-vanish-when-you-post","status":"publish","type":"post","link":"https:\/\/dataflowsoln.com\/blog\/your-custom-fields-vanish-when-you-post\/","title":{"rendered":"BC Teardown #1: Your custom fields vanish when you post"},"content":{"rendered":"\n

The pain<\/h2>\n

You added a Project Code field to sales orders. Users fill it in every time. After posting, the invoice shows it blank and your reports break.<\/p>\n

Why it happens<\/h2>\n

Posting copies the header with TransferFields, which matches fields by field number. If the posted table has no field with that number, the value is silently dropped.<\/p>\n

Before: Field only on the order<\/h2>\n
tableextension 50100 \"DF Sales Header\"\n  extends \"Sales Header\"\n{\n  fields\n  {\n    field(50100; \"DF Project Code\"; Code[20])\n    { }\n  }\n}\n\n\/\/ Sales Invoice Header: no field 50100\n\/\/ so the value never reaches the invoice<\/code><\/pre>\n
After: Same field number on the posted table<\/h2>\n
tableextension 50101 \"DF Sales Inv. Header\"\n  extends \"Sales Invoice Header\"\n{\n  fields\n  {\n    field(50100; \"DF Project Code\"; Code[20])\n    {\n      Editable = false;\n    }\n  }\n}<\/code><\/pre>\n
The result<\/h2>\n
The value flows to the posted invoice automatically. No posting code to write, nothing to break on upgrade.<\/p>\n
Tip:<\/strong> Add the same field number to Sales Shipment Header and Sales Cr.Memo Header too.<\/p>\n
Download this teardown as a PDF<\/a><\/p>\n
\n
Got a Business Central problem like this?<\/strong> Free 30 minute review of your setup. Senior Microsoft certified developers, and you talk to the person writing the code. Contact Dataflow Solutions<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
You added a Project Code field to sales orders. Users fill it in every time. After posting, the invoice shows it blank and your reports break.<\/p>\n","protected":false},"author":2,"featured_media":7,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[3,9,23],"class_list":["post-1001","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bc-teardowns","tag-al","tag-business-central","tag-table-extensions"],"_links":{"self":[{"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/posts\/1001","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/comments?post=1001"}],"version-history":[{"count":1,"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/posts\/1001\/revisions"}],"predecessor-version":[{"id":1019,"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/posts\/1001\/revisions\/1019"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/media\/7"}],"wp:attachment":[{"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/media?parent=1001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/categories?post=1001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dataflowsoln.com\/blog\/wp-json\/wp\/v2\/tags?post=1001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}