• Inconsistent date format when export data to excel

    My excel version is Office 2016. When I export data from Sage 50 to excel, there are different date format in the date column (as below image, different date format for 12/4/2022 and 14-4-2022). It is difficult to use Excel Power Query to do some analysis…
  • GL Acct ID Only Populates on First Line in Report

    In a number of reports that include GL Acct ID, only the first line of a record will include the GL Acct. Below is an example from the Job Ledger Report. All four lines are in GL Acct 4000, but the report only lists the acct ID for the first. This creates…