x Want to participate? Join the group to interact

  • Calculate Running Total per Invoice in a VI Job

    My client imports SO Invoices, and would like to calculate the quantity of one line based on the running total of the other lines, and then assign that quantity to the item line. Here's the scenario: 1. Accumulate the quantity of all the items that…

  • Import Quantity used to Work Tickets

    need to import Quantity used in to work tickets. I have a VI Import to JT_Transaction that when run populated the JT_Transasction file. Seen in DFDM. However, it does not show in the work ticket; the exploded sales order nor does the quantity appear…

  • VI Import Cash Receipts Deposit w/o Deposit Number

    Working on Sage 100 v2016 and trying to figure out how to import cash receipts using one file when the file does not contain a Deposit Number. I don't believe I can use the 'NEXT' operation because my Cash Receipts Header/Detail import needs to use the…

  • VI Date Import with format of YYYY-MM-DD

    Running Sage 100 v2018. Creating a VI import job where the field in the import file has a date format of YYYY-MM-DD. Unfortunately there isn't a date format option matching the dashes ( - ). Is there a perform or conditional expression I could use to…

  • Unable to Export to Excel from Explorer

    We have a client that is using Sage 2020. They say that they had been able to export to Excel but suddenly they are unable to. I have checked their Excel and it is the 32 bit version. Any ideas on how to correct this? Thanks Sue

  • Perform Logic to Prevent Duplicate A/P Invoices on VI Import

    There are a few threads offering perform logic for VI jobs to prevent duplicate A/P invoices for older versions of Sage 100. Would anyone be willing to share any updated steps or perform logic for the latest version (Sage 100 2021)?

  • Inventory Import by UPC code

    I am trying to figure the best way/best practice method of displaying one of our vendors inventory within our Sage system. All the items are IIG matrix items and we receive the data with the quantities being tied to the UPC. I have all the UPC codes already…

  • Visual Integrator import into AP Manual Check Entry - Need to suppress invoices that do not already exist in AP_OpenInvoice

    Running Sage 100 v2018 and have a VI import that brings in records into AP Manual Check Entry. The client wants to suppress any invoices that are not in AP_OpenInvoice and be able to review the Import Log to see those invoices that were skipped. This…

  • User unable to export to excel from Explore View because the excel icon is not visible.

    Other users with other roles can export. Role Maintenance:Library Master:Miscellaneous tasks:Business Insights Reporter Export doesnt show in role maintenance either. Business Insights Report Import is enabled.

  • VI Conditional Expression for QuantityOrdered equaling QuantityInvoiced

    Running SAGE 100 v2018 and am exporting out of PO_PurchaseOrderDetail. Trying to figure out the correct syntax for a conditional statement where a TEMP field will either populate "OPEN' or "CLSD" depending on if QuantityOredered = QuantityInvoiced. If…

  • Line Key for PO module Order

    Could someone explain why the line key for line items doesn't change for the line when rearranging the lines in PO entry? Example; item#ABC on line 1 its line key=1 item#def on line 2 its line key=2 item#ghi on line 3 its line key=3 item#jkl on…

  • Call stored procedure using a button on Customer Maintenance

    We're looking to build a function to push newly entered customer data (for new account setups) out to an external database for one of our in-house programs (both Sage and external are on SQL 2016). What our developer is suggesting is using a stored procedure…

  • Adding a space between multiple strings within VI Expression Builder

    Running SAGE 100 v2018 and have been tasked with merging the Vendor Remit To Name and Address fields into one temp file for exporting. I'm using the Expression Builder to combine the information but I need to add a space between each field. I've tried…

  • Visual Integrator Conditional Expression for HoldPayment

    Running SAGE 100 v2018 and am importing into the AP Invoice Entry. Source file has HoldPayment set to either blank or 1. I'm trying to convert that into a "N" if it's blank or a "Y" if it contains a 1. I've created a Temp001 record to bring in the information…

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

  • Visual Integrator Export Sales Orders w/ Ship Via Desc

    I working on a job to export SO information (header and detail), however it seems that whether I start with SO_SalesOrderHeader or SO_SalesOrderDetail as the base table of the job, I'm unable to get SO header, detail, AND the ship via description included…

  • Append Date and Time to VI export using Perform function?

    Running SAGE 100 v2018 and exporting a file using VI that requires the current date and time be appended to the file. Is there a way to accomplish this using the Perform option within the VI Export job or do I need to create a separate batch process once…

  • VI job to change all customers for a sales person to email invoices - Paperless Delivery

    I am trying to figure out how to create a VI job to be able to change all of the customers for a sales person to email Sales Order & S/O invoices. I've tried exporting AR_CustomerDocuments and AR_CustomerDocumentsContacts, but neither of those seem to…

  • Can I use SAGE 100 Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table?

    I've encountered problems while trying to use SAGE 100's Visual Integrator to export data from Job Cost's JobHistoryTransDetail table to a SAGE 100 User Defined Table? I need to export all of the JobHistoryTransDetail table records for a desired date…

  • VI General Journal total debits and assign credit account number

    I'm trying to import a journal entry. I've calculated the Debit Account number by combining other fields to make the complete account and that works. Now I need to total all the debits to get the credit amount and then assign the credit account number…

  • VI Import chain via batch file launched by windows task scheduler.

    We have a long time customer that has been running a batch file that launches a VI job. The first job chains to another and so on for several jobs. They are and have been Sage 100 premium, we just upgraded them to 2020. The batch file works and all the…

  • Using VI to Import Cash Receipts

    Can a VI job be setup to total a column on your source file? For example if importing cash receipts I have a column in my source file pointing to the Line Amount Posted and I want the job to sum up that column by customer and put the amount in the Header…

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

  • VI Import - Payroll 2.x Data Entry

    I am importing into PR Data entry and trying to set a condition on the Labor code. Import it if it is contained in the import file (col 15), if blank, look to the Employee Master and pull it from there. I tried my hand at a conditional expression…

  • Visual Integrator Expression Builder - Substituting one field with another if blank

    In my export job I am trying to export two fields into two different columns if the fields contains data (in this case one field is a string and one is a date) (also, if one of these fields is empty, both will be empty). If the fields are empty I want…

*Community Hub is the new name for Sage City