Sage 300

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! So I've been able to successfully import orders via the import function. I'm wondering though, if I want to make changes to orders already in there, is it also possible via the import function? As of now it will give me an error saying the…

I can successfully upload A/P invoices using the basic template included with Sage 300. However, if my invoice number ("IDINVC") includes any text (e.g. "A23456") the upload fails with the error message "Document number cannot be blank". It is very…

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?

We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…

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…

Hi all, On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below. I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible. Anyone know…

I really thought I just exported the customer file to excel from within Sage but I don't see that column anywhere. Or in the SQL tables.

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…

Description: Failed to process the file due to an unspecified error. When I try to import an OFX file I get the error above. It worked five months ago when I tried it last. I have rebooted the server and the workstation. I get the same error whether…

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!

Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…

Is there any way to update my unit descriptions from an excel spreadsheet? I tried an import but apparently there is no insert/update for that import, just insert. Would a macro be the only way?

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

Getting an error 127 every time a client tries an item combine function. I believe the 127 indicates a duplicated field but I cannot find anything. RVSpy is giving no clues. Any ideas for where to look?

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…

Anyone know if there is a way to generate an export file from a list generated using the GL account code change pattern. I have generated a very extensive list of GL account code changes using patterns in the lab. I am wanting to grab that list and turn…

Is there a list somewhere of the minimum REQUIRED fields for importing into SAGE 300 modules? Rather than experimenting with exporting everything and removing columns one by one then importing until it fails? I'm specifically looking for payroll timecard…

While uploading a CSV of employees to sage, I got an error code 3.3978.0 I have attached the error report here. I cannot find anything under that error code and the report does not give any direction to fix the issue.

Hi, I have a test company with 20 banks defined which I exported in excel to import to the production company. Import fails on record 1 with the error "There is no entry for statement currency in this bank's valid transaction currencies." Although the…

Every year I have to change AR Customer default price list. We have 90K customers and import from excel takes more than 72 hours. Hardware is definitely not an issue since ship to locations are updated for less than 12 hours. Using minimum of data in…

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…