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…
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.
We have an user that is moving parts around on several bill of materials. He is consistently receiving this message. Often after the message is received the items behave oddly, such as not being able to delete or modify. When we try to delete or modify…
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
I have a vi job that is suppose to transfer inventory items from one warehouse to another along with their bin location. Scanco muti-bin is installed. The job is not able to distribute the line tiers of bin location. Has anyone had this issue with VI…
Is user data backed up, and if so, is it backed up to a third-party solution? what about Hosting Platform, Can you provide detailed information about this ?
This is all done on a test company.
I am running a task through Task Scheduler, but am not seeing anywhere that is has completed running. I've looked through the logs with no indication of completion. Anyway to see completion?
I am receiving an error message when clicking on any template in the task scheduler. Here is what happened.
How it happened:
Library Master > Task Scheduler > I ran IMPORTITEMS (worked great until I put all the imports into script).
It has been…
Hi Team
Please help to locate the Opening Balance column/field in the GL table list.
Or how can we get the Opening Balance/Closing Balance data from Sage 100 ERP.
Thanks
Thulasi.
Hello,
We have a custom-defined script that triggers Post-Write on the table CI_Item. This script then reads the field 'ItemCode' of that table. We also want to extend this by triggering this script with other tables.
I am seeking a way to retrieve…
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…
This is happening with a single table MS Query in Excel 64-Bit when accessing large individual I/M and P/R files and continues after rebuilding them (Ex. IM_ItemTransactionHistory) . I reviewed the other thread on this error, but nothing applies other…
I've noticed that we have just over 14,000 records in the SO_SalesOrderHistoryDetail table where the SalesOrderNo field is null. This is causing some issues with trying to do a copy into a MySQL database due to the Primary Key not accepting null values…
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…
Morning,
I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)?
{SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…
Hi Guys
So we recently upgraded to Sage 2023. Since the upgrade some users have being reporting that the Customer Last purchase history (Red Binoculars) is not populating for them on sales order.
I first thought it might have been a permissions issue…
Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…
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