Sage 200 UKI Ideas Portal

Excel Reporting - Revenue and Cost report: flip sign on budgets

A client is using the Excel Revenue and Cost report to extract budgets and actuals from Sage 200 for reporting. The actual values are signed flipped, so that the revenue credits are displayed as positives and the cost debits as negatives. Budgets, however, are not, these show as negatives for revenue and positive for cost. This then causes issues with formulas using these values, on this spreadsheet and when pulled into other spreadsheets. Can this be fixed so that when the spreadsheet is updated from the Excel reporting list the budgets use the same signage as the actuals? Keep them consistent with each other.

  • Gregor Imrie
  • Jul 29 2021
  • Idea Accepted - Gauging Support