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...
Forum Discussion
Oh yes...there are a lot of formula fields in there. Do you know if there are limitations around fields that are references/lookups from other tables as well? Upon further review that seems to be the case.
I'm newer to QB, so when you say convert it to scalar/entry, what is best practice for that?
Appreciate the reply!
------------------------------
Dave Brian
------------------------------
Since you're doing a true snapshot - you just want to convert them all to be entry fields so that nothing can change. So if in your original table the field was formula-numeric - you want to change the type to just be 'Numeric'. Do that across the board for any field that is a formula, summary field, lookup etc. The idea is that in your new table you won't have the same relationships or data feeds, so you're just storing all that data in a way that it can never change this way.
------------------------------
Chayce Duncan
------------------------------