Sage 100

Hi Sage 100 Community, I'm trying to help our warehouse cut some manual entry time with their UPS tracking numbers. There is currently a process in place with UPS Worldship that exports a CSV at EOD to our Sage server and then a series of VI Import…

I'm currently running SAGE 100 version 7.10.5.0. I can run VI Import jobs no problem via a .bat file or through command line. However I'm looking to get some output back from running the job. Ranging from: Successful or unsuccessful login (right…

Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number. Manual entry allows to enter an invoice number followed by the check number. This automatically…

is there a way to export the line details on current open AR invoices. When I use Business insights the current open AR invoices just give the balance of the invoice not the line detail for those invoices. If I use invoice history I get more then open…

When you create a new memo, there is a preset list of records automatically populated into the module's ...memosettings.m4t table. I don't see anything in VI nor any other work-around that will let us access that table to do updates. (This is when we…

First time in 12 years that the report I maintain is getting an error. Failed to retrieve data from the database. Details: s0000:[ProvideX][ODBC Driver][PVKIO]Data page header contains invalid record offset information. [Database Vendor Code: 109…

Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…

I am importing into Sage 100 Payroll Data entry. Using perfom logic, I am able to import earnings using TBL(NOT(Temp006), coBusiness'Lines'CreateStandardEarningsLine( Temp001$, Temp006 ) , 0) Does any know if I can import Deductions as well? I tried…

I have multiple serial numbers that need to be entered for purchase receipts They are not in the warehouse where they can be scanned in. I am trying the import tool but keep getting an error message. HELP

I'm importing Wire Transfers into Manual Check Entry with Check Type "W" before the Check Number field. Using Next on Check Number. It is pulling the next CHECK number instead of the next WIRE number. Anyone run into this and have a fix?

How can we check/fix the bad data causing "invalid segment number"? We need the SQL Export data for our daily reporting. ==>SQL EXPRESS select qry (linked to cloud-hosted SAGE100c 2022v3 Standard) has been working up until error today (12/6/2023) SELECT…

How can export all Customer Contacts in VI from AR_CustomerContacts. When I do this in VI I only get the primary contact. I don't see a record type field that would allow me to select multiple contacts.

I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return…

When using VI and importing from an Excel file, does the VI import job spin off a *.csv file into ..\mas90\home\textout to use as the source data? I'm getting this error:

I can add new emails by importing into AR_CustomerDocuments, but I want is to replace one of the existing Customer Email addresses with a new one. Backgroud: the "Additional Email Address" is populated with an internal email address to cc themselves when…

Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

2019 Advanced - Sales order history detail has extended into a second partition and MS Access now gets the message "Cannot open Database" when trying to link or import the table. It may not be a database that your application recognizes, or the file…

I suppose this could be for almost any table with a DateCreated or DateUpdated field, but in this case I'm trying to create an export for CI_Item what includes only those records with a DateUpldated of today. Based on 3 different posts here on Sage City…

Morning, I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)? {SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…

Is it possible to change the company code during a VI Chain to event? We have a process of importing data into the SO tables in one company code and then updating a field in the PO Header of another company code. I'd like to use the VI Chain To field…

Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

I am trying to create a VI - Import job into the IM_TransactoinHeader table. For the field, TransactionDate, we are wanting to ASSN <MODULEDATE> or <TODAY>, but keeps receiving error about invalid date. "20230609 This is an invalid date." I've tried…

I am looking to import sales orders either into sales order invoice and create an invoice batch or import into sales order shipping data entry. Of course it would be ideal if it would pull the lines in without having to give each line item its own line…

Hello everyone, We are trying to merge similar customers in SAGE 100 2020, and we have discovered that ship-to addresses with the same shiptocode are being overwritten by the source shiptocode if they are identical. Is there any way to modify the shiptocode…

I'm working on an import job to enter cash receipts and don't have the AR_CashReceiptsDetail table in the table list. I see it when I'm in export job maintenance, just not import. What am I missing?