There is a new feature for Financial tags on Sales orders. https://learn.microsoft.com/en-us/dynamics365/finance/general-ledger/financial-tag This feature can be enabled under the feature management. After it is enabled, the sales order form will show a new fast tab under the header and line. It is similar to the financial dimensions but shows as a grid. Note that the tags do not show under the posted invoice journal but the field FinTag is stamped. If you want analyse or do reports, it is possible. The great thing about this feature is that it carries over to the voucher transactions. Below are 2 examples I posted. First example, I created a sales order with 2 lines and unique financial dimensions. The system splits the vouchers by financial dimension and hence the tags appear correct. On a second example, I created a sales order with 2 lines but have the same financial dimension on them. The product sales voucher line has only the first sales order line tag.
One advantage with parquet files is that it keeps history. Run the below script and it will give you the history. %% sql DESCRIBE HISTORY dirpartytable; Below is an example I have in my environment. Use "VERSION AS OF" Now that you have the history, you can use the VERSION AS OF statement. This will give you the previous values for the record. %% sql SELECT partynumber, primarycontactphone, primarycontactemail FROM dirpartytable WHERE partynumber = '000001702' ; SELECT partynumber, primarycontactphone, primarycontactemail FROM dirpartytable VERSION AS OF 2 WHERE partynumber = '000001702' ; The below example is when I deleted the primary contact phone number.