Sage 200 UKI Ideas Portal
Add a new idea Subscribe
Status Idea Accepted - Gauging Support
Categories Excel
Created by Gary Butler
Created on Jun 29, 2020

RELATED IDEAS

Data to Excel to show Returns/Credits as negative

Not sure if this is possible as Data to Excel dumps the data contained in a report to Excel from the table formatting and ignores formatting on the report, but it would be great if Credits and Returns would show as negatives when using Data to Excel. Of course the data in the tables shows positive invoices and positive credits (which is still logical), but we have customers who love this functionality other than having to manually change the credit/return values from positive to negative.

  • Post comment
  • Gary Butler
    Reply
    |     Jan 4, 2024

    Hi Jo, its using Data to Excel from any report.

  • Admin
    Jo Kirkup
    Reply
    |     Jan 4, 2024

    hi there, thanks for the idea can you give specific information as to where you are doing this from. Is it a report that's being run, are you using BI, Power BI or Excel reporting? Which version of the product have you reviewed this in?