• Assign the correct Tax Schedule in Visual Integrator

    Hey All, I have a VI question. I have a pretty decent understanding of import jobs, but this one has me stumped. For our eCommerce website, we now have to start collecting sales tax in states where we meet economic nexus, and bring those taxes into…
  • VI Export - how to export the Company Code

    Can't find this having been discussed anywhere, although I thought I had. I am assuming I can use a Temp field and either assign "<CompanyCode>" or Calculate it somehow. So far, nothing that I have tried has worked.
  • VI Job for PM Work Ticket Entry

    Can anyone help me with importin in PM Wok Ticket Entry? I've created the Temp H file, but it gives me an error "HS Record Invalid"
  • How to rename a Temp Field in a VI export?

    Haven't found this posted before, although it may have been and my searching skills are diminished. I also understand that this might be something that I can pull into Access or Excel, or even write a Crystal Report, to accomplish. But for the moment…
  • how to give my user permissions to run a visual integrator job from the command line

    I've worked to get my VI job to run by following the instructions here: https://support.na.sage.com/selfservice/viewContent.do?externalId=19387&sliceId=1 This is the command I run: "C:\Sage\Sage 100 Workstation\MAS90\Home\pvxwin32.exe" -hd ../launcher…
  • VI Invoice Counter on export of AP_CheckDetail

    Hi Everyone, I am trying to export the AP_CheckDetail and CheckHeader information but I need to have a counter on the invoices. There is a field NumberOfDetailLines but if the Check has 5 invoices this field shows 5 but I need to have each invoice…
  • VI for Transaction Entry

    Hello, I setup a VI import Job for Transaction Journal Entry and it was working fine until recently. It is taking the offset account number and using it for the line account number as well. I am telling it to get the number from column, but it ignores…
  • VI Job Cycle Option - what is this for?

    Can someone explain the purpose of the Cycle Option in VI. I have read what documentation I can find but want a "real world" explanation of how it is used. I am hoping it will cause my VI Job to complete. I have a bat file that is run from Windows Task…
  • VI Bat File Error

    Attempting to create my first bat file to run a VI job outside of Sage 2018 Advanced 6.00.5.0, getting a Connection Time Out error. Can anyone tell me where I went wrong? I followed the steps carefully to create the new app in the Sage Application Server…
  • Can't Add New Product Codes in Item Maintenance

    When we enter a new item code into "Item Maintenance," it used to create a new product in the system. However now when we enter a new product code, everything goes blank, but it says "NEW" right by the Description (as it would do before). Everything else…
  • VI Jobs missing for newly created Role.

    Hello, I am in the process of restructuring roles for our company. We just began testing, and one of the reported issues is that there are no VI jobs in the job select menu. All of the Visual Integrator permissions are selected for this role, so I am…
  • Visual Integrator - how do I renumber a vendor and delete the old vendor number?

    I used visual integrator on a test company to try to renumber an AP vendor. I used AP Vendor Master table, downloaded a copy, changed one vendor to test, and uploaded. This worked to create another vendor with the new number, however, the original vendor…
  • Restricting Invoice Entry Dates

    Hello, First, I have tried and used the "Restrict Accounting date to current and one future Period," and this is not what I am looking for. I am looking for a way to restrict the dates that a user may enter for invoices and other data entry to the…
  • Electronic Delivery Message Maintenance - Message not sending with emails

    FormerMember
    FormerMember
    So we finally set up our email feature and after some tweaking emails now send perfectly fine to our customers. Our issue is that in the EDMM module where we create a default email message, even though a message is saved when we send electronic invoices…
  • Purchase Orders

    I've noticed that if we fill in the Work order/sales order fields after creating a purchase order that when we then look at the item we just purchased it does not reflect in the Quantities section on the main tab that there is anything on a Purchase order…
  • Item Maintenance Fields-Tab 6

    I am having difficulty getting our items in item maintenance to show up on tab 6 under Sales Orders and Work orders appropriately. Am I missing a setup somewhere to make this work for all items? It works when we create a purchase order...
  • User Limit exceeded (no topic in base Knowledge)

    Hello We just Update from sage 2013 to a 2016 Version, But now I am getting a message " User Limit exceeded" I did try the base knowledge but I could not fine any topic about this message. If you have any suggestion please let me know Thank you…
  • how to import ship zone under shipping rate maintenance?

    how to import ship zone under shipping rate maintenance for Sage 100 V4.5 Shipping Code already set "Actual" under Sales Order, item has it's own item weight, want to set up everything in the right place to do a calculation on freight for the sales…
  • How to use VI to adjust an invoice and recode it or use VI to enter one invoice coded to many GL accounts

    I currently have a VI job that we use to import commissions invoices. We obtain those commissions from a separate software. Here is a screen shot. I am looking to modify this in order to adjust an invoice. For example, we pay our corporate credit…
  • Setting up Remote Desktop users - searched but could not find

    I am setting up 4 users to remote into my server to access Sage Mas 100. I know there is a way to have them log in and have the program start automatically, but I can't seem to find it. Can anyone help? See below image...i need help figuring out what…