• import qty cancel at PO Receipt

    Hi All, can we import Qty Cancel at PO Receipt? Or any macro or tools for this?
  • Missing Line Details when Import PO Receipt Entry

    Hi, I have tried to import PO Receipt Entry using Single CSV file format. The data import showing no error message. However, when I call out the receipt number, only header with data but line details showing blank. Choosing the Single CSV file for…
  • PO Receipt Entry Import Missing Line Details & Optional Fields

    Normally I import into PO Receipt Entry using an ODBC connection to the tables. Recently I've run into a issue where the receipts will import but upon checking the receipt, the header populates but is missing the PO line details and Export SetID. This…
  • 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…
  • Sage 300 2012 Expected Delivery date.

    I have a client working with Sage 300 2012. Does a field exist that provides the expected delivery date? If so, what table/field would contain that?
  • Exporting GL transactions gives error "External table is not in expected format"

    We have Sage 300 2020 running on a Windows RDS server with multiple users accessing the application via RemoteApp programs. Everything has been running fine for a couple of years but randomly last month our users cannot export files any more. A user…
  • T4A Employee Invalid field index 108 in Payroll 7.30 (Latest Tax Table update

    After installation of the latest tax table update, the above message appears along with:A error has occured during the process of T4A extraction. The error returned was 1142. The operation being performed was a viewPut call to paper T4A information. Create…
  • Microsoft Excel, or a 32 bit compatible version of Microsoft Excel is not installed

    Recently my workstation was upgraded from Windows 10 to Windows 11, shortly thereafter I started experiencing issues importing excel files into Ship Orders (Tairox). Whenever I try to import an excel file into ship orders I get the error "Microsoft Excel…
  • Exporting Payroll Employee - error Type Mismatch, LASTRAISE field should be date

    Hello, When we try to export the Employee section of Payroll employees in the Canadian Payroll module we get an error message before it completes that says, error - Type Mismatch, LASTRAISE field should be date. It also says error - stopped processing…
  • Exporting Customers list on Excel with email address and customers information

    Hi All, Kindly advise on where i can get a list of customers with all information updated such as email address, customer number, postal address etc.
  • 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
  • Importing excel AP invoice error invoice invalid characters put to field 'remit-to location'

    I was importing an excel invoice template getting error in sage 300: invoice invalid characters put to field 'remit-to location' Thank you
  • Sage 300 Terminal server workstation

    Installed sage 300 on sql server all working On TS did wstation setup When opening accpac it is not seeing the databases why - these are created on sql server Pathing shared data and programs is correct did a test odbc to sql server also failing…
  • 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…
  • Is there anyway to Bulk Import Items?

    Is there a way to bulk import items within Sage 300? We around 2000 items that we need to add. Typically we add items using the Items Wizard manually as we utilize quite a few Optional fields and use different pricing Item Pricings. I have tried to use…
  • Sage 300 - Where can I find the template for importing A/P invoices?

    Where can I find the template for importing A/P invoices? Someone mentioned that I can find it under the Data folder, however I don't have a data folder?
  • Sage 300 crashes on company when sql database was restored from production to test

    We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error. Other companies work so it has to be the database but it is the same as in production. I change the database setup to go straight…
  • SQL Table Map

    Where can I find a listing of all the SQL Tables & their definitions? I use to use this website: http://sageaom.kcsvar.com/AOM2012/Advantage.xml . But, now the site seems to be down. Thanks in advance for your help. -Kartik
  • Difference between INVDISC and HDRDISC in OEINVD

    Hello. There are two columns in table OEINVD, INVDISC and HDRDISC. The descriptions for these are "Invoice Discount Amount" and "Header Discount", respectively. What is the difference between them? Thanks in advance, Mike
  • Sage300 2023 Excel 2007 option not available

    Hi We recently upgraded to 2023 PU1. The operating system is Windows 2019. We noticed that there is no 2007 export/import option on all the desktop screens. Please note that Excel 2016 is installed on the server. An article in Sage KB related to…
  • Where is the voucher?

    Hello. I'm working on importing A/P data from SAGE Accpac 6.0a. Nowhere in the SQL database can I find a table with a column for a voucher number. Am I missing something? Thanks in advance, Mike
  • 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…
  • database load

    is it possible to load part of the database. where you just want to bring in new data set into an existing database. eg company A has moved all Sales division to company B. Company B had no AR module. We want to move all AR options and history to company…