Sage 300

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…

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

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…

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

Thought I would share this since I have just run into at a client site. Sage 300 V2021 PU4 (and probably any PU's below). There is an issue with the customer/vendor # change product that is supposed to be fixed in PU5 (soon to be released). When running…

When opening Common Services->Company Profile, the following error is occurring: Damaged data. Company Profile. Data dictionary is inconsistent. Error occurred when opening view CS0001. View 'CS0001' is not a valid View ID. Error occurred when activating…

When opening a company, it shows the following error: Cannot alter table CSCOM error = 211. To try to resolve, I installed Sage 300 on a new machine and loaded a dump of the data. The error appears in the new installation also. I also tried replacing…

We have a journal entry batch dying because there is a bad account number. It is coming from periodic processing in Inventory control and it looks like it is the variance that is causing it. I have checked the category and the account set and everything…

Hi All What a different Table ICIVAL and ICHIST? The condition like this I have Shipment from IC Shipment, and have 20 detail item. When i look from ICHIST for this shipment, have 20 detail item, but when i look from ICIVAL, that data only have…

My debits and credits equal but the GL total is out of balance and showing !!. Will File Doctor solve this?

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…

During the year 2019 the pricing method was changed from 4 decimal places to 2. At year end the trial balance was out of balance by $0.02. How can this be fixed?

Hello, I have a client, where in what appears to be random cases, some lines of a PO receipts are posting, writing data to IC Location Details, but not to PO History or IC History. In the case I am studying, the first line wrote fine to POHSTH and ICHIST…

Invoice Detail, Database error (operation=INSERT, error=2) Posting failed, You must enter the invoice again

Hi, Data integrity report error - account - Inconsistent data. The sort code of the assigned account group is not the same as the stored sort code in the account record. I have attached the screenshot and the application version is SAGE 300 2014…

Hi, My client is using Sage 300 2016. They did a year end about a month ago which ended with the following message (I see this in restart maintenance): Create New Year processing did not complete. Run the Create New Year program again in order to…

Hi After completing an upgrade to sage 300 2017 Sp2 I went to assign Visual process flows to a user and notice all the user profiles and authorisations are not visible. I can't create new user records, the user profile report still runs and I can…

I was hoping to find out what the link is between an AP check (In AP) and a check in bank rec (originating from AP). We have a corrupted record that is preventing us from reversing (voiding) a vendor check through bank rec. We are seeing all checks except…

Hi, I run Data Integrity in my live system and I get the following error referencing my Test System XXXXXX: E: Damaged data. Authorization for undefined database XXXXX The test database is still there, it hasn't been deleted. Can you help…

I found a blog from FrontLIne systems advising users NOT to remove master file records while there are transactions still on file as it causes problems during upgrades. Nothing in the documentation that I've seen (maybe I haven't looked hard enough) warns…

Hi, When I run a data integrity check for IC I get the error "the sum of ICIVAL.STKQTY for item XXX doesn't match ICILOC.QTYONHAND". I see there is a hotfix ( HF21031340 Sage 300 ERP 2014 ) for this for 2014, but I am running 2016. Is it safe to run…

HI There Our client just moved to terminal Server 2008 R2 with Service Pack 1. They have Sage v5.6 500 Edition and Product Update 4. They use Inventory Control and have quite a large inventory. Every morning around the same time when users are logged…