• Reasons a macro would suddenly quit working on some Windows 10 devices and not others.

    What are some reasons a Sage 300 macro would suddenly quit working in Windows 10? We have five Windows 10 clients, and the macro has quit working on four of the five clients. Sage 300 itself still works fine. We don't know when it broke given, we only…
  • Sage 300 GL Financial reports error

    I have several customized GL financials (Excel) that I used to run successfully for years. Once I converted my data from V2022 to V2023, all of these financials come up with errors >> Invalid account reference in cell A45. They all deal with column A…
  • How to create on-demand subreports caption into number value

    So, so I have a custom report to display a list of costs, and each list displays the total cost per category and there is a navigate function using the on-demand subreport to display detailed costs per category. when I want to export the custom report…
  • FR View fails in Sage300 2017 & 2020. Screen just goes blank, no error

    In Sage 2017 & 2020 the FR View Fails but gives no error. Below is the update I uninstalled. It breaks the variance report on newer Windows versions, but not on older versions. Security Update for Microsoft Excel 2016 (KB4484338) 32-Bit Edition…
  • Importing Employee Transaction History from Excel

    We have many employees with pre-tax 3rd-party short-term disability deductions. When those employees receive payments for short-term disability, some employer-related taxes must be calculated. I have a custom Excel workbook to carry out these calculations…
  • Unable to auto send XLS output using Report Manager and Gmail G-suite mail client

    Unable to auto send XLS or XLSX output using Report Manager and Gmail G-suite mail client. I AM able to successfully schedule and send PDF reports. XLS and XLSX reports are generated and placed into output directory but no evidence of email having been…
  • Excel crashes printing A/R invoices through VBA - MSVCR120.dll

    I have some macro code that is printing A/R Invoices to PDF files. The code works fine on my laptop, but on the client workstation, it crashes. Event Viewer identifies MSVCR120.DLL as the problem. The OS and Excel versions are identical on the workstation…
  • Connectivity problem with Excel

    Hi, MS released an update this past weekend and it seems to have affected connections to excel. I was wondering if anybody else has experienced this. Before the MS updates our macros were programmed to connect to Excel with Microsoft.ACE.OLEDB.12.0…
  • Create shipped and invoiced Order Entry

    hi all i need help i am record a micro fist thing i am entered the data in order entry screen and then press ship all button and then check the check box create invoice and then post the ORDER ENTRY and then i take the code and put it in visual studio…
  • How do you produce effective, multi-currency financial statements?

    How do you produce effective, multi-currency financial statements?
  • NOTHING APPEARS IN INCOME STATEMENT :(

    Hi guys, we have upgraded from Sage 5.3 to Sage 6.1. Everything was okey, and this morning I'm generating the financial reports. As I was generating the financial reports, I'm able to generate datas in BALANCE SHEET. But as I generated the income Statement…
  • Importing spreadsheet data into A/R invoice batch Sage 200 ERP

    Hi there! I have hit a bit of a wall and I'm hoping someone here can provide some pointers. Here is my situation: We have a company with multiple operation centers. I'm in the head office and part of what we do is to take paper contracts and input…