Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
hello
i had those errors
Unexpected Error: An unexpected problem has occurred. Please try again or contact your administrator for assistance.
Unexpected Error: Error HRESULT E_FAIL has been returned from a call to a COM component.
when i try to…
I’m trying to determine what table & field name lies behind the field in the yellow box below? Looks like I’ve got to drive some conditional logic with it for a report, but I can’t find it in the database.
You get to it by clicking the Item/Tax button…
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!
After installing Sage 300 2023 PU3 I have created 2 new databases and an SQL user as it is explained in the Sage300EnhancedSecurity.pdf document. However, when I log in Database Setup and entered the required fields on the opened Configure Databases pop…
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 All,
In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table.
But there is no entries for 3, 4, 5 in AOM.
Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH?
Thanks.
Hi everyone,
We are just moving DBs of some Sage 300 customers to new database servers with SQL Server 2019 (Windows Server 2019). We are not going to upgrade Sage 300 or move applications to new server, just Databases. From SQL Server 2008 R2 to SQL…
Hi All,
Has anyone installed Sage 300 2023 with SQL 2022 yet? Does anyone have it working? I know it isn't in the compatibility guide yet (as of 8th March 2023).
I am hoping it is supported in the next Product update or sooner.
Regards,
Quent…
Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet.
I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…
I cannot find the Tables names and field description for the Manufacturing module in Sage300. Anyone knows where to get it
Something similar to this
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…
Hi everyone,
A customer is still running Sage 300 2019 (with SQL Server 2012) and its going to move to Sage 300 2022 in a few months. But before of that its going to invest in a new server and want to upgrade some applications to SQL Server 2019.…
Hi all.
I am looking for the Column that store the deposit date of AR Receipt Batch. But ARBTA does not have Deposit Date column. Then I go to ARPJH and update the column DATEDEPST (Deposit Date), but the new value does not reflect on the AR Receipt…
We have disabled login user Sa in SSMS and created different user to access Sage 300 databases, Our auditors asked us about the default logging users created when you install SQL. What's the best practice to deal with those users created during SQL installation…
Hi, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully.
I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…
Every now and then I have Sage freeze and lock everyone from doing anything. It commonly happens in the payment batch list during heavy usage around month end, but it can happen other times as well. The system during the working day is under heavy usage…
Can anyone think of a reason why random PO Requisitions are randomly getting nuked? I am the only one with a DELETE button so it's not like anyone is able to manual delete them. We created an alert to find them when they are deleted but we just can't…
Are there any best practices or caveats for re-indexing Sage 300 Databases using Microsoft SQL Server's maintenance plans?
Thank you in advance for any suggestions!
One of our users runs a script in the evening to modify data. Once in awhile, they will receive an error that data is locked by user. I know that we can kick users by going into Help > Current Users, but I was wondering if there is a table containing…
Changing one item code to another
Gets to file 112 (then pauses) of 130 and then crashes out
Ran Fixit on IC, OE, PO - no change in behavior
Sage300 2022 PU2
SQL Profiler says last batch completed was table APOBLJ changing Resource field if needed…
Hi all,
During a database load, I have encounter this error. No clear message so I don't know what is the cause and how to solve it. Below is the screenshot.
Can anyone help me please? Thank you.
Hi,
I'm an IT Manager of my company. My user deleted the Currency Rates by mistake and I already restored the data back to the table (CSCRD). But the Currency Rates still do not show the data that I restored back. How I can fix the screen Currency…