Uploaded image for project: 'Blesta Core'
  1. Blesta Core
  2. CORE-1788

Reports sent to multiple companies contain data from only one company

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.5.2
    • Fix Version/s: 3.5.3, 3.6.0-b1
    • Component/s: Staff Interface
    • Labels:
      None

      Description

      The "Invoice Creation Report", "Aging Invoices", and "Tax Liability" email templates that Staff can subscribe to sends daily/monthly CSV reports via cron. However, the report generated for the first company is the same report sent to all other companies run at the same time.


      It's been reported that the report sometimes contains invoices from other companies. In a customer provided example of reports from 2 companies over 3 days, 2 of the 3 reports were identical across both companies.

      Investigate to see if there is any way an invoice creation report would contain invoices from other companies.

        Activity

        admin Paul Phillips created issue -
        Hide
        tyson Tyson Phillips (Inactive) added a comment -

        I was not able to duplicate this issue. Every report requires it to be filtered by company.

        In the Invoice Creation Report, the invoices retrieved are from clients belonging to the current company. You could not fetch invoices for more than one company using this report neither manually nor by cron.

        Whomever reported this issue should double-check their report and confirm that each invoice number, client number, total, date billed, etc. match an invoice in the current company. It is possible to see the same data in two companies on the off chance two clients with the same ID number have an invoice created on the same day for the same amount with the same invoice number. The system-level invoice ID would be different in this case, but that ID is not visible in the report.

        Show
        tyson Tyson Phillips (Inactive) added a comment - I was not able to duplicate this issue. Every report requires it to be filtered by company. In the Invoice Creation Report, the invoices retrieved are from clients belonging to the current company. You could not fetch invoices for more than one company using this report neither manually nor by cron. Whomever reported this issue should double-check their report and confirm that each invoice number, client number, total, date billed, etc. match an invoice in the current company. It is possible to see the same data in two companies on the off chance two clients with the same ID number have an invoice created on the same day for the same amount with the same invoice number. The system-level invoice ID would be different in this case, but that ID is not visible in the report.
        tyson Tyson Phillips (Inactive) made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Won't Fix [ 2 ]
        tyson Tyson Phillips (Inactive) made changes -
        Fix Version/s 3.6.0 [ 10600 ]
        tyson Tyson Phillips (Inactive) made changes -
        Resolution Won't Fix [ 2 ]
        Status Resolved [ 5 ] Reopened [ 4 ]
        tyson Tyson Phillips (Inactive) made changes -
        Summary Invoice Creation Report may contain invoices from other companies Reports sent to multiple companies contain data from only one company
        tyson Tyson Phillips (Inactive) made changes -
        Description The "Invoice Creation Report" email template that Staff can subscribe to sends a daily CSV report of invoices created for the previous day.

        It's been reported that the report sometimes contains invoices from other companies. In a customer provided example of reports from 2 companies over 3 days, 2 of the 3 reports were identical across both companies.

        Investigate to see if there is any way an invoice creation report would contain invoices from other companies.
        The "Invoice Creation Report", "Aging Invoices", and "Tax Liability" email templates that Staff can subscribe to sends daily/monthly CSV reports via cron. However, the report generated for the first company is the same report sent to all other companies run at the same time.
        ----
        It's been reported that the report sometimes contains invoices from other companies. In a customer provided example of reports from 2 companies over 3 days, 2 of the 3 reports were identical across both companies.

        Investigate to see if there is any way an invoice creation report would contain invoices from other companies.
        Hide
        tyson Tyson Phillips (Inactive) added a comment -

        This issue only occurs when reports are delivered for multiple companies via cron. The same report will be delivered to subscribed staff of all companies that is delivered for the first.

        Show
        tyson Tyson Phillips (Inactive) added a comment - This issue only occurs when reports are delivered for multiple companies via cron. The same report will be delivered to subscribed staff of all companies that is delivered for the first.
        tyson Tyson Phillips (Inactive) made changes -
        Status Reopened [ 4 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        tyson Tyson Phillips (Inactive) made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            tyson Tyson Phillips (Inactive)
            Reporter:
            admin Paul Phillips
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Fix Release Date:
              2/Sep/15