Sage 300

I accidentally deleted all the records in the 'currency rates' section of Sage 300. How can I recover them?

Sage 300 Version: 23.1.1.72 I am working on a simple interaction between an Excel spreadsheet that extracts data from specific tables within the Sage 300 database. With my "admin" credentials it works but with a specific user's credentials it fails…

Hi All, can we import Qty Cancel at PO Receipt? Or any macro or tools for this?

Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…

Hi, I have tried to import PO Receipt Entry using Single CSV file format. The data import showing no error message. However, when I call out the receipt number, only header with data but line details showing blank. Choosing the Single CSV file for…

Normally I import into PO Receipt Entry using an ODBC connection to the tables. Recently I've run into a issue where the receipts will import but upon checking the receipt, the header populates but is missing the PO line details and Export SetID. This…

On the server, V2024 with PU1, when posting item number change, we get these errors: AP68ATRK: Critical Error: [4039] unsupported field type. AR68ARRD: Critical Error: [4039] unsupported field type. On a standalone, V2024 withOUT PU, no error…

Our Sage local DB environment was setup in 2017 hosted on a Windows Server 2016. I am attempting to gain access to the data. Currently an active SQL Instance is named SAGESQLGATEWAY and when connected to it, only lists SqlGatewayConfiguration database…

we are receiving this error when attempting to change a customer account code. There seems to be a lot of issues with the account change programs these days. I found in the past that it was missing files that needed to be copied over but this error has…

I have a client working with Sage 300 2012. Does a field exist that provides the expected delivery date? If so, what table/field would contain that?

I have successfully upgraded my Sage 300 install from version 2022 PU2 to 2024 PU1. Thus far no problems have been found running it. On the Database Server, in MS SQL Server Management Studio however, multiple new users were created during the install…

Hi, is there an online video to explain how to do the following: I want to export on excel particular info from invoices. I tried to do so but get an error when trying to set up criteria. i would need in particual cust name date inv # the detail of each…

I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation. What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…

we are using sage 300 with the technisoft service manager app on a Samsung a8 tablet. in the stored actions it says the above line and wont sync anything following that. I've tried everything from fully deleting the work order on the dispatch side (pc…

We have Sage 300 2020 running on a Windows RDS server with multiple users accessing the application via RemoteApp programs. Everything has been running fine for a couple of years but randomly last month our users cannot export files any more. A user…

I am reaching out because I have diligently followed the installation document step by step for importing simple data. However, I encountered an error, as indicated in the attached screenshots.

Error: "Failed to Establish the Vault and Store Databases" During database setup. Above error showed up. New server 2022, new MSSQL 2019, new Sage 300 2024. ODBC tested successfully new install, no Vault/Store in shared data directory mapped…

After installation of the latest tax table update, the above message appears along with:A error has occured during the process of T4A extraction. The error returned was 1142. The operation being performed was a viewPut call to paper T4A information. Create…

Recently my workstation was upgraded from Windows 10 to Windows 11, shortly thereafter I started experiencing issues importing excel files into Ship Orders (Tairox). Whenever I try to import an excel file into ship orders I get the error "Microsoft Excel…

Hello, When we try to export the Employee section of Payroll employees in the Canadian Payroll module we get an error message before it completes that says, error - Type Mismatch, LASTRAISE field should be date. It also says error - stopped processing…

We have one laptop running Sage 300 version 2023 (Product Update 1) and have error activating New company. After Click Data Activation > Proceed below error pop up. Please advise

Hi All, Kindly advise on where i can get a list of customers with all information updated such as email address, customer number, postal address etc.

When clearing transactions in IC I run into the following error: ICITEM record not read (2362 ICASEN1.C) Any ideas? TY

I was importing an excel invoice template getting error in sage 300: invoice invalid characters put to field 'remit-to location' Thank you

Hi all. I create my own excel file with the same sheet name, column name as exported one. however, it failed to import with the error below. However, copy pasting the content to an exported excel file seems to works fine. The issue is: I am going…