We currently have Sage 100 Contractor being hosted on Azure VM. I would like to know if it's possible to connect Power BI to our Sage database to create dashboard from Power BI.
I am having an issue with inventory reports not matching, and showing false negative quantities. The inventory quantity report will sometimes show negative Pending Sales Order quantities, and currently I am seeing negative quantities for some items only…
Hi ClarkM and Erzsi_I
I see that that a similar question was posted by slacka 6 months ago, and remains unfixed.
I don't understand why this issue hasn't been taken seriously. This seems to be a critical issue in the way a client is able to, or in…
I turned my timeslips 2017 and the main.db was missing. i now can't find it to access my data. can someone please call me at 310-556-1001 or refer me to someone who can find it? I found my tseg.fdb file but that is it.
Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables?
Thank you
Hello Sage Community,
Todays question is how to find order(s) in shipping that I cant find! In the image below, I have the part in Shipping and cannot find it!! I've reviewed numerous orders and shipping batches that are not updated yet, they are nowhere…
Hello,
I have a bunch of custom scripts that get triggered Post-Write on different tables, for example, sales order, item, alias, etc.
Only one script would not trigger, and I can't find why. The script should trigger Post-Write on the table IM_ItemWarehouse…
We are on the updated Sage Businessvision 2023 edition, but we have been experiencing an unusual problem in the past few months.
Random items will show items as "back-ordered" despite there being no outstanding sales orders. That, or the back-ordered…
Hello, I am running into an issue when importing vendors. We are mass importing items along with the vendors, but are running into a block on the vendor import.
It appears that this popup might be blocking the vendors from being imported. Is there…
I am using sage 50 and the way that I import is —> file—> select import/export —> inventory—> inventory item list where I’m trying to create my own template in csv in order to import item/inventory however it doesn’t go through which I believed the template…
We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI.
We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
Hello - I know this article shows how to upload your inventory listing ( https://ca-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=220924150010124 ).
But how I update the stock currently on hand as part of the upload? I can't make…
I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message:
"VI JOB_NAME Unable to open [wdx][odb]<dsn_name>"
I don't get this message…
Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
Has anyone found a company that can dig deep into a Sage 50 data file to uncover and repair issues. Our file has countless issues now e.g. different inventory numbers for the same item in the same location depending on what report you run and who runs…
I am trying to export the component list for parts within Business Works. There is no way to do this through the program, but was told you can do this through a query in excel. Does anyone have experience with this? Can someone provide steps to query…
We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…
Hi all,
On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below.
I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible.
Anyone know…
A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…
Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…
I'm installing Sage 50 Premium in a Convenience Store which has a POS system. This POS system generates a plethora of reports & data, all of which is available in Excel format. The daily sales report it generates would be the feedstock for the SAGE invoicing…