Intermittent performance issue when posting Accounts Payable batches

Less than one minute read time.

After diagnosing issue with SQL Profiler, determine a long query against PMPROJS table and then single record fetches to PMPROJT table. 

The behavour is intermittent as not all AP Batches are Project Job Cost entries so only occurs when particular projects are referenced in AP entry. 

Sage 300 PJC was not optimized to work with large open project data set, and does not filter by a particular project or phase, but queries the entire table to the record.

This issue has been brought to developments attention and product management is determining what resources may be required.

  • Hi Jfabel, 

    The issue with performance is related to Projects being marked as "inactive" rather than completed/closed.. so the more inactive projects, the greate the lag in performance.

    If your clients have too many inactive projects to be able to complete/close via the standard UI, Development did create a macro that can perform the task on a range of inactive projects.

    If you would like the macro, please reach out to Customer Support and open a Support Ticket.

    Regards,

    DCrampton

  • Hi Ron, We have 2 customers facing that issue on Sage 300 2024.  Can you tell me if the development found something?