• Book Balance in Bank Reconciliation

    Our bank has not been reconciled in Sage from 2018 onwards because of some issues. Now I want to start reconciling in Sage. Our bank balance is as below and there is a book balance of the below amount in the picture. The question I have is where is the…
  • Sage Accpac ERP Database error=49153 After restore database from another server

    Hi All, I just restore Sage Accpac 5.6A from old server to our new server (both database names are the same: "ACCPACSYS" & "ACCPACDAT"). After restore successfully and launch Sage Accpac ERP on server (on where Accpac 5.6A and its sql server database…
  • AR Customer default price list

    Every year I have to change AR Customer default price list. We have 90K customers and import from excel takes more than 72 hours. Hardware is definitely not an issue since ship to locations are updated for less than 12 hours. Using minimum of data in…
  • G/L Inquiry with Income Statement Year End Income Statement Amounts

    FormerMember
    FormerMember
    Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…
  • Excel 2007 option to export and import

    Hello, We upgraded our office product from 32 to 64 bit. Office 2010. Now in Sage when we Import/Export in any module, the option for Excel 2007 disappeared. Only Excel 2000 is available. Any ideas? Do I need to uninstall-reinstall Sage? Sage…
  • The values of "Category" in timecard import sheets

    Hello, I need to know the values I should use for "CATEGORY" in time card import sheets,,,,can someone help pleeeease? BR
  • Do A/R Invoices have or allow for Kit (Kitting) Items?

    Would like a conclusive answer if Accounts Receivable (A/R Transactions) allow for the use of Kit items with individual components. I know they are available in Order Entry Transactions. Thank you for any/all help!
  • Sage 300 ERP Payroll time card import

    I need to set up an import for timecards into Sage 300 payroll. I have gone through the process of manually entering a few timecards and then exporting to Excel. Now I need to figure our which fields really need to be populated by the import file that…