Sage 100

Hello Sage 100 Community, I've been tasked with creating an Excel import sheet for Journal Entries. I've used the following layout: Account No. Debit Credit Posting Comment Journal Comment 6570-00 500.00 0.00 Test comment…

New install bringing in JC Trans Detail seems to think all entries are change orders and change orders can only be Cost Type S (subcontractor). Errors on all transactions that are not Cost Type S.

Is it possible to copy an existing company, then "cherry pick" some modules to remove all previous transactions using re-init. For example, if I wanted to keep the AR customers list only (not transactions or history), the CI_Items table and the employees…

I'm trying to create a VI Import job to bring in some general journal entries but can't seem to figure out to grab the next Entry No automatically like I can with Batch Numbers and Invoice Numbers. I can't get them to import properly without actually…

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…

Have the following source file (CSV) 2 questions: 1 - I want to import the Invoice No and append "-CM". Is this possible? 2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…

PR header and detail are chained. Same problem with each.

Hello, I have created a VI job to import into PO Receipt of Invoice and encountered a problem with assigning the OrderLineKey from the original purchase order. I have it working if I manually provide the order line key in the import file but need to…

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

Hello. We're moving from Sage 100 (2013) to another software, and I need to export actual tax exemption certificate numbers out of Sage, but having a hard time finding it. Let me start by saying I got thrown into supporting Sage without any training or…

I have a client his mas90 program crashed. He has a backup. Can i get the name of a company that can help me import the data into sage 100

Why is this popping up...HELP!!!! THANKS

I exported the AR_OpenInvoice file to Crystal to extract very old invoices and save to a .csv file. I built a simple VI_Import to create CMs to write off the invoices. The import job validates on test but then fails when run with HS Record Invalid or…

Across our network users have previously been able to run the data query as explained in the Sage article https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=51308&sliceId=1&noCount=true&isLoadPublishedVer=&docType=kc&docTypeID…

Utilizing Visual Integrator, I am attempting to create an export query where I only export the AR Customers records with blank comment fields. Anyone know of a way to do this?