Sage 300

Hi all,

My Sage 300 version is 2023.1.0. I already have the web screen running & working fine.

My Visual studio version and info below:

Microsoft Visual Studio Community 2017 
Version 15.9.52
VisualStudio.15.Release/15.9.52+33403.129
Microsoft …

Hi Everyone,

We seem to be having an issue with our A/P Vendor Reports. One of our users was able to run a T5018 form from the "Print T5018 (CPRS) Forms" icon on Feb 10th. Now when she goes to run the report the icon is no longer shown, along…

I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.

Now I want to add some fields to it that are not in the set of data tables already in the report. 

In the "Field Explorer" I right…

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?

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?

TIA

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?

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…

Hi, 

We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…

I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2

I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5.

Location 1 had zero of these items and so it…

Hi all,

A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea?

Thank you.

Yours Faithfully…

Hi all, I tried to use Visual Studio 2019 with Sage 300 Solution Wizard to generate a simple screen. Right after the solution was auto generated, I use Sage 300 Code Generation Wizard to create a payment code screen. I tried to build the solution but the…

I may not be processing this correctly. Send the request below creates a new batch everytime.

POST: http://localhost/Sage300WebApi/v1.0/-/TESTCOM/AR/ARReceiptAndAdjustmentBatches

We are rolling out the Project Management module and want to require certain fields so our Project Managers are required to enter the information before they can create the new job.

Is this possible?

Sometimes clerk uses the wrong year, or month, when entering AP invoice. We post automaticall;y to GL

She doesn't check her report for errors and then controller needs to investigate when it is denied posting at GL level.

Does anyone know of a way…

What is the syntax to add a budget colunm of a specific year?  How to specify 2020 budget column to the report?

can we integrate sage 300 SDK with node js? 

Hello Team,

When I try to call ARCustomers via API using a filter that designated in the Sage 300 specification, I received an error.

Example of the request:
http://{IP Adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$filter=DateLastMaintained le datetime…

I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears

Good Day, our client upgraded there office from 32bit to 64bit.

But now we are getting a class not registered error when trying to open macro to display user form.

We have tried to reg edit the fm20.dll file and that also gave us an error.

How else…

Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning 

Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH")

On "OnUIAppOpened()"

Public WithEvents dsGLJEH As…

We need to retrieve Purchase Order details to include the PO # and "Ship to" name.   Can this be done with canned reports in Sage 300?  My searches have come up empty.

We have intelligence but not Connector.  The Purchases Master report doesn't appear…

Having problem with my SAGE 2020 (300 Premium) (Build 0)

When I tried to add COM Components for example AP2100 (AccpacAP2100.AccpacAP2100UICtrl)

and drag that to my Empty Project .NET (VB), it show's the error below (Failed to import the ActiveX Control…

Hi there,

This is my first post in Sage 300 online Community, woohoo. I find myself in uncharted waters.

I am putting together a custom date formula, where the date has DDD field, which means 3 digits for "day in year".

Example would be that…

Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time?

We're trying to determine:

1) How many commitments were…