Sage 300

Hi, We are experiencing an odd situation. When in location details and drilling down on the quantity on S/O we are missing orders. It shows the correct quantity but you are unable to see the list of orders. -Customers allow backorders, are not on…

is it possible to load part of the database. where you just want to bring in new data set into an existing database. eg company A has moved all Sales division to company B. Company B had no AR module. We want to move all AR options and history to company…

How to export ACB file from Sage 300?

Hello its me again. I am now able to import a PO receipt entry in Sage. Question now is, can i import multiple receipt entry at the same time?

I have started to upload A/P Invoices using the Excel template provided with Sage 300. Whenever I upload a file, I get the error message "Vendor cannot be blank" despite the Vendor Number (IDVEND) being populated in the Excel file (in the "invoices…

I accidentally cleared all A/R Statistics instead of doing just the year-end activity. So now I'm in big trouble since we use that a lot. Does anyone know of a way to get it back without having to go to the backup? Or maybe an add-on I can purchase?

Hi all, We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project). The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered. We have registered the accpacic1500…

Hi, Does anyone have more specifics in this topic regarding Sage 2022.3 installation and/or setting up? What do we need to do? Buy and install certificate? Just setting ODBC differently? Thank you very much

According to the Sage KB116170 information "In a new implementation like 2023 or in an upgrade where a new DSN using the ODBC Driver 18 for SQL Server to connect, your will require a Server Certificate in place for SQL to connect to the SQL database properly…

I have upgraded to Sage 300 2022 PU2 One one of the client machines, for one of our databases, when checking the database setup, the Database Setup tool give me the following error: Damaged data DBSETUP: Create applications table. Data dictionary…

Sage 300 Premium (Version 2022) SQL 2019 on Windows Server 2019 GL batch posting freezes during month end closing periods and Sage 300 becomes inaccessible for anyone who wants to further login. Other logged in users won't be able to post from GL…

Hi Everyone, I am just wondering if there are any excel template that we can use to import Order? Our order has hundreds of SKU, it is taking alot of time to enter one by one. Thank you very much

Sage 300 2020 PU5 Importing AR customer records to change the delivery method. Import screen displays the field and when I select value I get only a selection box with the 4 available values. When I select a value, it appears in the field list as…

Are there any tools that can help with importing / updating IC items, IC Pricing? I find there are lots of extra data points that I need to include for an import to work. This always requires an export first to make sure I grab those field. IC Items…

Thought I would share this since I have just run into at a client site. Sage 300 V2021 PU4 (and probably any PU's below). There is an issue with the customer/vendor # change product that is supposed to be fixed in PU5 (soon to be released). When running…

When opening Common Services->Company Profile, the following error is occurring: Damaged data. Company Profile. Data dictionary is inconsistent. Error occurred when opening view CS0001. View 'CS0001' is not a valid View ID. Error occurred when activating…

When opening a company, it shows the following error: Cannot alter table CSCOM error = 211. To try to resolve, I installed Sage 300 on a new machine and loaded a dump of the data. The error appears in the new installation also. I also tried replacing…

We have a journal entry batch dying because there is a bad account number. It is coming from periodic processing in Inventory control and it looks like it is the variance that is causing it. I have checked the category and the account set and everything…

Does someone have a template that I can use for importing invoices into SAGE 300 AP using Excel? I tried an export but the arrangement of the output doesn't make sense for a template. Also, I cannot locate the function to import. So I am not sure that…

Hi all, I already create New Category from PJC Setup - Categoties Now i want add that new categories to All Contract - Project at Contract Maintenance. Can we do that with import with excel? Because i failed import, and the error, Contract Already…

I have a sync app running and it's exporting out from Sage: Orders, Shipments, Customers, Inventory, and Credit Notes. I want to only grab the records that have changed since the last time I ran the sync. For some of these it seems I can grab the DATELASTMN…

I want to import items into an O/E quotation. I have attempted to export an existing "QTxxxxx" to use as a template, but I get an error message "Can't Append Table. Error: Too many fields defined." even when I limit the requested fields to those in…

As a system administrator, but not familiar with the app Sage 300 app. I wish to activate the Payroll Module for three “Historical Data” companies in Sage 300. Need this in order to access payroll information from 2009-Current Just wish to know how…

Having issues with Carriage Return characters breaking the Consolidation import files. The fix is not terrible, but does allow for missed transactions if the processing user doesn't action error messages. I've reviewed the utility Sage made available…

Hello Everyone! I am currently learning Sage 300 2019. While using it, I accidentally deleted the Sage 300 System Manager, which contains : Common Services and Administrative Services. Can anyone please show me how to restore it? Thank you in advance…