Jobs are currently closable before all AP invoices are paid and all customer invoice funds are received. When a year is closed, those jobs that are closed are usually archived unless there are AP or AR invoices that remain unpaid attached to those jobs. If there are unpaid invoices, the status remains closed, but all the information is not archived and will appear on the 6.1.4 report 61 when you select status 6 or "closed". The job will appear on this report despite being close, in some cases, several years before the current period. The issue this solves is the following:

1) Often, we keep back-charge information in the form of credits against AP Vendors. This information needs to be accessible in perpetuity. This information often relates to subcontractors with whom we have had bad dealings, but may still interact with in the future. These amounts will sit as unpaid invoices and credits and will be adjusted through journal entries at year-end. By having these, we are currently experiencing database bloat
2) And difficulty extracting accurate job costing reports due to old, non-relevant jobs still being included in the 6.1.4 61 report.

Comments