x Want to participate? Join the group to interact

  • Export Invoices From Prior Day and Where Sales Order Begins With J

    I need to export invoices that are from yesterday's date and the related Sales Order begins with a J. I am a novice at using Sage Intelligence, but I have some SQL experience. I understand that it's not actually SQL. I'm able to get the below SQL…

  • VI Export Job - Conditional export of two data fields into one column

    I want to export SO_InvoiceDetail data. In one of the columns, I need the value to be the ItemCode, unless there is an AliasItem, in which case I want the AliasItem to be exported in the column. My export currently looks like: InvoiceNo - Col 1 ItemCode…

  • Visual Integrator - Export Job - Error 12

    Running Sage 100c 2018 I had a job get stuck and attempted to unlock. In doing so, it now gives me the error that a file could not be found and an error #12 File VIWDEF.LIB Is this an easy fix? Thanks, Ryan

  • Visual Integrator Export by Date

    Is it possible to subtract days from the current date? I'm trying to do an export from the AR_InvoiceHistoryHeader table, and I want this to be automated, and I don't want to export the entire table every time. I've tried things against the TransactionDate…

  • "index was outside the bounds array" error

    i got this error when i was trying to import from sage to excel "index was outside the bounds array" any help? thanks

  • How to change file type in EXPORT JOB MAINTENANCE,

    How to change file type in EXPORT JOB MAINTENANCE, For me it is showing FILE TYPE: Delimited, and that drop down box is disable (grayed) so I can not change file type. Tried checking / unchecking ASCII

  • Question about Bill of Materials and Crystal reports

    My client is on Sage 100, 2014 Product update 7. Currently, I am trying to write a Crystal report for Bill of Materials. I need to have a field brought n that is the current bill or default bill for the bill of materials. I can pull the bill of materials…

  • AR TRANSACTION TYPES

    Hi, I'm writing a query of my Version 4.5, I need a listing of TransactionType used in AR_TransactionPaymentHistory and what mathematical sign should be used with each in creating a report in Excel. I know about the following Transaction Types: I, P…

  • Need to get Invoices/Contacts data from sage 100 directly in website

    Hi, I am developing website using Laravel frame work (PHP) which is invoice management system and we are giving facility to our customers to fetch Invoices/Contacts from their ERP. For sage, I have setup API based import system for Xero, Sage and Quick…

  • Looking for Data Migrator Tool to migrate 'Netsuite' historical data to Sage 100 ver 2013?

    Any suggestions?

  • IM_PriceCode issues with Visual Integrator

    Hello! I am having a problem importing records with Visual Integrator using the IM_PriceCode table. HELP! In the past, we have used this table to manually import customer pricing, basically uploading the CustomerNo, ItemCode, & Price directly into…

  • VI Perform Logic for AP Invoice Duplicates - Sage100 Business Framework (v2014)

    Hello - I am looking for someone to be so kind as to post the syntax for Perform Logic to look for already posted duplicate A/P invoices during VI. I used perform logic in the past (non-framework) but do not know what the current syntax should be. …

  • Visual Integrator Issue

    After importing Excel database files through the "job Select" option, I run the TEST option and it is starting to "Ignore" all the imported files, which it has never done that before. Does anyone have an idea why this would happen and more importantly…

*Community Hub is the new name for Sage City