Sage 500

Hello, I am trying to get data about transactions made per account between dates and get information about related documents with transactions. Payable and receivable. So I need Purchase Orders and Sales Orders documents etc. What I know / discovered…

My end user is getting error Task # XXXX is not defined in task definition tables.

There are a few KB on Sage's support site. That indicate a Data Fix but no download file is available for download. Is there a link anywhere to download all?

In company C we have 3400 customers. Each customer needs to have a new secondary address added. Same address information for all. 1. Is inserting into tciaddr and using the new addrkey then inserting into tarCustAddr (via direct database calls)…

Here are a few friendly suggestions that you might want to park in the back of your minds that could help out with some yearly maintenance and upgrading. These are not day-to-day type things but can help out over time. There is a table in the system…

Newbie here. I am entering items details manually into the different fields of a purchase requisition. I have a csv file with data from an MSC shopping cart. How do I transfer this data into the Purchase requisition grid without copy and pasting field…

Looking for the best method to import transactions. We do not have Data Import Manager. Sage 500 version 2016, upgrading to version 2021 this year.

Hello Sage 500 friends, one of our employees does not have the ability to export data into Excel, see below. I have all options available. We have tried going through permissions and reached out to Impact for help to no avail. Does anyone out there know…

We have an existing payment engine that processes credit card and checking. I have created the ability to lookup invoices with a balance, "grab" all the details, and offer customer payment through other means. Now I need to bring the payment information…

We have a customer group that is wholesale. In the Matrix Pricing GUI - the group is set to: Method - Discount Amt Base - List Price Amount - 0 The customers in this price group do not show up in the timCustItemPrice table at all. We have…

During a GL Import I am receiving the following error message: "Incorrect import file header. Please verify the header information. " I use the same template every time. Most of the time there is no issue, but this has been happening every so often. I…

Can somebody take a look at their database, and verify the following? I'm on Sage 500 2016 January 2018 MU (i.e. 7.70.6.0). tciCarton contains CartonKey, but it is NOT a primary key, nor are any constraints. As a result, I've got a few duplicate…

We want to import a csv file instead o manual entries to save time. I select file "Select Import/Export" select "General Ledger" and then we created a template for our import file. The fields are in this order Reference Description Number of Distributions…

Does anyone know what the file format needs to be for the 1099 Beginning balance import function? i tried Excel and it kicked out immediately, i tried CSV and it's not reading the comma delineation. I did some digging and it sounds like it's expecting…

We are having difficulty using the SO Import Utility for a secondary company setup in our SAGE 500 (2013) system. It works fine for our main company, but when we try and use it for the 2nd company it just fails - no real error message. Sage support…

Hi, We have been having issues in SAGE2016 (we recently installed the May updates to see if it would help) when entering items on Sales Orders. The last suggestion we got from support seems to help alleviate the problem. The suggestion was to run…

We are running into issues where a user copies a part ID from an excel sheet only to get a space at the end of the item ID or SO tranno. Sage support didn't have a good suggestion to keep this from happening. Has anyone else run into this? If so what…

HI, Instead of manually keying in data, we want to have the option to import a .csv file. How would I set this up? I added an image below that shows our current view next to our desired view? Ben

We stopped using Sage as our ERP system 2 years ago. We still access the system for old orders, accounting information, etc... We are still paying to have this system up and running, supported, backed up etc... Is there a way to back up the entire Sage…

Over the years of use and lots of data imported from our various sales channels, our database has grown to about 80gb in size. Maintenance on a database that big can be cumbersome when rebuilding indexes, doing backups, dbcc checks, et al . Is it…

Does any one at Sage still monitor the Sage 500 ERP Ideas site and keep it up to date? I just entered a new one today and was reviewing some of the existing items. It's hard to tell what has been considered and rejected as far as ideas go. It would be…

We have acquired a company that has Sage 500 9.13 for accounting that has been discontinued support since 2004. This system was being used as of last month. 1. We need to be able to extract data from this system. Is it possible to export data from…

I have a Sales Order that I'm trying to close but cannot. There are two lines in the SO. You can see this correctly in all Inventory Transaction Tables and Explorer View (Sales Order Lines). However, on the enter Sales Order screen. It shows three Line…

Is there an online resource on how to use the dataport ?

Our AP department continues to put invoices into the incorrect batch (ex February invoices in a January batch). Is there a way to prevent that? If not, is there a way to search to see if it has happened? Is there a way to fix it without making a journal…