• How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
  • GL -> Account Inquiry -> History Best way to extract similar info for external report

    I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…
  • Importing data from excel to generate A/R invoices and Sales

    I am only familiar with the surface level of Sage products therefore, how can I use data that is in an excel format and import it into AR to generate invoices? We are currently putting the information into excel and than retyping item codes and descriptions…