• Received not Invoiced report?

    Is there a standard report that will show me POs received but for which an AP Vendor Invoice has not been entered into the system?

  • How to remove Crossing mark in cheque print?

    Is it not allow to print a cheque without crossing in Sage 300? I can't find a place to remove "Not Negotiable" crossing. Pls help me.

  • Database dump fail

    Hi there,

    I am trying to perform Database Dump but always get the following error message.

    Then, if I perform database verification, it returns this.

    Could I know how to fix this issue to be able to dump database?

    Thank you!

  • Change Job Cost Code Format

    Good morning,

    I'm trying to align our cost code with the 2014 AIA cost code format in Sage. Right now, it's formatted as xxxxx.xxx but I want it to be xx-xx-xx.

    Does anyone know how i can change this format?

    Thanks in advance!

  • Charles Schwab 401K export file

    I know this is a very specific question and I may not get any replies.  But I thought it was worth the ask.  We are transiting our 401K fund to Charles Schwab.  They have a quite extensive file spec for uploading payroll data in regards to 401K deductions…

  • Sage Alerts and Workflows with 2 Factor Authentication

    Our IT company has turned on 2 factor authentication and now Sage Alerts and Workflows is not able to send out e-mail notifications.  Has anyone figured out a way around this?


  • Are ICPRIC and ICCPUR accessible via the Sage API?

    Are ICPRIC and ICCPUR accessible via the Sage API?

    If not, is there any other way to access Price Lists, other than by direct SQL Query or middleware such as Realisable IMAN?

  • Sage 300 What's New in Version 2023.0 training is now available on Sage University

    A new What’s New in Sage 300 Version 2023.0 anytime learning training is now available on Sage University for customers and consultants. This training provides you with information on the exciting new features and improvements that have been implemented…

  • Sage 300 FTP Credentials

    It seems sage have changed their FTP credentials.

    How can I download patch updates

  • How to filter OptionalFields collection via Sage 300 WebAPI


    I was trying to perform some oData filter on the ReceiptOptionalField2s collection but the return from Web APi is:

    statusCode: 400

    "error": {
    "code": "InvalidParameters",
    "message": {
    "lang": "en-US",…

  • [Sage 300] I cannot add optional fields.

    Hello Team,

    I cannot add the optional field for A/R Documents.
    Previously, I used the button Create New


    But in Sage 300 2022 the button is absent.


    Could you clarify on how to add the button 'Create New' optional field?

  • How to reverse posted job-related transactions?

    There are two types of job-related transactions. One is done within the Project and Job Costing module ( in PJC transactions folder).  The other one is done outside of PJC module and it’s a job-related transaction.

     Now we are going to talk about…

  • Bank Reconciliation posting error: Requested payment was cleared previously

    We have been working with a customer who has had some issues with their bank rec.  We have worked through their issues and are at the point where we are ready to post the reconciliation and we have received this error:

    Requested payment was cleared pr…

  • Can you reconcile E-Statements with Fifth Third Direct Bank that is different from Fifth Third Bank


    I have a client that would like to Reconcile E-Statements with Fifth Third Direct not Fifth Third Bank and they cannot. Does anyone no if Fifth Third Direct is supported?

    Thanks for all you do

  • Customer number change and National Accounts

    Client has a request to change the customer id but the customers belong to a national account.  Reason for the change is that the customers are changing affiliations and client built in national account identifiers in the customer number.  Most of the customers…

  • Sage 300 crashes after upgrade

    I created a new virtual server with sql server.  Then i installed sage 2020 and loaded the sample databases.   Then I ran the sage 2022 installer to upgrade it.   Now when I open Sage it opens and shows my company but when i try to open the company it says…

  • Test System not showing expected data

    I am trying to create a test system to I can run a test upgrade before I do it on the live server.

    Steps Taken:

    Created a new virtual server and installed server 2019

    Installed a new dev SQL Server instance

    Did a backup of my test sys database from pr…

  • Sage300 2022 Installing Web Screens crashes IIS

    Windows Server 2019
    Sage300 2022
    I have setup & load SAMLTD & SAMSYS

    I have installed both PU1 & PU2.
    IIS cannot start just after WebScreen installed.

    Problem solved...Thanks.all

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

  • Accounts Payables discount not posting a Journal

    I have a client who's vendor is giving out some accessories with a 100% discount in a certain month. On Purchase order, the client is capturing  this accessories with the previous cost but discounting it at 100%.

    The challenge is and I stand corrected…

  • Sage 300 Premium (Version 2022) Software Integration Documentation

    This is my first time working with Sage software.

    I have a Python web application running on the same Microsoft Server as Sage 300 Premium (Version 2022). When a payment is completed through the web application I need to associate the payment, payment source…

  • How to make OE CN on account and reference an OE Invoice

    on OE/CN screen you fill in OE/Invoice number and Sage loads details

    I have certain customers where all OE/CN are on account, trouble is once you erase the OE Invoice# the screen details erase (can we stop this from happening?)

    I did not want to manually…

  • Posting Payroll

    Our payroll period is 5.9.22 - 5.22.22.  Payday is 5.27.22.  After we are done with payroll, we post payroll.     Our GL manager stated that there are unposted items.  Can we run a repost?  Before our next payroll pay date?

  • Financial Statements fails to open in MS Office 2019 Pro Plus

    Hi everyone,

    Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…

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