Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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?
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…
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
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
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…
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
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…
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…