• Special codes in customer details tab

    How do I set up special codes in the customer details tab? I want to flag certain customers when orders are done up.
  • Is there any way to have payroll sort with most current at top?

    Currently Payroll sorts with the most current entries at the bottom. That means from about November on, I am always having to page down to get the current entries, and every transaction resets it so I have to scroll down again.. Is there a way to have…
  • querying historical GL Transaction file. (YYYY_GL.btr)

    Is it possible to create a Database View which represents the data from the GL archive data files? such as, a view called 2018_GL_TRANSACTIONS which mounts 2018_GL.btr? Also wondering if anyone knows why the YYYY_GL.btr files do not have the same…
  • Sage History Detail

    I do a SQL join of the SAGE_HISTORY_HEADER and SAGE_HISTORY_DETAIL DB tables by the column NUMBER, but I have some HEADER records that don't have any matching DETAIL records. When I look them up via the application and drill down into the order (invoice…
  • DATABASE QUERY: Find qty of a particular sku that has been purchased/received since date.

    As per the subject, could someone help me with the query to find the Quantity Received since a particular date for a particular SKU ? If an order is placed for 10 of SKU(ABC) we receive 1 on date X, I'm assuming TODATEQTY would be 1. we receive…