Bryan and I looked at some code for the advanced invoice sub inventory search and results. We had a complaint from a client that the report was taking a long time. We briefly looked at the code and worked on a plan of attack. Currently, the report is looping and then going out to the database multiple times per loop to fill in missing and/or unknown data. We will be reworking things to do what is called a query of a query. This changes the approach from back and from between the database and the page to back and forth between memory (a cached query in memory) and the page. It should speed things up considerably.

After that, we worked on a small change to the plain footer. That small footer is used by the system when generating a PDF document for a PO, invoice, quote, or financial report. We had to get some white label variables out into that footer through non session (memory) based means. We tested and merged in the new code. We then pushed it out to all servers.