Sage 500

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)…

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…

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…

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, 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…

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…

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

How can I import Items with bill of materials into MAS500?

I am wanting to import a batch of AP invoices into Sage 500 ERP from an excel spreadsheet. If I were to use the Import AP data function of Sage 500 ERP and select Voucher Batch as the Import Target what is the file name that I will be importing data…