x Want to participate? Join the group to interact

  • VI Cash Receipt with only invoice number

    Sage 2019 - Looking for way to import into AR_CashReceiptHeader from a source file that contains only the invoice number and check number but not the customer number. Manual entry allows to enter an invoice number followed by the check number. This automatically…

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

  • VI Job How can I import a job with forced return?

    I am importing new item descriptions and it includes a character return (alt enter). If I enter it in the file, it causes the entry to error out when imported. Is there another way I can import it or will we have to go in and manually enter the hard return…

  • Safe to convert Sage 100 Premium to Temporal Tables in MS SQL?

    Currently on Sage 100 Premium 2021; I need to track changes to AR_RepetitiveInvoiceHeader and AR_RepetitiveInvoiceDetail, but no built-in audit log exists. I've toyed with scripting to a UDT but now that we've moved to Premium, the power of MS SQL is…

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

  • VI Export Conditional Expression

    Morning, I am trying to create a conditional express for a VI export job, but don't seem to be able to figure out the formula. Can someone guide me on what it is I am doing wrong (if not all)? {SY_SalesTaxClass29.TaxClass$} = "NT" then {Temp002…

  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

  • General Journal Posting - duplicating

    Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…

  • VI job to import cash receipts

    I've been tasked with creating a VI job to import cash receipts and am new to using VI. Actually, fairly new to Sage, but I come with some relational database experience. I am having issues linking the AR_CashReceiptsDeposit and AR_CashReceiptsDetail…

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

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

  • Object Reference & Table name for Customer Price Schedule --> Pricing Method --> Price Discount Amount

    Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

  • 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 Export Job: Issue Linking Tables

    I am needing to run an Open Balance Export job that contains specific headers that are located on different tables. The primary table I'm using is the `AR_OpenInvoice`, to which I am attempting to link to the `AR_InvoiceHistoryHeader` table. The problem…

  • 100E - Sage 100 - Object Interface Course

    Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

  • Read & Write data in Sage100 using Business Object Interface

    Hi, I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100. I did some research on the functionality to write back the data in Sage100 but was not able to find any…

  • Remove line breaks in VI Export

    Hello all, SAGE 100 Could Advanced 2020 (V6.20.1.0) I have a VI (Visual Integrator) export job that pulls fields from CI_Items out of SAGE and into a .CSV file. I use Task Manager to automate this export and then another software reads the .CSV files…

  • Sage 100 Premium 2020 SQL Server Transactional Replication for Reporting

    Version: Sage 100cloud Premium 2020 (Version 6.20.0.01) Additional software: Scanco Operations Management & Multi-bin, Some custom DSD programming Hello all! First post here. Looking for some assistance when it comes to replicating data for reporting…

  • VI Job error WO with Bill Revision

    I'm trying to create a job to change dates for Work orders. Some WO through errors like this when the Revision Code has any letters. Some of our revisions are just numbers like the ### but some do have some letters which are allowed in the Bill of Materials…

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

  • Import AR Salesperson Commission - Err Record in Uneditable State

    Older version Sage 100 4.5 (yay, I know) Need to change the SalesSubjectToComm amount, created VI Import to AR_SalespersonCommission Test run, all records pass. Live run, all records fail with "Record is in Uneditable State". No other users…

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

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

*Community Hub is the new name for Sage City