Sage 100

I am developing a Windows Forms application which is required to connect to Sage 100 and get order information. I am using ASP.NET and SQL Server 2008. Is there a way to connect to the sage 100 database? myprepaidcenter login

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

I am trying to import into po and getting this error even though the vendor number exists . Error is HS passed with invalid fields 9000001.

Can anyone help me, I am working with developers to help them pull data from sage 100 2019 using Sdata. Using say the customer contract bellow, they want to make the XML return to be much smaller and only need about a dozen fields from the customer…

I am new to Sage 100 and am looking to simply extract my customers into a list for Excel that I can send to a marketing company. Sounds simple however I am lost. Thanks in advance!

Hi, I know that I cannot delete Inventory if their is history. What constitutes the meaning of history? Thanks, Tim

We are querying invoice data to read from MAS using the ProvideX ODBC driver from within a custom application. Within the custom application, we have tried specifying credentials explicitly within the connection string used to open the ODBC connection…

I am running the following VB scripting: do while not RS3.eof ARDiv=trim(cstr(rs3("Field1"))) strCustNo=trim(cstr(rs3("Field2"))) strContNo=trim(cstr(rs3("Field3"))) If strContNo="" Then strContNo=" " End If retVAL = oSS.nSetProgram(oSS.nLookupTask…

When I try to open a sales order I get the following error dialog "the lock information was not found" This is from Sales Order Entry on Sage 100 2019 Premium.

Looking to have Sage Alerts and Workflow create a PO in Sage 100. It's my understanding that the Sage Alerts Workflow module has collection of API's that can update a database but Sage 100 Providex is difficult to write to and that Sage 100 does not have…

Hi, I've been wondering if there's a way to get the latest revision number from A Bill of Materials. I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number. Thanks…

Hi Forum, I am working on an import to PO Receipts of Invoice and I cannot get the PO_ReceiptsOfInvoiceDetal_bus to work. Actually I've tried PO_Receipts_bus and I cannot get it to work. I am Getting an error 200 and the LastErrorMsg is showing…

Where are the VI import export jobs saved? One was inadvertently deleted and subsequently recreated, but I'd like to have backup copies of all of them.

I'm using "sage 100 Standard 2019" and Version "6.10.0.0" I tried to get "Item Maintenance details" from I nventory Management - > Item Maintenance . I'm able to get 'Item code value' and 'Qty values(pl refer screenshot1)', but I need to get values…

Hello, Is there anyway to complete the following script? Set Company to "ZZZ" Run "Route Export" in Job Select Input Box "Select Route" Run "Route Export Ext Description" Set Company to "ZZP" Run "Import Route" Run "Import Route Description…

Where I can find the work order header & material details in C# language?( help-sage100.na.sage.com/.../index.htm In which table I can find those? Eg: For purchase order I fetch the details from PO_PurchaseOrder_bus. Where I can find the details of…

We are using a 32-bit System DSN with SOTAMAS90 to connect our Knowledge Sync Tool (Sage Alerts & Workflow) with Sage 100 Advanced (Providex). It works great 29 days out of 30. On the first day of the month all users are locked out so month-end process…

We run SAGE 100, and recently I purchased BizNet 5, but I also have BizNet 7 datasets - A/R, A/P and IM. The BizNet tool works well when I am pulling general ledger information, but for our inventory, accounts receivable and accounts payable there…

For FFCRA, we need to add the same 4 new GL Accounts to over 200 different companies. Does anyone have a suggestion on how to "automate" this process? We are using Sage 100 on SQL Server. My background is in MS SQL Server database management and development…

Hello Everyone, I am trying to updated the "Hold Payment" field for our Vendors with an import file that will contain Vendor code and a number. The number will act as a switch for the Hold Payment field, so if it's a 0 then N, if greater than 0 then…

I am trying to use PowerShell instead of VBScript to access Sage via BOI. I am able to login, set the company, set the module and get a handle to the table I want. But I am not able to retrieve values when looping through the table. I tried multiple variations…

Good evening, I'm having a bit of trouble restoring a file from back up. My client emailed me a CAB file and it's giving me this error: "This data has been updated to a new file format and is not compatible with this version of the software." Is…

Is there any way to populate the BM_ComponentReportSelection.M4T without manually keying it in the Gross Requirements Report? It is not an available table to import into for Bill of Materials.

Is there any way to populate the BM_ComponentReportSelection.M4T without manually keying it in the Gross Requirements Report? It is not an available table to import into for Bill of Materials.

Is it possible to access Sage 100c data from a Java program? Is there a JDBC driver available to connect and get data from Sage 100c?