Browse By Tags

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

Import started... Error importing records. The import file does not contain a compatible country type. Importing Summary: Import employee(s) cancelled. While importing employees from csv file above error coming. Can anybody help? Thanks Yat…

Hello, Our Sage X3 instance is located in AWS Frankfurt. We will migrate our Australian Operating Company to Sage X3. However, we know about Australian data protection law. Can we host a personal information db in Australia and federated to the X3…

I am trying to use VI to import Sales Orders from a e-Commerce platform but the only customer-unique field that the source file has is the customer's email address. I would like to use those emails as a cross-reference to assign the customer number to…