Sage 300

Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…

While the new ability to add a PO Receipt referencing an existing PO is a long awaited for feature of the Web API, the 2023 release has a bug that makes it impossible for us to use this feature. PO Receipts with additional costs incorrectly assigns…

Is there a way to bulk import items within Sage 300? We around 2000 items that we need to add. Typically we add items using the Items Wizard manually as we utilize quite a few Optional fields and use different pricing Item Pricings. I have tried to use…

We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error. Other companies work so it has to be the database but it is the same as in production. I change the database setup to go straight…

Hello. There are two columns in table OEINVD, INVDISC and HDRDISC. The descriptions for these are "Invoice Discount Amount" and "Header Discount", respectively. What is the difference between them? Thanks in advance, Mike

Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?

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…

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…

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…

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…

The questions was asked 5 years ago and the answer (thanks Ettienne) is pretty straight forward: --------------- Clear these fields: ARCUS.IDNATACCT AROBL.IDNATACCT AROBS.IDNATACCT You can delete records from these tables: ARNAT ARNSM ---------…

one of my customers is having missing data from the Tax Tables in both Header and Detail whereas the same is available in AR and AP Tables. What is the best way to update the tax tables so that they can generate the Tax Reports. Any Suggestion?

When running a data integrity check on Order Entry we get a few of the following errors on Shipments. E: Header Mismatch: Number of Lines on Shipment(SHILINES) is incorrect. E: Header Mismatch: Shipment Item Total Amount(SHIITMTOT) is incorrect. When…

I have just upgraded my client who has 3 databases on the server and I am having a problem with 1 of them. After activating Sales Analysis and OpsInquiry, I receive an error: Load of System Manager roto events. Load of System Manager roto events…

I will often do the importing of data for my clients. Is there a document that explains what the minimum field requirements are for an import? Is there some kind of logic that I could use to figure it out on my own?

We are a company that hosts a number of concerts, each with their own 'Transaction Optional Field' so we can attribute each sale and invoice spend to a concert if we want to pull a report by Transaction Optional Field. The list is getting quite long…

Hi team , We used to take backups from the "Database dumb" manually but, I want make a scheduled back up from the database dumb in sage 300 ERP like automatically not manually. please advice..

i want to know the user passwords. in which table in the database can i get the information ..and we are using sage 300 ERP

I would like to know if there is a way or a tool that can be use to reduce Sage300 database. I have a company database of 90GB size with data since 2000.

Just wondering if anyone has seen the following error: Error occurred when opening view AS0035 View 'AS0035' is not a valid View ID. Error occurred when activating Sage Accpac Data Source. while trying to do a Data Activation after setting up a new…

Hello Everyone, I am currently learning Sage 300 2019 and have download the latest student limited edition of the software along with the SQL Server Management Studio 2017. I did manage to install all the software and setup the database as seen on the…

Looking for someone who knows their SQL tables here. How can I use SQL to identify the active fiscal period? I see the CSFSC table but what is the best way to determine which fiscal period start date to use? Looking at BGNDATE1, BGNDATE2, BGNDATE3,…

I have imported items and quantities into a Transfer from an excel spreadsheet. The Transfer then SAVES correctly within SAGE300 however, it errors out at the end of the posting process. Error reads "Transit Transfer/Receipt Detail record already exists…

When upgrading to 6.5 received error when trying to activate Ops Inquiry 6.5: Microsoft SQL Server Native Client 11.0 . SQL Server incorrect syntax near “2018”. Anybody with similar problem?