Sage 100

I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

A SAGE100 Premium VS. 2020 has occasional missing S/O order header records. The order lines are still there. The order is completely there in order history. The order has NOT been invoiced. Anyone seen this?

I am getting this error "Missing record to calculate taxes." while trying to import Sales order in Sage using BOI. Has anybody faced this issue before? OR anyone has some idea how to solve this. Appreciated your help

Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…

Hello, I've used VI jobs for various import and export jobs to import things from sales order info to bill structure. I dont use a lot of conditional based columns. What im trying to do is have the ShipExpireDate be 5 business days added to the order…

After Job Cost was updated to the Business Objects Interface Sage confirms but has not corrected two major problems (for us). When Sales Order is integrated with Job Cost there is the ability to create a new job from Sales Order Entry. When entering the…

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items. After researching in the Knowledge Base, I came across the following steps to clear out the issue: Update all transactions…

Hi, I got this "The Records is not in editable state" Error while delete details from SO_SalesOrderDetail_bus object. Please anyone give hint to solve this issue. Given below is my code int TaskID = (int)oSS.GetType().InvokeMember("nLookupTask…

I would like to have a list of all email address associated with every account, but I am not aware of a method to do this.

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?