Project Income Report, we need another column that tells us what is still owed

Is there anyway to add a column, (or would Sage in the next update, pretty please) to the Project Income Report, that would have the outstanding owed on each invoice.   We need this information daily.  We are now exporting the report, then going back and clicking into the invoice, writing down the amount, then clicking into the excel report we just exported and adding the amount to one of our created columns. ( which is extremely frustrating and fraught with possible errors to be made)  How does anyone else deal with this

Parents
  • 0

    I would build a custom query in Access or LibreOffice.   If you want help doing this please let me know.

    Such a thing should also be possible in Sage Intelligence.  It's available from Sage.

    SQL queries in Excel are also possible.  There are some sample worksheets under the Reports | Microsoft Office Documents menu.  

    And with a load of 'if' statements and some Lookup formulas, you can export the A/R aging and reference that from an export of the Project Allocation.  I wouldn't want to do THAT every day.

Reply
  • 0

    I would build a custom query in Access or LibreOffice.   If you want help doing this please let me know.

    Such a thing should also be possible in Sage Intelligence.  It's available from Sage.

    SQL queries in Excel are also possible.  There are some sample worksheets under the Reports | Microsoft Office Documents menu.  

    And with a load of 'if' statements and some Lookup formulas, you can export the A/R aging and reference that from an export of the Project Allocation.  I wouldn't want to do THAT every day.

Children