• Sage intelligence add functions

    SI has a function for "GLActual" that nets the debits and credits. Is it possible to add 2 different functions to get the debit and credit separately? the data exists in the actuals currently included sub report.
  • Need support for quarterly and year end closings. Sage 100 with Job Cost

    We are network cabling contractors using Sage 100 with Job Cost and lost our Sage 100 support person. We have a CPA, but need someone for quarterly/year end closings. Located in Orange County, CA near John Wayne Airport. Any referrals would be appreciated…
  • I need help creating an amortization schedule in excel with a prorated first month payment

    The situation is a leased piece of equipment with 48 payments of 701.00. However, the first month payment is prorated based in delivery date of the equipment. SO the first month payment is 316.58 calculated as: 701.00/31=22.61, and then 22.61 x 14 days…
  • Sage Intelligence with Excel 2019

    Sage Intelligence has been tested at high level and found that it works with Excel 2019. However, issues may arise from consistent Microsoft updates. In those cases we will determine cause and method for resolving. In one example, a Microsoft update…
  • Is there a way to include a Date Object in a pass through query in Access....

    Hello All, Below is my pass through query. This is how I extract data from MAS and upload to Axiom to do my P/L reporting. This works flawlessly. The unfortunately part of this query is that I have to open each query and change start & end dates.…