A customer recently encountered the error “Cannot connect to Sage 300 Signon Manager” and, when checking the event viewer, the error code 2147943660 was displayed.
To get the relevant error message description, firstly convert the error code 2147943660 to hex: 800704EC.
This can be done using e.g. Google or Windows calculator in Programmer mode.
Next, take the last 4 digits (04EC) and convert to decimal…
Employers in different Provinces in Canada and different States in the US have their own offerings when it comes to vacation time but all offerings are within the regulations in each employee’s jurisdiction. A couple of commonly used methods with setup steps based on certain scenarios are referenced below:
A wildly unused feature of Sage 300 is General Ledger Integration. This feature will increase the level of details that populate GL entries from the subledgers.
How to:
GL Integration is specific to each modules.
The most common error in web screens appears during login.
This error is an Unexpected error:
An unexpected problem has occurred. Please try again or contact your administrator for assistance.
What to look for:
Financial reporter derives values from specification defined in Column A and B in the spreadsheet.
The most common use is to define an account group to a section in the sheet. When troubleshooting issues with FR the first level is to verify accounts associated with groups.
How to verify accounts to groups:
After diagnosing issue with SQL Profiler, determine a long query against PMPROJS table and then single record fetches to PMPROJT table.
The behavour is intermittent as not all AP Batches are Project Job Cost entries so only occurs when particular projects are referenced in AP entry.
Sage 300 PJC was not optimized to work with large open project data set, and does not filter by a particular project or phase, but queries…
With the release of Sage 300 2023 there is a major change to Sage 300 Database structure. Download now includes 4 document files:
1. Sage 300E What's New in Version 2023.3 (Video)
2. Sage 300 2023 Release notes
3. Sage 300 Enhanced Security (Has step by step information on how to setup)
4. Sage 300 Security guidelines.
With the recently released Sage 300 2023 Product Update 3, the following message may occur if your user account password has expired when attempting to log in to Sage..
"You password has expired. Ask your administrator to change it".
In the lead up to this expiry, you would receive a message "Your password will expire in XX days. Do you want to change it now?"..
It is recommended to change the password…
After installing 2023 Product Update 3 (2023.3) you may encounter the following error message during the initial configuration of the Database ID Vault and Store Databases.
The assumption is that the Vault and Store Databases have been created in SQL Server Management Studio and the correct SQL Login ID and Password has been entered.
Possible reasons for this error could be:
There was a scenario that the client didn't uninstall Sage Intelligence workstation setup before their old server was already offline with the new server in place. When the client tried to uninstall Sage Intelligence workstation setup, the program was looking for the old server which is already offline with "Cannot connect network server" error during the uninstall.
Please make a backup of the registry if…
In Sage 300, it allows you to import one or more entries into P/O Purchase Order by using an import template to import the data. There are different types of files formats you can generate to fit your needs. For example, Excel, Single CSV file, CSV file, Access, ODBC, and XML.
The steps to generate the import template are as follows:
This is a known issue with task scheduler and is being investigated by Sage Intelligence development.
As a workaround, use a batch file to launch report and add in a task kill statement to clean process.
For example.
TASKKILL /F /FI "USERNAME eq <UserName>" /IM Excel.exe
(Note: Change <UserName> to Domain\User or Local user that has rights to execute in the operating system).
The following error message may occur when running a Sage 300 Intelligence Report :
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
Viewing the Tenant Cache you can see that the DB Pswd field is blank:
To resolve this message, you will need a Connector Module entitlement.
Launch the Sage Intelligence Connector
Select the Sage Accpac (Auto Connect) connection.
Uncheck the "Use Auto…
With the introduction of Microsoft Server 2019, a change in task scheduler causes a malfunction in task from executing.
Add the below folders listed folders:
**Make sure the task will be created with administrative privileges.
Navigate to the below folders and ensure there is a Desktop folder.
C:\Windows\SysWOW64\config\systemprofile
C:\Windows\System32\config\systemprofile
With the release of Sage 300 2022 which was launched in August 2021 Integration Access Pack (IAP) is no longer supported, and applications that used IAP licenses now using lanpak licensing.
It has been found that third party applications connecting to Sage 300 may experience connection failures resulting in lanpak.bin maximum licenses being exceeded.
When application opens a session the connection holds a lanpak license…
Different Provinces in Canada and different States in the US have their own regulations on sick time compensation. Different employers may also offer different Sick Time/Pay to their employees through use various methods but are within the regulations in each employee’s jurisdiction.
A couple of commonly used methods are referenced below:
For Sage 2023, there are now three Sage 300 related menus (Sage 300, Sage 300 Admin Utilities, and Sage 300 Support Utilities) under Windows Start menu.
In Sage 300 Admin Utilities menu, there are some new items (Data Activation, License Manager, and Current Users). Please see below screenshot.
Users can now use these utilities without the need to open Sage 300.
Hope these information help.
Compensatory/Banked time is a practice that employers can use to track additional hours that an employee worked instead of compensating as overtime pay. Compensatory/Banked time can be setup as an accrual in Sage 300 to track these hours worked. Since there is no calculating method or an increment amount or percentage, some standard setup options for an accrual code are not available. The employees accrue compensatory…
When you click the Components Button in Order Entry for a line item that consists of a Bill of Materials (BOM) the Component Description displayed is the BOM Master Item Description.
This is a setup issue for the BOM.. Go to I/C Items - Bill of Materials.. Select your Master Item
Double-Click on the Component Item to bring up the I/C Component's Bills of Material screen.
If this description is Blank, then in…
Do you know there are different types of O/E Orders in Sage 300?
There are four different types of O/E Orders you can do:
For Active type of O/E Order, it can contain items on backorder or may be on hold. If the order is not on hold, you can post and print the an invoice for shipped goods.
For Future type of O/E Order, Day End Processing automatically activates future orders on the order…
Setup:
There are many Pennsylvania local taxes that are supported and they are stored in a Repository table that is updated by the Sage 300 tax updates. These local taxes must be setup and added before they can be available to be added to any employee. When setting up an employee with Pennsylvania local tax, usually a Resident (R) and Non-Resident (NR) tax code is required. These usually references the Home (R) and Work…
Sage 300 2023 only includes Microsoft ODBC Driver Version 18, native client is only available on previous version media.
For example to find native client, mount Sage 300 2022 media iso.
Native client will be available in below for x86 and x64 version
<Iso Mount drive>\Sage 300 ERP\ISSetupPrerequisites\{63A88B12-4E66-43FC-8869-2360D32FB05D}
<Iso Mount drive>\Sage 300 ERP\ISSetupPrerequisites\{125AB5F8-0156-4A9F…
As of the December 2022, the printing and eFiling of 1099s and 1096s from Accounts Payable will go through Aatrix. The printing of the forms will continue to be free but the eFiling part will require a fee that will be charged by Aatrix. The Sage 300 versions that will have this feature include:
I listed the forms that Sage 300 supports in another Blog but with this new…
We have identified an intermittent issue with worker process crash, resulting in failure in web screens. The event viewer shows an application error with Sage.CA.SBS.ERP.Sage300.ExportReport.exe.
This issue has not been replicated in support as a result a debug process has been created to help identify the issue. Please see KB 118436 to apply debug.
Debug will create report trace in online\web folder
There are two ways for the program to cost inventory in the Costing tab in I/C Options in I/C Setup:
- Cost Items During Posting
- Cost Items During Day End Processing
The first option above allows the program to update cost during each time you post an inventory transaction and the second option allows you to update costs when you run Day End Processing.
Users can perform Day End Processing in Inventory Control, using the…
