Sage 100

Hello... I'm trying to create VI jobs that will update the Customer Price Levels. I have two tables with fields I need, CI_Item (itemcode & Vendor) and the IM_PriceCode (Price Method, CustomerPriceLevel and DiscountMarkup). So I created one VI job to…

Can Visual Integrator update all the PriceCode values to a specific value (like an SQL Update works)? Example; I want to apply the letter "A" as the PriceCode for all records in the ci_item table. Using visual Integrator, I can export, modify the…

Is it possible to copy an existing company, then "cherry pick" some modules to remove all previous transactions using re-init. For example, if I wanted to keep the AR customers list only (not transactions or history), the CI_Items table and the employees…

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?

Hi guys.. I just tried to "import transactions" (Xchange tab) with DIF file on my MAS90 ver3.4 (it's very old. It's time to upgrade... anyway) All thing's going well except 'year'. For example, whatever I key in or put in 12/31/23 or 12/31/2023 or…

I'll probably rebuild this process as a BOI but.... this is just so perplexing I'd kind of at least like tug the thread and see where it leads. Environment: Sage 100c 2021 v7.05 I have an ETL process that brings the invoices in from our mobile invoicing…

Hi all, Boy I sure wish it was easier to look up SAGE help ANYWHERE on the internet... I need to modify hundreds of items "INVENTORY CYCLE" code/status. We just did Inventory and out of 87 pages printed, there were actually only around 6-7 pages of…

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.

Hi Team I would like to know about the description for the values in the column (CustomerType) in the AR_Customer table

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…

Hello, I am running into an issue when importing vendors. We are mass importing items along with the vendors, but are running into a block on the vendor import. It appears that this popup might be blocking the vendors from being imported. Is there…

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…

We are in the discovery phase of a vendor integration, previous vendor integrations have just been simple file transfers, no importing into SAGE, all exporting query results to FTP sites. The next integration I want to explore if we can expand on the…

Running Sage 100 v2016. Have a VI job that imports data that typically contains a numeric value (the field is Quantity) as well as a total unit price. The import file does not have a per unit price but it's needed. In order to get the unit price I added…

Greetings SI & SQL Gurus! I built customer SI containers for tables containing UDFs as part of a larger project. Some of those UDFs are date fields, which are typically null. This doesn't present a challenge for Sage, SQL, or the custom Crystal Reports…

We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…

Can anyone share with me the .csv format or what ever format sage needs to import an invoice and payroll time into sage 100 v 2022? im thanks Kevin

I am looking to update the item locations for a large number of SKUs, is it possible to update that information in bulk via an Excel upload or something similar? I don't want to have to open each SKU individually in Item Maintenance and update them if…

New to V/I. I've used it for basic functions, but I cannot figure out how to merge item codes within V/I. I have hundreds of items that we would like to delete by converting them to a single item code. What would I need to do within the job to make this…

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…