Dynamics GP Tips & Tricks: SmartList Builder Export Solution
Dynamics GP Tips & Tricks Create SmartList Favorite within Smartlist Builder Add Search Criteria Add Columns & Change Display Names Add ‘Customer Name’ and ‘Document Date’ Columns Change Display Name ‘QYT’ to Quantity Change Display Name ‘Extended Cost’ to ‘Cost’ Change Display Name ‘Extended Price’ to ‘Sales’ Click ‘OK’ Save SmartList Favorite Export to Excel Begin Recording of Excel Macro Create Pivot Table and Pivot Chart Data > PivotTable and PivotChart Report > Finish Drag Customer Name to Rows Drag Sales and Cost to Data Items Drag Data Column Over Total Format Sales and Cost Columns as Currency Select [...]