• 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 Error, L record AddLine() Failed. Missing or invalid header.

    I am trying to import payroll as I do every pay period. But for some reason I keep getting this error today. My VI import job for payroll has not changed, and has worked for years...until today. Any direction where I could get some help to fix the issue…
  • Copying an Employee's Report Setting

    Hello, I have been asked to copy the Report Setting that a specific employee that is no longer with the company had created and to bring it to the main company's account. The reason for this being is that the company's account, for some reason, is printing…
  • How to import Sales Forecast by Customer and Item

    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…
  • Upgrade from Sage 2016 to Sage 2023?

    I started working here 3 years ago, and there was an existing Sage 2016 installation. I've been meaning to upgrade it since I started here, but just haven't taken the time to do it. Yesterday I received a threatening email from Sage about TLS, and there…
  • Cash Receipt Import 2022.2 Premium

    Client just upgraded from 2019 Premium to 2022.2. This Cash Receipt import was working on the prior version. It is basically line for line what I have with another client on 2019 Adv which IS working and same as what I just tested on my Std 2022. I have…
  • 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 *.SQL Files Are Not Being Migrated To 2021

    I have seen two different upgrades affected by the *.SQL files under MAS90\VI failing to be migrated to the 2021 MAS90\VI folder during upgrades. Anyone else encountering this? The manual solution is to just copy them but I don't recall having to…
  • 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…
  • Desktop Customization Import v2020

    Has anyone used the new v2020 feature under File, Desktop Utilities, Customization Import? I have an upgrade from 2017 to 2020 and have classic users on the 2017 version with shortcuts and the boxes to check for importing are blank. There doesn't seem…
  • Is it possible to export the security roles and user settings from any version of Sage but in particular from Sage Premium?

    I need to re-migrate system settings during go live after a long pilot testing period. Multiple changes have been made in the source version since the pilot began. I was wondering if I can export the security roles and user settings from the upgraded…
  • Pass TEMP0001 to next VI Job in chain?

    On Sage 100 Advanced 2018, 6.00.5.0. Most of my experience with VI has been rather basic, updating or adding customer accounts, but I also have written scripts to import to Repetitive Invoicing Entry and Cash Receipts. However that is using data that…
  • 2018 Import into Job Posting Entry - Error

    Having an issue with Cost Codes in an import into Job Posting Entry. The cost codes, with "-", are longer than 9 characters, and I do have the Skip Source Data Transaction checked. It still did not like the Cost Code, so I did a calculated field where…
  • Importing AP Invoices into Sage 100

    I am work with VI to import AP invoices. One of the required Fields is the GL Account Key. I am looking for a way to look up the GL Account Key to be entered into the record for importing AP Invoices into Sage 100?
  • Visual Integrator Error: Unable to instantiate BO_BillOfLadingMargin_bus. Module P/R is Not on File

    FormerMember
    FormerMember
    Hello all, Need some help. Hoping someone else has seen this before. Trying to use a VI import on a table I haven't imported into before. Asked if my Job_Name was a new VI job. Hit Yes and... POOF. Pop up error. Unable to instantiate BO_BillOfLadingMargin_bus…
  • 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
  • "Missing or Invalid Header" when deleting Cash receipts entry batch.

    Hello, Today I had someone want to delete a batch that was entered into A/R cash receipts entry. When I try to delete it, a pop up box says "Missing or Invalid Header," and I am not allowed to delete the batch. I have seen this error before while importing…
  • Importing manual checks into Sage 100 2018 payroll

    I'm trying to design a VI job to import manual payroll checks to assist with conversion from another payroll system. When I test it the log says all the records are importing successfully; however, when I actually try to import the data the header record…
  • selling price of items excl tax/ incl tax

    FormerMember
    FormerMember
    Hello, please i have a question, I created more than 4000 product with the parameterizable file, and I put the price in incl tax and the problem sage considers it as a price in excl tax and it adds VAT again. is there a way to define at once that the…
  • VI Job HS Record Failure (All lines have not been distributed)

    I'm running into a problem with an import job from Excel where the VI Job passes in Test mode but not when executed. If there is more information needed please let me know and I will try to get it. Keep in mind that I was not fully trained in this…
  • Visual Integrator Sales Invoice Import

    We are considering using a 3PL company pick, pack, and ship some of our orders. The 3 PL would download the orders from us on a daily basis and each day send back a file with information on all the orders they shipped. This file would contain the line…
  • Does SDATA have any line item limitations? Orders with more than 40 line items throw an internal server error.

    I have an integration built that works really well. The problem I run into is if the order has more than 40 lines on it, I get an "Internal Server Error". Is anyone using it in a similar manner and have you run into this? Is there a workaround or…
  • Visual Integrator: records read not equal to records passed, but no records failed or were skipped

    We are importing SO invoice records using VI. There are 445 lines in the file. The summary says that none of them failed or were skipped, yes the number "passed" is not equal to the number read. What causes this to happen? From looking at the summary…
  • Importing new serial numbers into Physical Count

    Using VI to import into physical count. On serialized items, if I import a new serial number (did not previously exist in the system), the "frozen" qoh (which should be 0) is incorrect. If I had 3 new serial numbers for the same part, each new line shows…
  • Vendor Number does not import when importing new vendors

    I am a veteran MAS 200/Sage 100 ERP user and have done many types of imports over many years. I am working on a 4.5 Sage 100 Advanced version of Sage (we are upgrading in early September) and need to import some temporary vendors and their invoices…