Issues with Bulk Replication of Data
We have a use-case where we would like to freeze a snapshot of month-end Inventory levels in a table that is a "clone" of our already existing Perpetual Inventory table. In my mind, it's so easy lol - so far I have:
-Created a copy of the Perpetual Inventory table (Month-End Inventory) without any of the data. This gives me the table structure I need - same exact fields
-When I try a Bulk Record Sets / Copy Records Pipeline step, quite a few of the fields I select from the Source table are not available in the Destination table as options.
Does anyone have any insight as to why? I've reviewed some QB documentation on this function but do not see any documented limitations (Quickbase Help). There are a number of fields that do not show up as options on the Destination table and there doesn't appear to be any rhyme or reason as to which ones are included or not.
Screenshot of the issue showing field 'Inventory on Hand' simply does not appear as an option:
------------------------------
Dave Brian
------------------------------