Custom Office Datasource Options

Sage 100 Premium 4.50: I have a udf for an expiration date in the IM Item Cost table. Each item has a lot which has an expiration date. I placed this expiration date UDF on the Bill of Materials Production Entry header screen. When a bill is produced, user has to give the finished good an expiration date and then when production entry is updated, this date flows with the item to be viewed in Item Maint.  This is accomplished by choosing the IM_TransactionPosting datasource in the BM_ProductionRegister_upd business object for IM Item Cost table. Problem is that each component on the lines page has an expiration date too and once the production register is updated, the expiration dates for components only do not flow with the items back into item maint. The update makes the expiration dates for components blank.  As a result I changed the data source to be BM_ProductionTierDistribution to test.  The result was that the expiration dates for the components flow with item to item maint; however now the finished goods expiration dates do not flow to item maint and the exp dates are blank.  Ideally I want both the components and finished goods to retain their expiration dates after a production entry update. I need both datasources. Any suggestions would be greatly appreciated!