x Want to participate? Join the group to interact

  • 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.

  • VI Import Job Unable to open [wdx][odb]<dsn_name>

    I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message: "VI JOB_NAME Unable to open [wdx][odb]<dsn_name>" I don't get this message…

  • VI job does not import Serial Numbers

    I'm going through a process of converting several Standard Cost Parts to Serialized in our system for each of our warehouses. I've adjusted the items out manually using a transaction entry. I've changed the valuation from Standard to Serialized using…

  • VI Import Not Recognizing All GL Account Numbers

    Trying to upload a budget file. However, when I test the upload I am getting errors where the 3rd segment of a GL account number is being left off and causing the error XXXXX-XX- is not on file. However, other GL accounts are loading just fine. Our…

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

  • VI Import product type

    Hi, I'm trying to do an import of about 350 inventory items that are already in the system. I am trying to change the product type to "Discontinued" I am getting an error on the import saying the product type is needed???? Any help with this would…

  • Need script to delete prior records in file prior to VI import

    I have set up a VI import to import Item/Customer Pricing info for a single customer into IM_PriceCode. However, I would like to run a program as part of the VI job "On Execution" that would remove the previous records for that customer so my imported…

  • VI Import of A/P Invoices using AP Expense Distribution Table

    Our client has a system in place that kicks out a dept code. This department code has been directly linked to a G/L account by utilizing the AP Expense Distribution Table (Code 5 on the Distribution Table is equivalent to the G/L account we want to import…

  • VI Manual Check import with new invoice with only one GL distribution line per invoice. Distribution lines fail to import.

    Each invoice has a single line distribution, but fails to distribute. Checks and new invoices import, but distribution lines do not.. No errors show up when doing test import. Do you have any ideas?

  • Combining Companies in MAS

    I need to take 2 different companies in MAS and combine them in to one database (make them one company). Is there an easy way to do this? Do i use Visual Integrator? If so, do i have to do each database one by one? Thank you for your help.

  • Visual Integrator not exporting from Check History

    We have upgraded to MAS200 43 and our VI is no longer working. It will search records but will not export files. This was accomplished using AP Check History Detail Report in previous system. Using same information in new system, the report will not…

*Community Hub is the new name for Sage City