Sage 100

I am working on an import that is related to the following thread; https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/177980/how-to-run-visual-integrator-from-bat-file . When I go to test the PO_Header import I keep getting…

When exporting payment history for AP I am only getting a few years information. If I run a report I can see the system has 20 years worth of data but its only giving me 2+ years which is more like just the time frame for viewing in the system. I tried…

Running Sage 100 v2018. Created a VI import into AP_InvoiceHeader/Detail in order to populate invoices into AP Invoice Entry. I have a Perform that checks to see if there are duplicates in the AP_InvoiceHistoryHeader table: ------------------------…

I'm writing a BOI script to create Inventory Adjustment Transactions. I want to use the next available entry number so I have the GetNextEntryNo(refNo$) function in my script. What I can't figure out is what the "refNo$" needs to be. Does anyone have…

Need to clean up inventory alias. My first attemp is adding another alias I need to replace the alias with the alias in the import file If I need to deete aliases first before I import, how do I delete without going into each alias?

I'm trying to create a job to change dates for Work orders. Some WO through errors like this when the Revision Code has any letters. Some of our revisions are just numbers like the ### but some do have some letters which are allowed in the Bill of Materials…

Hi Forum, When importing Invoices in Sage i am getting the message.. " You cannot use a credit card or ACH payment when credit card of ACH payment type is not set up" The customer payment type is "CHECK", the process continues with no problem. …

We are exporting Sales Orders to a distribution center for shipping. I have created 2 UDFs on the SO_SalesOrderHeader table. Once the export file is done, I have a script that reads through it and is trying to update the 2 header UDFs. When I go to save…

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…

I'm trying to do a compare of Sage 100 TIME (hours past midnight - fractional) column in a SQL WHERE statement. I was able to get the DATE field to work with {d '2021-09-16'} but there doesn't seem to be a [t '17.500000'} like scalar function for TIME…

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…

With the NEWS that DSD is retiring their SQL Mirroring solution as of the end of the year, I wanted to mention that I wrote a SQL mirroring solution for Sage 100 using the open source and free Postgres SQL 64 bit server. If you're looking for a DSD replacement…

I found a SQLite3 OLE wrapper that might be useful with VBScript BOI scripts when MS Access and OLE DB isn't an option, SQLite is free and open source. I used a VB6 demo that came with the control to populate a test.db. This is an example of reading…

Within the ProvideX environment Sage 100 references their objects by an ID value starting at 100001 for SY_Session . When scripting is used, does 100 create an OLE reference (iDispatch pointer) to the object and pass that to WScript Host ? If so what…

The ScriptBasic distribution comes with a web server version of the language. It runs as a Windows process and is multi-threaded. The best part is you can run your BOI external scripts on the web server with no modification to your BOI specific code.…

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…

I am a contract web developer and currently have a painting company asking if I could create a web app that automatically pulls and manipulate data from their database. I went to a meeting with them and realized that they use a program called “sage 100…

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…

Curious if anyone knows when we are moving our data from Sage 2018 ProvideX Database to Sage 2020 SQL Database for some reason unknown 3 customers didn't carry over. We use Mapadoc and one of them customers is using that. Any ideas on what would cause…