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…

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…

We have a large number of items in our inventory that were setup incorrectly. The items have activity posted against them. Is there any way in the data tables to flip a raw material item to a finished good? For example, our BOM pulls together the…

Does anyone know where the Item Type table is in Sage 500? Thanks, Tina McLauchlan, Business Analyst Industrial Fabricators, Inc. 2408 Forbes Road Gastonia, NC 28052 (704) 864-3032 Ex 211 “Carpe Diem”

One of my users receives an error when they attempt an update Detail on a recurring invoice. Other aspects of the invoice can be updated, and Detail can be updated for the other companies in our system. This error is triggered on all recurring invoices…

I have the database on SQL Server 2008 R2. I'm trying to access our database for historical purposes but it's telling me it is not registered. I've attempted to register manually and it tells me the user must sign out and back in for the changes to take…

I can easily find the GL file format, but not the AP file format for importing. How can I import into the AP Module? Where is the file format?

We moved our database from SQL-02 to SQL-03 server name. I am unable to register the application to use it's modules. I've ran the Database Synchronization Utility be get the following error: I also tried to manually register but receive this error…

Hi everyone, Can someone provide a list of accounts payable tables to show AP invoice payment history? Also, I am looking for vendor master tables. thank you

Hello Community, I have a couple questions that i need help with. We are thinking of moving our sister company, that is using Sage 300, to our Sage 500 software. Has anyone successfully done this before? Can someone point me in the correct direction…

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…

Hi, I have built a DIM job for AP Vouchers on Sage 500 v7.90 and have it working properly but now I need to set it up to run every night unattended. How do I tell SQL or SSIS which company code to import the data into? My current Sage 500 database…

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…

Microsoft SQL Server 2008 Standard R2 was upgraded to SQL standard version 2014 on 64-bit machine. Upgrade was successful without any error, but when users tried to save Purchase Order, message 'Append' is not a recognized option appeared and PO was not…

Hi all, I would like to import customer and sales order details in Sage 500. Any API/ Web service example is available in vb or c# ? Please let me know if documentation is available for API or Web service list. Thank you.

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, We have a vendor that sends us invoices in pdf and an xml file. To save the people in accounting some time, we are looking at importing the vendors invoice(s) into Sage 500. We have the Data Import Module. Is there an example of an XML file or…

FINRA Requirements for financial institutions are very vague and subject to a lot of interpretation. How does your firm meet FINRA requirements? Are you storing all your SQL backup files on WORM storage? Other financial reports on WORM? How long?

hello i want to access sage 500 database , i am creating an application where we get the data from the client and we are going to run few calculations and implement it on sage 500 thank you

We have reference codes required on some of our GL accounts. When we import a journal entry, it is possible to post the entry without the reference code. Is there a way to stop this?

We are still on 7.3 of Sage 500. I have a boatload of new Natural Accounts/GL Accounts, and they all need to be inactive for the remainder of this year, and then all of them activated when the new year 2015 begins. Is there a way to import the new accounts…