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

    Please kindly help us.
  • 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…
  • Internal Error: field [25] of [AP68AOBP] is not a string field.-when using Vendor Number Change

    We have a client running 200 2021 with Product update 1. On the machine that is the main one (server), they get the above message when posting a combine Vendor request using Vendor Number Change. Anyone have any sugeestions as to how to proceed.
  • AP PAYMENTS CORRUPTION CURRENCY CONVERSION FAILED

    I have several entries in several different batches that error out and make an error batch with the message Currency conversion failed. Source=CAD, Functional=, Rate date=0000-00-00, Rate operator=M, and Rate=1.000000 anyone seen this before …
  • Balance due is not equal to the sum of open documents for vendor

    Currently running Sage 300 2019 and have noticed a number of errors during the data integrity check. Balance due $ is not equal to the sum of open documents for vendor. Restoration of data is not an option as the errors go a long ways back before my time…
  • •Not Answered 7.2D tax table on pervasive DB running 2014

    We have had 2 clients install the 7.2D tax table and they are on pervasive running Sage 300 2014, and after activating the 7.2 D tax table, their payroll data was gone! Both instances the client did the download and install themselves, just like previous…
  • Can't Create control: {cb69722c-30ba-443d-88dc-1c3339680c53}

    A user gets this error for the past two days when trying to open anything in Sage 300 ERP. Uninstalled and reinstalled, ran the regacc as administrator and opened Sage as Admin. Everything would work fine for the day but then the next day same thing…
  • Sage 300 ERP - issue in Order Entry

    My client has an issue in Order Entry: They create an Order it is OK They create a shipment – ship all, the total amount is zero (except the freight amount) They create an invoice – zero amount. Does anyone know why it would go to zero even when…
  • Disconnect in beginning balances

    Customer is on v2012 all PUs installed. They have two GL accounts where the ending balance for FY2014 does not match the beginning balance for FY2015. One account is the R/E and the other is a prepaid expense account. They are off by compensating amounts…
  • INVOICES POSTED THROUGH ORDER ENTRY NOT APPEARING IN A/R INVOICE BATCH LIST

    Hello, I have a POS that integrates to Accpac by posting sales through the Order Entry module. The invoices were posted to the invoice entry within Order Entry successfully. I ran the O/E Periodic Processing by "creating a batch" and the box "Post…
  • Sage 300 2012 Purchase Order has replicated itself and is the wrong jobs

    Thanks in advance, In the middle of December, we created a multiline purchase order that was job costed to roughly 25 identical jobs. Everything seemed fine until we viewed a job report for a completely unrelated job - the purchaser realized that a…