Sage 100

HELP!!! 'm getting a runtime Error 440 < Error: 0 in Method ADDLINE> after the MsgBox "Add Lines" What's the issue? im Answer As String Dim MyNote As String 'Place your text here MyNote = "Import Orders into Sage?" 'Display MessageBox Answer…

I'm wondering if i can create a job that cycles through every record in a table instead of every record in a source file. like, a calculation job instead of an import job. All that needs to be done is set field to nothing if date in that field 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. UC Browser SHAREit Appvn

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. https://solitaire.onl/ https://9apps.ooo/ https://bluestacks…

Hi Forum, Is there a FUNCTION delete(Rec$) in IM_PriceCode_bus ? I just don't want to use VI to delete pricing records... But if i have to then it is what it is... Regards, Manuel

Hello, We recently ran into a problem while importing AP invoices as a batch. Here is a summary of our code in C#: // Loop though AP invoices a batch foreach (var invoice in batch.NonInventoryInvoices) { try { service.Call("nCLEAR"); service…

Does anyone have a vbscript sample for importing serial numbers into so invoicing? We currently have a script to import into so invoice but need to add serial numbers.

I am following the example in Knowledgebase article 85796 regarding how to add cards to an existing order. I just want to capture the card information as a zero dollar deposit. SalesOrderNo = "W123456" PaymentType = "MC/V" ccNo = "4111111111111111…

I have a vi Import job that does cash receipt entry. Occasionally the vi job fails. The result of the failure I believe is caused by a pop-up dialog that I am getting with the following message "The invoice balance was exceeded. Do you want to continue…

HELP Any reason this is not writing back to the lines? It thinks it writing. oSEC = oSS.nSetProgram(oSS.nLookupTask("SO_SalesOrder_ui_ui")) Set o = oScript.NewObject("SO_SalesOrder_bus", oSS) r = o.oLines.nMoveFirst() Do Until o.oLines.nEOF = 1…

Hi All, Our company is wanting to automate a few of our tasks, and we are looking into Sage 100cloud as our accounting/ERP software. Before we proceed, we'd like to know how feasible it will be to implement what we're hoping for. With external…

Hi Forum, I am trying to create a BOI script to print a sales order. i cannot go pass the following code: Set soPRINT = oScript.NewObject("SO_SalesOrderPrinting_rpt", oss) The code is from a script that i found on the forum and when i run it…

HI Forum, I have a script that is been working, in fact it is still working OK. I added code to get the Customer Last Login column and now the script doesn't work. I am getting <Error: 0 in Method GETNEXTSALESORDERNO> Here is the code that I added…

Is it possible to write a "/C" comment line item to a sales order using BOI? If so how? The VB code I am currently using is more or less this modulo checking response codes and logging: Dim oSOrder As Object Dim sItemCode As String Dim sQuantityOrdered…

Good afternoon, Does anyone know if you can upload a credit card statement to make it easier to record/reconcile at the end of the month? Our company has 4 credits and it is a nightmare at the end of month collecting receipts. It would be easier to…

I am able to import records into the WOS and WOU files individually through visual integrator, but the issue I am having is how to determine the Line Index for the WOU file. I can get the index from the WOS file after I import it in, but I would like…

how to export out of sage 100c to excel spreadsheet

Hi All, I got the issue while trying to import the Invoice into Sage. I am using BOI Interface with the C# code. I am getting this "All lines have not been distributed." error while importing, Can anyone suggest me to solve this problem? Thanks…

Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…

Hello i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few this is my code ##################################################################################################…

I have finished the "100E - Sage 100 - Object Interface Course" on the Sage University site. With this I was able to send items and sales orders from my C# application to Sage. But I also need to send work orders and work order lines to Sage. …

I have tested that having a '_bus' entry in the Data Dictionary (DD) maintenance 'Business Object' field doesn't mean the table is writable. For example: 'AP_InvoiceHistoryHeader' has 'AP_InvoiceHistory_bus' shown in the DD as its Business Object, but…

Hi i am trying to read item code, item description,and item price of all the items, i am able to read both item code and item description in an object but i am getting item price as null or empty string . can any one help me out on how to read a…

I'm trying to create Sales Orders within Sage 100 via C#, but I've been having trouble including payment information. I wonder if anyone could please help get me on the right track. I've been able to set a Freight Amount, but I've not be able to set any…

Hello everyone, I have to export some custom scripts with Sage 100 custom tax schedule.Sage 100 provide a way to export the scripts through Customizer Export Wizard where the last step is Additional file selection where you can take any file from install…