Sage 100

Hi Forum, I am importing Sales Order and the a fixed number of items (4 lines) The last line is "/C" comment, and it is the only one written to the lines table. Is it because the ADDLINE() not working properly? Regards, Manuel

Hi Forum, Is there a reason on why when i set the CusotmerPONo in a BOI script , I am getting Error: 0 in method ADDLINE() ?. Here is my line of code. I have the same line of code on other scripts and work fine, although the script is reading a…

Older version Sage 100 4.5 (yay, I know) Need to change the SalesSubjectToComm amount, created VI Import to AR_SalespersonCommission Test run, all records pass. Live run, all records fail with "Record is in Uneditable State". No other users…

Running Sage 100 v2018. Using VI to import AP invoices into AP Invoice Entry. Client would like to use a separate Source Journal when updating these imported transactions rather than the default "AP" Source Journal. I don't know if I can force something…

I'm running SAGE 100 v2018 and have been asked t ocreate a VI Import job where the source file contains a field that is not an invoice number but can be used to identify if the record should be grouped into an invoice (they call it CustPONo). I'm sure…

I'm running SAGE 100 v2018 and am trying to create a VI Export job based on historical PO Receipt records within 60 days of the Receipt Date. I can add a hard-coded date range for the Selection option but I was hoping to find a way to have a specific…

Is there a way to get some type of output when the process runs? I am not seeing any output (good, bad or indifferent). I'd like to see some type of results. How do I do that? \MAS90\Home>Pvxwin32.exe ..\Launcher\Sota.Ini ..\SOA\Startup…

We are trying to import sales and AP invoices, getting Sage100 error message: "A task ID or program name has not been associated with this menu item." Can anyone advise on what this error is?

I am working on SAGE 100 v2018 and am trying to import a file containing multiple record types (within the file a record type 01 might be for the header information; record type 05 might be for payment terms; record type 21 might be line information.…

I getting an error 200 when I try to do a simple export of G/L account numbers and descriptions to Excel using General Ledger Exchange. (Utilities) Is it just me or has anyone else had this issue? Thanks in advance for any feedback on this. Details…

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

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…

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.

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…

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…

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.

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…