Browse By Tags

Merci de m'aider, j'ai vraiment tout tenté ? Je ne comprends pas , les deux fichiers sont présents?

Hi, hope you all are well. im trying to pull up the database for company that was provided by my school for the assignment however, i am having thought time to pull and keep getting error message saying “ You cannot upgrade your data directly from…

Hi does anyone know if this information is stored in Sage 300 and where I would find it? thanks Judy

How to vi import automatically on a key field the next value for a UDT

I'm a developer working on application that requires syncing a database of my own with a number of tables in the SAGE 300 databases. I was previously using the SAGE COM APIs to do this syncing, but my application is written in C#, so I'm in the process…

Je suis nouveau avec Sage 50. J'ai créé mes produits et je veux entré mon inventaire (quantité et cost) à la main. Comment fait-on? merci

I have my system working fine using Sage 300 ERP, I upgraded to PU5 and now it is asking me for vault and store databases. I followed the procedure in https://www.greytrix.com/blogs/sageaccpacerp/2023/06/06/configuring-store-and-vault-database-in-sage…

We were working in this file a few weeks ago. We tried to open it this week, and we're receiving the message "You cannot open this company. It was created in a newer version or is incompatible with your Sage 50 solution..." But, we didn't upgrade our…

Is it possible to allocate stock to a sales order line via import/webservice ?

Hello I need to delete around 300 skus in SAGE 50 canada and I can't find a way to do it other than delete one product at a time. Is there a way I can do it in bulk?

Hi. My company is finally looking to move from the dark ages of paper time cards with job names, cost codes and hours to something on a database that can be accessed by multiple superintendents in the field. We currently only have 26 employees. We'd…

It looks like this question has been asked before, but I am not finding a current answer to my question. Is there an API to connect to Sage 300 CRE Job Cost files?

Is there a way to import Sage 50 Premium into Sage 50 Pro Accounting? Thanks. Blaine

I recently paid an invoice through direct deposit, not realizing that our manager had already paid it using their visa card. The vendor doesn't have a refund policy, but we managed to reach an agreement with them. They agreed to consider the duplicate…

I am looking for the correct way to access aging info for each customer in my instance of Sage 50. I currently run a query that pulls info from the customer table (odbc), and am wondering if the aging information is in a separate table, and how to go…

Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…

Hi all, I needed to make an exact copy of my company for testing purposes. To do this, I made a backup and then restored to a new company. As soon as the restore was done, I went to Maintain - Company Information and changed the company name. This changed…

Sage 300 typically uses a database backup system where you back up the entire database. Is it possible to extract specific period from the entire database, i.e. Jan 2020 to Dec 2021 only.

When I go to add Historical Transactions to Customers the window that pops up is called Historical Sales Invoice and it requires the items purchased and the account/s they would go to. These are things I do not have. I have entered Historical Transactions…

Can I download or scan the 100+ pages of insurance certificates for our vendors, instead of manually inputting all the policy numbers?

I have been importing fixed assets monthly for 2024 and have now been asked to include additional columns of data for reporting purposes. How can I import additional columns of data to assets already in SAGE without affecting the data previously imported…

Is there a way to import the Customer Exemption Numbers? The data file the customer has provided contains the Sales Tax Schedule, but I believe we have to import into the AR_CustomerShipToExemptions file, which contains the TaxCode. The customers Sales…

which field would link an item to a location or many locations ?

Will inactivating or deleting assets help make the program run smoother/faster? Our database has a significant number of fixed/intangible assets and running reports sometime takes a long time and I am sometimes booted out of the program. Our program…

Hi There, We have a test environment called TEST 2024, does anyone have the steps to deactivate it? It's interfering with another connection that we have. Thanks, Julie