Sage 300

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…

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…

We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…

Project and Job Costing (Job related) PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found.". All other PO receipts have no issues. Please help us to solve this issue. Our Version is Sage 300 ERP 2019 and Database is Sql server…

Good day, I am trying to export data from my local sql DB in sage. I am new to sage integration, so i have narrow knowledge on this subject matter. When i inserting InsertInvoiceDetailSoftCols() i get an exception "Error HRESULT E_FAIL has been…

This is the file I am using to Import bank statements to reconcile our postings on Sage. The entry does not reconcile, I have tried everything please help and let me know what I am missing on this Excel sheet to complete the reconcilition. This file…

Hi When I imported one transaction to see how reconciliation works, i got the below error. It says 1 updated but It does not reconcile that transaction, please could someone throw some light ?

Hi, I want to import bank statements into Sage 300 - I am not sure what the below fields do and what their exact column name would be for my import file. Could someone please help ? Cleared Y/N - Integer (Column Name ?) Used Y/N - Boolean (Column…

Merry Christmas Everybody, Before I left my office for Christmas Eve Thursday night, I was struggling with the very clumsy and unwieldy asset acquisition data entry process of the norming asset management module of our Sage 300 system. I had noticed…

We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…

Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

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 ---------…

I have been using Sage 2017 for Payroll for some time and have used Dbase format to import/Export since days of Accpac Dos. Upgrading to 2020 SM finds that the option no longer exists. I am having issues exporting using CSV (Through Visual Foxpro) and…

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…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…

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?

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, kindly advise me

During an end of month retrieve into SA the client is getting the following error message: [Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot insert duplicate key row in object 'dbo.UXARINVHO' with unique index 'UXARINVHO_idx0'. The duplicate…

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..

Hello, As per subject, it pop-up error message and i have to manually delete off from my excel and continue import. I have 130k of new items and i do not wish to do the deletion part. Please help. Sage 300 2016 Advance PU 5.

We have a couple of optional fields set up in I/C on about 50K items that have not been used in years. Can't delete then because "they are in use" I want to clean this up and then set up one new valid optional field. Are there any ramifications…