• VI General Ledger Journal Entry Import - JournalComment Issues

    Hello Sage 100 Community, I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout: Account No. Debit Credit Posting Comment Journal Comment 6570-00 500.00 0.00 Test comment…
  • VI import to JC Trans Detail Cost Type invalid

    New install bringing in JC Trans Detail seems to think all entries are change orders and change orders can only be Cost Type S (subcontractor). Errors on all transactions that are not Cost Type S.
  • NEW COMPANY - COPY-RE-INITIALZE

    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…
  • VI Export Conditional Expression

    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…
  • VI Import General Journal Entry

    I'm trying to create a VI Import job to bring in some general journal entries but can't seem to figure out to grab the next Entry No automatically like I can with Batch Numbers and Invoice Numbers. I can't get them to import properly without actually…
  • Export Invoices From Prior Day and Where Sales Order Begins With J

    I need to export invoices that are from yesterday's date and the related Sales Order begins with a J. I am a novice at using Sage Intelligence, but I have some SQL experience. I understand that it's not actually SQL. I'm able to get the below SQL…
  • VI Import AP Credit Memos

    Have the following source file (CSV) 2 questions: 1 - I want to import the Invoice No and append "-CM". Is this possible? 2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…
  • VI import into payroll doesn't stop, have to click "cancel". All records are imported, though.

    PR header and detail are chained. Same problem with each.
  • Sage 100 2020 VI for JT Tables

    Hi, I am attempting to export the JT_Template table to turn around and import the file in another company. The only field not coming through the export is the Text field from tab 6 of WT Template Maintenance. The field in the Data tab of the export says…
  • VI import for PO Receipt of Invoice

    Hello, I have created a VI job to import into PO Receipt of Invoice and encountered a problem with assigning the OrderLineKey from the original purchase order. I have it working if I manually provide the order line key in the import file but need to…
  • VI Perform logic Error Log

    Hello everyone, I received existing import job with defined perform logic The import job contains Command "CREATE_ERRORLOG" on Failure. Сan anyone tell me where I can find this error log? Also, Is there a link where listed all available commands…
  • Visual Integrator - Export Job - Error 12

    Running Sage 100c 2018 I had a job get stuck and attempted to unlock. In doing so, it now gives me the error that a file could not be found and an error #12 File VIWDEF.LIB Is this an easy fix? Thanks, Ryan
  • Tax Exemption Exports

    Hello. We're moving from Sage 100 (2013) to another software, and I need to export actual tax exemption certificate numbers out of Sage, but having a hard time finding it. Let me start by saying I got thrown into supporting Sage without any training or…
  • Does positive pay only work correctly if you are using the bank reconciliation module to reconcile?

    We are in the beginnings of trying to get positive pay setup. I have our bank specifications for the positive pay file. I am learning that this file can be setup to be produced by Sage under the Bank Reconciliation module. We do not use the bank reconciliation…
  • Importing data from mas90 to sage 100

    FormerMember
    FormerMember
    I have a client his mas90 program crashed. He has a backup. Can i get the name of a company that can help me import the data into sage 100
  • VI job into AP_ManualCheckHeader Sage 100 2018 6.00.4.0

    Why is this popping up...HELP!!!! THANKS
  • VI Import to AR_InvoiceHeader fails with HS Record Invalid

    I exported the AR_OpenInvoice file to Crystal to extract very old invoices and save to a .csv file. I built a simple VI_Import to create CMs to write off the invoices. The import job validates on test but then fails when run with HS Record Invalid or…
  • No longer able to Import Data into Excel

    Across our network users have previously been able to run the data query as explained in the Sage article https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=51308&sliceId=1&noCount=true&isLoadPublishedVer=&docType=kc&docTypeID…
  • How to enter search criteria for Blank Fields

    Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?