Sage 300

I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?

Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you

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…

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.

When I upload excel file in bank entry module, the file row is broken. All row is not inserted to the bank entry at a same time, some rows are missing when uploading. how can I solve it, can anyone help me.

Is it possible to import updated unit price in order details using excel file, I import data using excel but unit price can't be updated , it automatically pick the price from the finder.

Can someone please help me build a csv for order entry import? I've tried to export an OE Order but it's too large and keep failing. If anyone has a template or a resource or any other guidance I'd really appreciate it. Thanks!

Hello. I'm working on a project where I need to extract the purchase history from the company's Sage Sql database. According to the documentation located at https://sageaom.kcsvar.com/AOM60/POHSTL.xml the TRANSTYPE of 2 is a Purchase Order. I know…

Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS

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…

A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…

Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…

Hello, Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank

Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

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.

I was wondering if there is a quick way to delete over 1000 accounts quickly, rather than one by one. I am pretty familiar using the import and export feature, however that only allows me to update the accounts, not delete them. Or maybe it does allow…

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

What field in IC item pricing table determines discount by percentage or by amount?

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 integrating my data into sage accpac. How ever I get the below error " Purchase Order Line Attempt to change read-only field 'Optional Fields'. " My Question is how do I change Optional Fields to be not read only? Regar…

Hi, I would like to update the item descriptions on all price lists to match the item descriptions in the regular I/C Items file. If I were comfortable in MS SQL I'm sure it's not difficult to do there. But I believe it can also be done by exporting…

Hi all, I am doing customization on Bank Entry Screen using ISV module called Extender. But that is not the problem. I notice that, on the Bank entry grid, every time I add new line, the LINE value will auto decrement -1,-2,-3. if I remove -2, and…

Hello, we have an old invoice that shows in the documents tab. This invoice was originally imported when we switched to 300. We are not been able to credit it. In which table is this information stored? The invoice does not show on OE invoices, only…

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…

A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed. sage 300 has detected module update inconsistencies that requires activation. The…