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…

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 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…

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…

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?

I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience. I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…

Hi, We want to import a sheet from a client that sends us a csv of monthly invoice info. Some lines on the csv need to be split into 2 and occasionally 3 lines, based on the data. I can parse the line fine, but is there a way to have multiple detail…

I set up a VI job to set paperless office settings for all of our customers so it would email their A/R Statement to a contact code (rather than the customer email). Now I'm trying to figure out how I can remove that contact code using a similar job …

I've been working on a VI Import job for PO receipt of goods, serialized items. I think I am close, but I am running into this error: T Record Invalid or Write Failed. I've scoured the net, Sage City, Knowledgebase for a solution but no luck. Does anyone…

How can I use an IF THEN ELSE statement in the Expression Builder when importing a job? I keep getting a syntax error. For my current example: I'm looking to import item shipping weights. I already have my import value assigned to Temp001 . So now I…

Is it possible to create either a Crystal report or VI export job to show a list of AP invoices that were adjusted over a certain period of time? I'm having trouble distinguishing between original invoices and adjustments when looking in DFDM, other than…