Sage 300

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

On the server, V2024 with PU1, when posting item number change, we get these errors: AP68ATRK: Critical Error: [4039] unsupported field type. AR68ARRD: Critical Error: [4039] unsupported field type. On a standalone, V2024 withOUT PU, no error…

we are receiving this error when attempting to change a customer account code. There seems to be a lot of issues with the account change programs these days. I found in the past that it was missing files that needed to be copied over but this error has…

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

When clearing transactions in IC I run into the following error: ICITEM record not read (2362 ICASEN1.C) Any ideas? TY

I see this posted all over the place but nothing I have tried has fixed my problem. I have a new VM with Server 2022 with Sage 6.0A installed. I have the database configured and I can login to Sage. The issue is that I can't post new orders. I can do…

Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.

Hello, I'm hoping someone can help me with this issue. There is a deposit that, believe it or not, goes all the way back to 2016 on our bank reconciliation in Sage 300. I have attached a picture file showing the bank reconciliation and error message…

IN our A/R data integrity reports, I see lots of entries stating E: The Year/Period of the latest activity [201406] is not consistent with those maintained in payments [201405]. IDCUST:[ARISEH] Do these need to be fixed / how? - or if it should be…

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…

Suddenly having the above error at two different clients. any new information on this error? It appears when running an April 2023 report *only* where it hadn't appeared in the past. Same for January 2023 *only* for the other client.

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…

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

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…

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…

Hi, Our customer upgrade and its working with Sage 300 2022 Update 2. All accounting modules. We get an error when running ACC a few weeks ago that damage database. We dbload backup and then create a company copy for testing in another server. From…

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…

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…

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…

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…

I have upgraded to Sage 300 2022 PU2 One one of the client machines, for one of our databases, when checking the database setup, the Database Setup tool give me the following error: Damaged data DBSETUP: Create applications table. Data dictionary…

Please kindly help us.