x Want to participate? Join the group to interact

  • AR Invoice History file size limits or performance hits

    Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…

  • Visual Integrator; Importing into SO_InvoiceHeader and Leaves Back Order

    I'm on Sage 100 Standard 2020 (v6.20.1.0). We create sales orders, and then after each sales order ships, invoices are imported into a SO_InvoiceHeader batch. When the batch is posted, all the sales orders are supposed to disappear from SO_SalesOrderHeader…

  • VI Import Job Expression Builder IF THEN ELSE Statement

    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…

  • Sage 100 Standard 2020: How do I import a bank statement to Sage 100?

    Hi all, I'm new to Sage 100 and trying to become more efficient at my job. I learned recently that it is possible to import a bank statement onto Sage 100 and automatically create invoice entries for them. After doing some preliminary research, there…

  • Journal entry uploads

    Hi, My company is currently importing journal entries to the General Journal Entry module by uploading a csv file through the General Ledger Exchange. I was wondering if there's a way to customize the settings so that Sage is the one assigning the journal…

  • Is there a way of getting an archive to load?

    Hi, I am pretty new to Sage 100 and I am still getting up to speed. We had a server crash at the office. I was able to reload Sage 100 and restore from backup. My problem now is getting into the archives for previous years that I do not have backups…

  • visual integrator conditional expression

    The original statement we have is as follows - Temp001$=“458” I want to include "459". How should the formula look? Temp001$=“458, 459" or Temp001$=“458” or Temp001$=“459”

  • importing salesorder error

    FormerMember
    FormerMember
    Hi, I have been trying to import new or exisiting sales order into SalesOrderHeader. However, when importing. i get these errors. it seems creating the new SO was fine. the only problem right now is the LotSerialNo.

  • How to avoid duplicates during VI import into AR_InvoiceHeader

    FormerMember
    FormerMember
    I am putting together a VI import job to import invoices into the AR_InvoiceHeader table in Sage 100 2016. The import appears to be identifying the headers and line items appropriately, however it does not skip duplicates as all existing invoices are…

  • VI IMPORT strip or sub?

    Hi, I am trying to load some sales orders using VI, the file that the customer is sending has some unwanted charecters in the ship to name field. I am wanting to remove them during the import. i noticed in the field properties of the ship to name…

  • VI Importing Sales order with CSV file

    we use visual integrator to import sales orders. I have a customer that sends us a csv file and on that file we have header and detail information on each line. so i would see something like: PO#, Vendor#, Shipto, item#, model#, sku#, ship date, qty…

  • Maintain Standard Price Import?

    Hi, Couldnt find anything in KB so thought i would post a question. was looking to create an import that would maintain the Standard Price in Item Maintenance. is there a way to create a VI Job to CI_ITEM? has anyone done this? wanted to just…

  • Importing Sales Orders existing customer with Primary Ship To assigned

    When importing a new Sales Order the Primary Ship To Code is assigned to the new order even though a different address is imported and Ship To code is not even used in the import. I don't want the Primary Ship To code to be assigned to an order that is…

  • Does Visual Integrator -> Sage Timesheet

    We are using a cloud based project management system. All employee time is entered into this system. However, Sage Timesheet (9.85) is used to feed our billing, which is currently done through MAS 200 (4.40). I can grab the time entries from the project…

  • VI Import Job update new field added to import table

    I have an import job that is working and I have to add a new field to the source that is imported. Is there a way, when I click on "Tables", to show the new field in the available fields list? I would like to stick with the original job because I am running…

  • Importing Purchase Order Information into MAS90.... almost there

    Trying to import a CSV file into Mas90. Looking to bring in the following.... PO# PO Date Vendor# WarehouseCode ItemCode ItemCodeDesc QtyOrdered UnitCost ExtensionAmt What I have is working perfectly if I import a PO# that has already been entered…

*Community Hub is the new name for Sage City