• 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…
  • Sage 300 2017 PU6 Import AR Invoice line comments without line breaks issue

    Hi All, May I know is this the limitation in Sage 300 2017 PU6 whereby user unable to import AR Invoice line comments with line break? One of our clients encountered this issue recently. At first, this client was in Sage 300 2017 PU3. Hence, we…
  • Bank entry import problem

    When I try to import excel file to bank entry UI, the header and details files not upload correctly, one bank details data automatic transfer to another bank code when upload, why this? Can anybody help me.
  • Excel upload of A/P invoices - document number including text not allowed

    I can successfully upload A/P invoices using the basic template included with Sage 300. However, if my invoice number ("IDINVC") includes any text (e.g. "A23456") the upload fails with the error message "Document number cannot be blank". It is very…
  • is it possible to change the document date, post date, fiscal year on AR Invoice after posted?

    Hi All, is it possible to change the document date, post date, fiscal year and period on AR Invoice after posted? Situation: user import AR Invoice to Sage 300 using the Import feature on AR2100 (Invoice Entry). For some reason, the year of the…
  • Book Balance in Bank Reconciliation

    Our bank has not been reconciled in Sage from 2018 onwards because of some issues. Now I want to start reconciling in Sage. Our bank balance is as below and there is a book balance of the below amount in the picture. The question I have is where is the…
  • 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…
  • Sage Accpac ERP Database error=49153 After restore database from another server

    Hi All, I just restore Sage Accpac 5.6A from old server to our new server (both database names are the same: "ACCPACSYS" & "ACCPACDAT"). After restore successfully and launch Sage Accpac ERP on server (on where Accpac 5.6A and its sql server database…
  • import ofx in Sage 300 2018 failing when it worked before

    Description: Failed to process the file due to an unspecified error. When I try to import an OFX file I get the error above. It worked five months ago when I tried it last. I have rebooted the server and the workstation. I get the same error whether…
  • Can't find RRH Record after A/R Receipt Posted

    Please kindly help us.
  • GL Account Code Change

    Anyone know if there is a way to generate an export file from a list generated using the GL account code change pattern. I have generated a very extensive list of GL account code changes using patterns in the lab. I am wanting to grab that list and turn…
  • 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…
  • Import File Specifications

    Is there a list somewhere of the minimum REQUIRED fields for importing into SAGE 300 modules? Rather than experimenting with exporting everything and removing columns one by one then importing until it fails? I'm specifically looking for payroll timecard…
  • Invoices partially paid

    Hi, We are in need of an alert on AR cash receipts where customers short pay. We were considering using AROBL and AROBP for this. Are these the best tables for this purpose? Thanks.
  • Banks import error

    Hi, I have a test company with 20 banks defined which I exported in excel to import to the production company. Import fails on record 1 with the error "There is no entry for statement currency in this bank's valid transaction currencies." Although the…
  • AR Customer default price list

    Every year I have to change AR Customer default price list. We have 90K customers and import from excel takes more than 72 hours. Hardware is definitely not an issue since ship to locations are updated for less than 12 hours. Using minimum of data in…
  • Invoices in APIBH but not in vendor activity

    Hi, we have 2 invoices that can be seen though SQL in the APIBH file but are not displayed in the vendor activity window. Has anyone encountered this before? Ty.
  • how do I import data into a new Sage 300 database?

    how do I import data into a new Sage 300 database? I would like to import data but I have never done it before. Can some one give me any advise?
  • Check number field

    Hello, We are creating a report of paid AP invoices with the APTCP table. This table does not contain the check number used for the payment. Where can we find that information? Ty.
  • AR Receipt Import - Auto apply in the import

    Hello, I am setting up an import template so that we can take all of our payments and apply them to the outstanding documents / invoices. I am wondering what the field is called in import to make that happen. If I was manually entering it in sage I…
  • Assigning a new close to account using import / export function in Accounts

    I need to remap a bunch of the close to account. Instead of me going one by one and selecting close to segment, can I just export this data and then do an import to fix it ? When I export the G/L Accounts screen I get the options to export basic account…
  • Filling up the GL-JE Import template in Excel

    Hi All, Trying to fill up an import template in Excel - As you can see in the screenshot, there are 4 transaction per journal entry but in some cases there are 5 - 6 transactions as well. I know that excel follows a 20-40-60-80 patter in the TRANSNBR…
  • 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.
  • Recurring Entry - Adjusting Last Run Date

    The recurring entries will not run because the last run date is later than the date I need (2 months later - batch was run and deleted by mistake). I tried exporting the entries and importing them again but it does not update the last run date. has…
  • Cannot export customers

    I have a client, where for a couple of companies, I cannot export the customer or ship-to records. When I attempt to export my customers, the screen that shows the records, the first record should be customers, but it only shows a "-". If I look at attempting…