• Old Financial Statements

    How do I print a financial statement from 2021?

  • Sage combing paystub info

    Hello, SAGE Payroll Processing is combining pay stub info. Could this be a crystal report issue? if so, where we would we begin for diagnostic? 


  • SAGE 300 2020 - User Access Review

    As part of a user access review, Support have asked if we can provide a “last signed on” field either with the user details or in a separate report. Is this data available?

  • Generate the Inventory Value Report as at 31st December 2022

    Hi, I want to know, which is the correct way of getting Inventory Value Report as of end of the year (31st December 2022). Today 2nd March 2022. If we Generated Item Valuation Report using Transaction Cost ( Changing the year end date to 31st December 2022…

  • OE invoices emailing same invoice to all customers

    Sage 300 2017

    One workstation only when sending multiple invoices out of OE is sending the first invoice in the range to every customer. Has anyone had this before? 


  • Auto save pdf of report after preview

    Hi all,

    can Sage 300 do something like this? when user preview the report, to auto save the report as pdf to specific folder based on the year, month, date generated, and customer.

    thank you

  • Norming Fixed Assets - asset reporting

    Hi I am new to Sage and Norming Fixed assets,

    I am trying to look for an asset report that I can run for the month that will show me the following on 1 report: sorted by category

    - asset number

    - asset description

    - Orig purch price

    - In service date

  • Bank Reconciliation Status report as of a specific date

    I need to find the details of what withdraws and deposits were outstanding at 10/31/22. The reconciliation status report seems to give me what is outstanding at this moment in time for anything processed through 10/31/22, not exactly what I need. I have…

  • Email with Outlook 365 client

    Sage 300 2023 PU1 installed. Common services email option has "use service" unchecked. Client has MS Outlook 365 installed. Sending emails through Sage is giving an error. I can't find any documentation regarding versions of outlook that are supported…


    Hi , 

    I have clients that require a monthly billing report with specific fields from the transactions processed.

    Invoicing is done from the AR & OE module. 

    Since OE invoicing ends up in the AR tables, I have created a report from the AR tables. 


  • AP Checks Printing Differently

    We have a client with offices in two different cities (in the same state).  Each office has its own individually licensed installation of Sage 300.  (Common ownership, but legally separate companies.)  There is a one-version difference between the offices…

  • Sage300 Font issue

    Just upgraded to Microsoft Azure. Same version of Sage300 and crystal reports. If you print preview a report fonts are crazy and look strange on screen . Export and view in Adobe font is as specified in the report layout. Arial font is loaded on server…

  • Sage 300 Web Screen - How to data populated in Activity Trend on the Dashboard?


    Anyone can tell me how was the data in Activity Trend in web screen's Dashboard was populated? 

    Am checking for the Shipment Value on the bar chart. Compared it with the Shipments information on the same date from Sage 300, but could not get…

  • Web screen report

    Reports do not print from the Sage 300 Web Screens. No error message or warning is displayed.

    I tried to open on server and on client.

  • ERROR Code: 2147467259

    I am trying to preview or print in sage 300 and keep on getting  Error Code: 2147467259 (Method object failed)

  • Pallet labels


    has anyone done pallet labels. so you create an order and items are scanned in and placed on pallet. This can be a mix of products.  Like 10 boxes product A 2 boxes product B. 
    pallet label must print those 2 

    has anyone done this in sage 300 or know of…

  • 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 just…

  • Overdue Customer Report Needed

    We need a simple way to query a report for on hold accounts and their outstanding payment amounts. I thought I could use some of the data provide from the AR Customer Inquiry table, but I can't seem to find what that table is called? 
    We need - Customer…

  • Is there a way to have CRM notes print on the picking slip?

     I have the option for it to print on the packing slip but want to include notes for our shippers on the picking slip. Is there an option that would allow this?


  • How to print TB for future year.


    The scenario is like this:

    The Financial year is Jan - Dec 2021 while the transaction that entered in the system is until Jan 2022. Note that the user is not yet create new year as the transaction of Dec 2021 is not yet completed. So, here, how to…

  • Accounts Receivables SAGE 300

    Hi Good Morning, could some one list all the tables in SQL server that are related to Accounts Receivable Aging Report.  We have SAGE 300 2021 version



  • 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 and…

  • Web Screens and PrintBoss


    Has anyone tried (successfully) printing from the Sage 300 2022 Web screens to PrintBoss? (For AP checks, OE Invoices, etc.)

    It seems to me that, since these immediately save to PDF from the Web Screens, they won't be able to be redirected to PrintBoss…

  • Email more than one invoice at a time

    How can you select more than one invoice for the sane customer and email in one go 

  • A/R Customer Reports - Statements / Letters / Labels can i re run this after I print it?


    I was warned that if I go to A/R Customer Reports and then run the Statements / Letters / Labels, that I won't be able to run it again. The person telling me this said it's a one and done thing.

    My question is how often can I run it? I…