Browse By Tags

  • AP Check printing with missing alpha text.

    AP Check printing with missing alpha text. Noticed after upgrades to 2023PU1 and 2024PU1.
  • Emailing 1000's of invoices out or Sage in error

    I had a customer that wanted to email out invoice in Sage 300 but before she selected the range of invoices, she selected delivery method of customer and clicked print. OOOHHH NNNOOO!! Panic!!. over 4000 invoices were going to either be printed or emailed…
  • HOW TO GENERATE A PREVIOUS BANK RECONCILIATION REPORT?

    Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…
  • List of Open Batches VIA WEB API

    Hi Is it possible to get a list of Open AR Invoice Batches via WEB API\ Or provide an endpoint through which we can query to find list of open AR Invoices batches in Sage 300 Regards
  • Are First and Last Names needed for printing or eFiling 1099s?

    I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…
  • Printing error

    HI All Please assist on how to resolve this error. It appears when trying to print any report in the system. The print server is configured and the service is running. Job 2 - ERR 262 coming from the edition server : Connection to the X3 file server…
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Setting up ZPL Printer (Private Network) with Sage X3 (Cloud)

    Hello Everyone, We are trying to setup ZPL printer on Sage X3 but the problem we are facing is: a. ZPL printer is on a private (LAN) network - not accessible outside b. Sage X3 is on the cloud (Accessible only by a secured SSL URL) c. Sage X3…
  • Work Ticket Printing Error

    There are 2 buttons designated to printing the pick list and also the work ticket. When clicking on the Pick List print button it allows us to print the pick list with no issues. However, when trying to print the Work Ticket we are met with an error …
  • Error on Opening the xla macro

    Hi, We have encountered an issue whereby we are receiving the following error messages: 1. PrintReport: Error on opening the xla macro 2. Problem is found in running Financial Reporter Addin We do not have application support in-house and have…
  • Multicontact emailing using Gmail giving error

    Why are Multi-contact emails not sending out when using GMAIL settings, however when selecting single email setting in AR it works?
  • How to enter a project expected billings/invoices for cash flow forecast

    Hello, Does anyone know how to enter in Sage expected billings/ invoices for projects ? Goal - cashflow forecast And also where to find a report for this filtered by project. Thank you!
  • User Activity Report

    sage300 v7 (2023) sp1 fresh install. I can't get user activity to show any details. it comes out blank. running it as admin the company has had users using it for a month now
  • Windows 11 / Business Vision 2023 Reports freezing when printing &/or saving as pdf

    Hello community, I am in desperate need of HELP ! We use Sage Business Vision for small business version 2023. We installed it on 1 new computer with Windows 11 operating system in November 2022. Originally, there was an immediate C++ runtime error…
  • Does anybody know what table and field the Notes module stores the note status? (Active, Future, Expired, Dismissed)

    I see there are 4 tables for KN module. KNNOTEH is the main one. KNNTDIS is apparently to make a list of notes that have been dismissed, however, these records remain if you restore the note so this cannot be where Sage records the note status. KNSEQ…
  • ZPL List "cuting" my file

    Hello, I need help, i'm creating a PAT file using openo and wrseq with some ZPL code, that file is then called by a Report wich has been created using a ZPL list. The PAT file is created without any problem, but when i call the report the .DATA is generated…
  • Is Sage 300 2022 PU2 Compatible with MS Office 2021 32bit?

    Hi, One of our client upgraded their Microsoft Office version to Office 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit. Does it compatible with Sage 300 2022 PU2? They need to run FR, but encounters the following errors: Description: PrintReport…
  • Printing Multiple Invoices

    Hello everyone, this there a way to print multiple invoices under a customer number at once? (I use Sage300) Example: A customer sends me a list of multiple invoices that they need. I don't want to search each invoice individually and save as a pdf…
  • OECOINI comments

    Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?
  • Download or Print Select Invoices to Pay in Sage 300 CRE

    Is there a way to either download or print the vendor invoice list that appears on Select Invoices to Pay?
  • Mismatch between I/C quantity and Lot/Serial quantity of an item

    How to fix mismatch between I/C quantity and Lot/Serial quantity of an item if there is a variance on the I/C Serial/Lot Number Quantity on Hand Report? Below is an example in our sample data for this item, A1-405/0 at location 1. As you can see the…
  • Slow Performance during Report Phase Job Started and Printing X3 V12

    Hi, my company is in the middle of a migration from SAGE X3V5 to SAGE X3V12. R093.001.00019 When running a report in X3V12, the querying part (Job Started Phase with the green bars) takes an extra 1-3 minutes on average than it did in X3V5. In X3V5…
  • System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at AccpacCOMAPI.IAccpacSession.GetPrintSetup(String menuID, String ProgramID)

    accpacPrintSetup = accpacSession.GetPrintSetup(" "," "); on reaching this line application crashed
  • FINANCIAL REPORTS IN DETAILS

    I have chart of accounts with two segments i.e MAIN & MAIN SUB 1234 Repair and maintenance 1234-01 Repair and Maintenance - HQ 1234-02 Repair and Maintenance - TZ 1234-03 Repair and Maintenance - ZM On printing financial reports only Main…
  • Purchase Order Printing

    When I print the purchase order it does not show the item description on the purchase order. How do I fix it to show the description on the purchase order? Thanks