• Item Number Change Errors

    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…
  • Customer Account Change - Error executing SQL statement when updating CRM Company ID! Error Code = 133

    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…
  • IC Clear History error

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

    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…
  • Error message on bank reconciliation: Record has been modified by another user.

    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…
  • Data Integrity - E: The Year/Period of the latest activity [201406] is not consistent with those maintained in payments [201405]. IDCUST:[xxxx]

    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…
  • Web API Bug in POReceipts with Additional Costs

    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…
  • Sage Intelligence - Conversion failed when converting date and/or time from character string on General Ledger Transaction Details report

    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.
  • Missing Orders in Quantity on S/O drill down in Location Details

    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…
  • Account Code Change v2022 Error - AR68ARRD Critical Error [1212] Invalid working directory path

    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…
  • REQ's mysteriously being Deleted

    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…
  • Item Number Change crashes

    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…
  • Database Setup: Damaged data DBSETUP: Create applications table. Data dictionary is inconsistent

    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…
  • Can't find RRH Record after A/R Receipt Posted

    Please kindly help us.
  • Customer/Vendor Change Issue in V2021 - Just Sharing a KB Article

    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…
  • Clearing cheques with Printed Status in bank Rec

    I have a situation where a group of about 50 cheques from canadian payroll show in the bank rec program with a "printed" status. A payroll was done, printed to screen (so cheque #'s assigned) and then a power outage was experienced. We don't know exactly…
  • Error occurred when opening view

    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…
  • Cannot alter table CSCOM error

    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…
  • Inventory control periodic processing of shipments to GL

    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…
  • Upgrade from 6.2 to 6.8 - Data activation error - G/L Tax

    Data activation gets stuck at 3% when upgrading - The DB verification log shows fields related to tax services. Any idea on how to overcome this issue? much appreciated
  • Database Upgrade 6.2 (PU3) to 6.8 (PU3) - Data activation error

    I am upgrading a database from 6.2 to 6.8 - When I open data activation, it gets stuck at 3% at G/L Level. Below is the log from database verification. Any way I can solve this issue? Much appreciated GLJEH.CODETAXGRP: Field does not exist. GLJEH…
  • Errors during data activation

    Hello, I'm trying to move one version at a time from 5.4a to 5.5a so that i can then move to 5.6 and end up in 6.X branch of Sage 300. When trying to activate the data in 5.5 i get a bunch of errors: one being "Error converting table APPJD" and the…
  • GL Budget screen suddenly will not open

    GL Budget screen suddenly no longer opens uses CPU but no RVSPY and no SQL activity after accessing GLAFS D.I. is good on GL anc CS Downloading Fixit and will see what it sees
  • Job related PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found."

    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…
  • item at location does not match the sum of the lot quantities on order

    We have a customer that has recently upgraded to Sage 300 2021. They encountered this problem entering a sales shipment and trying to apply Lot Numbers to it. Although there was sufficient quantity available if they looked in either location details or…